Answer Posted / senthil kumar

if you use sql server
SqlConnection con = new SqlConnection();
con.ConnectionString ="Data Source=servername;Initial
Catalog=databasename;";
con.Open();
String sql;
sql ="select * from tbl_tablename";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
while(reader.Read)
{
Console.WriteLine("Field1:"+read.GetString(0));
Console.WriteLine("Field1:"+read.GetString(1));
Console.WriteLine("Field1:"+read.GetValue(2));
}
con.Close();
}

Define data access layer?

904

---

What is ado full form?

966

---

What is ado.net connection?

911

---

What is ado.net objects?

910

---

What is difference between ado and other data object?

865

---

Which name space is used to get assembly details?

923

---

What is the purpose of using adodb?

904

---

differance between ADO vs ADO.Net?

996

---

How can we load multiple tables in to dataset?

1033

---

What is an example of ordinal data?

1050

---

What are all components of ADO.Net data provider?

1007

---

How to read data with the sqldatareader ?

924

---

What are the essential features of ado.net?

899

---

What is a non query?

889

---

What is ado.net and its architecture?

1076

---