how to row update in gridview

Question

plz send me any sample c# code for update row in gridview

srinivas rao · Answer

Hi James, Have you actually implemented this code. I tried it but the gridview doesn't update. I have actually copied your code and run. It doesn't run. Have you got any idea?

Niradhip Chakraborty · Answer

// Inline code(.aspx page) Topic Details '> '> ' CssClass="NormalText" Rows="5" TextMode="MultiLine" Columns="50" > pagebehid code(aspx.cs) protected void grdvTopicDetails_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e) { int intIndex = e.RowIndex; clsDBFunctions objdata = new clsDBFunctions(); TextBox txtDesc; Label lblTopicDetailsID; Label lblTopicID; { lblTopicDetailsID = grdvTopicDetails.Rows.Item(intIndex).FindControl("lblTopicDetailsId"); txtDesc = grdvTopicDetails.Rows.Item(intIndex).FindControl("txtEditDesc"); lblTopicID = grdvTopicDetails.Rows.Item(intIndex).FindControl("lblTopicId"); } objdata.SQLQuery = "update topicDetails set tpd_vch_Desc='" + txtDesc.Text + "' where tpd_uid_TopicdetailId=" + lblTopicDetailsID.Text + " and tpd_uid_TopicId=" + lblTopicID.Text + ""; objdata.ExecuteQuery(); grdvTopicDetails.EditIndex = -1; } Dont use objdata i have used a dll for my sql queries. use simple sql statement.The way you are doing creating command and adapter. do it in same way.

jeevan mummadi · Answer

hello james, i created gridview like this asp : GridView ID ="GridView1" runat ="server" style ="z-index: 100; left: 400px; position: absolute; top: 200px" AutoGenerateColumns ="False" AutoGenerateDeleteButton ="True" AutoGenerateEditButton ="True" CellPadding ="4" ForeColor ="#333333" GridLines ="None" OnRowEditing ="GridView1_RowEditing" DataSourceID ="SqlDataSource1" OnRowUpdating ="GridView1_RowUpdating"> Columns > asp : BoundField HeaderText ="item" DataField ="itemname" /> Columns > asp : GridView > asp : SqlDataSource ID ="SqlDataSource1" runat ="server" ConnectionString =" " SelectCommand ="SELECT [itemname] FROM [cards1]"> asp : SqlDataSource > i wrote code for gridview edit ,and update like this... protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; SqlConnection con = new SqlConnection ( "server=localhost;initial catalog=online_application1;user id=sa;pwd=" ); con.Open(); DataSet ds = new DataSet (); string stmt= "select * from card1" ; SqlCommand cmd = new SqlCommand (stmt ); SqlDataAdapter da = new SqlDataAdapter (cmd, con); da.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } protected void GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e) { GridView1.Rows[GridView1.EditIndex].Cells[0].Controls[0]; } but i getting below errors Error 1 The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapter(string, string)' has some invalid arguments c:\inetpub\wwwroot\xyz\Default3.aspx.cs 29 29 http://localhost/xyz/ Error 2 Argument '1': cannot convert from 'System.Data.SqlClient.SqlCommand' to 'string' c:\inetpub\wwwroot\xyz\Default3.aspx.cs 29 48 http://localhost/xyz/ Error 3 Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'string' c:\inetpub\wwwroot\xyz\Default3.aspx.cs 29 53 http://localhost/xyz/ Error 4 Only assignment, call, increment, decrement, and new object expressions can be used as a statement c:\inetpub\wwwroot\xyz\Default3.aspx.cs 38 9 http://localhost/xyz/ plz help me....

Niradhip Chakraborty · Answer

public void Grid() { SqlConnection con = new SqlConnection("server=. ; integrated security=sspi; database = Ram"); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from Ram ", con); DataSet ds= new DataSet(); da.Fill(ds, "Ram"); GridView1.DataSource = ds; GridView1.DataBind(); ListBox1.DataSource = ds; ListBox1.DataTextField = ds.Tables[0].Columns[0].ToString(); ListBox1.DataBind(); con.Close(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { Button lb = new Button(); TextBox txt1 = new TextBox(); txt1 = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]; string str1 = Convert.ToString(txt1.Text); TextBox txt4 = new TextBox(); txt4 = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]; string str4 = Convert.ToString(txt4.Text); TextBox txt2 = new TextBox(); txt2 = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]; string str2 = Convert.ToString(txt2.Text); TextBox txt3 = new TextBox(); txt3 = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]; string str3 = Convert.ToString(txt3.Text); SqlConnection con = new SqlConnection("server=. ; integrated security=sspi; database = Ram"); con.Open(); SqlCommand com = new SqlCommand("update Ram set NAME=@NAME,Fname=@age,address =@address where id=@lname ", con); com.Parameters.AddWithValue("@lname", str1); com.Parameters.AddWithValue("@age", str2); com.Parameters.AddWithValue("@address", str3); com.Parameters.AddWithValue("@NAME", str4); com.ExecuteNonQuery(); Response.Write("successfully updated"); GridView1.EditIndex = -1; Grid(); }