通过 Dictionary＜string, string＞泛型集合键值对的方法对DataSet多表查询的时候 为Table进行初始化表名称(赋表名称)

         定义链接数据库字符串
         string connString="SERVER= ;UID= ;PWD= ;DataBase= ";
          //实例化conn
        SqlConnection  conn = new SqlConnection(connString);
        //通过泛型集合定义查询语句 并对表赋表名称
        Dictionary<string, string> dic = new Dictionary<string, string>();
        dic.Add("Student", "Select *from Student");
        dic.Add("Course", "Select*from Course");
        foreach (KeyValuePair<string,string> item in dic)
        {
            //实例化cmd
            SqlCommand cmd = new SqlCommand(item.Value, conn);
            //实例化DataAdapter
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            //指定DataAdapter类型
            sda.SelectCommand = cmd;
            //打开conn
            conn.Open();
            //填充
            sda.Fill(ds, item.Key);
            //关闭
            conn.Close();
        }
        dgvStudent.DataSource = ds.Tables["Student"];
        dgvCourse.DataSource = ds.Tables["Course"];