ADO.NET Interview Questions
Questions Answers Views Company eMail

what is data access layer?

Honeywell,

2 7538

What is the default view of Data Grid?

TCS,

5 12567

what is Sql Native Client?

Gantec Solutions,

5 16576

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 14851

what is the syntax code for oldb to connect oracle?

2 3756

what is execute scalar?

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

11 20372

what is Execute NOn Query?

Infosys, Protech, Sars Systems, SwanSoft Technologies,

29 60101

what is the syntax code for oldb to connect oracle

IBM,

3 4919

what is the syntax code to oledb to connect oracle

IBM,

6 9403

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

HCL,

5 9597

how do u connect ado.net to sql server

Microsystems,

1 4930

how to keep track of index in listbox items.

2 4736

How do we invoke queries from the application

2 3335

Why sql Data Reader object not created

Matrix,

9 19021

what is the criteria of selection in sbi interview?

BCS, State Bank Of India SBI,

1 3814


Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is meant by executenonquery?

460


What is an example of ordinal data?

428


Which method in OLEDBAdapter is used to populate dataset with records?

492


What are the rules to implement connection pooling?

447


Name which operations can you not perform on an ado.net dataset?

433






How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

456


Give few examples of datareader that is used in different dataproviders.

481


Describe briefly an ADO.NET Dataset ?

495


What is the difference between executenonquery () and executescalar ()?

431


What is the difference between statement and preparedstatement interface?

500


How to identify the updated rows in a dataset?

470


Why is stored procedure used in ado.net?

487


Define ado.net?

495


What is linq and entity framework?

439


What are the essential features of ado.net?

479