| Other ADO.NET Interview Questions |
|| Asked @
|When multiple users attempt to modify data at the same time
Ex user 1 is updating record at same time user2 deleted
record sucessfully.now user1 has press update button . how
to handle concurrency
|If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
|What providers does ado.net uses internally ?
|What's the difference between Dataset.clone and Dataset.copy?
|How to Handle the exceptions in Sqlsrver2000
|How to call the SQL commands asynchronously in ADO.NET
|Can we bind one datareader wid two dropdown list?
|can u tell me the how to get the print for the form
|Why DataReader is Forward Only?
|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 !
TextBox lnm=(TextBox)e.Item.Cells.Controls; string
str=lnm.Text ; SqlCommand cmd=new SqlCommand("update
customer set lastname='" + str + "' where id=" + varid
+ "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=-
|What does connection string consists of ?
|We all know that Dataset is purely disconnected
architechure, but we also know that we can update the
changes made to the dataset can be updated in the backend
database. when there is no connection how does the update
|For more ADO.NET Interview Questions Click Here |