string myComStr = "SELECT * FROM db2 WHERE [Cpinfo]='" + comboBox1.text + " //不用等值,我的意思是你选择combox显示的值
string sql=string.Format("select {0} as 菜系,{0}菜价格 as 价格 from Cpinfo where {0} not is null",combobox1.SelectionItem); OleDbDataAdapter adapter = new OleDbDataAdapter(sql, 某Connection); adapter.Fill(某DataSet);dataGridView.DataSource=某DataSet.Tables[0]; 建议修改表的设计,否则你的这个东西永远都是只能是个玩具.
查询语句: select * from Cpinfo where 字段名称=“+combox1.SelectionItem+”;然后添加到DATATABLE
using(OleDBConnection conn=new OleDBConnection(""))
{
conn.open();
//使用oledbparemeter
}
OleDbConnection myCon = new OleDbConnection(conStr);
try
{
myCon.Open();
//测试连接
//使用DataSet
string myComStr = "SELECT * FROM biao1 WHERE [Name]='"+textBox1.Text+" ";
DataSet ds = new DataSet();
OleDbDataAdapter myCommand = new OleDbDataAdapter(myComStr,myCon);
myCommand.Fill(ds,"biao1");
}
catch
{
throw;
}
//loge.mdb你的Access文件
string myComStr = "SELECT * FROM biao1 WHERE [Name]='"+textBox1.Text+" ";
//textBox1.Text改成combox.text="川系"
{
string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db2.mdb;";
OleDbConnection myCon = new OleDbConnection(conStr);
try
{
myCon.Open();
//测试连接
//使用DataSet
string myComStr = "SELECT * FROM db2 WHERE [Cpinfo]='" + comboBox1.text = "川系" + " ";
DataSet ds = new DataSet();
OleDbDataAdapter myCommand = new OleDbDataAdapter(myComStr, myCon);
myCommand.Fill(ds, "Cpinfo");
}
catch
{
throw;
} }
//不用等值,我的意思是你选择combox显示的值
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, 某Connection);
adapter.Fill(某DataSet);dataGridView.DataSource=某DataSet.Tables[0];
建议修改表的设计,否则你的这个东西永远都是只能是个玩具.