difference between Data Set, Data Reader,Data Adapter

[donilourdu]

hi all.

1) I want know the difference betwwen DataSet,DataReader,DataAdapter.

2) How can I call Stored Procedure in vb.net

with regards,
Doni

[aaryan]

hi all.

1) I want know the difference betwwen DataSet,DataReader,DataAdapter.

2) How can I call Stored Procedure in vb.net

with regards,
Doni

hi doni,
Data reader is an object through which you can read a sequential stream of data. it's a forward only data wherein you cannot go back to read previous data.
data set and data adapter object help us to work in disconnected mode. data set is an in cache memory representation of tables. the data is filled from the data source to the data set thro' the data adapter. once the table in the dataset is modified, the changes are broadcast to the database back thro; the data adapter.
to know the usage of each, follow the link,

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson04.aspx

stored procedures can be accessed from the coding thro' ado.net
for that you have to mention your command type as stored procedure.

[rakeshkashnia]

Using procedures in vb.net

Dim con As New SqlClient.SqlConnection(Session("ConnectionString" ))
Dim adpater As SqlClient.SqlDataAdapter
Dim ndtTempTable As DataTable
Dim dRow As DataRow
adpater = New SqlClient.SqlDataAdapter
adpater.SelectCommand = New SqlClient.SqlCommand("SelectComand", con)
adpater.SelectCommand.CommandType = CommandType.StoredProcedure

adpaterSelectCommand.Parameters.Add(New SqlClient.SqlParameter("@ClientID", SqlDbType.Int, 4))
adpater.SelectCommand.Parameters("@ClientID").Valu e = niClientId


Regards,
Rakesh Kashnia

[r035198x]

hi all.

1) I want know the difference betwwen DataSet,DataReader,DataAdapter.

2) How can I call Stored Procedure in vb.net

with regards,
Doni

Why don't you read the specs for those classes and see for yourself.