Textbox column at the end

Question

Hi

In a Gridview i want to add Textbox column at the end & then read its value. Below is the code. AutoGenerateColumns is true

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

<asp:GridView ID="grdPlanning" class="table table-bordered" runat="server" OnRowDataBound="gr_RowDataBound" OnRowCommand="grdPlanning_RowCommand" AutoGenerateColumns="true">
</asp:GridView>

Thanks

Rajkiran Swain · Answer

DataTable dt = sQLUtility.GeBookPlanningRecommendation(HRpl, BookCollection, StudentCollection).Tables[0]; if (dt != null) { // Add Remarks column DataColumn remarksColumn = new DataColumn("Remarks", typeof(string)); dt.Columns.Add(remarksColumn); // Bind the DataTable to the GridView grdPlanning.DataSource = dt; grdPlanning.DataBind(); // Add a TextBox column dynamically if (grdPlanning.Rows.Count > 0) { int columnIndex = dt.Columns.Count - 1; // Index of the Remarks column foreach (GridViewRow row in grdPlanning.Rows) { TableCell cell = new TableCell(); TextBox txtRemarks = new TextBox(); txtRemarks.ID = "txtRemarks"; txtRemarks.Text = ((TextBox)row.Cells[columnIndex].Controls[0]).Text; cell.Controls.Add(txtRemarks); row.Cells.Add(cell); } } }