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

Explain the difference between sqlcommand object and command behavior object?

529

---

Explain sqlconnection object?

529

---

What is openquery?

525

---

Which is faster datareader or dataadapter?

519

---

What are the drawbacks of using ado.net?

541

---

---

What does ado stand for?

514

---

Which namespaces are used for data access?

613

---

What is partial class?

546

---

What is oledb driver?

491

---

Which architecture does Datasets follow?

582

---

Explain the differences between oledb sql server, oledbdotnet provider?

549

---

Define isolation?

526

---

How to generate a single aggregate?

535

---

What is ado control?

519

---

Explain how to find the given query is optimised one or not?

509

---