19 January 2013

Assign System.DBNull.Value in SqlParam value instead of 0 using Ternary operator



Assign System.DBNull.Value in SqlParam value instead of 0 using Ternary operator

  int i = 0;
           
  SqlParameter[] SqlParam = null;
  SqlParam = new SqlParameter[1];
  SqlCommand SqlCmd = new SqlCommand();

 SqlParam[0] = new SqlParameter("@SectionCode", SqlDbType.VarChar, 50);
 SqlParam[0].Value = i == 0 ? (object)System.DBNull.Value : i;



No comments:

Post a Comment

Comments Welcome