types of Store procedure in Sqlserver2000?

4 Answers  

---

What is dataset object? Explain the various objects in dataset.

0 Answers  

---

How to identify the updated rows in a dataset?

0 Answers  

---

Which is the best method to get two values from the database?

0 Answers  

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

---

What is the full form of ado?

0 Answers  

---

What are the data access namespaces in .NET?

0 Answers  

---

What is ODP.NET ?

1 Answers   TCS,

---

What we do with the object of ado.net dataset after using it?

0 Answers  

---

What is a datagridview?

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,

---

How many commands does the oledbcommand takes?what are they?

2 Answers  

---