Getting Data from a Table Control into a DataTable

[gchq]

Hi

Is there a way to get the data held in cells of a Table control into a DataTable? Since essentially (as I understand it) a DataTable is a Table element with <thead> and <tbody> elements there must be a method, but I haven't been able to find it yet!

[channaJ]

Hi

Is there a way to get the data held in cells of a Table control into a DataTable? Since essentially (as I understand it) a DataTable is a Table element with <thead> and <tbody> elements there must be a method, but I haven't been able to find it yet!

Hi gchq,

By 'Table control' you are refering to a HTML table right..?

HTML table is rendered in the client side. If you want to add data to a DataTable, those data should be accessed from the server side. So it's not possible to do this.

Why don't you use a DataGrid server control here, which you can access from the server side.

[gchq]

Hi gchq,

By 'Table control' you are refering to a HTML table right..?

HTML table is rendered in the client side. If you want to add data to a DataTable, those data should be accessed from the server side. So it's not possible to do this.

Why don't you use a DataGrid server control here, which you can access from the server side.

By Table Control I meant a HTML Table that is now (by virtue of an id and runat=server) is also a .NET server control!

[channaJ]

By Table Control I meant a HTML Table that is now (by virtue of an id and runat=server) is also a .NET server control!

OK..then your table works as a server control. Now you can access it from the server side. Check the following code.

            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("td1");
            dataTable.Columns.Add("td2");
            foreach (HtmlTableRow row in tblTest.Rows)
            {
                object[] values = new object[row.Cells.Count];
                for (int x = 0; x < row.Cells.Count; x++)
                {
                    values[x] = row.Cells[x].InnerText;
                }
                dataTable.Rows.Add(values);
            }
 

Here tblTest is your HTML table. Hope this will make sence. Let me know if not.

[gchq]

OK..then your table works as a server control. Now you can access it from the server side. Check the following code.

            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("td1");
            dataTable.Columns.Add("td2");
            foreach (HtmlTableRow row in tblTest.Rows)
            {
                object[] values = new object[row.Cells.Count];
                for (int x = 0; x < row.Cells.Count; x++)
                {
                    values[x] = row.Cells[x].InnerText;
                }
                dataTable.Rows.Add(values);
            }
 

Here tblTest is your HTML table. Hope this will make sence. Let me know if not.

Thanks for the heads up on that - "HtmlTableRow" was the key I was looking for:_

Dim gTable As New DataTable()
        Dim gRow As DataRow = Nothing
        gTable.Columns.Add("Amount") 'GetType(Double))
        gTable.Columns.Add("Item_Date") 'GetType(Date))
        Dim row As HtmlTableRow
        For Each row In Table1.rows
            gRow = gTable.NewRow()
            gRow("Amount") = row.Cells(0).InnerText
            gRow("Item_Date") = row.Cells(1).InnerText
            gTable.Rows.Add(gRow)
        Next
 
        'test with gridview
        GridView1.DataSource = gTable
        GridView1.DataBind()

Works a treat! Thanks again!

Just got to to mess with coverting the types and I'm there :-)