Collect the data

  • Thread starter Thread starter Vivek Sharma
  • Start date Start date
V

Vivek Sharma

Hi,

Under the current scenario I am fetching around 700 records in an
application and keeping the recordset open. The reason being the user wants
to navigate through the records anytime. I am not sure if it is the best
practice. Also, I have a problem. When I add a record I have to refresh
the list view control. In order to do that i have retreive the whole
recordset again.

Is there an effective way around doing so?

Please guide.

Thanks
Vivek
 
Hi,
I am not sure if you're referring to "dataset" as recordset. In .NET,
dataset is one of the ways you can get the data in-memory and navigable.
Whenever user makes update to the dataset, each data row's state is
maintained. So, you can use dataset to have your own copy of data, modify
that data as necessary before you make the permanent update to the database.
By using the dataset, you can also modify your user presentation without
fetching the data from database each time of update. I hope I get what you
want. If not, you can post your question more specific. Thank you.

Rgds,
Noble Lesmana
 
Back
Top