How to dynamically create columns in datatable and assign values to it?

vb.net datatable vb.net-2010
Anuya picture Anuya · Jun 28, 2012 · Viewed 113.2k times · Source

I will have to create columns in datatable during runtime and assign values to it. How can i do it in vb.net. Any sample please...

Answer

RKK picture RKK · Jun 28, 2012

If you want to create dynamically/runtime data table in VB.Net then you should follow these steps as mentioned below :

  • Create Data table object.
  • Add columns into that data table object.
  • Add Rows with values into the object.

For eg.

Dim dt As New DataTable

dt.Columns.Add("Id", GetType(Integer))
dt.Columns.Add("FirstName", GetType(String))
dt.Columns.Add("LastName", GetType(String))

dt.Rows.Add(1, "Test", "data")
dt.Rows.Add(15, "Robert", "Wich")
dt.Rows.Add(18, "Merry", "Cylon")
dt.Rows.Add(30, "Tim", "Burst")

Related questions

Loop through the rows of a particular DataTable

IDE : VS 2008, Platform : .NET 3.5, Hi, Here is my DataTable columns : ID Note Detail I want to write sth like this : //below code block is not the right syntax For each q in dtDataTable.Column("Detail") strDetail = Row of Column Detail …

Read More
How to append one DataTable to another DataTable

I would like to append one DataTable to another DataTable. I see the DataTable class has two methods; "Load(IDataReader)" and "Merge(DataTable)". From the documentation, both appear to 'merge' the incoming data with the existing DataTable if rows exist. …

Read More
DataTable already belongs to another DataSet

This error is occuring while adding one datatable from a dataset to another ."DataTable already belongs to another DataSet." dsformulaValues.Tables.Add(m_DataAccess.GetFormulaValues (dv.ToTable.DefaultView.ToTable(False, strSelectedCols)).Tables(0))

Read More