Ggtcf

Read/write a pipe-delimited file line by line with some simple text manipulation

Is a linearly independent set whose span is dense a Schauder basis?

"Eavesdropping" vs "Listen in on"

Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?

Raspberry pi 3 B with Ubuntu 18.04 server arm64: what pi version

Prodigo = pro + ago?

Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?

Creating a script with console commands

Is it OK to decorate a log book cover?

Does int main() need a declaration on C++?

How can I separate the number from the unit in argument?

Can you teleport closer to a creature you are Frightened of?

Is it reasonable to ask other researchers to send me their previous grant applications?

How to unfasten electrical subpanel attached with ramset

Finitely generated matrix groups whose eigenvalues are all algebraic

Create custom note boxes

Mathematica command that allows it to read my intentions

Man transported from Alternate World into ours by a Neutrino Detector

Upgrading From a 9 Speed Sora Derailleur?

Variance of Monte Carlo integration with importance sampling

Why do we say “un seul M” and not “une seule M” even though M is a “consonne”?

MT "will strike" & LXX "will watch carefully" (Gen 3:15)?

What happens if you break a law in another country outside of that country?

Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico

C# int? parameter- Data is Null. This method or property cannot be called on Null values

0

I am trying to call a stored procedure which has an INT parameter (BusinessID) and allows NULL. From my C# code, I can't figure out if data is null, how to identify and pass. I have listed three techniques I have tried numbered #1,#2,#3 and the errors I get. Please guide
Here is my sample code:

private static DataRow ValidateRecord (string ProjectNum, int? BusinessID)

 DataRow returnRow = null;
 using (SqlConnection connection = Connection.GetConnection())
 
 if (connection.State != ConnectionState.Open)
 
 connection.Open();
 

 try
 
 using (SqlCommand command = new SqlCommand(
 "[dbo].[mySQLProc]", connection))
 
 command.CommandType = CommandType.StoredProcedure;
 command.CommandTimeout = 90;

 command.Parameters.Add("@ProjectNum", SqlDbType.VarChar, 17).Value = ProjectNum;

 // #1 – error: "Data is Null. This method or property cannot be called on Null values."
 //if (!BusinessID.HasValue)
 //
 // BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; 
 //

 //#2 - "Data is Null. This method or property cannot be called on Null values."
 if (BusinessID == null)
 
 BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null;
 
 //#3 - error on compile time – Type of conditional expression cannot be determined because
 // there is no implicit converstion between ‘System.DBNull’ and ‘int?’
 // BusinessID = BusinessID == null ? DBNull.Value : BusinessID;
 command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID;
 command.ExecuteNonQuery();
 connection.Close();
 returnRow = CreateDataRow(ProjectNum, BusinessID);
 
 
 catch (Exception ex)
 
 throw ex;
 
 return returnRow;
 

c# stored-procedures null int

share|improve this question

asked Mar 8 at 19:11

SilverFishSilverFish

184216

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The line BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; - try (int?) also whether BusinessID is null or not you're still passing it to the stored procedure I'm not sure why you're checking for null if the SP can handle it. Not sure what version of .net you're using but maybe change command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID; to command.Parameters.AddWithValue("@BusinessID", BusinessID); - Hope this helps
  
  – Andrew
  Mar 8 at 19:41
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It might be to do with you including the '@' symbol in the name - whenever I create SqlParameters, I drop the '@' e.g. new SqlParameter("BusinessID", BusinessID)
  
  – Andrew Williamson
  Mar 8 at 19:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  same error with (int?)System.Data.SqlTypes.SqlInt32.Null;
  
  – SilverFish
  Mar 8 at 19:51
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if I do command.Parameters.AddWithValue("@BusinessID", BusinessID); and pass null, then the stored procedure doesn't even recognize it as if @BusinessID is missing
  
  – SilverFish
  Mar 8 at 19:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Worked!!! command.Parameters.AddWithValue("@BusinessID", (Object)BusinessID ?? DBNull.Value);
  
  – SilverFish
  Mar 8 at 20:32
  

  
  
  
  

 | 
show 1 more comment

0

I am trying to call a stored procedure which has an INT parameter (BusinessID) and allows NULL. From my C# code, I can't figure out if data is null, how to identify and pass. I have listed three techniques I have tried numbered #1,#2,#3 and the errors I get. Please guide
Here is my sample code:

private static DataRow ValidateRecord (string ProjectNum, int? BusinessID)

 DataRow returnRow = null;
 using (SqlConnection connection = Connection.GetConnection())
 
 if (connection.State != ConnectionState.Open)
 
 connection.Open();
 

 try
 
 using (SqlCommand command = new SqlCommand(
 "[dbo].[mySQLProc]", connection))
 
 command.CommandType = CommandType.StoredProcedure;
 command.CommandTimeout = 90;

 command.Parameters.Add("@ProjectNum", SqlDbType.VarChar, 17).Value = ProjectNum;

 // #1 – error: "Data is Null. This method or property cannot be called on Null values."
 //if (!BusinessID.HasValue)
 //
 // BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; 
 //

 //#2 - "Data is Null. This method or property cannot be called on Null values."
 if (BusinessID == null)
 
 BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null;
 
 //#3 - error on compile time – Type of conditional expression cannot be determined because
 // there is no implicit converstion between ‘System.DBNull’ and ‘int?’
 // BusinessID = BusinessID == null ? DBNull.Value : BusinessID;
 command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID;
 command.ExecuteNonQuery();
 connection.Close();
 returnRow = CreateDataRow(ProjectNum, BusinessID);
 
 
 catch (Exception ex)
 
 throw ex;
 
 return returnRow;
 

