ajax例子

<form id="Form1" method="post" runat="server">
<asp:DropDownList id="goodsType" style="Z-INDEX: 101; LEFT: 216px; POSITION: absolute; TOP: 88px"
runat="server" Width="184px"></asp:DropDownList>
<asp:DropDownList id="pptype" style="Z-INDEX: 102; LEFT: 536px; POSITION: absolute; TOP: 96px" runat="server"
Width="152px"></asp:DropDownList></form>
<script language="javascript">
<!--
var pptypelist = document.getElementById("<%=pptype.ClientID%>");

function loadPP(goodsType)
{
var goodsID = document.getElementById("goodsType").value;//goodsType.options[goodsType.selectedIndex].value;
if(goodsID >0)
{
Demo.getPP(goodsID,loadPP_CallBack);
}
else
{
pptypelist.options.length = 0;
}
}
//callback we told Ajax.Net to pass the response tos
function loadPP_CallBack(response)
{
if(response.error != null)
{
alert(response.error); //we should probably do better than this
return;
}
var ds = response.value;
if(ds == null ||typeof(ds) !="object")
{
return;
}
pptypelist.options.length = 0;
for (var i = 0; i < ds.Tables[0].Rows.length; i++)
{
//pptypelist.options[pptypelist.options.length] = new Option(ds.Tables[0].Rows[i].PPName, ds.Rows[i].PPID);
var name = ds.Tables[0].Rows[i].ppName;
var ID = ds.Tables[0].Rows[i].PPID;
document.getElementById("pptype").options.add(new Option(name,ID));
}
}


//-->
</script>

public class Demo : Page
 {
  protected System.Web.UI.WebControls.DropDownList goodsType;
  protected System.Web.UI.WebControls.DropDownList pptype;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   Ajax.Utility.RegisterTypeForAjax(typeof(Demo));
   if(!this.IsPostBack)
   {
       goodsType.DataSource = bindData();
    goodsType.DataTextField = "GoodsTypeName";
    goodsType.DataValueField ="GoodsType_ID";
    goodsType.DataBind();

    goodsType.Items.Insert(0,new ListItem("--please select item --"));
    goodsType.Attributes.Add("onchange","loadPP(this);");
   }
  }
  public DataTable bindData()
  {
     SqlConnection conn = new SqlConnection("server=.;database=cvbbs; uid=sa;pwd=");
     conn.Open();
     SqlDataAdapter da = new SqlDataAdapter("select * from D_GoodsTypeInfo",conn);
     DataTable dt = new DataTable();
     da.Fill(dt);
     return dt;
  }
  [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
  public DataSet getPP(int goodsTypeID)
  {
   //string str ="select * from D_PP where GoodsType_ID = "+goodsTypeID;
   SqlConnection conn = new SqlConnection("server=.;database=cvbbs; uid=sa;pwd=");
   conn.Open();
   SqlCommand  cmd = new SqlCommand();
   cmd.Connection = conn;
   cmd.CommandText ="p_GoodsTypeGetPP";
   cmd.CommandType = CommandType.StoredProcedure;
   SqlDataAdapter da = new SqlDataAdapter(cmd);
   cmd.Parameters.Add("@GoodsID",goodsTypeID);
   DataSet ds = new DataSet();
   da.Fill(ds);
   if(ds!=null && ds.Tables[0].Rows.Count>0)
    return ds;
   else
    return null;
  }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值