Hello all, I'm relatively new to the .NET framework and like to exhaust all resources before asking for help, but I've finally been stumped.  The scenario:  I have two database tables:  PURCHASE and PURCHASE_LINE, with a one-to-many relationship defined between PURCHASE and ...

I am currently working on a windows application using VS.NET. I have a situation where I will be creating a form from three tables with 2 comboxes and a datagrid.when I select a value from the first combobox1(table1-parent) the values are updated in combox2(table2-child of ...

I'm having a very strange issue with an application I'm building.  The
applicaiton has multiple users, each with their own connection to the
database.  However, when one of these connections closes then all the
other users connections seem to close.

I have a customer with over 60,000 records bound to a main accounts form.
Using a dataset as the datasource I have to prefill the accounts table
before binding which can take around a minute to complete.
What is the best practice for binding a large number of records to a single

I am using a DataSet to get lookup tables from my database to use in a form
and when I have finished with the form I am clearing and then disposing of
the DataTables from the DataSet.  When running the application against a
memory profiler I am finding that there are String Arrays ...

I have three tables in an XML file containin a list of programs written and
the systems on which they are installed:  the Programs table, the Systems
table, and the ProgramsSystems table.  The ProgramsSystems table lists the
IDs for the combinations of Programs and Systems.

What would you use to, on a regular basis, transfer potentially large sets of
data from one db to another from a c# or vb.net app?  The source database(s)
could be msde/sql6.5/sql2000 or sybase ase and the destination db is going to
be an embedded firebird db.

If a .NET transaction gets rolled back and SQL SP that, itslef contains SQL
transactions had already been invoked, will the SQL transaction get rolled
back if the .NET transaction gets rolled back?
Thanks,

I have a disconnected strongly typed dataset with around a 10 depth
hierarchy of related tables.
I am using windows.forms to hierarchically display the parent, child,
grandchild etc. etc. data. Each form represents a level in the hierarchy and

I am trying to find a database that will not cause me to go bankrupt.
Looking for a database that:
1)  Has ADO.NET Drivers
     (I have noticed that ODBC Drivers loose Data integrity if there are

This is probably a known issue or a FAQ. However, I could not find a
straight answer to the question, or a nice workaround, so I appologize if
this was answered before (in that case, I would appreciate if someone will
provide a link to a previous related thread or article).

I am trying to update an access database using a datagrid with a dataset( VS 2003).  When I click the Update link on the grid it doesn't fire and does not come out of the edit mode.  My primary key is TABID (autonumber field) and Fld_name and Fld_domain which are both text fields ...

we use this ODBC connectionstring:
"Driver=Sybase SQL Anywhere 5.0;Dbf=C:\SqlAny\Demo.db;Uid=me;Pwd=me"
in a windows application it works fine, but in an asp.net applicatie we get
the next error:

I've got a DataList with for exemple 2 rows in it.
Now I want to add a new row.
How can I do that, without knowing anything of the dataset that was bound to
the datalist?

<this is a repost as i did not get an answer from the ado.net group>
I want to use UpdateDataset method to update more than 1 rows at any time.
The database is Oracle 9x
Namespace/provider is System.Data.OracleClient;