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();
}

Is entity framework better than ado.net?

1018

---

Why do we need ado.net?

969

---

What is the difference between a datareader and a dataset?

1043

---

What is the difference between oledb sql server and oledbdotnet provider?

1014

---

What is bubbled event?

976

---

What are all the different methods under sqlcommand?

989

---

What is connected architecture in ado.net?

1074

---

What is data access pattern?

946

---

What is dataset object? Explain the various objects in dataset.

1052

---

What are the advantages using ado.net?

1039

---

Explain the advantage of ADO.Net?

991

---

Explain the difference between ado and ado.net?

941

---

What are the important features of ado.net 2.0?

1076

---

Explain executenonquery?

1140

---

Which name space is used to get assembly details?

994

---