Once a SqlTransaction object has been committed or rolledback, can the
object still be used?
The reason I ask is because I am building a class that uses a
SqlTransaction object. It has methods that would use the same

When multiple rows selected on a DataGrid, how can my code find out which
rows have been selected?  I thought the IsSelected property would tell me but
when I select rows on the DataGrid, the property does not evaluate to True
for the specified rows.  I have a DataGrid bound to a ...

I'm getting some strange results using the autoincrement column on my
datatable. I'm populating a datatable with data from my database and
displaying this in a datagrid. The first time I get the data from the
database I create a new table with an autoincrement column bind the ...

I'm a bit new to using Oracle from .Net, tend to use SQLServer mostly.
I'm just looking for a bit of advice.
What do you need to get a connection working from .Net to Oracle. Do I
need to install the Oracle Client on my machine? The code I have is

If any one has the exam questions for MCAD 70-316  (App. Dev. C#) please
send it to me in the following address:
li_areekkal (at) sympatico.ca
Thank you.

I'm inserting into a table using a stored procedure feeding data from a
CSV file.  The stored procedure checks for uniqueness of a social
security number.  If the SSN exists, I update the record.  Otherwise, I
enter a new record.  As a test, I had two rows in my CSV file with the ...

I know there is some way to select only the new rows (and not the deleted,
changed etc) in a DataGrid, and insert them in the DataBase.
I want to do this by using a SqlDataAdapter.
Does anybody knwo how to doe this?

The MSDN article:
       Developing high-performance ASP.NET applications
recommends using the SqlDataReader above using DataSets.
One of the advantage of using DataSets over DataReaders is (as I understand

After searching for information on how to populate a dataset from a .csv file
programmatically, all I can find is how to populate a dataset from an xml
file.  
Can anyone tell me the best way to populate a dataset from a .csv file

When this code executes:
   if (dbConnection.State != ConnectionState.Open)
   {
       dbConnection.Open();      /* 1 */

I have created a simple dataform from the wizard and i use the grid to
display the data. I added a textbox and button. What i want to do is find a
customer based on the customerid (index). I want the focus moved to the
customer row.

Is there a limit to the number of Output parameters a SqlCommand can
handle?  Thanks!

Guys,
I have a stored procedure in SQL Server where I pass few parameters
like username, email address etc. The stored procedure simply inserts
these records into users table that has an identity column as ID.

I have read a lot of articles about datasets, strongly-typed datasets
and customer objects but am still at a loss on which is the best
solution.
We are building a 3-tier application that uses Webservices as our

Is there any special way of handling a many-to-many relationship in a
dataset?  
I am wondering if I could set up my dataset so I can navigate directly to
the second table in the many-to-many relationship as opposed to the table