Can datareader hold data from multiple tables?

0 Answers  

---

FetCh Records No 5 to 10 From Dataset

4 Answers  

---

Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,

---

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

4 Answers  

---

How we can provide data to ado.net?

0 Answers  

---

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

0 Answers   EDS,

---

What is the functionality of data provider in ado.net?

0 Answers  

---

Is datareader faster than datatable?

0 Answers  

---

What is openrowset?

0 Answers  

---

Explain acid properties?

4 Answers  

---

What is the difference between executenonquery () and executescalar ()?

0 Answers  

---

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,

---