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

Why edit is not possible in repeater?

892

---

What is bubbled event can you please explain?

962

---

What are all the commands used with Data Adapter?

969

---

What is difference between entity framework and ado.net?

880

---

What is disconnected data?

974

---

What is the difference between executequery and executenonquery?

866

---

Define isolation?

916

---

Does executenonquery return a value?

881

---

What is shadow copy?

932

---

What are the different row versions available in table?

907

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

943

---

What does executequery return?

899

---

What are the features of ado.net?

948

---

What is the meaning of executenonquery?

959

---

What is difference between Dataview and Datatable?

986

---