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 the executescalar method?

523

---

Why is stored procedure used in ado.net?

549

---

What are the different ado.net namespaces are available in .net?

499

---

What is ado.net and its features?

503

---

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

530

---

---

What are all the different authentication techniques used to connect to MS SQL Server?

546

---

Which parameter of ConnectionString is used to specify the name of the database?

553

---

How do you connect to sql server database without using sqlclient?

564

---

how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

3724

---

Which ado.net object is very fast in getting data from the database?

654

---

What is a serialized object?

538

---

How do you merge 2 datasets into the third dataset in a simple manner?

540

---

What is ole access?

552

---

differences between ADO and ADO.NET

574

---

Explain what are acid properties?

544

---