无法绑定由多个部分组成的标识符！！！！！！！！！！！！

Question

SqlConnection con = new SqlConnection("server=10.200.128.120;database=KJVIEW;uid=sa;pwd=tcs54321;");
        string sql = "select * from xuesheng where xuesheng.schoolid=school.schoolid";
        SqlCommand com = new SqlCommand(sql,con);
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = com;
        con.Open();
        DataSet ds = new DataSet();
        sda.Fill(ds, "xuesheng");
        con.Close();
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
大家帮我看看这么写为什么老提示 无法绑定由多个部分组成的标识符school.schoolid啊 

Answer 1

select * from xuesheng ,school where xuesheng.schoolid=school.schoolid

Answer 2

select * from xuesheng inner join school 
on xuesheng.schoolid=school.schoolid
where ...条件

Answer 3

string sql = "select * from xuesheng where xuesheng.schoolid=school.schoolid"; sql不对啦，应该是select a.* from xuesheng a,school b where a.schoolid=b.schoolid

Answer 4

select * from xuesheng join school on xuesheng.schoolid=school.schoolid

Answer 5

sda.Fill(ds, "xuesheng"); 这个xuesheng表的数据都显示出来了 没有执行where a.schoolid=b.schoolid这个条件啊 

Answer 6

那个不是算是条件啦
应该算是内连接看看sql的帮助文档
里面的内连接、外连接等信息

Answer 7

 试试：  protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("server=10.200.128.120;database=KJVIEW;uid=sa;pwd=tcs54321;");
        string sql = "select * from xuesheng where xuesheng.schoolid=school.schoolid";
        //SqlCommand com = new SqlCommand(sql, con);
        SqlDataAdapter sda = new SqlDataAdapter(sql, con);  //Insus.NET changed
        //sda.SelectCommand = com;
        con.Open();
        DataSet ds = new DataSet();
        sda.Fill(ds, "xuesheng");
        con.Close();
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();       
    }

Answer 8

不行，你给我发的这个 SQL语句有错误的 select * from xuesheng where xuesheng.schoolid=school.schoolid 这么写不对啊

Answer 9

乱七八糟写的Sql语句.......回去先看一下Sql语句怎么写的...school表在哪?????

Answer 10

school表在这里面呢啊database=KJVIEW;