.Net Framework 1.1 and SQL Server 2000 SP3a
I use the SqlConnection, SqlCommand, SqlDataAdapter,
Dataset to connect to a SQL Server and Call there a
Stored Procedure that produce a Resultset that i catch

I've got a dataset with one table table[0]
This table has 3 different rows.
I've created 3 different datatable objects and I would like each table to contain the content of each row from the dataset
How can I do that?

None of the schema filters such as OleDbSchemaGuid.Tables work when a
database has a period "." in its name, such as "Test 7.7".  Is this
expected? It doesn't seem like this should fail since OleDb is a
generic mechanism and who knows what a DMBS will allow for a database

I am new to ADO and I want to know in which way can I
update Access dataset (about 10,000 records a time, and
the new values are coming from an Excel .csv file) with
best efficentcy? Which way is better, SQL or DataAdapter's

I'm having a problem that I don't know how to sort.
I am trying to execute a number of SQL stored procedures in a single
transaction. However it always throughs an exception saying that the "Thread
was being aborted"

I am trying to design optimistic concurrency in my application.  The
application connects to a MS SQL server and is 3 to 5 user concurrent
application.  The application works with one record at a time (ranges from 8
to 12 tables) and if the update fails everything is rolledback via ...

I'm trying to wrap my head around this and it's hurting hard.
I need to swap 2 rows in a table.
This is basically a list system, where a user can click an up arrow, and the
current record gets -1 in priority.

This question isn't so much about code as it is about development process.
I'm focused on improving the performance of an app I've developed over the
last several months. One area that has troubled me is how long to maintain a
FILLed dataset across classes and even within classes.

I keep getting this error:
A first chance exception of type 'System.IndexOutOfRangeException' occurred
in system.windows.forms.dll
        Additional information: Index was outside the bounds of the array.

Is there another method besides using a uniqueidentifier column and
(newid()) default value to create a "transactionid" for entries into a
table? Is there a method with VB code to create a transactionid unique to a
table, possibly with formatting (such as 0000000001, and so on)?

I want to create a Strongly Typed DataSet for a table with a LOT of columns.
Now I could write the XML Schema file by hand (to then give to xsd.exe to
generate the C#), but before I do that, is there any tool/utility I can use
to scrape the table schema out of the database and ...

I was developing a web application using SQL Server. Suddenly, my
customer decided to use Oracle 8.1.6 as the database. The DBA is
deciding if the application will access a new database or a scheme and
I wiil have to migrate my SqlHelper class to an OracleHelper class.

I have a DataSet with two DataTables.
Table 1 contains group data:                  Table 2 contains part data:
           CT                                                        CT
           EG                                                        CT05

Good Morning to all,
I have a bunch of XML files that need to be readed inside the same DataSet
(each XML represent a single table).
In the event of a large (some megabytes) file, what is the best practice to

Calling OleDbConnection.GetOleDbSchemaTable on a SQL Database that has
a period in it's name fails:  How to duplicate, create a database
called "test 7.7" and try this code.
try