K
KavvY
After messing about I've made some headway towards getting a DataSet filled
with data from an SQL database, unfortunately I've been advised that this
isn't the way forward due to the overhead involved of filling the DataSet
with every page access.
So what method is prefereable to use?
Am I supposed to create a DataAdapter that only fetches a certain query,
dependant on what the users type in fields? Or am I supposed to use a
DataSet in the same way?
The book I bought is pretty useless in the respect that it focuses on the
DataSet as the all-encompasing solution to all your needs. Which I debate
TBH.
All I want to do is execute SQL queries and put the results in to text
boxes, then update the SQL tables with an update query afterwards....
Any advice greatly appreciated.
Rich.
with data from an SQL database, unfortunately I've been advised that this
isn't the way forward due to the overhead involved of filling the DataSet
with every page access.
So what method is prefereable to use?
Am I supposed to create a DataAdapter that only fetches a certain query,
dependant on what the users type in fields? Or am I supposed to use a
DataSet in the same way?
The book I bought is pretty useless in the respect that it focuses on the
DataSet as the all-encompasing solution to all your needs. Which I debate
TBH.
All I want to do is execute SQL queries and put the results in to text
boxes, then update the SQL tables with an update query afterwards....
Any advice greatly appreciated.
Rich.