Answer / vaishuparmar

.it's used with aggregate functions.
.there are main 5 aggregate function max,min,sum,avg,and count..
.it returns only one value at a time.
.it fetches the data from the database.
.it returns only first column of first row.

Explain the namespaces in which .net has the data functionality class.

0 Answers  

---

What is sqlconnection and sqlcommand?

0 Answers  

---

What are the key features of ado.net?

0 Answers  

---

What is row state?

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 do you update database through dataset?

0 Answers  

---

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?)

0 Answers  

---

What are the benefits of ADO.NET?

0 Answers   B-Ways TecnoSoft,

---

What are the differences between OLEDB and SQLClient Providers?

0 Answers  

---

What are the advantages of oledb compared with other classes?

0 Answers  

---

Define atomicity?

0 Answers  

---

What is difference between datagridview and datagrid control in winforms?

0 Answers  

---