Problems while inserting records in an existing user table

[pradeepkk2008]

Hi, this is my first job in UK, so need bit of help. The problem goes like this. I have an existing SQL database where there are 2 user tables. One contains only field.U_Id(int) not null and other is user_details table where there are fields like user_id(int), username and so on. While I am trying to insert values into the usertable, if i leave the user id field, then it throws an exception that the field cannot contain nulls, which is right but I want to know a way of incrementing the userid by 1 in both tables.

My code goes like this.

  string connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connString))
            {
               string insertstr = " insert into ct_user(User_Id,name,password,email)values(@UserId,@UserName,@Password,@email)";
                var cmdtext = new SqlCommand(insertstr,conn);
                cmdtext.Parameters.AddWithValue("@UserId",0);
                cmdtext.Parameters.AddWithValue("@UserName", txtUserName.Text);
                cmdtext.Parameters.AddWithValue("@Password", txtPassword.Text);
                cmdtext.Parameters.AddWithValue("@Email", txtEmail.Text);
                conn.Open();
                cmdtext.ExecuteNonQuery();
                Console.WriteLine("Your account has been successfully created", conn);
                conn.Close();

Thanks and Regards,
Pradeep Khatri

[LizR]

Dont include the ID in the insert statement, if the DB is set to auto inc, it will do it all for you.

[pradeepkk2008]

I have tried that also, it still throws an error.

[pradeepkk2008]

and in both tables it is not set as autoincrement field it is an int field.

[LizR]

Then you need to put the int in yourself, and ensure its unique, once you've done that if it still errors, we need some errors, and the code it executed.

[pradeepkk2008]

but that is hardcoding the userid, which i dont want to do..wht i want is it automatically adds to the existing number which is there in both tables..for example, if the last userid was 675 , and if i create 2 users through front end , they should 676 and 677 respectively.

[LizR]

Well, then thats the point of getting the DB to do it for you, however, I didnt say hard code it, i said you have to insert the code to add the int, I wasnt suggesting you fixed the number..

So, you have the spec for your new bit of code, as you said, you need to get the last userid add 1 to it, and put your new line in