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.

Explain ODP.net

1064

---

How to creating a SqlCommand Object?

1199

---

Which is faster sqldataadapter and sqldatareader?

982

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

1018

---

How can we perform transactions in .net?

1107

---

What are the different row versions available in table?

1033

---

What is aggregating data ?

1027

---

What are the benefits of using of ADO.NET in .NET 4.0?

1154

---

How do you update a dataset in ado.net?

1064

---

Explain how to create dynamic gridview?

1019

---

What are dataproviders?

1024

---

Is entity framework better than ado.net?

1077

---

Which object needs to be closed?

2309

---

Explain why edit is not possible in repeater?

1101

---

Some important instruction regarding ADO.NET connection string ?

1048

---