Update gridview row in asp.net

Text ; sqlcmd. AddWithValue " gender", gender. AddWithValue " city", city. AddWithValue " id", Convert. ToInt32 GridView1. ToString ; sqlcmd. ExecuteNonQuery ; GridView1. According to your description and code, if you meet some error or exception message when you execute update in gridview?

Please post it! This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual.

Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Related Questions. Bulk update in ASP. NET gridview update all. Row update in Gridview of Asp. GridView Updating event. GridView events inside update panel. Layout: fixed fluid. Web03 2. Strip HTML. Encode HTML. End Sub. Private Sub BindGrid. ConnectionStrings "constr". Using con As New SqlConnection constr. Using dt As New DataTable.

Fill dt. End Using. CustomerId which is the primary key is fetched from the DataKey property of GridView while the Name and Country fields are fetched from their respective columns by referencing the TextBoxes in it. Finally an Update query is executed over the database table. ToInt32 GridView1. Values[0] ;. Controls[0] as TextBox. AddWithValue " Name" , name ;. AddWithValue " Country" , country ;. Open ;. ExecuteNonQuery ;. Close ;.

Rows e. DataKeys e. Values 0. Cells 2. Controls 0 , TextBox. Cells 3. AddWithValue " Name" , name. AddWithValue " Country" , country. Cancel Edit. Here the EditIndex is set to -1 and the GridView is populated with data.