C# winform -> SQL server Trouble writing null values

[Mattzimmerer]

I'm no professional, so I am aware that I may be missing out on a better method but here is what I am trying to do.

            int Market\_Value;
                if (this.MarketValue.Text == "") Market\_Value = -1;
                else Market\_Value = Int32.Parse(this.MarketValue.Text);

            TableAdapter.InsertQuery(Market\_Value == -1 ? Market\_Value : null)

            TableAdapter.Update(DataSet);

*lots of code left out This doesn't compile because of the line : Market_Value == -1 ? Market_Value : null, its telling me that I cannot set an int to null Perhaps I could handle this in my InsertQuery? I'm super new to SQL so I cant see how... heres that function:

INSERT INTO [dbo].[THE DATABASE]
([Market Value])

VALUES (@Market_Value)

I guess I could make the conditional statement in there somehow... but how? :confused: :sigh: .. need to learn more SQL :laugh: I just dont know, any insight into a better way would be greatly appreciated!

[i j russell]

This is a c# issue and has nothing to do with Sql or the database. Your code will not compile because the Conditional Operator (?) is typed by the test values as an int and it cannot convert null to an int. Try changing Market_Value to a nullable int (int?).

[Mattzimmerer]

duh.. yea I always seem to hit the wrong forum.. thanks for your help!!! =)