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

What is different between sqlcommand object and command behavior object?

1118

---

Does executenonquery return a value?

999

---

What are different layers of ADO.Net?

1144

---

What is ado full form?

1070

---

What do you know about ado.net's objects?

1062

---

What is a dynaset in access?

1102

---

What is microsoft ole db provider for sql server?

972

---

What is full form of ado?

1135

---

Which database is the ado.net sql connection object designed for?

1085

---

What is ado net stands for?

1007

---

What are the advantages of using datalist?

1043

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

1017

---

What are the pre-requisites for connection pooling?

1056

---

Name which operations can you not perform on an ado.net dataset?

1038

---

What is the use of SqlCommand object?

1282

---