Convert Girdview into Datatable

Hi Ramco,

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

Hi all

  I want to convert Gridview to JQuery Datatable. 

Thanks

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 < dtg.HeaderRow.Cells.Count; i++)
                {
                    dt.Columns.Add(dtg.HeaderRow.Cells[i].Text);
                }
            }
 
            //  add each of the data rows to the table
            foreach (GridViewRow row in dtg.Rows)
            {
                DataRow dr;
                dr = dt.NewRow();
 
                for (int i = 0; i < row.Cells.Count; i++)
                {
                    dr[i] = row.Cells[i].Text.Replace(" ", "");
                }
                dt.Rows.Add(dr);
            }
            return dt;
        }

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 < row.Cells.Count; i++)
        {
            dataRow[i] = row.Cells[i].Text;
        }

        dataTable.Rows.Add(dataRow);
    }

    return dataTable;
}

You can call,

GridView myGridView = new GridView(); 
DataTable myDataTable = ConvertGridViewToDataTable(myGridView);

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 < dataRowView.Row.ItemArray.Length; i++)
            {
                dataRow[i] = dataRowView.Row.ItemArray[i];
            }

            dataTable.Rows.Add(dataRow);
        }
    }

    return dataTable;
}

Thanks

Hi,

I think your idea is not best practice of using datasource.

I think better you make private List