How to create dynamic datatable?

Question

I would like to create a list of datatable dynamically, something like :

 DataTable[] Mydt = new DataTable();

and fill it like :

Mydt[i] = .....

Do you know if such a syntax exist in c# ?

Thanks

Chamika Sandamal · Accepted Answer · 2012-05-01 07:16:04Z

16

You can use following code sample,

    private static DataSet SampleData()
    {
        DataSet sampleDataSet = new DataSet();
        sampleDataSet.Locale = CultureInfo.InvariantCulture;
        DataTable sampleDataTable = sampleDataSet.Tables.Add("SampleData");

        sampleDataTable.Columns.Add("FirstColumn", typeof(string));
        sampleDataTable.Columns.Add("SecondColumn", typeof(string));
        DataRow sampleDataRow;
        for (int i = 1; i <= 49; i++)
        {
            sampleDataRow = sampleDataTable.NewRow();
            sampleDataRow["FirstColumn"] = "Cell1: " + i.ToString(CultureInfo.CurrentCulture);
            sampleDataRow["SecondColumn"] = "Cell2: " + i.ToString(CultureInfo.CurrentCulture);
            sampleDataTable.Rows.Add(sampleDataRow);
        }

        return sampleDataSet;
    }

answered May 1, 2012 at 7:16

Chamika Sandamal

24.4k5 gold badges68 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

matao Over a year ago

you should add a call to sampleDataTable.AcceptChanges() before you return the table in order to mark all rows as unchanged.

Collectives™ on Stack Overflow

How to create dynamic datatable?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related