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 ado.net dead?

957

---

What is the usage of the dataset object in ado.net?

923

---

What is serialization and de-serialization in .net?

884

---

What is the difference between oledb sql server and oledbdotnet provider?

960

---

Does executenonquery return a value?

892

---

What is ole2 format?

855

---

Does sqlclient and oledb class share the same functionality?

880

---

How to add a javaScript function in a datagrid?

1064

---

What is ado.net components?

903

---

What is sql connection in ado.net?

901

---

Why edit is not possible in repeater?

900

---

What is ole in excel?

901

---

What is ado asp?

954

---

What is the difference between dataset and datatable?

948

---

What are advantages of microsoft-provided data provider classes in ado.net?

955

---