Import data from sqlserver into Excel Sheet Using DataTable

static DataTable dta;
SqlDataAdapter da = new SqlDataAdapter("select * from Emp", conn);
  DataSet    ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count > 0)
        {
         
            dta = ds.Tables[0];
     
        }

        string attachment = "attachment; filename=Address.xls";

        Response.ClearContent();

        Response.AddHeader("content-disposition", attachment);

        Response.ContentType = "application/vnd.ms-excel";

        string tab = "";

        foreach (DataColumn dc in dta.Columns)
        {

            Response.Write(tab + dc.ColumnName);

            tab = "\t";

        }

        Response.Write("\n");



        int i;

        foreach (DataRow dr in dta.Rows)
        {

            tab = "";

            for (i = 0; i < dta.Columns.Count; i++)
            {

                Response.Write(tab + dr[i].ToString());

                tab = "\t";

            }

            Response.Write("\n");

        }

        Response.End();

How to "Add Favorites" in asp.net

 <asp:LinkButton ID="addFav" runat="server" class="smlrednormal" OnClientClick="window.external.AddFavorite(location.href, document.title);">Add to favorites</asp:LinkButton>

How to select substring according to CHARACTER INDEX

select serial_num,   SUBSTRING([imagePath],CHARINDEX('a',imagePath),CHARINDEX('g',imagePath)) as column1   from Tbl_EmpDetails order by serial_num asc

How to Use Trim in Sql

Trim from Right Hand Side

select serial_num, Rtrim(imagePath) from Tbl_EmpDetails

Trim from Light Hand Side

select serial_num,Ltrim(imagePath) from Tbl_EmpDetails

How to Use Replace Query in SQL

UPDATE emp_details set lastname=replace(lastname, 'Kumar', 'Sharma') where serial_num=100

How to use While loop in Sql Query Analyser

declare @i as int
set @i=1
BEGIN
while @i < 10

UPDATE employee_details set lastname='Kumar' where serial_num=@i
set @i=@i+1

END;

Convert unicode in hex

 string str = "युवराज फिर बने भारत की जीत के नायक"; //unicode text

        string data= string.Empty;  //for high performance
        foreach (char ch in str)
        {
            int temp= ch;
            data+= String.Format("{0:x4}", (uint)System.Convert.ToUInt32(temp.ToString()));
        }
        data= data.ToUpper();