You must Sign In to post a response.
  • Category: Windows

    How to save data grid view empty cell values in sql data base.

    I am creating windows application using c# 2010, here I am using data grid view for billing purpose, I am not entered all cell values. But how to save empty cells value in sql data base

    Please any one guide me.
  • #767342
    Hi,

    Whether those fields are nullable fields or non nullable fields in database side?

    Based on that we can say, if the field type is nullable then you can store empty cell value but if the datatype is non nullable column then it will throw error, you can't insert null value into non nullable fields.

    Still if you want to insert some data into that then insert default values for those non nullable fields.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


  • Sign In to post your comments