How to aggregating data across related tables?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ADO.NET Interview Questions

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,


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 is difference between entity framework and ado.net?

0 Answers  


How do you sort the data in datagrid?

4 Answers   Choice Solutions,


Define table relations?

0 Answers  






What is partial class?

0 Answers  


Which type of database is used while processing dynamic database?

1 Answers   Microsoft,


Explain the ADO . Net Architecture ( .Net Data Provider) ?

2 Answers  


List all the steps in order, to access a database through ado.net?

0 Answers  


Difference between function and trigger?

1 Answers   HCL,


What is data adapter in ado.net with example?

0 Answers  


What is ado in agriculture?

0 Answers  


Categories