Quest: Inserting records into a table with Pri Key set from ASP.NET app...

[lewi]

I have a ASP.NET app that I want to add user login data and use a Primary
Key for an UserID number now I tried INSERT INTO SQL statement(I didn't
include the Primay Key column in both (...) for the stamement) but the
ASP.NET app debugger show that the statement is trying to set the Primay Key
column of the record to NULL and not the next key number(this case 0 or 1 -
whatever it should gives the first record)...

What is going on here?

Any help...

[Richard K Bethell]

It just shouldn't do this, if the primary key is autonumbered. Have you
ensured the database is set to autoincrement?
"lewi" <bj******@willapabay.org> wrote in message
news:vt************@corp.supernews.com...

I have a ASP.NET app that I want to add user login data and use a Primary
Key for an UserID number now I tried INSERT INTO SQL statement(I didn't
include the Primay Key column in both (...) for the stamement) but the
ASP.NET app debugger show that the statement is trying to set the Primay Key column of the record to NULL and not the next key number(this case 0 or 1 - whatever it should gives the first record)...

What is going on here?

Any help...

[Miha Markic]

You might show us command definition.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

"lewi" <bj******@willapabay.org> wrote in message
news:vt************@corp.supernews.com...

I have a ASP.NET app that I want to add user login data and use a Primary
Key for an UserID number now I tried INSERT INTO SQL statement(I didn't
include the Primay Key column in both (...) for the stamement) but the
ASP.NET app debugger show that the statement is trying to set the Primay Key column of the record to NULL and not the next key number(this case 0 or 1 - whatever it should gives the first record)...

What is going on here?

Any help...

[lewi]

> It just shouldn't do this, if the primary key is autonumbered. Have you

ensured the database is set to autoincrement?

That is what I thought... But where would I set autonumbering... I am using
MSDE that comes w/ VS.NET 2002 Pro...

Any more help...

[lewi]

> You might show us command definition.
This is what the SQL cmd looks like after all the string appending...

INSERT INTO USERS (Username, Password) VALUES ('UserText', 'PasswordsText');

Username and Password are two column in the USERS table and UserText is any
string typed in the Username enter box by user(me - thus no validation yet)
on the .aspx page and same with PasswordsText for the password...

Any more help...

[Miha Markic]

How do you create the table in first place?
CREATE TABLE dbo.Table2
(
Id int NOT NULL IDENTITY (1, 1),
tubo varchar(50) NULL
) ON [PRIMARY]

Here is a sample sql command. (note Identity(1, 1))
--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

"lewi" <bj******@willapabay.org> wrote in message
news:vt************@corp.supernews.com...

It just shouldn't do this, if the primary key is autonumbered. Have you
ensured the database is set to autoincrement? That is what I thought... But where would I set autonumbering... I am

using MSDE that comes w/ VS.NET 2002 Pro...

Any more help...

[Marco Martin]

Lewi,

If you are using a dataset, you can the PrimaryKey Column.AutoIncrement =
true. This will automaticaly create the next primary key value when you
create new row().

hope this helps

Marco
"lewi" <bj******@willapabay.org> wrote in message
news:vt************@corp.supernews.com...

I have a ASP.NET app that I want to add user login data and use a Primary
Key for an UserID number now I tried INSERT INTO SQL statement(I didn't
include the Primay Key column in both (...) for the stamement) but the
ASP.NET app debugger show that the statement is trying to set the Primay Key column of the record to NULL and not the next key number(this case 0 or 1 - whatever it should gives the first record)...

What is going on here?

Any help...

[lewi]

> How do you create the table in first place?
I use table design mode but I just look at the designer once more and for an
Identity setting and setting it to YES make two other options valid the Seed
and Increment both set to 1 by default...

So everythings working out now...

Thanks...