Posted By

miziomon on 01/12/07

Tagged

datatable

Versions (?)

Advertising

Who likes this?

1 person has marked this snippet as a favorite

haoji

Create DataTable

Published in: VB.NET

Website Promotion
DIRECTORY is a crucial factor for all websites that need to gain better organic search engine rankings and increase website traffic.
Submitting your website as part of your Web Promotion strategy to our SEO friendly and high traffic Business Directory for review is an excellent way to gain a valuable backlink and increase your websites visibility online.

Howto create a new datatable manually

Expand | Embed | Plain Text

Public Function CreateDatatable() as DataTable
        ' Create new datatable
        Dim mydatatable As New DataTable
        ' Create columns
        mydatatable.Columns.Add("field_a", Type.GetType("System.String"))
        mydatatable.Columns.Add("field_b", Type.GetType("System.String"))
        ' Declare row
        Dim myrow As DataRow
        ' create new row
        myrow = mydatatable.NewRow
        myrow("field_a") = "filed a row 1"
        myrow("field_b") = "filed b row 1"
        mydatatable.Rows.Add(myrow)
        ' create another row
        myrow = mydatatable.NewRow
        myrow("field_a") = "filed a row 2"
        myrow("field_b") = "filed b row 3"
        mydatatable.Rows.Add(myrow)
        ' return the datatable filled with 2 columns and rows
        return mydatatable
End Sub

Report this snippet

Comment: