定义链接数据库字符串
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"];
通过 Dictionary<string, string>泛型集合键值对的方法对DataSet多表查询的时候 为Table进行初始化表名称(赋表名称)
最新推荐文章于 2024-04-28 19:45:00 发布