Answer Posted / pushpendra singh

step 1---// Connection creation using Connection string
to connect SQL database

SqlConnection conn=new SqlConnection("data
source=server_name;initial catalog=database_name;integrated
security=sspi");

conn.Open();

step2----execute command using SqlCommand Class.

SqlCommand cmd=new SqlCommand("select * from asd",conn);

DataSet ds=new DataSet();

SqlDataAdapter da=new DataAdapter();
da.SelectCommand=cmd;

//insert data from dataadapter to dataset

da.Fill(ds);

dataGridView1.DataSource=ds.Tables[0];
conn.Close();

What is ole db and odbc?

860

---

What does datareader object do?

948

---

What are the namespaces used in ADO.Net to connect to a database?

1111

---

How does entity framework work?

857

---

What is connected architecture in ado.net?

978

---

Explain the basic use of "dataview" and explain its methods.

943

---

What does executereader return?

899

---

What is a string variable?

868

---

differences between ADO and ADO.NET

1029

---

What are typed and untyped dataset?

1045

---

What are the data access namespaces in .NET?

1135

---

What is ado data control?

940

---

What are the Features and disadvantages of dataset

1037

---

How to perform sorting on a table in ADO.NET?

970

---

Describe ado.net object model in detail.

947

---