Answer Posted / dinesh sharma

_cmd.Connection = CON; //_cmd is sqlCommand and
CON is Connection
_cmd.CommandText = "select
Book_Code,ISBN,Title_Of_book from Book_Master";
SqlDataReader dr = _cmd.ExecuteReader();
dts.Columns.Add("Book_Code");
dts.Columns.Add("ISBN");
dts.Columns.Add("Title_Of_book"); DataRow drs;
while (dr.Read())
{
drs = dts.NewRow();
drs[0] = dr[0].ToString();
drs[1] = dr[1].ToString();
drs[2] = dr[2].ToString();
dts.Rows.Add(drs);

Application.DoEvents();




}
dataGridView2.DataSource = dts;


dr.Close();
_cmd.Dispose();

How would you connect to a database by using .NET?

939

---

What are all the classes that are available in System.Data Namespace?

1013

---

How to add an aggregate column?

1018

---

What are the benefits of ADO.NET?

1121

---

What are the advantages of using datalist?

1004

---

How do you update a dataset in ado.net and how do you update database through dataset?

928

---

Explain the two fundamental objects in ado.net?

992

---

What are the ado.net objects?

944

---

What is the executescalar method?

1102

---

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

999

---

What is ado control?

955

---

What is the DataTableCollection?

1053

---

Which method is used to sort the data in ADO.Net?

1978

---

What are dataproviders?

969

---

What are the advantages of oledb compared with other classes?

2794

---