Answer / mehboob ali chouhan

1.Connection
2.DataReader
3.DataAdapter
4.Command

Answer / shishir kumar patel

The major Component of Data Provider is
1-Connection
2-Command
3-datareader
4-dataadapter

Answer / rajeesh m

Dataset and .Net data provider

Answer / servesh saxena

Major components are based on major namespaces used in ADO.net

System.data
System.data.common.
System.data.sqlclient
System.data.oledb
System.data.odbc
System.data.types

theses are the majorly used namespaces any provider,dataset
reader etc are based out of these name spaces.

Why is stored procedure used in ado.net?

0 Answers  

---

What is the difference between Data adaptor and Data set?

0 Answers   HCL,

---

What is ado connection?

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 can you implement sub data grid in a master datagrid?

1 Answers  

---

Define different execute methods of ADO.NET command object ?

0 Answers   NA,

---

Describe the command object and its method.

0 Answers  

---

What is the maximum pool size in ado.net connection string?

0 Answers  

---

What are the steps you will take to improve performance?

0 Answers  

---

Explain the difference between ado and ado.net?

0 Answers  

---

Explain how to pass multiple tables in datasets simultaneously?

0 Answers  

---

How do you implement locking concept for dataset?

0 Answers  

---