Thanks Ken that was helpful,
im currently using the following code to populate my dataset.
If Cache("cch_Dataset") Is Nothing Then
xmlFeed =
DirectCast(WebRequest.Create("http://www.anylink.com"), HttpWebRequest)
xmlData = New DataSet
xmlData.ReadXml(xmlFeed.GetResponse().GetResponseS tream())
Cache("cch_Dataset") = xmlData
Response.Write("<img name=IMAGE
src=http://www.anylink.com//" &
Trim(xmlData.Tables(0).Rows(0).Item("i1") & " width=120 height=76
border=0>"))
Response.Write(Trim(xmlData.Tables(0).Rows(0).Item ("textdetail")))
End If
there is a time lag of between 10 - 15 seconds before the data is
pulled in and displayed on the load event, other sites that use the
same third party dont appear to have any time lag. is this the best
way to do it ????
what other options do i have - i think other sites do it almost
instantly.
Any help appreciated.
Cg
Ken Cox - Microsoft MVP wrote:
Hi CG,
Once you've got the data in a dataset, use the DataView's RowFilter property
to filter down to the parts you want. You just create an expression that
acts somewhat like a SQL query of the datatable.
dv.RowFilter = "City = 'Berlin'"
http://msdn.microsoft.com/library/de...iltertopic.asp
http://msdn.microsoft.com/library/de...tviewtopic.asp
Ken
Microsoft MVP [ASP.NET]
"csgraham74" <cs********@gmail.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com... Hi Guys,
hopefully someone can help me with an issue. I have recenlty linked to
third party to receive data in XML format which i then want to display
on my site. The provider supplies a large amount of data which i want
to be able to search on the various fields using a web form (drop downs
etc) i then want to display the appropriate results of the search in a
datagrid. i need to search on price (greater than and less than) and
on a free text search
I have the part where i populate the dataset but how do i search within
a dataset ???? is this even possible ?? An idea was to populate my
database table with the data but i would have to do this every time and
therefore this would slow down my application.
any hints, tips or advice greatly appreciated.
Regards,
CG