看了几个有人回答的..但不是很明白..就是用DATALIST 绑定两个表..我现在的代码如下:请帮我修改一下..
string sql = "select t_BusinessInfo.*,t_member_user.* from t_BusinessInfo inner jion t_member_user on t_BusinessInfo.MemberID=t_member_user.id";
DataView dv = DBFun.GetDataView(sql);
DataList1.DataSource = dv;
DataList1.DataBind();
这样子提示:'jion' 不是可以识别的 join 选项
------解决方案--------------------------------------------------------
应该是join吧
------解决方案--------------------------------------------------------
sql都是错的.不是提示你了。
这样子提示:'jion' 不是可以识别的 join 选项
string sql = "select t_BusinessInfo.*,t_member_user.* from t_BusinessInfo inner jion t_member_user on t_BusinessInfo.MemberID=t_member_user.id";
================>
string sql = "select t_BusinessInfo.*,t_member_user.* from t_BusinessInfo inner join t_member_user on t_BusinessInfo.MemberID=t_member_user.id";
------解决方案--------------------------------------------------------
是inner join
不是 inner jion