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

Find number of letter occurence of all letter in c#

  Find number of letter occurence of all letter in c#  namespace ConsoleApp1 {     internal class Program     {         static void Main(st...