void BindDataGridView()
{
string conn = System.Configuration.ConfigurationSettings.AppSettings["conn"].ToString();
SqlConnection sqlconn = new SqlConnection(conn);
sqlconn.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from lab_Users,lab_Roles where lab_Users.RoleID=lab_Roles.RoleID", sqlconn);
DataSet dataSet = new DataSet();
adp.Fill(dataSet);
DataTable dt = dataSet.Tables[0];
dataGridView1.AutoGenerateColumns = false; //这句很重要
dataGridView1.DataSource = dt;
}