ASP.NET

 protected void gv_RowUpdating1(object sender, GridViewUpdateEventArgs e)
    {
        connectAccessDb();
        int i = e.RowIndex;
        //par = cmd.Parameters;
        //cmd.Parameters.Clear();
        string id = (gv.Rows[e.RowIndex].FindControl("lblCID") as Label).Text;
        string comp = (gv.Rows[e.RowIndex].FindControl("txtCName") as TextBox).Text;
        string address = (gv.Rows[e.RowIndex].FindControl("txtCAddr") as TextBox).Text;
        string city = (gv.Rows[e.RowIndex].FindControl("txtCcity") as TextBox).Text;
        //string strQuery="UPDATE companydetail SET companyname='" + comp + "',companyaddress='" + address + "',companycity='" + city + "' where id=" + Convert.ToInt32(id);
        //dCmd = new OleDbCommand(strQuery, cn);
        //dCmd = new OleDbCommand("UPDATE companydetail SET companyname=@comp, companyaddress=@address, companycity=@city where id=@id", cn);
        string strQuery = "UPDATE companydetail SET companyname=@comp, companyaddress=@address, companycity=@city where id=@id";
        cmd = new OleDbCommand(strQuery, cn);
        cmd.Parameters.Add("@id", OleDbType.Integer).Value = Convert.ToInt32(id);
        cmd.Parameters.Add("@comp", OleDbType.VarChar).Value = comp;
        cmd.Parameters.Add("@address", OleDbType.VarChar).Value = address;
        cmd.Parameters.Add("@city", OleDbType.VarChar).Value = city;

        cmd.ExecuteNonQuery();
        cmd.ExecuteNonQuery();
        //gv.EditIndex = -1;
        cn.Close();
        bindData();

      
    }
 private void bindData()
    {    
        connectAccessDb();
        da = new OleDbDataAdapter("SELECT id,companyname,companyaddress,companycity  from companydetail order by companyname", cn);       
        da.Fill(ds, "companydetail");
        gv.DataSource = ds;
        gv.DataBind();
        cn.Close();        
    }
private void connectAccessDb()
    {

        cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + strRootDir + "App_Data\\newsdb.mdb");
        cn.Open();
    }

 public static bool Send(string aa)
        {
         string[] host = (aa.Split('@'));
                string hostname = host[1];

                IPHostEntry IPhst = Dns.Resolve(hostname);
                IPEndPoint endPt = new IPEndPoint(IPhst.AddressList[0], 25);
                Socket s = new Socket(endPt.AddressFamily,
                        SocketType.Stream, ProtocolType.Tcp);
                s.Connect(endPt);
                //Attempting to connect
}

DataTable DTable;
DataRow DRow;
DataColumn DCol;

sqlda=new System.Data.SqlClient.SqlDataAdapter("select tmp_values from tbl_table1", conn);
sqlda.Fill(ds);

DTable = new DataTable("Headers");

        DCol = new DataColumn("Head");
        DTable.Columns.Add(DCol);
        DRow = DTable.NewRow();
        for (int i = 0; i <ds.Tables[0].Rows.Count; i++)
        {
            DCol = new DataColumn("" + ds.Tables[0].Rows[i][0].ToString() + "");
            DTable.Columns.Add(DCol);
            DCol = new DataColumn("" + ds.Tables[0].Rows[i][0].ToString() + " " + " Remarks");
            DTable.Columns.Add(DCol);
        }
        
        DTable.Rows.Add(DRow);
        GridView1.DataSource = DTable;
        GridView1.DataBind();