Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQLClient Classes - Best Practice

Thread Tools

SQLClient Classes - Best Practice

Posts: n/a
Can anyone recommend any article which differentiates, between
all the sqlClient classes. As I am getting confused as to which is the
best approach, bearing in mind my desire to have efficient access and
avoid unnecessary trips to the server .

I suppose my requirements are an 'updateable' RecordSet
and a 'read only' RecordSet, but the SQLReader seems as though it will
not work in a paging environment, as it is read forward only.

If one has a recordset, which consists of two tables - is it possible
to update that dataset, so that both or either one are updated. Like
in MSAccess when the datgrid view allows this.

How is a DataTable different from a DataAdapter ?

While wanting to release resources with Close or Dispose - what are the
arguments if say the recordset is to be re-selected with a different

Thanks for any help or pointers - Richard

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Best practice in organize classes into modules Steven Woody Python 3 01-09-2009 10:34 AM
Best practice in organize classes into modules Steven Woody Python 0 01-09-2009 04:57 AM
Remember when your piano teacher taught you, "Practice, practice,practice ...?" Wayne Wastier Windows 64bit 3 06-10-2005 08:29 PM
Re: vbc cant find William F. Robertson, Jr. ASP .Net 0 07-28-2003 04:59 PM
difference between SQLclient class and Oledb client Yangtsi River ASP .Net 0 07-02-2003 05:42 AM