Web Development

Ask something
Discussion Locked

Vb.net

0 helpful
1 reply

by a.jaya

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What is the use of sqldataAdapter, sqlCommand,Dataset,DataView in vb.net?

1 reply

by p.j.hutchison

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/

This discussion is closed to new replies.