今天做了一个查询页面.想查询两个dateTimePicker间的数据.但是VS2005显示SQL语句那块有问题,请各位帮小弟看一下
代码如下: string cmdstr = select data,HKJE from creat where data between '" + Convert.ToDateTime(this.dateTimePicker1.Text) + "' AND '" + Convert.ToDateTime(this.dateTimePicker2.Text) + "' ";
string connstr = "配置信息";
try
{
OleDbDataAdapter oda = new OleDbDataAdapter(cmdstr, connstr);
DataSet ds = new DataSet();
oda.Fill(ds, "test");
dataGridView1.Columns[0].ToolTipText = "日期";
dataGridView1.Columns[9].ToolTipText = "还款金额";
dataGridView1.Columns[0].HeaderCell.Value = "日期";
dataGridView1.Columns[0].Width = Convert.ToInt16(100);
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[9].HeaderCell.Value = "还款金额";
dataGridView1.Columns[9].Width = Convert.ToInt16(80); }
catch
{
MessageBox.Show("查询失败,错误原因如下:\n" + ep, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
代码如下: string cmdstr = select data,HKJE from creat where data between '" + Convert.ToDateTime(this.dateTimePicker1.Text) + "' AND '" + Convert.ToDateTime(this.dateTimePicker2.Text) + "' ";
string connstr = "配置信息";
try
{
OleDbDataAdapter oda = new OleDbDataAdapter(cmdstr, connstr);
DataSet ds = new DataSet();
oda.Fill(ds, "test");
dataGridView1.Columns[0].ToolTipText = "日期";
dataGridView1.Columns[9].ToolTipText = "还款金额";
dataGridView1.Columns[0].HeaderCell.Value = "日期";
dataGridView1.Columns[0].Width = Convert.ToInt16(100);
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[9].HeaderCell.Value = "还款金额";
dataGridView1.Columns[9].Width = Convert.ToInt16(80); }
catch
{
MessageBox.Show("查询失败,错误原因如下:\n" + ep, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货