Differences between data reader and data table

Asmita Hirdekar

9y1kLearn iOS Programming

Give me the answer of that question

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1
0
Bharathi Raja8y ago
http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1
0
Bikesh Srivastava9y ago
DataTable:-This one is used to contains data in tabular form in c#
Datareader:-this one use to read the no chance to apply dml command.and can not create object directly.
0
Gnanavel Sekar9y ago
Data Reader :
Connection Oriented,Read only, it will not update the DB record just to retrieve from db.

example :

protected void BindGrid()
{
using (SqlConnection conn = new SqlConnection("Data Source=servername;Integrated Security=true;Initial Catalog=dbname"))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from tblname", con);
SqlDataReader sdr = cmd.ExecuteReader();
gvtblInfo.DataSource = sdr;
gvtblInfo.DataBind();
conn.Close();
}
}

DataTable :

it's just single table in db, It has collection of rows and columns,
Collection rows and columns is called datatable,
collection datatable is called dataset

Example
SqlCommand cmd = new SqlCommand("select record from table", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

gvtblInfo.DataSource = dt;
gvtblInfo.DataBind();

For More...

Follow below links:

http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-datatable-and-dataadapter-in-asp-net1

http://www.aspdotnet-suresh.com/2012/10/aspnet-difference-between-datareader.html

0
Mayank9y ago
Hi Asmita,

Below link give you a brief idea with examples.

http://www.codefordotnet.com/Asp.net/differnce_between_dataset_and_datareader_aspnet.aspx

If it solve your issue please mark as answer.
+1
Manas Mohapatra9y ago
Follow below links:

http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-datatable-and-dataadapter-in-asp-net1

http://www.aspdotnet-suresh.com/2012/10/aspnet-difference-between-datareader.html
0
Nitin Sontakke9y ago
Did you google that? There are several articles explaining this.
If you don't understand any specific point in any explaination, that can be discussed.
+1