Cannot insert the value NULL into column 'Description

Question

Cannot insert the value NULL into column 'Description...

Can anyone help me ? Please , It will be highly appreciated.. Here is my Dapper Code to insert the Description, Quantity, Cost and HSCode and only the Description Colume is not working saying insert the value NULL into column 'Description.

public void CreateIncomingShipmentLine(IncomingShipmentLine incomingShipmentLine)
{
    DbConnection _Connection = new SqlConnection(Constant.DatabaseConnection);
    _Connection.Open();

    // IncomingShipmentLine

    string myIncomingShipmentLineQuery = "INSERT INTO IncomingShipmentLine( Description, Quantity, Cost, HSCode) VALUES ( @Description, @Quantity, @Cost, @HSCode)";

    _Connection.Execute(myIncomingShipmentLineQuery, new
                                                     {
                                                         Description = incomingShipmentLine.Description,
                                                         Quantity = incomingShipmentLine.Quantity,
                                                         Cost = incomingShipmentLine.Cost,
                                                         HSCode = incomingShipmentLine.HSCode
                                                     });
    _Connection.Close();
}

Looks like your Description column doesn't allow nulls and you actually provide such value in the Description property of the incomingShipmentLine. Either you should populate the object properly wth not-null value, or you should override the value to some empty string, or you should change your column to accept nulls. — Jakub Szumiato
– Jakub Szumiato, Commented Apr 11, 2016 at 11:06
Thank you so much - Jakub Szumiato, Its working ...... :) – Namaraj Giri — Namaraj Giri
– Namaraj Giri, Commented Apr 11, 2016 at 11:26

Vignesh Kumar A · Accepted Answer · 2016-04-11 11:06:38Z

1

Use ISNULL property before insert.

If it's NULL insert empty value instead of NULL, since your Description coulmn is NOT NULL

Try this

public void CreateIncomingShipmentLine(IncomingShipmentLine incomingShipmentLine)
{
    DbConnection _Connection = new SqlConnection(Constant.DatabaseConnection);
    _Connection.Open();

    // IncomingShipmentLine

    string myIncomingShipmentLineQuery = "INSERT INTO IncomingShipmentLine( Description, Quantity, Cost, HSCode) VALUES ( ISNULL(@Description,''), @Quantity, @Cost, @HSCode)";

    _Connection.Execute(myIncomingShipmentLineQuery, new
                                                     {
                                                         Description = incomingShipmentLine.Description,
                                                         Quantity = incomingShipmentLine.Quantity,
                                                         Cost = incomingShipmentLine.Cost,
                                                         HSCode = incomingShipmentLine.HSCode
                                                     });
    _Connection.Close();
}

answered Apr 11, 2016 at 11:06

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vignesh Kumar A Over a year ago

@NamarajGiri happy programming

Collectives™ on Stack Overflow

Cannot insert the value NULL into column 'Description

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related