I am having an OleDBDataAdapter and a dataset. I fill the dataset with
a row and execute

Adapter.update(dataset,"Table Name");
Adapter.fill(dataset,"Table Name");

For the database table, my primary key is an auto number.

Currently, I am fetching the key using:

dataset.Tables["Table Name"].Rows[0].ItemArray[0]

It is working because this is the only row added into my table.
But I am certain that there should be a better alternative to this.
Waiting for response.

Jag

check out www.betav.com - Articles, MSDN - Retrieving the Gozoutas

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am having an OleDBDataAdapter and a dataset. I fill the dataset with
> a row and execute
>
> Adapter.update(dataset,"Table Name");
> Adapter.fill(dataset,"Table Name");
>
> For the database table, my primary key is an auto number.
>
> Currently, I am fetching the key using:
>
> dataset.Tables["Table Name"].Rows[0].ItemArray[0]
>
> It is working because this is the only row added into my table.
> But I am certain that there should be a better alternative to this.
> Waiting for response.
>
> Jag
>

Are you using Access database?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am having an OleDBDataAdapter and a dataset. I fill the dataset with
> a row and execute
>
> Adapter.update(dataset,"Table Name");
> Adapter.fill(dataset,"Table Name");
>
> For the database table, my primary key is an auto number.
>
> Currently, I am fetching the key using:
>
> dataset.Tables["Table Name"].Rows[0].ItemArray[0]
>
> It is working because this is the only row added into my table.
> But I am certain that there should be a better alternative to this.
> Waiting for response.
>
> Jag
>

Hi Miha,

I am using Access database.

Hi,

Check out
Retrieving Identity or Autonumber Values
..net help topic.
MSDN Oct link
(ms-help://MS.VSCC.2003/MS.MSDNQTR.2004OCT.1033/cpguide/html/cpconretrievingidentityorautonumbervalues.htm)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Miha,
>
> I am using Access database.
>