C#ÈçºÎ¶ÔAccess½øÐжà±í²éѯ

string ConStr = "provider=Microsoft.jet.oledb.4.0;data source=" + Application.StartupPath + @"\MYText.mdb";
            OleDbConnection Olecon = new OleDbConnection(ConStr);
            Olecon.Open();
            //string sql = "Select * from ѧÉúÐÅÏ¢ where ѧºÅ= '" + textBox1.Text.Trim() + "' ";
            string sql = "Select Score ,Student from Student,Score where Score.STU_ID=Student.STU_ID";
            //string sql = "Select * from Score where Score.STU_ID=Student.STU_ID";
            //sql += sql + '"textBox1.Text.Trim()"';
            OleDbDataAdapter da = new OleDbDataAdapter(sql, Olecon);
            DataSet ds = new DataSet();
            da.Fill(ds);
            this.dataGridView1.DataSource = ds.Tables[0];
ÕâÊÇÎҵĴúÂ룺
´íÎó£ºÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ

---

debugһϣ¬¿´¿´¾ßÌåÄĸö²ÎÊýû¸³Öµ¡£

---

"Select Score.[Score] ,Student.[Student] from Student,Score where Score.STU_ID=Student.STU_ID";

---

ûÓÐÓð¡¡­¡­

ÒýÓÃ

"Select Score.