ADO.NET Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ADO.NET Interview Questions

Questions Answers Views Company eMail

what is data access layer?

Honeywell,

2 8437

What is the default view of Data Grid?

TCS,

5 14631

what is Sql Native Client?

Gantec Solutions,

5 18474

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, TCS,

2 16044

what is the syntax code for oldb to connect oracle?

2 4999

what is execute scalar?

Atharva Infotech, Dohatec New Media, Make eIT, Protech,

11 24100

what is Execute NOn Query?

Infosys, Protech, Sars Systems, SwanSoft Technologies,

29 67547

what is the syntax code for oldb to connect oracle

IBM,

3 6290

what is the syntax code to oledb to connect oracle

IBM,

6 11559

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

HCL,

5 11431

how do u connect ado.net to sql server

Microsystems,

1 5760

how to keep track of index in listbox items.

2 5599

How do we invoke queries from the application

2 4458

Why sql Data Reader object not created

Matrix,

9 21753

what is the criteria of selection in sbi interview?

BCS, State Bank Of India SBI,

1 4750

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What are the connected and disconnected modes in ado.net?

857

What is row state?

927

How would you connect to database using .NET?

985

How will you fill the gridview by using datatable object at runtime?

981

What is openquery?

925

How do you find the count of records in a dataset?

914

What are the namespaces used in ADO.Net to connect to a database?

1111

Which method is used to sort the data in ADO.Net?

1922

What is difference between connected and disconnected architecture in ado.net?

1101

How do you update database through dataset?

940

What is Serialization in .NET? what are the types of Serialization?

1026

Explain the difference in record set and dataset?

878

What is the full form of ado.net?

936

How to maintain the relation between two tables in ADO.NET?

954

What is ado net stands for?

909

For More Un-Answered { ADO.NET } Questions Click Here