我要按日期查询出我的日记表中的详细内容,前二个字段都是Date类型的,我用的代码如下,运行报错,但我不知道咋改,请各位高手帮帮忙。
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"");
//创建数据库连接对象、数据库连接字符串
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from thing where date = 'dateTimPicker1.Value'";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string xierushijian = reader.GetString(1);
string dotime = reader.GetString(2);
string thingscontent = reader.GetString(3);
textBox3.Text = ("写入时间:" + xierushijian + "做此事的时间:" + dotime + "事项内容:" + thingscontent);
}
}
我的是winform,不能用response.write()吧