日期:2014-05-17 浏览次数:20514 次
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using FrameWork.Components;
namespace FrameWork.web.gongneng
{
public partial class quanxianshezhi : System.Web.UI.Page
{
SqlDataReader reader1; SqlDataReader reader2; SqlDataReader reader3;
sys_UserTable ut = BusinessFacade.sys_UserDisp(Common.Get_UserID);
FrameWork.Data.SqlDataProvider sa = new FrameWork.Data.SqlDataProvider();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Panel1.GroupingText = "站点区";
reader1 = sa.DataBase3("select [UserID] ,[U_LoginName] from sys_User");
reader2 = sa.DataBase3("SELECT [id] ,[name] from [AreaTable]");
while (reader1.Read())
{
DropDownList1.Items.Add(new ListItem(reader1["U_LoginName"].ToString(), reader1["UserID"].ToString()));
}
while (reader2.Read())
{
DropDownList2.Items.Add(new ListItem(reader2["name"].ToString(), reader2["id"].ToString()));
}
reader1.Close();
reader2.Close();
list3();
//COMLIST();
}
COMLIST();
}
&nbs