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

What is namespace in ado.net?

1078

---

What is the DataTableCollection?

1097

---

What is the meaning of object pooling?

1310

---

Explain what is datagrid with an example?

1145

---

How to aggregating data across related tables?

1096

---

Explain the difference between sqlcommand object and command behavior object?

1149

---

What is sql connection in ado.net?

1012

---

What are dataproviders?

1021

---

What is ado and rdo?

961

---

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

1005

---

Explain the advantages and disadvantages of using datalist?

1110

---

What is the meaning of executenonquery?

1137

---

Name which operations can you not perform on an ado.net dataset?

1038

---

What is connection pooling and what is the maximum pool size in ado.net connection string?

986

---

What is the difference between the clone() and copy() methods of the dataset class?

1149

---