1、使用udl文件自动生成连接语句
//step1 creat the connenction string
string strcon = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=db_PWMS;Data Source=DESKTOP-CF5K0P5\\SQLEXPRESS";
//creat a sqlconnection instance
SqlConnection sqlCon = new SqlConnection(strcon);
//取表中的内容到缓存
SqlDataAdapter sqladp = new SqlDataAdapter("select*from tb_City", sqlCon);
//将缓存中的内容填入dataset1数组
sqladp.Fill(dataSet1);
//对gridview赋值
dataGridView1.DataSource = dataSet1.Tables[0];