#2
qingcong332018-10-27 14:49
|
只有本站会员才能查看附件,请 登录
private void button2_Click(object sender, EventArgs e)//点击按钮查询
{
string shijian = events.Text.Trim();//读取文本框的值
string con_str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=D:\C#测试\LOGIN\LOGIN\BIN\DEBUG\WORKEVENTS.MDF;Integrated Security=True";
string query =String.Format( "select events,recorddate,finishdate,department,supplier,price from workevensts where events={0}", @" ' " + shijian + @"% ' ");
SqlConnection conn = new SqlConnection(con_str);
SqlCommand cmd = new SqlCommand(query,conn);
= query;
SqlDataAdapter ada = new SqlDataAdapter();//数据适配器,访问数据用的
ada.SelectCommand = cmd;
DataTable dt = new DataTable();
ada.Fill(dt);
dataGridView1.DataSource = dt;
}
}
[此贴子已经被作者于2018-9-25 20:36编辑过]