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 8567

What is the default view of Data Grid?

TCS,

5 14855

what is Sql Native Client?

Gantec Solutions,

5 18735

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 16180

what is the syntax code for oldb to connect oracle?

2 5118

what is execute scalar?

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

11 24635

what is Execute NOn Query?

Infosys, Protech, Sars Systems, SwanSoft Technologies,

29 68622

what is the syntax code for oldb to connect oracle

IBM,

3 6459

what is the syntax code to oledb to connect oracle

IBM,

6 11796

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

HCL,

5 11655

how do u connect ado.net to sql server

Microsystems,

1 5888

how to keep track of index in listbox items.

2 5719

How do we invoke queries from the application

2 4596

Why sql Data Reader object not created

Matrix,

9 22111

what is the criteria of selection in sbi interview?

BCS, State Bank Of India SBI,

1 4862

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What are two types of transaction supported by ado.net?

996

Define Execute Scalar?

1021

What are all the classes that are available in System.Data Namespace?

1013

What are the benefits of using ado.net?

1006

How to identify the controls which can be used for binding data?

1000

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1002

What is a string variable?

917

What is openquery?

987

What are the drawbacks of using ado.net?

979

Explain the advantages and disadvantages of using datalist?

1074

What is the return type of executescalar?

1017

What is an example of ordinal data?

1142

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2382

What is a control toolbox?

968

how Sequence to connect and retrieve data from database using dataset?

1295

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