reader 读到空值怎么处理_SqlDataReader读取数据为null

写了一个方法publicstringMainNo(stringTableName){stringdjbm,sql,str;sql="selectmax(BillNo)asdjbmfromBillwhereLeft(BillNo,Len('"+head+"')+8)='"+head+DateTime.Now.ToString("...

写了一个方法

public string MainNo(string TableName)

{

string djbm, sql, str;

sql = " select max(BillNo) as djbm from Bill where Left(BillNo,Len('" + head + "')+8) = '" + head + DateTime.Now.ToString("yyyyMMdd") + "'";

SqlDataReader myread = bp.getRead(sql);

if (myread.Read())

{

str = (myread["djbm"].ToString()).Substring(myread["djbm"].ToString().Length - 4, 4);

str = Convert.ToString(Convert.ToInt32(str) + 2);

str = str0.Substring(1, 4 - str.Length) + str;

djbm = head + System.DateTime.Now.ToString("yyyyMMdd") + str;

}

else

{

djbm = head + System.DateTime.Now.ToString("yyyyMMdd") + "0001";

}

return djbm;

}

sql执行结果是null ,怎么直接让程序执行else呢?

展开