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.

What is the difference between dataset and datatable?

985

---

How can I retrieve two tables of data at a time by using data reader?

988

---

Explain the basic use of "dataview" and explain its methods.

977

---

Explain how can we load multiple tables in to dataset?

922

---

What is the difference between typed and untyped dataset?

1055

---

Explain the different row versions available in table?

1036

---

What are the parameters that control most of connection pooling behaviours?

1049

---

Compare Data Reader & Dataset in ado.net?

976

---

How to Read, Add, Update and Delete record in Entity Framework ?

1017

---

What does ado stand for?

890

---

What is adodb dll?

981

---

What is the role of clr?

927

---

What are the objects of ado.net?

1053

---

How can we save all data from dataset?

981

---

How to create data relations?

975

---