Let's say we have a program writing to the access database constantly. Let's
say i have another program that needs to read a lot of data to it. How does
ACCESS/JET handle this? Does it lock the database for the write so the
process reading from it has to block? Is this safe?

Every data adapter implementation (those in the framework and several other)
that i know has RowUpdating and RowUpdated events.Why aren't they in a base
class or interface, e.g. IDbDataAdapter or DbDataAdapter? Right now it's
pita to register a listener for them in a generic ...

I have made quite simple VB.NET (2003) Windows Forms-application to insert
only new lines into single database table for tracing purposes. (Other form
is used to browse target table with filterings.) I created inserting form
creating DataSet with one DataTable, bound these DataTable ...

I'm noticing that when I update a row in my DataSet, the child/sibling rows
are also getting their rowstate changed to Modified.  Is this the way it's
supposed to work?  Sounds strange to me.
Example:

After entering the sql statement da.deletecommand.commandtext = "Delete from
Users where username = @username" I set the parameter to the username I wish
to delete.
This successfully deletes the user. However, even if I enter an non-existant

I am experimenting with ADO.NET
I use MySQL 3.23 with MyODBC 3.51
At the moment I simply try an insert a select and an update. I use the
usual DataSet approach. The select works and retrieves the data from the

I am using a typed dataset in a application where I sometimes delete rows in
different tables.  The problem I am running into is after I delete a row(has
not updated db) and try to access a row in a different table (same dataset)
I get this error "Deleted Row Information cannot be ...

When I delete a row in my dataset, the row state for other rows in the
dataset (other datatables) rowstate is deleted.  Why is that?  Here is the
code I use to delete the row:
I have tried both methods below and get same result:

This may sounds very immature question; I'm new to VB.net and not mach
experience in VB as well.
I developed a database in Access 2000. It works. Now I want to make it
front end in VB.I thought of doing all the forms in VB.net and connect

I have an XML file that I have stored in ado.net dataset. What I want to do
is a SELECT DISTINCT on one of the columns (or individual tag) of table tag.
How can I do this?

I've seen alot of sample code about how to create and use them but whats the
best way to have them per application. Should every form that access's a
database have its own connection and adapter or should they share one? I can
see where multithreading might have implications but I'm ...

I have a table with one column, DivisionName nvarchar 20, and it is the
primary key.  The DataAdapter wizard can't create delete or update
statements for it.  I manually wrote those statements and it then worked.
If the table contains another field it will also work.

Hi all, I've created a web application and currently I'm NOT making use of connection pooling
Right now I have a public shared variable in my Global class of type System.Data.oledb.OleDbConnection.  I also have a shared member boolean variable that indicates whether connection has ...

Maaaaaaaaaan ... nothing but drama with ODBC and .Net.
On my development system, using the code below, I can successfully open/read
an Act.dbf file. I can successfull do this either in debug mode or simply
running the program.exe.

Hi Gang,
The latest in a string of messages dealing with Strongly Typed DataSets.
I've got a Strongly Typed DataSet 'filled', but I cannot seem to figure out
how to traverse it.