Answer Posted / khalid

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection
//If u provide uname & passwd to ur Database then this state //is true
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;uid=sa;pwd=;");
//else
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;");

con.Open();
if(con!=null)
msgbox("Connection sucessfully Done!");
else
msgbox("Sorry!Connection sucessfully is not Done!");

What are the different layers of ado.net?

1011

---

What is ado and dao?

900

---

Compare Data Reader & Dataset in ado.net?

941

---

Explain the two fundamental objects in ado.net?

906

---

Explain the namespaces in which .net has the data functionality class.

1008

---

What is ole access?

884

---

What are the advantages and disadvantages of using datalist?

984

---

What is the full form of ado.net?

930

---

What is ado.net full form?

935

---

Why is stored procedure used in ado.net?

1029

---

how can implement dropdownlist in particular of dataset when try to update?

2720

---

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

917

---

Explain the role of data provider in ado.net?

933

---

Explain the advantages and disadvantages of using datalist?

1027

---

describe the dataset object in ado.net.

904

---