Differences between data reader and data table

Question

Give me the answer of that question

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.

Manav Pandya · Answer

@Asmita Following is best answer : https://msdn.microsoft.com/en-us/library/ms254931.aspx

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 OrientedRead 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