Execute Non uery is used to perform catalog operations(i.e.
creating databse objcts such as tables) or to change the
data in database without using a dataset by executing
update, Insert and Delete operations.
This method belongs to connection object.We call this
method to indicate that the stored procedure doesn't return
results for a query but rather than an integer indicating
how many rows are effected by the executed statement.
I loaded the dataset with a table of 10 records. One of the
records is deleted from the backend, How do you check
whether all the 10 records were present while updating the
data(Which event and steps) and throw the exception.
If we want to connect to many databases in dataaccess layer
such as MSAccess,Sql server,oracle means not to a particular
database depends on condition we have to connect to
appropriate database in this scenario if we without changing
code Ho wdo you handle this situation?