i use ado.net to call a stored procedure in SQL Server 2000.
the SP have a parameter that is input and output
when i send an input value of null, the return value does not return
correctly and i get null in return even if the SP set the value to something

I'm trying to update the Database (sql2000) using the DAAB v2.0
SqlHelper.UpdateDataset method. The problem is that my insert stored
procedure returns the primary keys of my new inserted rows as a returned
values parameters. But with the above method there seems to be no way to ...

Everything I've read says the below code should update the foxpro table,
but it doesn't.  The dataview and datagrid are being updated, but the
actual foxpro table isn't.  The table has 3 fields ( idnum, fname and
lname).  The select statement gets the one matching record just ...

The field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data. Is the error message I get when it gets to
dbCmd.ExecuteNonQuery();. I have 15 fields to insert, therefore I did one
field at the time and found that the 13th field is ...

I have 2 tables:
Table: UserTable
Field: Id (pk)
Field: FullName

hey guys, i need some help on an approach.
i need to compare, two different lists.
one will be pulled from a dataset and could have as much as 2500 varchar employee numbers in it.
the other will have the same data, but might be missing some of those same numbers.

I need to insert NULL into the field with SmallDataTime datatype.
In .NET when I tried to use "" or DBNull.Value it insert "" what
will be automatically converted into '1/1/1900' by SQL Server...
I need to have the Insert statement like this:

Hi All!!!
Seasons Greetings....
I have read a lot of the post regarding CommandBuilder, InsertCommand and
Update.  The code below works....

Have just downloaded v2 of the Data Access Application Block but see that v3
is available on the GotDotNet website. Does anyone know: if v3 is stable
enough for use in real systems and when Microsoft are likely to release it
officially.

I seem to run into weird problems and when I post info about them on
this and other microsoft newsgroups I usually don't get any replies.
Recently I posted about a problem I got when i filled a dataset with
data from a text-file. From this post: (Fill a dataset causes an

Does System.Data.OleDb.OleDbLiteral have a purpose or is it just there to
look good, as if it is used by something when it is not, or will be used in
something in the future ?

Any way in ADO to get to the Description of the field - for example, in
Access you can provide a logical description for each field in the table.
Thanks,
Scott

I am trying to make sure I'm using best practice for an Access table.
If I have a table that has 100 discrete colums.  Is it best to just keep
the table with so many columns or to split it into a few other tables.
The 100 columns are indeed discrete so splitting them isn't going to ...

I have a dataset that reads from an xml file. When the file was read, 5
tables where created.having the relationship between the table. how can i
merge those five tables into one table or better yet how can i make that
table relational?

I am posting this question here too coz I was not sure whether I had posted
this earlier in the right group.
I need an editable datagrid. But for editing a datagrid as shown in the
walkthrough: Using a DataGrid Web Control to Read and Write Data,  the table