学步园

function GetList() {
 document.getElementById("ListBox1").options.length=0;
 var param=getDDLTextandValue();
        var url = "GetUserList.aspx?SessionName=" + encodeURI(encodeURI(param));
        send_request(url);
    }

    var XML_Http_Request = false;
    function createXMLHttpRequest() {
        XML_Http_Request = false;

        if (window.XMLHttpRequest) {
            XML_Http_Request = new XMLHttpRequest();
            if (XML_Http_Request.overrideMimeType) {
                XML_Http_Request.overrideMimeType("text/xml");
            }
        }
        else if (window.ActiveXObject) {
            try {
                XML_Http_Request = new ActiveXObject("Msxml2.XMLHTTP");
            } catch (e) {
                try {
                    XML_Http_Request = new ActiveXObject("Microsoft.XMLHTTP");
                } catch (e) { }
            }
        }
    }

    function send_request(url) {
        createXMLHttpRequest();
        if (!XML_Http_Request) {
            window.alert("Cannot create XMLHttpRequest instance!");
            return false;
        }
        XML_Http_Request.onreadystatechange = process_Request;
        XML_Http_Request.open("GET", url, true);
        XML_Http_Request.send(null);
    }
    function process_Request() {
        if (XML_Http_Request.readyState == 4) {
            if (XML_Http_Request.status == 200) {
var xmlDoc=XML_Http_Request.responseText;
//var xx=xmlDoc.split(',');
//for(var i=0;i++;i<xx.length)       
//{
//if(xx[i]!="")
//{
//var yy=xx[i].split('|');
//LISTAddNew(yy[0],yy[1],DropDownList1);
//}

//}  

 

 var str2=new Array();
    str2=xmlDoc.split(",");
    var list1=document.getElementById("ListBox1");
    for(i=0;i<str2.length;i++)
    {
    if(str2[i]!="")
    {
     var yy=new Array();
     yy=str2[i].split("|");
     var newOption11=new Option(yy[0],yy[1]);
            list1.options.add(newOption11);
        }
    }
            }

 

 

调用 GetList
        }
    }

 

后台取值页面（GetUserList）代码：

 

    string Groupid = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        Groupid = Request.QueryString["SessionName"];
        try
        {
            OleDbConnection myconn = new OleDbConnection();

            myconn.ConnectionString = ConfigurationManager.ConnectionStrings["strconn"].ConnectionString;
            myconn.Open();
            OleDbCommand mycomm = new OleDbCommand();
            if (Groupid == "-1")
                mycomm.CommandText = "select * from TGroup_User order by userid";
            else
                mycomm.CommandText = "select * from TGroup_User where Groupid=" + Groupid + " order by userid";
            mycomm.CommandType = CommandType.Text;
            mycomm.Connection = myconn;
            OleDbDataReader mydr = mycomm.ExecuteReader();

            string s = "";

            if (mydr.HasRows)
            {
                while (mydr.Read())
                {
                    s = s + ',' + mydr["UserId"].ToString();
                }
            }

            if (s.Length != 0)
            {
                s = s.Substring(1, s.Length - 1);
            }
            else
            {
                s = "-100";
            }
            //Response.Write(s);
            mydr.Close();
            string sql = "";
            if (Groupid == "-1")
                sql = "select * from TUser where IsAdminUser = '1' order by Country DESC, UserName";
                else if(Groupid == "-2")
                sql = "select * from TUser where IsAdminUser = '0' order by Country DESC, UserName";
            else
                sql = "select * from TUser where UserId in (" + s + ") order by Country DESC, UserName";
            string content = string.Empty;
            mycomm.CommandText = sql;
            mydr = mycomm.ExecuteReader();
            if (mydr.HasRows)
            {
                while (mydr.Read())
                {
                    content = content + ',' + mydr["UserName"].ToString();
                    content = content + '|' + mydr["UserId"].ToString();
                }
            }
            myconn.Close();
            mycomm.Dispose();
            mydr.Close();
           Response.Write(content);
           Response.End();
//             DataSet custds = new DataSet();
//custds.Load(mydr,LoadOption.OverwriteChanges,new string[] { "TableName" });

//Response.Write(custds.GetXml());
//            Response.End();       
         
        }
        catch (Exception ex)
        {
        
        }
        finally
        {
        }
    }