RE: Collect the data

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

"Vivek Sharma" wrote:

> 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
>
>
>
.

Relevant Pages

  • Re: Connection types and speeds
    ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
    (microsoft.public.access.queries)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... return another column from the database that stores the users 1st name :-) ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ... ' validate variables against database ...
    (microsoft.public.inetserver.asp.db)
  • Re: Recordset problem
    ... This is why I'm trying to use Recordset. ... Dim strPrice As String ... >> Dim dbs As Database ... >You don't need to open the database object dbs before ...
    (microsoft.public.access.modulesdaovba)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ... ' validate variables against database ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ... ' validate variables against database ...
    (microsoft.public.inetserver.asp.db)