Convert Girdview into Datatable

Question

Hi I have below gridview . I want to convert it into DataTable Thanks

Vishal Yelve · Answer

Try this DataTable GetDataTable(GridView dtg) { DataTable dt = new DataTable(); // add the columns to the datatable if (dtg.HeaderRow != null) { for (int i = 0; i

Jignesh Kumar · Answer

Hello Ramco, using System; using System.Data; using System.Web.UI.WebControls; public DataTable ConvertGridViewToDataTable(GridView gridView) { DataTable dataTable = new DataTable(); foreach (DataControlField column in gridView.Columns) { dataTable.Columns.Add(column.HeaderText); } // Iterate through each row in the GridView foreach (GridViewRow row in gridView.Rows) { DataRow dataRow = dataTable.NewRow(); // Iterate through each cell in the GridView row for (int i = 0; i You can call, GridView myGridView = new GridView(); DataTable myDataTable = ConvertGridViewToDataTable(myGridView);

Naimish Makwana · Answer

Try below: using System; using System.Data; using System.Web.UI.WebControls; // Assuming this code is in the code-behind file of your ASP.NET page or user control protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Bind the GridView to its data source // ... // Call the method to convert GridView to DataTable DataTable dataTable = ConvertGridViewToDataTable(grdPlanning.DataSource); // Use the resulting DataTable as needed // ... } } private DataTable ConvertGridViewToDataTable(object dataSource) { DataTable dataTable = new DataTable(); // Retrieve the data source and cast it to a DataView DataView dataView = dataSource as DataView; if (dataView != null) { // Create columns in DataTable based on the DataView's schema foreach (DataColumn column in dataView.Table.Columns) { dataTable.Columns.Add(column.ColumnName, column.DataType); } // Iterate through each row in the DataView and populate the DataTable foreach (DataRowView dataRowView in dataView) { DataRow dataRow = dataTable.NewRow(); for (int i = 0; i Thanks

Vishal Yelve · Answer

Hi Ramco, https://www.aspsnippets.com/Articles/Using-jQuery-DataTables-with-GridView-in-ASPNet.aspx

Mudzakkir Toha · Answer

Hi, I think your idea is not best practice of using datasource. I think better you make private List listDatasource or private Datatable listtDataSource on backend class which is the lifecycle is still persist on the page. Converting gridView to dataTable will causing possibility of conversion error, and take efforts, when binding you just need to update value listDatasource from DB, and passing listDatasource object to gridview.

Rajkiran Swain · Answer

// Create a new DataTable DataTable dataTable = new DataTable(); // Add columns to the DataTable based on the GridView's header foreach (DataControlFieldHeaderCell headerCell in grdPlanning.HeaderRow.Cells) { dataTable.Columns.Add(headerCell.Text); } // Iterate through the GridView's rows and populate the DataTable foreach (GridViewRow row in grdPlanning.Rows) { DataRow dataRow = dataTable.NewRow(); for (int i = 0; i

Ramco Ramco · Answer

Hi all I want to convert Gridview to JQuery Datatable. Thanks

Convert Girdview into Datatable

Answers (7)