Edit and update a textbox value in gridview

Question

Hi All i have a gridview with 5 columns in 2nd column i have placed a text box all the data are populating in the grid . now i need to edit a text box value in 2nd columns and after editing it should get updated in database also.. this all thing should happen under update button which i placed outside the gridview. please help me

Satyapriya Nayak · Answer

Hi Satishchandra Here in this example there is a checkbox control inside gridviewyou have to check the checkbox of which records you need to update.Type new records in the textbox and click update button.Records will be updated. Try this... Untitled Page AllowPaging=True DataSourceID=SqlDataSource1 AutoGenerateColumns=false> AutoPostBack=true OnCheckedChanged=chkSelect_CheckedChanged/> SortExpression=ID/> SortExpression=Name> Text=' ' ReadOnly=true ForeColor=Blue BorderStyle=none BorderWidth=0px > SortExpression=Location> Text=' ' ReadOnly=true ForeColor=Blue BorderStyle=none BorderWidth=0px> ConnectionString=  SelectCommand=SELECT [ID] [Name] [Location] FROM [Details] DeleteCommand=DELETE FROM Details WHERE (ID = @ID) UpdateCommand=UPDATE [Details] SET [Name] = @Name [Location] = @Location WHERE [ID] = @ID> OnClick=btnUpdate_Click Text=Update /> Text=Check all /> Text=UnCheck all /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Collections; using System.Text; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; protected void btnUpdate_Click(object sender EventArgs e) { StringBuilder strSql = new StringBuilder(string.Empty); SqlConnection con = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(); for (int i = 0; i { CheckBox chkUpdate = (CheckBox) GridView1.Rows[i].Cells[0].FindControl(chkSelect); if (chkUpdate != null) { if (chkUpdate.Checked) { string strID = GridView1.Rows[i].Cells[1].Text; string strName = ((TextBox) GridView1.Rows[i].FindControl(txtName)).Text; string strLocation = ((TextBox) GridView1.Rows[i].FindControl(txtLocation)).Text; string strUpdate = Update Details set Name = ' + strName + 'Location = ' + strLocation + ' WHERE ID =' + strID + '; strSql.Append(strUpdate); } } } try { cmd.CommandType = CommandType.Text; cmd.CommandText = strSql.ToString(); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); } catch (SqlException ex) { string errorMsg = Error in Updation; errorMsg += ex.Message; throw new Exception(errorMsg); } finally { con.Close(); } UncheckAll(); } private void UncheckAll() { foreach (GridViewRow row in GridView1.Rows) { CheckBox chkUncheck = (CheckBox) row.FindControl(chkSelect); TextBox txtname = (TextBox) row.FindControl(txtName); TextBox txtlocation = (TextBox) row.FindControl(txtLocation); chkUncheck.Checked = false; txtname.ReadOnly = true; txtlocation.ReadOnly = true; txtname.ForeColor = System.Drawing.Color.Blue; txtlocation.ForeColor = System.Drawing.Color.Blue; } } protected void chkSelect_CheckedChanged (object sender EventArgs e) { CheckBox chkTest = (CheckBox)sender; GridViewRow grdRow = (GridViewRow)chkTest.NamingContainer; TextBox txtname = (TextBox)grdRow.FindControl (txtName); TextBox txtlocation = (TextBox)grdRow.FindControl (txtLocation); if (chkTest.Checked) { txtname.ReadOnly = false; txtlocation.ReadOnly = false; txtname.ForeColor = System.Drawing.Color.Black; txtlocation.ForeColor = System.Drawing.Color.Black; } else { txtname.ReadOnly = true; txtlocation.ReadOnly = true; txtname.ForeColor = System.Drawing.Color.Blue; txtlocation.ForeColor = System.Drawing.Color.Blue; } } protected void Button1_Click(object sender EventArgs e) { CheckState(true); } protected void Button2_Click(object sender EventArgs e) { CheckState(false); } private void CheckState(bool p) { foreach (GridViewRow row in GridView1.Rows) { CheckBox chkcheck = (CheckBox)row.FindControl(chkSelect); chkcheck.Checked = p; } } } Thanks If this post helps you mark it as answer

vijay · Answer

hi.. Refer this below link....... http://www.dotnetcode.in/2011/12/updateedit-and-delete-in-grid-view.html

Satishchandra TN · Answer

HI Thanks for your Needful help..