数据库多表查询,绑定的问题!
各位大侠!我现在用access,有两个表:
part(域:id mid uid pname)id自动编号,mid整数,uid与user表中uid相关联,pname字符串
user(域:uid name)uid自动编号
我想先查处part中uid=2的记录,找到uid,在user中将name值显示出来!
在access中用select * from user where uid in (select uid from part where mid=2)可以查处!
但我在asp.net中却抱错!
string strdb = @"Provider=MicroSoft.Jet.OleDb.4.0;Data Source=e:\user.mdb;";
OleDbConnection conn=new OleDbConnection(strdb);
conn.Open();
string cmdstring2 = "select * from user where uid in (select uid from part where mid=2";
OleDbDataAdapter cmd2 = new OleDbDataAdapter(cmdstring2, conn);
DataSet uds = new DataSet();
cmd2.Fill(uds, "ulist");
ulist.DataSource = uds.Tables["ulist"].DefaultView;
ulist.DataBind();
如果我作简单查询string cmdstring2 = "select * from part where eid=2" 就没有我问题!请问如何做这类多表便和查询的问题!
另外我用去他方法如:string cmdstring2 = "select b.name,b.uid from part a inner join user b on a.uid= b.uid where a.mid= 2";
string cmdstring2 = "select * from part,user where part.uid=user.uid and mid=2";
都不行,但在access中查询都正常!