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")

Web Scraping Using ASP.NET

---

Private Function ScrapeHTML(ByVal strURL As String) As String

Dim objWebRequest As System.Net.HttpWebRequest
Dim objWebResponse As System.Net.HttpWebResponse
Dim streamReader As System.IO.StreamReader

Try
objWebRequest = CType(System.Net.WebRequest.Create(strURL), System.Net.HttpWebRequest)
objWebRequest.Method = "GET"
objWebResponse = CType(objWebRequest.GetResponse(), System.Net.HttpWebResponse)
streamReader = New System.IO.StreamReader(objWebResponse.GetResponseStream)
strHTML = streamReader.ReadToEnd
ScrapeHTML = strHTML
Catch ex1 As Exception

ScrapeHTML = strHTML

End Try

End Function

The Return value of the scrapeHTML hold the HTML String output of the given URL.

Do further string comparison to make your own stuffs. :)

Remove Horizontal Scrollbar in IFRAME

---

Remove the following line from your HTML Page

< ! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >


So your IFRAME won't show the Horizontal Scrollbars :)