My ASP.NET application needs to use a named Mutex that is also used by a
Windows Application.  The Windows Application runs under administrator
rights, while the ASP.NET application runs under the SYSTEM account.
Depending on which layer creates the mutex first, the other may get

Hello (sorry for my english),
i'm trying to detect whether a column in a table of a database (sql server,
access, mysql, ...) is identity and i'm not able to get it.
I first used GetOleDbSchemaTable and it didn't work.. then i tried a simple

I currently have a defined Datalayer in a C# application which is filled
with data on startup. All forms in the system bind the to this dataset data
source. The datatables within the dataset have various datarelations setup
and as most of the table keys are Identity fields I had to ...

I am having trouble with my UpdateCommand stored procedure. It updates
the row in the Data Source OK but keeps returning the original value of
"Cost" to the DataSet rather than the newly updated value. Any values
changed in the stored procedure before the Update statement seem to be

Let's say I have a typed DataTable called "MyDataTable" and it has the
following columns:
ID: Integer
Name: String

My VB.NET-application has to do some actions on a SQL Server Database, but
during these actions the DataBase may not be used by any other application.
the total time of the lock could be up to 15 minutes. How can I perform
something like a lock, who denies other users/applications ...

I'm trying to decide on a concurrency strategy with my asp.net application.
I've seen examples where a dataset is used and the update query's WHERE
clause basically checks to see if the original data (from the original read)
equals the data in the database.  I've also seen ...

How canI format the text in a rowfilter expression for a DataView object
which contains a quote mark...is there a special escape character? or what?
For example, "Album = 'One's too many'"
Thanks

I need to insert roughly 10,000 rows from a text log file into SQL. Ideally,
I will use ADO as there is a bit of pre-processing before the inserts. I am
guessing this will eliminate Bulk Copy.
In general, what is the fastest method of inserting rows into SQL?

This is reposted from the vb forum since a couple of folks there thought it
was more suited to this forum.
When I execute the following, it finishes without error (return value is 0),
but the field dateOfInspection remains unchanged.  I've verified that the

I have a combo box and a grid on the windows form. I have the grid
populated with data from a query with on simple join to show the user
friendly description of the ID that is in the table. When I click on
one row of the grid, I will show the value in the combo box. When the

Why is this an inaccessable property.  As soon as I do an update to the
table, it is storing the @@Identity value - that I need.  Why has it
been made unavailable???
Sam

Are there constants (min/max values) for the SqlDbType.SmallDateTime?
Thanks,
Marc

I checked the Knowledge Base article 317043, "HOW TO: Read and Write a File
to and from a BLOB Column by Using Chunking in ADO.NET and Visual C# .NET,"
at http://support.microsoft.com/default.aspx?scid=kb;en-us;317043.
But it explains only for sql server, does anyone have a sample ...

I'm having the same issue, but with a hierarchical dataset in a many-to-many relationship.
TASK|--< TASKSTEP >--|STEP
My data adapter is correct as currently, Im removing the Expression from the calculated fields using the code below and can save/update the database.
<CODE>