passing null to database using C#

Question

I have a null able integer in database table. I want to pass a null value from C# to database table. How can i able to do that. If any one knows about it then please help me.

waqar laghari · Answer

Dear I have tried your solution but it is not working properly.. I am again repating my question?.. I want to insert a null data in a column which is define as int by using insert qurey.. any brother have some idea about it then please share it. because your idea may work for me.... Thanks in advance

zirano latt · Answer

If you are using C# 3.0 you can use null able int data type and insert it into the database. the use of nullable int is as follows; int i = null; // compile error value type can't be null int? i=null; // no error as int? is nullable int value type. If your C# version is lower than V3.0 may be you can consider the following work around. if(i==0) insert null else insert i