ASP.NET

ASP.NET RSS

gridview rowupdating using parametrized query.

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2007

Posts: 33

Reputation: ansari.wajid is an unknown quantity at this point

Solved Threads: 0

ansari.wajid ansari.wajid is offline

Offline

Light Poster

gridview rowupdating using parametrized query.

Sep 4th, 2008

Hi

I have gridview and I am using gridview1_rowupdating event to update the gridview, but when I am using the code given below its not working. I do not know why it is not updating, it is not even showing error. please help me resolve this problem.
Thanks

 Help with Code Tags 
 aspnet Syntax (Toggle Plain Text) 
 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();
    }
 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();
    }