无法将NULL值插入“自动增量主键”列

Muhammad Younas 发表于 Dev

穆罕默德·尤纳斯（Muhammad Younas）

我已经Items在C＃数据库中创建了表，因为主键的属性是AutoIncrement = True，AutoIncrementStep = 1，Unique = True，AutoIncrementSeeds = 0；

CREATE TABLE [dbo].[Items] 
(
    [item_id]       INT          NOT NULL,
    [item_name]     VARCHAR (50) NULL,
    [item_model]    VARCHAR (50) NULL,
    [item_price]    VARCHAR (50) NULL,
    [item_quantity] VARCHAR (50) NULL,
    [entry_date]    VARCHAR (50) NULL,
    [user_id]       VARCHAR (50) NULL,

    PRIMARY KEY CLUSTERED ([item_id] ASC)
);

我正在Items使用此代码将数据插入表中：

string query = @"Insert into Items(item_name, item_model, item_price, item_quantity, entry_date, user_id)" +
                "VALUES(@name, @model, @price, @quantity, @date, @user)";

using (SqlConnection c = new SqlConnection(Properties.Settings.Default.Database1ConnectionString))
{
    try
    {
        c.Open();

        if (c.State == ConnectionState.Open)
        {
            SqlCommand command1 = new SqlCommand(query, c);

            command1.Parameters.AddWithValue("@name", name.Text.ToString());
            command1.Parameters.AddWithValue("@model", model.Text.ToString());
            command1.Parameters.AddWithValue("@price", price.Text.ToString());
            command1.Parameters.AddWithValue("@quantity", quantity.Text.ToString());
            command1.Parameters.AddWithValue("@date", dateTimePicker1.Text.ToString());
            command1.Parameters.AddWithValue("@user", added_by.Text.ToString());

            int k = command1.ExecuteNonQuery();

            if (k > 0)
            {
                MessageBox.Show("Data Added Successfully");
                c.Close();
                return;
            }
            else 
            {
                MessageBox.Show("Data was not added successfully - try again later");
                c.Close();
                return;
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("Failed To Open Connection :." + ex);
        return;
    }
}

当我运行代码并尝试插入数据时，出现错误

无法将NULL值插入列“ item_id”表中

Ganesh_Devlekar

NOT NULL意味着您不能将NULL它们插入需要显式插入的列中。

设置IDENTITY(1,1)将以item_id1的种子自动插入。

像这样更改您的定义

CREATE TABLE [dbo].[Items] (
[item_id]       INT          NOT NULL IDENTITY(1, 1),
[item_name]     VARCHAR (50) NULL,
[item_model]    VARCHAR (50) NULL,
[item_price]    VARCHAR (50) NULL,
[item_quantity] VARCHAR (50) NULL,
[entry_date]    VARCHAR (50) NULL,
[user_id]       VARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([item_id] ASC)
);

或者

明确地将其插入数据库

string query = @"Insert into Items(item_id,item_name,item_model,item_price,item_quantity,entry_date,user_id)" +
                "VALUES(@item_id,@name, @model, @price, @quantity, @date,@user)";

停止使用.AddWithValues 来源

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。