I have a function which takes a table and calls DA.Update with that table. I
can't seem to get my new ids returned back to me.
My second problem is I don't like using the select * for the SelectCommand.
I was thinking of adding where '1' = '2' but think that will definitly not

Have anyone here uses MySQL with a .NET web application? How difficult it is
to connect to the database and from the web application? Can you get me a
sample code on how to use the connector? Any help or comments are welcome.
Thank you.

I think this post was more appropriate here...
How do I Update a dataset into a DB if the orginal SqlDataAdapter I used to
fill the dataset is gone?
Thanks

Can one transfer an UnCommitted Dataset (AcceptChanges hasn't been called)
through WebServices?  If yes, are the RowVersions also transmitted?
Thanks a lot!

I need the help deperately.
My requirement is that i have to retrieve BLOB object from the Oracle and
need to save it on the Hard Disk through ADO.NET.
For this purpose i have tried it with OLEDB.NET Data provider and also

I upgraded my computer from windows 98 2nd edition to microsoft office XP
professional edition. Then, I uninstall MS office 97 and reinstall it to fix
some issue regarding accessing to my MS Access 97 database. After the
installation, I cannot run a query to import an external ...

Whats the best way to check and see if the IDataReader Has Rows since it
doesn't support HasRows like the other DataReaders?
Thanks ahead of time,
Mike

i need to create a autoincrementing primary key field in a access database
thru a sql command, (that kind of field is called a long integer in access,
and it autoincrements when a new record is added)
the following gets the field type created, but it doesn't auto increment.

Hi, Can any1 help me identify the problem with my update statement? Everytime
I'm trying to run it, there's "invalid sql statement. expected 'delete',
'insert', 'procedure' or 'update'. error msg coming up. Or could it be
something else? Here's the code. Thx in advance!

I've been thinking about using command.Prepare() to prepare the execution of
some of the statements that I run repeatedly in the database. We have run
into situations where prepared statements have drastically improved
performance, especially against Oracle.

I have a dataset with which I want to populate a TreeView. This dataset
contains tasks by person, therefore a person will repeat often in the
dataset. The first node of the TreeView is "Person" and under this node is
his/her tasks. I want one node per unique person in the dataset ...

I am new to .Net, ADO.Net and i have to programm an independent dataprovider
(no sql, no oledb, no odbc) and in addition it has to be in visual c++ :(
untill now i have two classes.
Class Conn derived from IDbConnection and class comm derived from idbcommand.

I'm using OleDbConnection.GetOleDbSchemaTable() to obtain the name of
all the tables in an access database.  This is a bit of my code:
OleDbConnection connection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  +

So, I am updating a SQL Database using a Windows Form.  When I save the
record I would like to refresh the SELECT command, but I don't know how.  Is
it possible to refresh the dataadapter or reselect so a Combo Box is properly
updated with the changes?

I see many examples of subs or functions that intialize a connection,
dataadapter, commands, parameters, etc. and then fill a datatable or
dataset table.
So my question comes from how do you handle dataadapters and scope?  Do