How can I fill all data in DataTable in Dataset.xsd then use it latter from these datatables.?
Question by Jack J: How can I fill all data in DataTable in Dataset.xsd then use it latter from these datatables.?
I want to transfer all data from server in Datatable of Dataset.xsd files. Then I want to use these data to another place directly from these Datatables of Dataset.xsd file.
I want that my webpage sould access data faster. So I want to transfer data in local machine in the form of DataSet.xsd file or XML file. Then It can be use in another place of webpage directly from clinet machine accept INSERT,UPDATE, AND DELETE.
I have write code in startup page and fill all Datatables with Query. But When I bind Dropdownlist with these datatable it does not show anything.
Am I doing wrong or Idea is wrong… Following are the code.
myBaseClass
{
Dim myData as new myDataset
sub myFillDataset(strQuery as string, strTableName as string)
myDataAdapter.SelectCommand(”selec *from T1″,myCon)
myDataAdapter.Fill(myData,strTableName)
end Sub
End Class
In starup Page
myBaseClass.myselect(”query”,”Table”)
In ather I just bind list with these Dataset
Best answer:
Answer by trythisagain
If I understand you correctly, I don’t believe you want to do this. You want to keep everything on the server. Just grab the data you want when you need it. Provide a limited amount of data to the user initially, and hit the database again when they want to get more data (i.e., when they want to drill-down). I’m assuming you’ve got a lot of data to display.
Know better? Leave your own answer in the comments!

















