0

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

Edited by Nick Evan: Fixed formatting

2
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by LizR
0

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

0

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.

0

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.

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.