Generated dataset and autoincrement

dbradley · April 19th, 2004, 04:02 PM

I have created a SQLDataAdapter that uses stored procedures. When I run my app. it retrieves the data in the table but the ID field does not have the correct values in it. It seems that the Dataset's ID field is regenerating new id's for the this field. If I run my stored procedure from the Query Analyzer the id fields contents are correct. Does anyone know why I am not getting the correct values back.

Thanks,

David

ank2go · May 14th, 2004, 12:47 PM

Hi drbradley,

Hope you found your solution.

I was wondering if you would be so kind as to share
w/ us how you created a dataAdapter that uses SPs.

Thanks !

melvik · May 15th, 2004, 04:06 AM

Use Configure Data Adapter on right-click on that!
after setting Connection select second type as (existing Stored porcedure) & go on ...

HTH

Always:),
Hovik Melkomian.

bmains · May 15th, 2004, 10:26 PM

Hello,

I don't know why it would be an incorrect ID... Do you specify any sort of autoincrementing on this field when setting up the data set, or are you doing anything else to that column specifically, or is coming back from the database that way?

Posting code may help some more also.

Brian

ritag · February 1st, 2005, 04:25 PM

Hi,

I would also love to know how to get a recordset using a Stored Procedure through the SQLDataAdapter. I thought you had to use the
SQLCommand to run Stored Procedures...

I didn't understand Hovik's way to do it.

Could somebody please give a VB.NET coding example!

Thanks.

Rita

melvik · February 2nd, 2005, 01:14 AM

Hi Rita:
I dont remember what was my last post here, but to getting recordset is pretty simple!
use DataAdapter genaretor & it'll help u to set that (use SP & ...)
then u'll fill it in a table in DataSet.
like:

Code:

sqlDataAdapter1.Fill(DataSet1, "urTableName");

remember we have no recordset in ADO.NET, & its called DataSet.
HTH.

Always:),
Hovik Melkomian.