unique ID's

[Chuck Bowling]

is there an easy way to generate unique ID's for a DataSet Table or am I
just going to have to generate a random number and search the db to see if
it's been used already?

[Amalorpavanathan Yagulasamy(AMAL)]

Use the following statement to generate the Unique id

System.Guid.NewGuid()

Regards,
Amal

[Kirk Graves]

Chuck,

depending on how you are using the DataTable, you probably don't even need
to worry about it. If you are writing back to the DB, the DataAdapter will
take care of this issue through it's UpdateCommand.

However, if you need to generate the unique number in the code, here is the
process for setting up a new DataTable that automaticaly increments an ID
column.

If you bind the resultant DataTable to a DataGrid you will see it creating
the ID value as you enter new records.

-------------------------
System.Data.DataTable dt = new DataTable("MyDataTable");

System.Data.DataColumn dc = new DataColumn("TableID");
dc.AutoIncrement = true;
dc.AutoIncrementSeed=1;
dc.AutoIncrementStep=1;
dt.Columns.Add(dc);

dc = new DataColumn("ValueField");
dt.Columns.Add(dc);
--------------------------

Kirk Graves
KRGIT Software

"Chuck Bowling" <ch**********@sbcglobal-NO-SPAM.net> wrote in message
news:OR*************@tk2msftngp13.phx.gbl...

is there an easy way to generate unique ID's for a DataSet Table or am I
just going to have to generate a random number and search the db to see if
it's been used already?

[Amalorpavanathan Yagulasamy(AMAL)]

Use the following statement to generate the Unique id

System.Guid.NewGuid()

Regards,
Amal

[Kirk Graves]

Chuck,

depending on how you are using the DataTable, you probably don't even need
to worry about it. If you are writing back to the DB, the DataAdapter will
take care of this issue through it's UpdateCommand.

However, if you need to generate the unique number in the code, here is the
process for setting up a new DataTable that automaticaly increments an ID
column.

If you bind the resultant DataTable to a DataGrid you will see it creating
the ID value as you enter new records.

-------------------------
System.Data.DataTable dt = new DataTable("MyDataTable");

System.Data.DataColumn dc = new DataColumn("TableID");
dc.AutoIncrement = true;
dc.AutoIncrementSeed=1;
dc.AutoIncrementStep=1;
dt.Columns.Add(dc);

dc = new DataColumn("ValueField");
dt.Columns.Add(dc);
--------------------------

Kirk Graves
KRGIT Software

"Chuck Bowling" <ch**********@sbcglobal-NO-SPAM.net> wrote in message
news:OR*************@tk2msftngp13.phx.gbl...

is there an easy way to generate unique ID's for a DataSet Table or am I
just going to have to generate a random number and search the db to see if
it's been used already?

[Chuck Bowling]

exactly what i needed. thank you Kirk.

"Kirk Graves" <kr***********@yahoo.com> wrote in message
news:OW**************@TK2MSFTNGP09.phx.gbl...

Chuck,

depending on how you are using the DataTable, you probably don't even need
to worry about it. If you are writing back to the DB, the DataAdapter will take care of this issue through it's UpdateCommand.

However, if you need to generate the unique number in the code, here is the process for setting up a new DataTable that automaticaly increments an ID
column.

If you bind the resultant DataTable to a DataGrid you will see it creating
the ID value as you enter new records.

-------------------------
System.Data.DataTable dt = new DataTable("MyDataTable");

System.Data.DataColumn dc = new DataColumn("TableID");
dc.AutoIncrement = true;
dc.AutoIncrementSeed=1;
dc.AutoIncrementStep=1;
dt.Columns.Add(dc);

dc = new DataColumn("ValueField");
dt.Columns.Add(dc);
--------------------------

Kirk Graves
KRGIT Software

"Chuck Bowling" <ch**********@sbcglobal-NO-SPAM.net> wrote in message
news:OR*************@tk2msftngp13.phx.gbl...

is there an easy way to generate unique ID's for a DataSet Table or am I
just going to have to generate a random number and search the db to see if it's been used already?

[Chuck Bowling]

exactly what i needed. thank you Kirk.

"Kirk Graves" <kr***********@yahoo.com> wrote in message
news:OW**************@TK2MSFTNGP09.phx.gbl...

Chuck,

depending on how you are using the DataTable, you probably don't even need
to worry about it. If you are writing back to the DB, the DataAdapter will take care of this issue through it's UpdateCommand.

However, if you need to generate the unique number in the code, here is the process for setting up a new DataTable that automaticaly increments an ID
column.

If you bind the resultant DataTable to a DataGrid you will see it creating
the ID value as you enter new records.

-------------------------
System.Data.DataTable dt = new DataTable("MyDataTable");

System.Data.DataColumn dc = new DataColumn("TableID");
dc.AutoIncrement = true;
dc.AutoIncrementSeed=1;
dc.AutoIncrementStep=1;
dt.Columns.Add(dc);

dc = new DataColumn("ValueField");
dt.Columns.Add(dc);
--------------------------

Kirk Graves
KRGIT Software

"Chuck Bowling" <ch**********@sbcglobal-NO-SPAM.net> wrote in message
news:OR*************@tk2msftngp13.phx.gbl...

is there an easy way to generate unique ID's for a DataSet Table or am I
just going to have to generate a random number and search the db to see if it's been used already?

[Chuck Bowling]

thanks for the reply Amal.

"Amalorpavanathan Yagulasamy (AMAL)" <an*******@discussions.microsoft.com>
wrote in message news:A3**********************************@microsof t.com...

Use the following statement to generate the Unique id

System.Guid.NewGuid()

Regards,
Amal

[Chuck Bowling]

thanks for the reply Amal.

"Amalorpavanathan Yagulasamy (AMAL)" <an*******@discussions.microsoft.com>
wrote in message news:A3**********************************@microsof t.com...

Use the following statement to generate the Unique id

System.Guid.NewGuid()

Regards,
Amal