Null value cannot be inserted

Asked Apr 11 '16 at 07:38

Active Apr 11 '16 at 07:38

Viewed 86 times

I am trying to insert this file on mySql database.I already allowed nulls on my database still I get this errors.

Additional information: Cannot insert the value NULL into column 'orderId', table 'MejOnlineManagementDB00.dbo.orders2'; column does not allow nulls. INSERT fails.

protected void btnSend_Click(object sender, EventArgs e)
    {
        con.Open();
        cmd = new SqlCommand(@"INSERT INTO orders2
                            (orderName,orderFile,orderPrice,orderQuantity,orderShipped)
                            VALUES
                            ('"+DropDownList1.SelectedValue+"','"+lblFile.Text+"','"+lblPrice.Text
                            +"','"+txtQuantity.Text+"','"+DateTime.Now+"')",con);
        cmd.ExecuteNonQuery();
        con.Close();
        lblFinished.Text = "Order has been submitted for process.";

    }

asked Apr 11 '16 at 07:38

rai nalasa

1

It looks like `orderId` does not allow NULLs. This is probably the primary key, so that makes sense. Maybe you can set `orderId` to `AUTO_INCREMENT`. – wimh Apr 11 '16 at 07:41
@Wimmel You could not set the primary to be null value right?or you could? – rai nalasa Apr 11 '16 at 07:43
change the `orderId` column to be `IDENTITY` – ntohl Apr 11 '16 at 07:43
@rainalasa See [Why primary key cannot contain null values?](http://stackoverflow.com/q/25701288/33499) – wimh Apr 11 '16 at 07:45
Mark the primary key column as auto_increment identity column. – Ranjit Singh Apr 11 '16 at 10:06

Null value cannot be inserted

0 Answers0