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 are all the classes that are available in System.Data Namespace?

1004

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

998

---

Does executenonquery return a value?

941

---

How do I delete a row from a DataTable?

1154

---

What is two way data binding android?

986

---

What are the advantages and disadvantages of using datalist?

1076

---

What does executereader return?

966

---

What does executenonquery () method return?

929

---

What are all the different authentication techniques used to connect to MS SQL Server?

1077

---

What is ado.net tutorial?

926

---

What is the use of connection object in ado.net?

1052

---

Describe connection object in ado.net

1028

---

What is bubbled event?

968

---

Is datareader faster than datatable?

960

---

Define ado.net?

1100

---