DataGridView控件与SQL多表连接~！

来源：互联网发布：数据异地备份方案编辑：程序博客网时间：2024/05/05 00:17

一个最简单的代码段：

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 =