Web Development

General discussion



By a.jaya ·
What is the use of sqldataAdapter, sqlCommand,Dataset,DataView in vb.net?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by p.j.hutchison In reply to Vb.net

SQLDAtaAdapter allows you to create sql select, insert, update and delete command strings using a simple Wizard and can be called from VB code.
A SQLCommand can be used to send ad hoc sql commands to a server to do other select, insert or update commands.
A Dataset is a 'cached' copy of data from the database for local manipulation. Eg you can run a select statement and then store it in an array in memory for processing.
A DAtaview is basically used to get data but have it in a different format eg different number of fields, different sort order or filtering features.
More info is available with Visual Studio on line help and at http://msdn.microsoft.com/

Related Discussions

Related Forums