What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

1 Answers   TCS,

---

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,

---

What are the Different layers in ADO.Net?

10 Answers   eXensys,

---

What is a string variable?

0 Answers  

---

What is Dataset Object?

0 Answers  

---

---

Which is better ole db or odbc?

0 Answers  

---

What is difference between executenonquery and executequery?

0 Answers  

---

What are the different layers of ado.net?

0 Answers  

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

---

Which property is used to check whether a DataReader is closed or opened?

0 Answers  

---

What is executescalar and executenonquery?

0 Answers  

---

Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,

---