62,266
社区成员
发帖
与我相关
我的任务
分享
var xmlhttp;
function btclick()
{
if(window.ActiveXObject)
{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
else if(window.XMLHttpRequest)
{
xmlhttp=new XMLHttpRequest();
}
xmlhttp.onreadystatechange=statechange;
xmlhttp.open("POST","DataPage.aspx,true);
xmlhttp.send();
}
function changeDDL()
{
var dropdownlist=document.getElementById('DropDownListDepartment');
//清空原有项
while(dropdownlist.options.length>0)
{
dropdownlist.remove(0);
}
document.getElementById('DropDownListDepartment').options.add(new Option("全部","0"));//给dropdownlist添加全部
//分割字符,加载数据到dropdownlist
var grop=new Array();
grop=retext.split(";");//首先按;分组,每组是一个ID+Name,用,隔开
//document.getElementById('mydiv').innerHTML=grop.toString();
var len=grop.length;
for(i=0;i<len-1;i++)
{
var temp=grop[i];
var obj=new Array();
obj = temp.split(",");//按,分组,把ID何Name都分开来。
val=obj[0];//值
txt=obj[1];//文本
document.getElementById('DropDownListDepartment').options.add(new Option(txt,val));//给dropdownlist添加数据
}
}
function statechange()
{
if(xmlhttp.readyState==4)
{
if(xmlhttp.status==200||xmlhttp.status==0)
{
var retext=xmlhttp.responseText;
changeDDL(retext);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=sample;User ID=mary;Password=1234;");
string cmdTex = "";
cmdTex = "select departmentID,departmentName from Department";
SqlCommand cmd = new SqlCommand(cmdTex, conn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);
conn.Close();
StringBuilder data = new StringBuilder();
int len = dt.Rows.Count;
for (int i = 0; i < len; i++)
{
data.Append(dt.Rows[i][0].ToString() + "," + dt.Rows[i][1] + ";");
}
Response.Write(data.ToString());
Response.End();//防止了返回一大串HTML代码引发其他错误。
}
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="sm1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="up1" runat="server">
<ContentTemplate>
<asp:Button ID="btnBind" runat="server" Text="BindData" OnClick="Bind_Data" />
<asp:DropDownList ID="ddl1" runat="server">
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
protected void Bind_Data(object sender, EventArgs e)
{
DataTable dt = this.GetData();
this.ddl1.DataSource = dt;
this.ddl1.DataValueField = "key";
this.ddl1.DataTextField = "value";
this.ddl1.DataBind();
}
private DataTable GetData()
{
DataTable dt = new DataTable();
dt.Columns.Add("key", typeof(string));
dt.Columns.Add("value", typeof(string));
DataRow dr = null;
for (int i = 0; i < 10; i++)
{
dr = dt.NewRow();
dr[0] = i;
dr[1] = "value" + i;
dt.Rows.Add(dr);
}
return dt;
}