if (DateTime.TryParse(txtInDate.Text, out inDate))
database.AddInParameter(cmd, "@InDate", DbType.String, inDate);
else
database.AddInParameter(cmd, "@InDate", DbType.DateTime, DBNull.Value);
if (DateTime.TryParse(txtInDate.Text, out inDate))
database.AddInParameter(cmd, "@InDate", DbType.String, inDate);
else
database.AddInParameter(cmd, "@InDate", DbType.DateTime, DBNull.Value);
转载于:https://www.cnblogs.com/delicious28/archive/2010/03/19/1690234.html