Autoincrement value.. Why in new row? How do I get the next value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rollasoc - 15 Dec 2004 16:47 GMT

Hi,

I have created added a Dataset to my project. In this dataset I have added
a table which has an ID column. I have set this column to autoincrement.
The dataset will be persisted using XML in a flat file.

When I try to add a new row in code, it is expecting an ID in the add row
function. I would have thought it would be more useful to add the row and
it reutrn me the value. How can I achieve this?

e.g.
DS_Customer dsCustomer = new DS_DN9848();

int CustomerNext = ?????????????????????????????????;

dsCustomer.CustomerTable.AddCustomerRow(CustomerNext , CustomerName,
CustomerAddress, CustomerPhone);

How do I find out what the next customer ID is (so I can populate
CustomerNext)?

Rollasoc
PS This is a single user application.

Reply to this Message

Colin R. R. Johnson - 16 Dec 2004 04:53 GMT

Hi Rollasoc,

It looks to me like what you want is something like:

DS_Customer.CustomerTableRow newRow =
dsCustomer.CustomerTable.NewCustomerTableRow(); // create a new row

// populate the row
newRow.CustomerName = customerName;
newRow.CustomerAddress = customerAddress;
newRow.CustomerPhone = customerPhone;

// add the row to the table
dsCustomer.CustomerTable.AddCustomerTableRow(newRow);

newRow.CustomerNext will equal the new value from the auto increment field.

Hope that helps.

> Hi,
>
[quoted text clipped - 19 lines]
> Rollasoc
> PS This is a single user application.

Signature

Colin R. R. Johnson
C&J Solutions
- Remember, everything you see on screen is but ones and zeroes.

Reply to this Message

Rollasoc - 16 Dec 2004 13:00 GMT

Colin,

Unfortunatly, there is no default constructor to use.

Rollasoc

> Hi Rollasoc,
>
[quoted text clipped - 38 lines]
> > Rollasoc
> > PS This is a single user application.

Reply to this Message

Rollasoc - 16 Dec 2004 15:25 GMT

Colin,

Ok, I've sussed it now.... Your code was correct, I was just having a
blonde moment and clicked on the wrong function in the inttelisense.

Thank you very much..

Rollasoc

> Colin,
>
[quoted text clipped - 49 lines]
> > > Rollasoc
> > > PS This is a single user application.

Reply to this Message

Autoincrement value.. Why in new row? How do I get the next value?

Free Magazines