这是利用编号查询数据库的part表:
//按编号查找零件信息
private void button15_Click(object sender, EventArgs e)
{
string strconn = "host=localhost; database=kufang; user id=root; password=990919";
MySqlConnection con = new MySqlConnection(strconn);
con.Open();
sql = "select * from kufang.part where P_id = '"+textBox34.Text.Trim()+"' ";
MySqlCommand sc = new MySqlCommand(sql, con);//定义一个sql命令语句
MySqlDataAdapter sda = new MySqlDataAdapter(sc);//数据适配器
DataSet dataSet = new DataSet();//表示数据在内存中的缓存
sda.Fill(dataSet, "part");//适配器匹配数据
dataGridView1.DataSource = dataSet;//设置数据源为dataSet
dataGridView1.DataMember = "part";//绑定dataSet的表名
textBox34.Clear();
dataGridView1.Columns[0].HeaderText = "零件编号";
dataGridView1.Columns[1].HeaderText = "零件名称";
dataGridView1.Columns[2].HeaderText = "规格";
dataGridView1.Columns[3].HeaderText = "价格";
dataGridView1.Columns[4].HeaderText = "数量";
dataGridView1.Columns[5].HeaderText = "存放库房";
con.Close();//关闭数据库
con.Dispose();//释放资源
}
这是查询全部,点击查询全部按钮能显示,为什么利用编号查询就没反应呢,求大神指点迷津。
//查找全部零件信息
private void button11_Click(object sender, EventArgs e)
{
string strconn = "host=localhost; database=kufang; user id=root; password=990919";
MySqlConnection con = new MySqlConnection(strconn);
con.Open();
sql = "select * from part";
MySqlCommand sc = new MySqlCommand(sql, con);//定义一个sql命令语句
MySqlDataAdapter sda = new MySqlDataAdapter(sc);//数据适配器
DataSet dataSet = new DataSet();//表示数据在内存中的缓存
sda.Fill(dataSet,"part");//适配器匹配数据
dataGridView1.DataSource = dataSet;//设置数据源为dataSet
dataGridView1.DataMember = "part";//绑定dataSet的表名
dataGridView1.Columns[0].HeaderText = "零件编号";
dataGridView1.Columns[1].HeaderText = "零件名称";
dataGridView1.Columns[2].HeaderText = "规格";
dataGridView1.Columns[3].HeaderText = "价格";
dataGridView1.Columns[4].HeaderText = "数量";
dataGridView1.Columns[5].HeaderText = "存放库房";
con.Close();//关闭数据库
con.Dispose();//释放资源
}
其实我在做数据库大作业,怎么感觉变成做C#大作业了...