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=@NAMEFname=@ageaddress =@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(); }