How to reset web form "CONTROL in ASP.NET" after save data

//call this function after completion of  insert query
 ClearInputs(Page.Controls);

 private void ClearInputs(ControlCollection ctrls)
    {

        foreach (Control ctrl in ctrls)
        {

            if (ctrl is TextBox)
            {
                ((TextBox)ctrl).Text = string.Empty;


            }
            else if (ctrl is DropDownList)
            {
                ((DropDownList)ctrl).ClearSelection();

            }

            ClearInputs(ctrl.Controls);

        }

    }

select gridview(template column) row index on button click

   GridViewRow row = ((Button)sender).Parent.Parent as GridViewRow;
    int index = row.RowIndex;

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