C#winform,查询sql数据库并显示在datagridview里
小弟最近在自学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();
}

现在的问题就是,选择了查询方式之后,查询并不显示数据,分布运行也没有报错,大侠们来帮看看~
下边是查询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();
}
...全文
相关推荐
C#winform DataGridView checkbox复选框 实现单选效果
C#winform DataGridView checkbox复选框 实现单选效果,系统默认的是界面中多选,下午没事,做个单选的效果,同时复习下datagridview的常用知识,包含dantGridVIew的常用操作内容,注意事项,代码有点乱,学习。
[C#] 检索数据库并用DataGridView 控件显示数据.
练习点: 数据库读取数据并保存在一个集合中. 使用DataGridView来显示数据. 1 Form1 用于用户登录验证 Form1 Code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Dra
c#winform简单数据库增删改查
简单在窗口实现数据的增删改查,可用于熟悉treeview、datagridview等
C#Winform基于SQL Server的网络连接数据库和本地连接,实现增删改查(内附数据库查询语句以及数据库配置,适合新手)
C#Winform基于SQL Server的网络连接数据库和本地连接,实现增删改查(内附数据库查询语句以及数据库配置,适合新手)
C#Winform 增删改查 SqlServer(附数据库)
本系统适合初学者,环境: SqlServer 工具:Visual Studio 2017 本系统实现了对Sql Server数据库的增删改查,共分为三个模块,学生管理,成绩管理,系统设置


