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 ole used for?

934

---

What is a datareader object?

1090

---

Explain the different row versions available in table?

1049

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1095

---

Define ado.net?

1096

---

What are different layers of ADO.Net?

1088

---

What are the different layers of ado.net?

1066

---

Which parameter of ConnectionString is used to specify the name of the database?

1037

---

What are all features of ADO.Net?

976

---

Which provider is used to connect ms access, oracle, etc…?

995

---

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

1006

---

What is dao and ado?

923

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1332

---

Which is better entity framework or ado.net?

1035

---

What is acid in ado.net?

1020

---