For sql express, can multiple computers access  same database file on
a shared network drive?  This is for a small client with 3-5
computers.  I do not wish to use Express if I am heading into
multi-user issues

Hope it is ok to post here !
We are looking for companies that are experts in dotnet and c# . Most also
have good knowledge of database, ado and XML
We have a project  where we need about 1-2 people for a period for 3-6 month

I am using VB .NET 2003
Assume I have the following tables:
==ORDERS==                ==ORDER_PRODUCTS==
OrderID (PK)              OrderProductsID (PK)

Hello!  We're seeing some very odd results from the below code.  Under
certain conditions, ADO.NET will create commands that specify a
negative zero amount ("-0.00").  It's easy to reproduce.
This is a major issue in our application as we do lots of decimal math

I am buidling a ASP 1.1 appliciation.
what is the best way to store file path in SQL server database field
Do I have to store the Physicalpath or only the file and then retreive the
full path name when needed ?

Is there a free Command/Query Tool for Sql Express?  I have seen posts
for commercial tools but I need a simple tool to allow creation of
databases, entry of create commands, stored procedures, and ability to
run simple queries.  

Will sql express 2005 and Studio 2003 (.net 1.1) work together?  I can
not find a definitive statement on the Microsoft site and need to
change a 1.1 app and wish to use the newer 2005 express.  
I know that I will need to load both the 1.1 and 2.x framework on the

while (dr.Read())
//dr is an instance of sqlDataReader
{
   double minAirTemp = (double)(Single)dr["minAirTemp"];

I have an DataTable with one extra column that I've added manually, and is
not in the database. I use this col for various calculations, and it should
never be saved to the db. That works fine, except for one thing: when I
change the value in a row for that col, the RowState ...

How can Ido this ?
I have a datatable/ dataset, which has rows with data in it.
I want to bulk insert all rows from the dataset to database table (having
same table structure).

I have been hunting for a code snippet to update an Access db using VB and
ASP.NET.  So far, nothing that helps me.  I am using OleDb libraries.
Can anyone provide me with the general steps or calls involved.  Here is
where I am at so far.  Any guidance would be great...

Thank you in Advance!
I'm storing a record for an AD object using the
Object GUID and storing it as a UniqueIdentifier in SQL server, like
this:

I have a web page that uses two ObjectDataSource controls to bind data to a
FormView and a grid .
In my grid which is bound to ObjectDataSource2, I want to add in the footer
information from certain fields from the first ObjectDataSource.  I am

Hi;
What IsolationLevel is best for transactions for the following (by sub-row I
mean a pk:fk to a second table that has N rows in the second table that
"belong" to a row in the first table):

This would seem to be a fairly simple and straight forward thing to do.  
So sorry if this has been answered somewhere already, but I have not
been able to find the answer.
I am creating a custom DataGridView component and need a way to