Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Passing a Null Value to a Query Parameter

using System; using System.Data; using System.Data.SqlClient;     class Program     {         static void Main(string[] args)         {             string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";             using (SqlConnection connection = new SqlConnection(sqlConnectString))             {                 SqlCommand command =new SqlCommand("PassNullParameter", connection);                 command.CommandType = CommandType.StoredProcedure;                 command.Parameters.Add("@ValueIn", SqlDbType.Int);                 command.Parameters[0].Value = 1;                 connection.Open( );                 Console.WriteLine(command.ExecuteScalar( ));                 command.Parameters[0].Value = null;                 Console.WriteLine("Parameter value = null");                 try{                                          Console.WriteLine(Convert.ToBoolean(command.ExecuteScalar( )));                 }catch (Exception ex){                     Console.WriteLine("ERROR: {0}", ex.Message);                 }                 command.Parameters[0].Value = System.DBNull.Value;                 Console.WriteLine(command.ExecuteScalar( ));             }         }     }