Creating a DataTable object with dummy data

Question

I am trying to databind a DataTable to an accordion and I have found that If I retrieve the DataTable from a database using a table adapter it binds to the accordion perfectly however what I want to do is create a dummy table (for testing purposes if I don't have access to my database) the code to create the dummy table is below:

    DataTable table2 = new DataTable("articletable");
    table2.Columns.Add("articleID");
    table2.Columns.Add("title");
    table2.Columns.Add("content");

    DataRow row = table2.NewRow();
    row[0] = "1";
    row[1] = "article name";
    row[2] = "article contents go here";
    table2.Rows.Add(row);

When I try to data bind that table however the accordion does not display. I can bind it to a gridview or detailsview but not the accordion.

can you try to add more information to the columns such as dTable.Columns.Add("firstName", Type.GetType("System.String"))? — Henry Gao, Oct 29 '09 at 17:23
I could try that but as I said before I can databind that table to a gridview with no issues. — Morgeh, Oct 29 '09 at 17:42

score 26 · Accepted Answer · answered Jul 26 '10 at 13:55

After 4 hours of banging my head against the wall, I discovered that the DataSource field is VERY picky.

Here's my code:

DataSet ds = new DataSet();

        DataTable dt = new DataTable();
        dt.Columns.Add("Name");
        dt.Columns.Add("Branch");
        dt.Columns.Add("Officer");
        dt.Columns.Add("CustAcct");
        dt.Columns.Add("Grade");
        dt.Columns.Add("Rate");
        dt.Columns.Add("OrigBal");
        dt.Columns.Add("BookBal");
        dt.Columns.Add("Available");
        dt.Columns.Add("Effective");
        dt.Columns.Add("Maturity");
        dt.Columns.Add("Collateral");
        dt.Columns.Add("LoanSource");
        dt.Columns.Add("RBCCode");

        dt.Rows.Add(new object[] { "James Bond, LLC", 120, "Garrison Neely", "123 3428749020", 35, "6.000", "$24,590", "$13,432",
            "$12,659", "12/13/21", "1/30/27", 55, "ILS", "R"});

        ds.Tables.Add(dt);

        accReportData.DataSourceID = null;
        accReportData.DataSource = ds.Tables[0].DefaultView;
        accReportData.DataBind();

Turns out that the accordion only likes being bound to a dataset table's defaultview. I tried binding to just a DataTable (dt) and it failed. Even dt.DefaultView failed. Once I added it to a DataSet, it binds like a champ. Very annoying, with lost of wasted time. I know you've probably long-since forgotten this, but I wanted to make it available to future searchers. Accordion.DataSource must be bound to a DataSet.Table.DefaultView to work.

score 1 · Answer 2 · answered Oct 30 '09 at 00:30

1

Make sure you specify a type for the columns in the table2.Columns.Add(...)

answered Oct 30 '09 at 00:30

Nestor

13,706
11
78
119

score 0 · Answer 3 · edited May 23 '17 at 12:00

0

Also, as seen in the answer below:

https://stackoverflow.com/a/6108163/637903

You can bind the Accordion Control to a DataTableReader constructed from the original DataTable

accReportData.DataSource = new System.Data.DataTableReader(ds.Tables[0]);
accReportData.DataBind();

edited May 23 '17 at 12:00

Community

1
1

answered Jun 21 '13 at 21:17

Pythonian

1
4

Creating a DataTable object with dummy data

3 Answers3

Linked