问题描述
我想通过一个datetimePicker控件里的日期来做查询数据库记录,可是怎么也查询不出来,请那位好心人帮帮忙啊究竟是哪里出错了,请指教,还有我数据表里的字段是datetime型的,插入的时候有日期和时间,怎么样才能按日期查询啊?usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceBSMS.BSMS.Stat{publicpartialclassTodayStatForm:Form{publicTodayStatForm(){InitializeComponent();//this.textBox2.Clear();//this.textBox3.Clear();stringstrConn="workstationid=localhost;IntegratedSecurity=SSPI;database=BSMS;";stringstrsql="select*fromsale_view"+"where[date]='"+dateTimePicker1.Value.Date()+"'";SqlConnectioncn=newSqlConnection(strConn);cn.Open();SqlCommandcmd=cn.CreateCommand();cmd.CommandText=strsql;SqlDataReaderdr=cmd.ExecuteReader();dr.Read();if(!dr.HasRows){MessageBox.Show("今天没有销售记录","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);dr.Close();return;}else{//textBox2.Text=dr.GetValue(1).ToString().Trim();//textBox3.Text=dr.GetValue(2).ToString().Trim();dr.Close();//this.sqlDataAdapter1.SelectCommand.Parameters[0].Value=textBox1.Text.Trim();SqlDataAdapteradapter=newSqlDataAdapter(strsql,strConn);DataSettodayStat=newDataSet();adapter.Fill(todayStat,"sale_view");this.dataGridView1.DataSource=todayStat.Tables[0].DefaultView;}}privatevoidbutton1_Click(objectsender,EventArgse){/*if(this.textBox2.Text.Trim()==""){MessageBox.Show("请先输入正确employeeID","提示");return;}*/TodayStatRptFormnewfrm=newTodayStatRptForm();TodayStatRptForm.date=this.dateTimePicker1.Value.Date;//向报表预览窗体中传递日期//newfrm.Text=this.textBox2.Text+"基本信息";newfrm.ShowDialog();}privatevoidTodayStatForm_FormClosed(objectsender,FormClosedEventArgse){this.Parent.Dispose();}}}
解决方案
解决方案二:
publicpartialclassTodayStatForm:Form{publicTodayStatForm(){这里不应放显示数据源的代码TodayStatRptFormnewfrm=newTodayStatRptForm();做完上面这句时,显示数据源的代码已做完了,下面给datetimepicker赋时间值没有意义了TodayStatRptForm.date=this.dateTimePicker1.Value.Date;//向报表预览窗体中传递日期其它有什么问题我就看不出来了
解决方案三:
我有两个窗体啊这个的查询,是在当前窗体做的stringstrsql="select*fromsale_view"+"where[date]='"+dateTimePicker1.Value.Date()+"'";另外一个则是水晶报表窗体,用来打印的
解决方案四:
怎么连个人都没有啊!