Monday, March 12, 2007

Retrieve and Insert Multiple DataTable into a DataSet (ASP.NET)




You can do it as following way

Public Function GenerateData(strCity as String, strState as String, Rural1 As String ) As DataSet
Dim dt As New DataTable("S1")
Dim dtData As New DataTable("S2")

Dim dr As DataRow
Dim ds As New DataSet

dt.Columns.Add("City", System.Type.GetType("System.String"))
dt.Columns.Add("State", System.Type.GetType("System.String"))
......


dtData.Columns.Add("Data1", System.Type.GetType("System.String"))
dtData.Columns.Add("Mile1", System.Type.GetType("System.String"))
......

dr = dt.NewRow
dr.Item("City") = strCity
dr.Item("State") = strState
......

dt.Rows.Add(dr)

dr = dtData.NewRow
dr.Item("Data1") = "Rural Population"
dr.Item("Mile1") = Rural1
.......

dtData.Rows.Add(dr)

ds.Tables.Add(dt)

ds.Tables.Add(dtData)

GenerateData=ds
ds=Nothing
End Function

Dim ds as New DataSet


ds=GenerateData(..., ..., ...)

Grid1.DataSource= ds.Tables("S1")
Grid2.DataSource= ds.Tables("S2")

No comments: