dynamically create datatable name in loop using vb.net

See more:

.NET3.5

VB

.NET

Here i posted my code

i want dynamic creation of tablename. For example in while loop if i=1 then create dt1 as new datatable and i=2 create dt2 as new datatable and so on....

anybody can help me....

Dim ds1 As New DataSet
Dim ds2 As New DataSet
Dim ds3 As New DataSet
Dim ds4 As New DataSet

Dim i As Integer = 1
Dim startind As Integer
Dim endind As Integer
startind = 0
endind = 25
Dim totalcount As Double
totalcount = ds.Tables(0).Rows.Count
Dim currentcount As Double
currentcount = Math.Round(totalcount / 25)

Dim dtname As Integer = 1


If ds.Tables(0).Rows.Count > 25 Then

While (i <= currentcount)


Dim dt1 As New System.Data.DataTable
dt1 = splitrecords(ds.Tables(0),ds.Tables(0).Rows.Count, startind, endind)
ds1.Tables.Add(dt1)
End While
End If


ds2.Tables(0).TableName = "Table1"
ds3.Tables(0).TableName = "Table2"
ds4.Tables(0).TableName = "Table3"
ds1.Tables.Add(ds2.Tables(0).Copy)
ds1.Tables.Add(ds3.Tables(0).Copy)
ds1.Tables.Add(ds4.Tables(0).Copy)

ds2.Clear()
ds3.Clear()
ds4.Clear()
ds.Clear()
End If