| Other ADO.NET Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the two fundamental objects in ADO.NET? | Ksb | 3 |
| Execute nonquery returns no. of afected rows.So if my stored
procedure hav lot of select stmnt, delete stmnt, insert
stmnt..then what does execute nonquery returns in this case? | | 1 |
| What is @@rowcount and with small code snippet explain the
usage? | BirlaSoft | 4 |
| 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 |
| Being fresher How would i answer to the question that
what is your salary exception? | | 3 |
| i making a project using windows application c#, i want to
show user name, password, and one button login. i wanna
make it with sealed class .how its possible . when i
clicked my login button all project should be open. pls
cleare me.
| | 1 |
| Can a DataReader be used as a DataSource for a GridView.
If it is so how will you handle paging. | Directi | 3 |
| What we do with the object of ado.net dataset after using
it?Can we dispose it or can we set it nothing?Is it must or
not? | SVI | 4 |
| What are the three Ado objects? | Microsoft | 5 |
| what is data access layer? | Honeywell | 2 |
| Explain different methods and Properties of DataReader which
you have used in your project? | | 2 |
| how to add a selected row of a gridview to another gridview
without reloading the page?? | | 1 |
| what is the syntax code to oledb to connect oracle | IBM | 5 |
| Differnce between Stored procedure and user defined functions? | Microsoft | 14 |
| Whate are different types of Commands available with
DataAdapter ? | | 2 |
| How to generate XML from a dataset and vice versa? | | 2 |
| What provider ADO.net use by default? | Accenture | 5 |
| If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ? | Ksb | 12 |
| what is a dataset? | Choice-Solutions | 5 |
| What is the main difference between ADO and ADO.Net | | 3 |
| |
| For more ADO.NET Interview Questions Click Here |