How to insert null into database?

c# asp.net c#-2.0
Zo Has picture Zo Has · Oct 12, 2010 · Viewed 52.8k times · Source

Hi I am trying to insert null in a database column depending on a gridview datakeys value (if being "" insert null into database) However, I am getting a space ' ' inside the database column.

string sbcId = gvTest.DataKeys[gr.RowIndex]["myColumn"].ToString();
 insgnp.Parameters.Add(new OleDbParameter("EMPID", (sbcId==""?DBNull.Value.ToString():sbcId)));

Answer

Klaus Byskov Pedersen picture Klaus Byskov Pedersen · Oct 12, 2010

You have to rewrite your code:

if(string.IsNullOrEmpty(sbcId))
    Parameters.Add(new OleDbParameter("EMPID", DBNull.Value)); 
else
    Parameters.Add(new OleDbParameter("EMPID", sbcId));

The problem with the ternary if statement that you have is that its returntype must always be the same, which is why you cannot use it (string and DbNull.Value are not compatible)

Related questions

OnCheckedChanged event handler of asp:checkbox does not fire when checkbox is unchecked

I have a repeater, in each ItemTemplate of the repeater is an asp:checkbox with an OnCheckedChanged event handler set. The checkboxes have the AutoPostBack property set to true. When any of the checkboxes is checked, the event handler fires. …

Read More
How can I force the base constructor to be called in C#?

I have a BasePage class which all other pages derive from: public class BasePage This BasePage has a constructor which contains code which must always run: public BasePage() { // Important code here } I want to force derived classes to call the …

Read More
How to get the URL of the current page in C#

Can anyone help out me in getting the URL of the current working page of ASP.NET in C#?

Read More