Editable GridView

Question

Hi, In gridview (2008) I want to edit all rows at a time instead of go by single row. Can any one help me with coding example. Thanks in advance. Regards, Revathi.M

Mayur Gujrathi · Answer

Please try this for adding dropdwn And for editable dropdown refer this http://www.codeproject.com/KB/webforms/Editable-DropDown.aspx

Revathi Murugesan · Answer

Hi Mayur, Thanks for the reply. In that attached example add row good be fine. In that I want to populate existing value in grid and all rows are editable. In my grid contain combo box value also. Could you please help me with example. Thanks in advance Regards, Revathi.M

Revathi Murugesan · Answer

Hi Satyapriya, While clicking the checkbox its throwing error. (NullReferencesError i'm getting) We have to select all check box?? Check box is availbale in each row. In gridview header is not having checkbox. help me. Regards, Revathi.M

Satyapriya Nayak · Answer

Hi Revathi, Have you run the attachments. Here in pageload event all the values are shown in the gridview.But there is CheckBox,so when you need all the data to be updated,you have to select all the CheckBoxs and enter the new values and when you click update button all are updated. Thanks

Revathi Murugesan · Answer

Hi Satyapriya, Thanks for the reply. In your code on click of check box able to edit a checked row right. Wat i'm expecting is I want to edit a entire grid data and do one time submit. Values are there in grid it should fetch on pageload itself. But it should be editable. If u knows please help me. Regards, Revathi.M

Mayur Gujrathi · Answer

Try this

Satyapriya Nayak · Answer

Hi Revathi, Try this ... Run the attachments. 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" /> 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; } } } Thanks

Editable GridView

Answers (7)