protected void Page_Load( object sender , EventArgs e ) { Security s = Session["sec"] as Security; if (s == null) { Response.Redirect("error.aspx"); } dbModule dm = new dbModule(); SqlDataSource1.SelectCommand = "SELECT [ID], [GLYXM], [SYSID], [GLYID], [SYSMC], [SYSDD] FROM [V_SYSGLY] where sysid in (select sysid from t_sysxxb where syslxid =" + dm.getZrSYSID( s.getUserCode()) +")"; SqlDataSource4.SelectCommand = "select id ,sysmc from t_sysxxb where syslxid =" + dm.getZrSYSID( s.getUserCode() ); if ( !IsPostBack ) { GLYDDL.DataSource = SqlDataSource3; GLYDDL.DataTextField = "GLYXM"; GLYDDL.DataValueField = "DLM"; GLYDDL.DataBind(); SYSDDL.DataSource = SqlDataSource4; SYSDDL.DataTextField = "SYSMC"; SYSDDL.DataValueField = "ID"; SYSDDL.DataBind(); } }