我的代码如下
private void button3_Click(object sender, EventArgs e)
{
string str = dateTimePicker1.Text.Trim();
SqlConnection con = new SqlConnection(@"server=.;database=CTGL;Integrated Security=sspi;");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select orderid,tbnum, sum(price)as allprice,svdate,svcnum from zhangdan group by orderid,svcnum,tbnum,svdate, having svdate ='" + str + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
我这样只能查询到同一时间的内容。不能查找其他该日发生的内容。。我要怎么改呢?请各位大侠帮帮忙
private void button3_Click(object sender, EventArgs e)
{
string str = dateTimePicker1.Text.Trim();
SqlConnection con = new SqlConnection(@"server=.;database=CTGL;Integrated Security=sspi;");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select orderid,tbnum, sum(price)as allprice,svdate,svcnum from zhangdan group by orderid,svcnum,tbnum,svdate, having svdate ='" + str + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
我这样只能查询到同一时间的内容。不能查找其他该日发生的内容。。我要怎么改呢?请各位大侠帮帮忙
string str = dateTimePicker1.Value.ToString("yyyyMMdd");// sql 部分:
"... having CONVERT(varchar(100), svdate, 112) ='" + str + "'"