c# - 如何在 ID 自动递增时将其他值插入 Visual Studio 中的数据库

Question

Userid 是自动递增的值并给出默认值，因为它的值不起作用

string inse = @"insert into registration (userid, firstname, lastname, day, 
                                          month, year, address, city, pincode, 
                                          state, country, phoneno, emailaddress) 
                values  (DEFAULT, @firstname, @lastname, @day, 
                         @month, @year, @address, @city, @pincode,
                         @state, @country, @phoneno, @emailaddress)";

SqlCommand cmd = new SqlCommand(inse, con);
cmd.Parameters.AddWithValue("@firstname", txtfname.Text);
cmd.Parameters.AddWithValue("@lastname", txtlname.Text);
.. 

等等

Answer 1

根本不要在查询中添加它，如果它是自动递增的，那么数据库将处理该 ID。

应该有效的查询:

string inse = @"insert into registration(firstname,lastname,day,month,year,
               address,city,pincode,state,country,phoneno,emailaddress) 
               values  
               (@firstname,@lastname,@day,@month,@year,@address,@city,@pincode,
               @state,@country,@phoneno,@emailaddress)";