Differences between data reader and data table

Question

Give me the answer of that question

Bharathi Raja · Answer

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

Mayank · Answer

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.

Nitin Sontakke · Answer

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.

Mageshwaran R · Answer

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

Bikesh Srivastava · Answer

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.

Gnanavel Sekar · Answer

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

Manas Mohapatra · Answer

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

Differences between data reader and data table

Answers (7)