DataGridView¿Ø¼þÓëSQL¶à±íÁ¬½Ó~£¡

Ò»¸ö×î¼òµ¥µÄ´úÂë¶Î£º
string sql = string.Format("select Consult_Info.CName,Consult_Record.RTime,Consult_Record.RContent,Emp_Info.EName,CMode.Mode from Consult_Info inner join Consult_Record on(Consult_Info.CID = Consult_Record.CID) inner join Emp_Info on(Emp_Info.EID=Consult_Record.EID) inner join CMode on(Consult_Record.MID = CMode.MID) where EName = '{0}'", lblConsultationName.Text);
                SqlConnection con = new SqlConnection(constr);
                SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, con);
                DataSet dataSet = new DataSet();
                con.Open();
                dataAdapter.Fill(dataSet);
                dgvList.DataSource = dataSet.Tables[0]; //¸ø¿Ø¼þÌí¼ÓÊý¾ÝÐÅÏ¢
SQL¶à±íÁ¬½Ó´úÂë¶Î£º
1.Consult_Info
2.Consult_Record
3.Emp_Info
4.CMode
£¨4ÕÅ±í£©
select Consult_Info.CName,Consult_Record.RTime,Consult_Record.RContent,Emp_Info.EName,CMode.Mode from Consult_Info inner join Consult_Record on(Consult_Info.CID = Consult_Record.CID) inner join Emp_Info on(Emp_Info.EID=Consult_Record.EID) inner join CMode on(Consult_Record.MID = CMode.MID) where EName =