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 disconnected data?

577

---

What is dataset and datatable in ado.net?

496

---

What is the role of data provider in ado.net?

539

---

Explain executenonquery?

547

---

What does executenonquery () method return?

495

---

---

What is isolation?

561

---

What does sqldatareader return?

499

---

What are different layers of ADO.Net?

578

---

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

536

---

Describe ado.net object model in detail.

527

---

What is executequery?

492

---

What is ado in agriculture?

509

---

Which name space is used to get assembly details?

513

---

differences between ADO and ADO.NET

564

---

What is the difference between Datareader and Dataset?

534

---