c# stored-procedures null int

share|improve this question

asked Mar 8 at 19:11

SilverFishSilverFish

184216

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The line BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; - try (int?) also whether BusinessID is null or not you're still passing it to the stored procedure I'm not sure why you're checking for null if the SP can handle it. Not sure what version of .net you're using but maybe change command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID; to command.Parameters.AddWithValue("@BusinessID", BusinessID); - Hope this helps
  
  – Andrew
  Mar 8 at 19:41
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It might be to do with you including the '@' symbol in the name - whenever I create SqlParameters, I drop the '@' e.g. new SqlParameter("BusinessID", BusinessID)
  
  – Andrew Williamson
  Mar 8 at 19:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  same error with (int?)System.Data.SqlTypes.SqlInt32.Null;
  
  – SilverFish
  Mar 8 at 19:51
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if I do command.Parameters.AddWithValue("@BusinessID", BusinessID); and pass null, then the stored procedure doesn't even recognize it as if @BusinessID is missing
  
  – SilverFish
  Mar 8 at 19:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Worked!!! command.Parameters.AddWithValue("@BusinessID", (Object)BusinessID ?? DBNull.Value);
  
  – SilverFish
  Mar 8 at 20:32
  

  
  
  
  

 | 
show 1 more comment

I am trying to call a stored procedure which has an INT parameter (BusinessID) and allows NULL. From my C# code, I can't figure out if data is null, how to identify and pass. I have listed three techniques I have tried numbered #1,#2,#3 and the errors I get. Please guide
Here is my sample code:

private static DataRow ValidateRecord (string ProjectNum, int? BusinessID)

 DataRow returnRow = null;
 using (SqlConnection connection = Connection.GetConnection())
 
 if (connection.State != ConnectionState.Open)
 
 connection.Open();
 

 try
 
 using (SqlCommand command = new SqlCommand(
 "[dbo].[mySQLProc]", connection))
 
 command.CommandType = CommandType.StoredProcedure;
 command.CommandTimeout = 90;

 command.Parameters.Add("@ProjectNum", SqlDbType.VarChar, 17).Value = ProjectNum;

 // #1 – error: "Data is Null. This method or property cannot be called on Null values."
 //if (!BusinessID.HasValue)
 //
 // BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; 
 //

 //#2 - "Data is Null. This method or property cannot be called on Null values."
 if (BusinessID == null)
 
 BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null;
 
 //#3 - error on compile time – Type of conditional expression cannot be determined because
 // there is no implicit converstion between ‘System.DBNull’ and ‘int?’
 // BusinessID = BusinessID == null ? DBNull.Value : BusinessID;
 command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID;
 command.ExecuteNonQuery();
 connection.Close();
 returnRow = CreateDataRow(ProjectNum, BusinessID);
 
 
 catch (Exception ex)
 
 throw ex;
 
 return returnRow;
 

c# stored-procedures null int

share|improve this question

asked Mar 8 at 19:11

SilverFishSilverFish

184216

private static DataRow ValidateRecord (string ProjectNum, int? BusinessID)

 DataRow returnRow = null;
 using (SqlConnection connection = Connection.GetConnection())
 
 if (connection.State != ConnectionState.Open)
 
 connection.Open();
 

 try
 
 using (SqlCommand command = new SqlCommand(
 "[dbo].[mySQLProc]", connection))
 
 command.CommandType = CommandType.StoredProcedure;
 command.CommandTimeout = 90;

 command.Parameters.Add("@ProjectNum", SqlDbType.VarChar, 17).Value = ProjectNum;

 // #1 – error: "Data is Null. This method or property cannot be called on Null values."
 //if (!BusinessID.HasValue)
 //
 // BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null; 
 //

 //#2 - "Data is Null. This method or property cannot be called on Null values."
 if (BusinessID == null)
 
 BusinessID = (int)System.Data.SqlTypes.SqlInt32.Null;
 
 //#3 - error on compile time – Type of conditional expression cannot be determined because
 // there is no implicit converstion between ‘System.DBNull’ and ‘int?’
 // BusinessID = BusinessID == null ? DBNull.Value : BusinessID;
 command.Parameters.Add("@BusinessID", SqlDbType.Int).Value = BusinessID;
 command.ExecuteNonQuery();
 connection.Close();
 returnRow = CreateDataRow(ProjectNum, BusinessID);
 
 
 catch (Exception ex)
 
 throw ex;
 
 return returnRow;
 

share|improve this question

asked Mar 8 at 19:11

SilverFishSilverFish

184216

share|improve this question

asked Mar 8 at 19:11

SilverFishSilverFish

184216

asked Mar 8 at 19:11

SilverFishSilverFish

184216

asked Mar 8 at 19:11

SilverFishSilverFish

184216