How to make column Editable in Gridview

Question

Hi

In below code i want SessionDate to be editable in all rows

SQLUtility sQLUtility = new SQLUtility();
DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0];
if (dt != null)
{
    DataColumn Remarks = new DataColumn("Remarks", typeof(string));
    dt.Columns.Add(Remarks);
    DataColumn Dates = new DataColumn("SessionDate", typeof(string));
    dt.Columns.Add(Dates);

    grdPlanning.DataSource = dt;
    grdPlanning.DataBind();
}

Thanks

Rajkiran Swain · Answer

Try like this and add your additional column in the grid. '> protected void grdPlanning_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = grdPlanning.Rows[e.RowIndex]; string bookId = grdPlanning.DataKeys[e.RowIndex].Value.ToString(); TextBox txtSessionDate = (TextBox)row.FindControl("txtSessionDate"); string sessionDate = txtSessionDate.Text; // Update the "SessionDate" field in the database SQLUtility sQLUtility = new SQLUtility(); sQLUtility.UpdateSessionDate(bookId, sessionDate); // Rebind the GridView to reflect the changes grdPlanning.EditIndex = -1; BindGrid(); } BindGrid code as below ------------------------- //Page Load SQLUtility sQLUtility = new SQLUtility(); DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0]; if (dt != null) { grdPlanning.DataSource = dt; grdPlanning.DataBind(); }

Ramco Ramco · Answer

Hi RajKiran Pls find the code. AutogenerateColumns = true. I want SessionDate only to be editable so that user can enter Date div class="row"> '> SQLUtility sQLUtility = new SQLUtility(); DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0]; if (dt != null) { DataColumn Remarks = new DataColumn("Remarks", typeof(string)); dt.Columns.Add(Remarks); DataColumn Dates = new DataColumn("SessionDate", typeof(string)); dt.Columns.Add(Dates); grdPlanning.DataSource = dt; grdPlanning.DataBind(); } Thanks

Rajkiran Swain · Answer

Please send the full code with HTML.

Ramco Ramco · Answer

Hi RajKiran I have attached image . Textbox should appear on right side of Gridvew SessionDate column. It is creating another column Thanks

Rajkiran Swain · Answer

In order to make the "SessionDate" column editable, you can use a TemplateField instead of a BoundField. Here's an example of how you can modify the code to achieve this: '> protected void grdPlanning_RowUpdating(object sender, GridViewUpdateEventArgs e) { DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0]; GridViewRow row = grdPlanning.Rows[e.RowIndex]; TextBox txtSessionDate = (TextBox)row.FindControl("txtSessionDate"); dt.Rows[row.DataItemIndex]["SessionDate"] = txtSessionDate.Text; sQLUtility.UpdateBookPlanningRecommendation(dt); grdPlanning.EditIndex = -1; BindGrid(); }

Ramco Ramco · Answer

Hi Rajkiran I have dynamic columns . These 2 columns i have added after the Dynamic columns. Code shared above. I have autogenerate columns = true I want SessionDate to be editable only. Thanks

Rajkiran Swain · Answer

SQLUtility sQLUtility = new SQLUtility(); DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0]; if (dt != null) { grdPlanning.DataSource = dt; grdPlanning.DataBind(); }

Ramco Ramco · Answer

asp.net

Rajkiran Swain · Answer

Is it windows or asp.net ?

Ramco Ramco · Answer

Hi RajKiran It is giving error - The type or namespace name GridViewColumn could not be found GridViewColumn sessionDateColumn = grdPlanning.Columns["SessionDate"]; Thanks

Rajkiran Swain · Answer

To make the "SessionDate" column editable in all rows of a GridView, you can set the `ReadOnly` property of the corresponding column in the `GridView.Columns` collection to `false`. Here's an example: ``` // Bind the DataTable to the GridView grdPlanning.DataSource = dt; grdPlanning.DataBind(); // Make the "SessionDate" column editable GridViewColumn sessionDateColumn = grdPlanning.Columns["SessionDate"]; sessionDateColumn.ReadOnly = false; ``` In the above code, we first bind the DataTable `dt` to the GridView `grdPlanning`. Then, we get the `GridViewColumn` corresponding to the "SessionDate" column and set its `ReadOnly` property to `false`, which makes the column editable in all rows of the GridView.

Ramco Ramco · Answer

Hi RajKiran It is giving error - The type or namespace name GridViewColumn could not be found GridViewColumn sessionDateColumn = grdPlanning.Columns["SessionDate"]; Thanks

Rajkiran Swain · Answer

// Create a DataTable with the required columns DataTable dt = new DataTable(); dt.Columns.Add("SessionDate", typeof(DateTime)); dt.Columns.Add("Remarks", typeof(string)); // Populate the DataTable with data dt.Rows.Add(DateTime.Today.AddDays(1), "Row 1 Remarks"); dt.Rows.Add(DateTime.Today.AddDays(2), "Row 2 Remarks"); dt.Rows.Add(DateTime.Today.AddDays(3), "Row 3 Remarks"); // Bind the DataTable to the GridView grdPlanning.DataSource = dt; // Make the "SessionDate" column editable GridViewColumn sessionDateColumn = grdPlanning.Columns["SessionDate"]; sessionDateColumn.ReadOnly = false; // Bind the GridView grdPlanning.DataBind();