I'm going to try to be as succinct as possible when asking this
question, so bear with me.
Let's say I have two tables in a DB: 'salespeople ' and 'contacts'.
'salespeople' has a primary key field "id", which is the foreign key to

I like to increment a number field in a database and return this value at
the same time. Can this be done with sql?
tnx for any help

What is the equivalent of
DataEnvironment1.rsCommand1("FIELD") [VB Dataenvironment]
in ADO.NET?

I'm using SqlDataAdapter to insert data from one table into another with
SqlCommand after I start a transaction.
If I have convertion error for the insertion of the data, The transaction is
no longer valid, I'ts rolled back.

Im trying to find out how to create a front end ASP page that connects to a
SQL server and retrieves a whole bunch of data. The page needs to be able to
update, delete or add new records. The form itself will be showing
information about computer hardware on our domain ie ram, hd ...

I created the stored procedures for Select, Insert, Update and Delete
I got the Select Stored procedure to select data from the database with no
problem. By the way, I'm kind of new to stored procedures.
So, I want to Insert, Update or Delete records from my Windows Application

I am taking a class and i have a project that is due on Tuesday and
I need help desperately with this program I could email it to you
please email me if you have any experience in VB.Net
My email is stargatesg1girl@yahoo.com and you can also IM me there to

I would have expected an IDataReader to be able to return an IDataRecord
from some interface function for the current row, to allow one to fetch the
row and its values generically. But I did not find such functionality. Did I
miss it ? Why is IDataReader not designed as ...

I have an error message: "Public member 'ExecuteNonqury' on type
'SqlCommand' not found."
on objComd.ExecuteNonqury().
Can someone point me out where did I do wrong?  Thanks.

How can I share the same transaction between two webmethods each in two
different webservices?
I want to be sure that when the client calls the two webmethods, there will
be the data integrity, I mean if the second method will fail, also the

At what "level" does connection pooling get managed? For example, if I have
a data access object (DAO) that uses a single connection string to access
the database is there a connection pool performance advantage to putting
that object in the GAC where it will be shared by all my web ...

When I connect to any table through UI .NET add select statement in
Insert statement by default .e.g.
"INSERT INTO TestMessageText(msg_no, line_no, msg_text, time_stamp)
VALUES (@msg_no, @line_no, @msg_text, @time_stamp); SELECT msg_no,

I need to do the following:
Create a DataSet containing one Table - no problem.
Create a second DataSet containing one Table - no problem.
Instantiate a new (third) DataSet - no problem.

Hey all -
Excuse the cross-post ... I'm not sure what the appropriate newsgroup
would be for this question.
I have a question that I'm not quite sure how to ask. For all I know, I

I'm running into a major problem with DateTime formats in an
ado.net-based program, probably as a result of international format
differences. Situation as follows:
The development environment is in Europe/UK (though hopefully the