| Other ADO.NET Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the syntax code for oldb to connect oracle | IBM | 2 |
| How to find the count of records in a dataset? | | 4 |
| How to check if a datareader is closed or opened? | | 1 |
| Difference between datareader and dataset? | Microsoft | 9 |
| what is clustered index?why is it created? | Microsoft | 3 |
| how do u connect ado.net to sql server
| Microsystems | 1 |
| How do you filter the data in datagrid? | Choice-Solutions | 1 |
| If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar() | | 4 |
| What providers do you use to connect to oracle database ? | Digital-GlobalSoft | 4 |
| What are the three Ado objects? | Microsoft | 5 |
| What is ODP.NET ? | TCS | 1 |
| What does connection string consists of ? | Digital-GlobalSoft | 1 |
| What happens when u try to update data in a dataset in .NET
while the record is already deleted in SQL SERVER as backend? | | 5 |
| Advantage of ADO.Net? | TCS | 2 |
| What are the different namespaces used in the project to
connect the database? | | 2 |
| How to retrieve the third table value from the data set? | Network-Solutions | 1 |
| How do we invoke queries from the application ? | Microsoft | 1 |
| FetCh Records No 5 to 10 From Dataset | | 3 |
| 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(); | Mind-Tree | 1 |
| If a table contains 20000 records . In a page at each time
100 records to be displayed. What are the steps u will take
to improve performance? will you use dataset or datareader? | | 5 |
| |
| For more ADO.NET Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map