C#winform,查询sql数据库并显示在datagridview里

zodiachAries zodiachAries 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
小弟最近在自学C#,然后现在自己琢磨着做个小的查询系统,大概如图
现在的问题就是,选择了查询方式之后,查询并不显示数据,分布运行也没有报错,大侠们来帮看看~
下边是查询button代码
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=LENOVO-PC;Initial Catalog=Passenger;Integrated Security=True";
conn.Open();
if (radioButton1.Checked == true)
{
DateTime.Now.ToString("yyyy-MM-dd");
DateTime dt0 = DateTime.Now;
SqlDataAdapter sda = new SqlDataAdapter("select * from SecurityCheck where InspectionBegin = '"+dt0+"'", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds;
}
if (radioButton2.Checked == true)
{
System.DateTime currentTime = new System.DateTime();
int 时 = currentTime.Hour;
int 分 = currentTime.Minute;
int 秒 = currentTime.Second;
DateTime.Now.ToString("yyyy-MM-dd HH:MM:SS");
DateTime dt0 = DateTime.Now;
DateTime dt1 = dt0.AddHours(-2.0);
SqlDataAdapter sda = new SqlDataAdapter("select * from SecurityCheck where InspectionBegin = '"+dt1+"' ",conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds;
}
if (radioButton3.Checked == true)
{
SqlDataAdapter sda = new SqlDataAdapter("select * from SecurityCheck where InspectionBegin='"+dateTimePicker1.Text+"'and InspectionOut='"+dateTimePicker2.Text+"'", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds;
}
conn.Close();
}
...全文

相关推荐

评论 17
收藏 已收藏
分享
返回顶部
zodiachAries
C# 111,129 成员 642,540 内容