if (DateTime.TryParse(txtInDate.Text, out inDate)) database.AddInParameter(cmd, "@InDate", DbType.String, inDate); else database.AddInParameter(cmd, "@InDate", DbType.DateTime, DBNull.Value);