Question

怎么实现一个textbox与一个dropdownlist的无刷新联动

怎么实现一个textbox与一个dropdownlist的无刷新联动，最好用c#来写
。用textbox的值做为条件在数据库中取值后自动填充到dropdownlist中。
谢谢

Answer 1

用AJAX控件啊！

把AJAX控件先放好！然后把textbox和dropdownlist都放进去！就好了！

Answer 2

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MeetWeb;
public partial class AjaxTest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxTest));
if (!Page.IsPostBack)
{
BindData();

}
}
private void BindData()
{
DataSet ds = new DataSet();
String sql = "Select id,name from test";
try
{
ds = GetDataSet(sql, "test");
this.DropDownList1.DataSource = ds.Tables[0];
this.DropDownList1.DataTextField = "name";
this.DropDownList1.DataValueField = "id";
this.DropDownList1.DataBind();
this.DropDownList1.Attributes.Add("onclick", "areaResult();");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

public static DataSet GetDataSet(string sql,string aa)
{
MeetWeb.SqlDataBase a = new MeetWeb.SqlDataBase("server=localhost\\PMSERVER;uid=sa;pwd=sa;database=test");
DataSet ds = new DataSet();
ds=a.CreateSet(sql, aa);
return ds;
}

[AjaxPro.AjaxMethod]
public DataSet GetCityList(int id)
{
string sql = "select name from test where id='" + id + "'";
return GetDataSet(sql,"test");
}

}

Answer 3

AJAX这个海