Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers   Wipro,

---

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

---

What is sequence of code in retrieving data from database ?

3 Answers   Accenture, BirlaSoft,

---

What is a sqldataadapter?

0 Answers  

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

---

What is dataset and datatable in ado.net?

0 Answers  

---

What are the parameters that control most of connection pooling behaviors?

0 Answers  

---

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

0 Answers  

---

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

---

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

Can you edit data in the Repeater control?

9 Answers  

---

Differences between dataset.clone and dataset.copy?

2 Answers   Ksb, TCS,

---