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 8643

What is the default view of Data Grid?

TCS,

5 15020

what is Sql Native Client?

Gantec Solutions,

5 18910

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 16276

what is the syntax code for oldb to connect oracle?

2 5202

what is execute scalar?

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

11 25025

what is Execute NOn Query?

Infosys, Protech, Sars Systems, SwanSoft Technologies,

29 69464

what is the syntax code for oldb to connect oracle

IBM,

3 6590

what is the syntax code to oledb to connect oracle

IBM,

6 11977

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

HCL,

5 11798

how do u connect ado.net to sql server

Microsystems,

1 5994

how to keep track of index in listbox items.

2 5818

How do we invoke queries from the application

2 4694

Why sql Data Reader object not created

Matrix,

9 22389

what is the criteria of selection in sbi interview?

BCS, State Bank Of India SBI,

1 4938

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

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

1027

Define Execute Reader?

1113

What is the difference between Data adaptor and Data set?

1093

What is a datareader object?

1141

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1054

What is the DataTableCollection?

1098

What is adodb dll?

1049

can we create synonymn in ms access,sql server,my sql if so explain me with example

2143

What is ado object model?

992

What is ado.net objects?

1010

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1098

What is ado or jdbc?

977

What is the use of Dataview?

1189

What do you know about ado.net's methods?

1172

What does sqldatareader return?

1008

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