/*如果用户登录，那么就展示全部课程*/
private void InitData()
{
string strCon = "Integrated Security=SSPI;Initial Catalog='NetDesign';Data Source='DESKTOP-HJQH3C9';User ID='sa'; Password = '******'; Connect Timeout = 30";
SqlConnection conn = new SqlConnection(strCon);
DataSet ds = new DataSet();
string str = "SELECT s.s_id AS 系部编号, s.s_name AS 系部名称, c.c_name AS 所属院 FROM System s LEFT JOIN College c ON s.c_id = c.c_id";
SqlDataAdapter da = new SqlDataAdapter(str, conn);
conn.Open();
da.Fill(ds);
conn.Close();
System1.DataSource = ds;
System1.DataBind();
}
