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")
Monday, March 12, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment