Answer Posted / senthil kumar

we can use two ways to retrieve the data from database
1 -> data reader
2 -> data adapter

when you use datareader
create connection object and open the connection
SqlCommand cmd = new SqlCommand(sql,con);
cmd.CommandType = CommandType.Text;
SqlDataReader sread = cmd.ExecuteReader();
while(sread.Read())
{
String data1 = sread.GetString(0);
int data2 = sread.GetValue(1);
String data3 = sread.GetString(2);
}

when u use the dataadapter

create the connection and open
SqlDataAdapter sda = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
sda.Fill(ds,"customer");

then use can get the data in row wise or directly assign
the data to the controls through datasource.

i think its enough.If i did any mistake correct me.

Do we use stored procedure in ADO.Net?

940

---

Can you explain how to enable and disable connection pooling?

920

---

How to create data relations?

937

---

What is ado.net explain with diagram?

917

---

How can we save all data from dataset?

940

---

What is the full form of ado.net?

931

---

What is DataReader Object?

984

---

What is the provider being used to access oracle database?

936

---

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

977

---

What is the difference in record set and dataset?

975

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

947

---

Is bulk insert faster than insert?

859

---

Which object of ado contains datarow datacolumn collection?

892

---

What is dataadapter in ado.net?

873

---

How can we check that some changes have been made to dataset since it was loaded?

917

---