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

How to work with disconnected data - the dataset and sqldataadapter?

986

---

Which is the best method to get two values from the database?

967

---

What is the difference between connected and disconnected environment?

1105

---

What is dataadapter in ado.net?

922

---

What is data access pattern?

939

---

Explain the dataadapter class in ado.net?

1210

---

differance between ADO vs ADO.Net?

1061

---

Why is ADO.NET serialization slower than ADO ?

1052

---

What is variable view?

875

---

What is the difference between statement and preparedstatement interface?

997

---

What is an ADO.Net?

987

---

How to generate a single aggregate?

978

---

What is microsoft ado.net?

1152

---

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

1012

---

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

1111

---