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

Is bulk insert faster than insert?

920

---

Does executenonquery return a value?

951

---

What is difference between executequery and executeupdate?

1007

---

How to enable and disable connection pooling?

1056

---

What are three methods for displaying data in a syncfusion datagrid

1072

---

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?

988

---

What are different layers of ADO.Net?

1093

---

Which is the feature of ado.net?

1014

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1110

---

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

995

---

What is difference between ado and other data object?

913

---

How to store data in memory?

954

---

What is csdl entity framework?

1022

---

Do we use stored procedure in ADO.Net?

992

---

What is the use of sqldatareader class?

1003

---