| Other ADO.NET Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the provider and namespaces being used to access
oracle database? | Microsoft | 2 |
| What are the different namespaces used in the project to
connect the database? | | 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 | 2 |
| Sequence to connect and retrieve data from database useig
dataset ? | MMTS | 3 |
| What is @@rowcount and with small code snippet explain the
usage? | BirlaSoft | 4 |
| what is the syntax code for oldb to connect oracle? | | 1 |
| Difference between datareader and dataset? | Microsoft | 12 |
| If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar() | | 4 |
| What is main five diffrent between Connected And
Disconnected environment | Wipro | 4 |
| What does connection string consists of ? | Digital-GlobalSoft | 1 |
| what is clustered index?why is it created? | Microsoft | 3 |
| ADO and ADO.NET differences? | Microsoft | 3 |
| What is Pooling? what is data pooling? what is sql pooling? | TCS | 1 |
| I am fresh graduate, trained in C# .net.
How do i answer when interview ask me ,
Where do you see yourself within 5 years from now? | | 2 |
| what is execute scalar? | Protech | 6 |
| 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 |
| Why DataReader is Forward Only? | NIIT | 9 |
| Differnces between oracle 9i and sql server? | Microsoft | 2 |
| how to display empty table to datagrid | LG-Soft | 1 |
| how to add a selected row of a gridview to another gridview
without reloading the page?? | | 1 |
| |
| For more ADO.NET Interview Questions Click Here |