Parameter with auto increment

[Mike]

Hello,

I have an autoincrement field and I'm not sure how to use a parameter
with it to insert data:

this.sqlCommand 1.CommandText = "INSERT INTO SickAndTired (String_ID,
Input_string) VALUES (@Parameter1,@P arameter2)";

this.sqlCommand 1.Connection = this.sqlConnect ion1;

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r1",
System.Data.Sql DbType.UniqueId entifier, 0, "String_ID" ));

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r2",
System.Data.Sql DbType.NVarChar , 0, "Input_String") );

this.sqlConnect ion1.Open();

string TB1 = this.textBox1.T ext;

sqlCommand1.Par ameters["@Parameter 1"].Value= (What do I put
here??????????? ????????)

sqlCommand1.Par ameters["@Parameter 2"].Value=TB1;

sqlCommand1.Exe cuteNonQuery();

this.sqlConnect ion1.Close();

Thanks

Mike

[Nicholas Paldino [.NET/C# MVP]]

Mike,

For something like this, you aren't going to get it through a parameter
in a select. Rather, you have to issue a select on the same open connection
on the @@IDENTITY value, which will return the last inserted identity value
for that session.

You have to be careful, since the identity can be changed by triggers
(if you insert into other tables with auto-generated identity fields then
that value will be returned).

Generally, this is a good argument for managing the id generation
yourself. Personally, I prefer to use GUIDs, since I can generate them
before the operation starts, and know exactly what my id will be (before and
after).

If you want to get this in a parameter, then create a stored procedure
which will select the @@IDENTITY value and return that in a parameter.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Mike" <am******@veriz on.net> wrote in message
news:N6_Re.121$ tx.8@trndny02.. .

Hello,

I have an autoincrement field and I'm not sure how to use a parameter
with it to insert data:

this.sqlCommand 1.CommandText = "INSERT INTO SickAndTired (String_ID,
Input_string) VALUES (@Parameter1,@P arameter2)";

this.sqlCommand 1.Connection = this.sqlConnect ion1;

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r1",
System.Data.Sql DbType.UniqueId entifier, 0, "String_ID" ));

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r2",
System.Data.Sql DbType.NVarChar , 0, "Input_String") );

this.sqlConnect ion1.Open();

string TB1 = this.textBox1.T ext;

sqlCommand1.Par ameters["@Parameter 1"].Value= (What do I put
here??????????? ????????)

sqlCommand1.Par ameters["@Parameter 2"].Value=TB1;

sqlCommand1.Exe cuteNonQuery();

this.sqlConnect ion1.Close();

Thanks

Mike

[carion1]

scope_identity( ) is probably safer to use. @@identity can potentially
produce very hard to find bugs in your app.

"Mike" wrote:

Hello,

I have an autoincrement field and I'm not sure how to use a parameter
with it to insert data:

this.sqlCommand 1.CommandText = "INSERT INTO SickAndTired (String_ID,
Input_string) VALUES (@Parameter1,@P arameter2)";

this.sqlCommand 1.Connection = this.sqlConnect ion1;

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r1",
System.Data.Sql DbType.UniqueId entifier, 0, "String_ID" ));

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r2",
System.Data.Sql DbType.NVarChar , 0, "Input_String") );

this.sqlConnect ion1.Open();

string TB1 = this.textBox1.T ext;

sqlCommand1.Par ameters["@Parameter 1"].Value= (What do I put
here??????????? ????????)

sqlCommand1.Par ameters["@Parameter 2"].Value=TB1;

sqlCommand1.Exe cuteNonQuery();

this.sqlConnect ion1.Close();

Thanks

Mike

[Mike]

All I did was left that parameter out and it incremented by 1.Should I have
made it more complicated?

"carion1" <ca*****@discus sions.microsoft .com> wrote in message
news:06******** *************** ***********@mic rosoft.com...

scope_identity( ) is probably safer to use. @@identity can potentially
produce very hard to find bugs in your app.

"Mike" wrote:

Hello,

I have an autoincrement field and I'm not sure how to use a parameter
with it to insert data:

this.sqlCommand 1.CommandText = "INSERT INTO SickAndTired (String_ID,
Input_string) VALUES (@Parameter1,@P arameter2)";

this.sqlCommand 1.Connection = this.sqlConnect ion1;

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r1",
System.Data.Sql DbType.UniqueId entifier, 0, "String_ID" ));

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r2",
System.Data.Sql DbType.NVarChar , 0, "Input_String") );

this.sqlConnect ion1.Open();

string TB1 = this.textBox1.T ext;

sqlCommand1.Par ameters["@Parameter 1"].Value= (What do I put
here??????????? ????????)

sqlCommand1.Par ameters["@Parameter 2"].Value=TB1;

sqlCommand1.Exe cuteNonQuery();

this.sqlConnect ion1.Close();

Thanks

Mike

[carion1]

Were you trying to insert a value into the identity column? If you need to
do that for what ever reason you can use set identity_insert <table name> on.
You don't have to increment the identity column yourself unless your app
depends on the identity field not having gaps from deleted records.

"Mike" wrote:

All I did was left that parameter out and it incremented by 1.Should I have
made it more complicated?

"carion1" <ca*****@discus sions.microsoft .com> wrote in message
news:06******** *************** ***********@mic rosoft.com...

scope_identity( ) is probably safer to use. @@identity can potentially
produce very hard to find bugs in your app.

"Mike" wrote:

Hello,

I have an autoincrement field and I'm not sure how to use a parameter
with it to insert data:

this.sqlCommand 1.CommandText = "INSERT INTO SickAndTired (String_ID,
Input_string) VALUES (@Parameter1,@P arameter2)";

this.sqlCommand 1.Connection = this.sqlConnect ion1;

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r1",
System.Data.Sql DbType.UniqueId entifier, 0, "String_ID" ));

this.sqlCommand 1.Parameters.Ad d(new
System.Data.Sql Client.SqlParam eter("@Paramete r2",
System.Data.Sql DbType.NVarChar , 0, "Input_String") );

this.sqlConnect ion1.Open();

string TB1 = this.textBox1.T ext;

sqlCommand1.Par ameters["@Parameter 1"].Value= (What do I put
here??????????? ????????)

sqlCommand1.Par ameters["@Parameter 2"].Value=TB1;

sqlCommand1.Exe cuteNonQuery();

this.sqlConnect ion1.Close();

Thanks

Mike