datalist 绑定两个表
看了几个有人回答的..但不是很明白..就是用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