跪求大牛~~~~
DataSet objDataSet = new DataSet();
SqlDataAdapter obj = new SqlDataAdapter();
String sql = string.Format("select * from 销售记录 where 姓名='{0}'",name);
obj.SelectCommand = new SqlCommand(sql, coon);
SqlCommand objSqlCommand = new SqlCommand(sql, coon);
using (SqlDataReader objSqlReader = objSqlCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (objSqlReader.Read())
{
n += 1;
obj.Fill(objDataSet);
m12.销售记录DataGridView.DataSource = objDataSet.Tables[0];
}
可以查出该name下的数据库记录,可是加上
string time = DateTime.Now.ToShortDateString().ToString().TrimEnd();
DataSet objDataSet = new DataSet();
SqlDataAdapter obj = new SqlDataAdapter();
String sql = string.Format("select * from 销售记录 where 姓名='{0}' and 日期='{1}'",name,time);
就查不出该name和time下的记录。
这是为什么?跪求大牛解答啊啊啊啊啊啊啊.................................
}