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 the difference between executequery and executenonquery?

969

---

What is Dataset Object?

1056

---

What is the current version of entity framework?

1017

---

Is datareader faster than datatable?

1017

---

What is data relation?

967

---

What is difference between datareader and dataadapter?

1090

---

Does executenonquery return a value?

1002

---

How will you fill the gridview by using datatable object at runtime?

1105

---

What is ado.net architecture?

969

---

What is disconnected scenario in entity framework?

1163

---

What is the use of SqlCommand object?

1283

---

What is DataRowCollection?

1146

---

How do I delete a row from a DataTable?

1229

---

Give few examples of datareader that is used in different dataproviders.

1009

---

What is data adapter in ado.net with example?

1103

---