Retriving Gridview Data to data table

Question

3.67/5 (2 votes)

See more:

Hi,

I have a requirement to copy GridView data to Datatable.

My code is below:--

.aspx:--

XML

<div>
      <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns ="false" >
      <Columns>


                    <asp:TemplateField HeaderText="Book Name">
                       <ItemTemplate>
                           <%#Eval("BookName")%>

                       </ItemTemplate>
                       </asp:TemplateField>

                    <asp:TemplateField HeaderText="Price">
                       <ItemTemplate>
                           <%#Eval("Bookprice")%>
                       </ItemTemplate>

                   </asp:TemplateField>






               </Columns>
      </asp:GridView>
  </div>

.aspx.cs:---

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataTable dt1 = new DataTable();
            dt1.Columns.AddRange(new DataColumn[2] { new DataColumn("BookName"), new DataColumn("BookPrice") });
            dt1.Rows.Add("khan Hammond", "10.00");
            dt1.Rows.Add("Mojibar", "20.50");
            dt1.Rows.Add("Saean Mathews", "11.25");
            dt1.Rows.Add("Robin Schidner", "20.35");
            Session["QtyTable"] = dt1;
            GridView1.DataSource = dt1;
            GridView1.DataBind();
        }
    }

private void getGridInfo()
{

DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("BookName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("BookPrice", typeof(String)));
for (int i = 0; i < GridView1.Rows.Count; i++)
{
dr[i] = GridView1.Rows[0].Cells[0].Text;
dr[i + 1] = GridView1.Rows[i].Cells[i].Text;
dt.Rows.Add(dr);
}
}

Now when I see the datatable,its blank.

Please post suitable code...

Thanks...

Posted 22-Jan-14 2:01am

rupai99

Updated 22-Jan-14 2:04am

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Jan-14 8:21am

Have you debugged and seen it is working or not?

2 solutions

Solution 2

just cast the Gridview to datatable as below
may it will help you

C#

private void getGridInfo()
{
   DataTable dt = (DataTable)GridView1.DataSource;
}

Posted 22-Jan-14 2:18am

Salman622

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2014-01-22T02:15:00

use this code..

C#

private void getGridInfo()
        {

            DataTable dt = new DataTable();
           
            dt.Columns.Add(new System.Data.DataColumn("BookName", typeof(String)));
            dt.Columns.Add(new System.Data.DataColumn("BookPrice", typeof(String)));
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                DataRow dr = dt.NewRow(); 
                var row = GridView1.Rows[i];
                dr[0]  = (row.Cells[0].Controls[0] as DataBoundLiteralControl).Text;
                dr[1] = (row.Cells[1].Controls[0] as DataBoundLiteralControl).Text;
               
                dt.Rows.Add(dr);
            }
        }

Retriving Gridview Data to data table

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Retriving Gridview Data to data table

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us