Export datagrid to Excel in asp.net (Revised)

How to export datagrid data into excel
Utility Code: It is self explanatory

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
DataTable dtOriginal = new DataTable();
dtOriginal = ReturnTable(); //Return Table consisting data

//Create Tempory Table
DataTable dtTemp = new DataTable();

//Creating Header Row
dtTemp.Columns.Add("Employee Name");
dtTemp.Columns.Add("Email");
dtTemp.Columns.Add("Join Date");
dtTemp.Columns.Add("Salary");
double dSalary;
DateTime dtDate;
DataRow drAddItem;
for (int i = 0; i < dtOriginal.Rows.Count; i++)
{
drAddItem = dtTemp.NewRow();
drAddItem[0] = dtOriginal.Rows[i][0].ToString();//Name
drAddItem[1] = dtOriginal.Rows[i][1].ToString();//Email

//Join Date
dtDate = Convert.ToDateTime(dtOriginal.Rows[i][2].ToString());
drAddItem[2] = dtDate.ToShortDateString();

//Salary
dSalary = Convert.ToDouble(dtOriginal.Rows[i][3].ToString());
drAddItem[3] = dSalary.ToString("C");

dtTemp.Rows.Add(drAddItem);
}

//Temp Grid
DataGrid dg = new DataGrid();
dg.DataSource = dtTemp;
dg.DataBind();
ExportToExcel("BudgeReport.xls", dg);
dg = null;
dg.Dispose();
}

private void ExportToExcel(string strFileName, DataGrid dg)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}

Find All trigger Information in our Database In Sql

This is the Query by which one u can get the whole information about the trigger which are in our database or particular database.

SELECT Tables.Name TableName,
Triggers.name TriggerName,
Triggers.crdate TriggerCreatedDate,
Comments.Text TriggerText
FROM sysobjects Triggers
Inner Join sysobjects Tables On Triggers.parent_obj = Tables.id
Inner Join syscomments Comments On Triggers.id = Comments.id
WHERE Triggers.xtype = 'TR'
And Tables.xtype = 'U'
ORDER BY Tables.Name, Triggers.name

Rupee foridian font Applied on Repeater control

This is a new font of Indian rupees I found and Apply it on the Repeater control as like this.

asp:Label ID="lblFees" runat="server" Text='<%#Eval("SemFees","`{0}") %>' Font-Names="Rupee Foradian" asp:Label

Also check the link for how to apply and download rupee foridian font.
http://www.indianweb2.com/2010/07/how-to-type-indian-rupee-symbol-download-indian-rupee-font/

http://www.codeproject.com/KB/silverlight/NewIndianRupeeSymbolDemo.aspx

Validate Number by Javascript function

by this function simply call this function on onkeypress event and get mast functionality.
function isNumberKey(e) {
var charCode = (e.which) ? e.which : event.keyCode
if ((charCode > 31) && (charCode < 48 || charCode > 57)) {
return false;
}
}

//call on onkeypress event in textbox

asp:TextBox ID="txtbox1" runat="server" CssClass="input_big" MaxLength="15"
onkeypress="return isNumberKey(event)"/asp:TextBox

Find any Control in Repeater using Javascript

I used Javascript function to check count of checkboxes into repeater which are checked.And on that count I performed some action on it on my client side perfomance.
function checkAll(cb)
{
var ctrls = document.getElementsByTagName('input');
var count=0;
for (var i = 0; i < ctrls.length; i++)
{
var cbox = ctrls[i];
if (cbox.type == "checkbox")
{

if(cbox.checked)
{
count++;

}
//cbox.checked = cb.checked;
}
}
}

Call this function on aspx contol

asp:CheckBox ID="chkPaper" runat="server" onclick="return checkAll(this)"
enjoy coding...

Find control in header template in repeater or any container

We can search any type of control in header templete through item_databound event of repeater like this.

protected void rptElective_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
Label lblSelect = (Label)e.Item.FindControl("lblSelect");
if (SpecFlag == false)
lblSelect.Visible = true;
else
lblSelect.Visible = false;
}

}

And also you can Hide Control without Item_dataBound like this enjoy coding...

Label lblSelect = rptElective.Controls[j].Controls[j].FindControl("lblSelect") as Label;

Convert string to datetime exactly not normal datetime.

The unexpected error was come once in front of me.string was not in a valid datetime format.Then i searched for this conversion and it works properly now.

DateTime dt = DateTime.ParseExact(txtdob.Text, "dd/MM/yyyy", null); ;