两种绑定DropDownList数据源的方式


第一种:   (更快)
   
                …………………………………………  
  DataSet   ds=   new   DataSet();      
  ds   =   cls2.SelectOle();  
  DropDownList1.DataSource   =   ds.Tables["My"].DefaultView;          
  DropDownList1.DataTextField   =   "dep_Name";      
  DropDownList1.DataValueField   =   "dep_Id";      
  DropDownList1.DataBind();    
   
  第二种: (更灵活) 
   
  DataSet   set1=   new   DataSet();    
  set1   =   cls2.SelectOle();  
  for   (int   num1   =   0;   num1   <   set1.Tables["My"].Rows.Count;   num1++)  
  {  
  DropDownList1.Items.Add(set1.Tables["My"].Rows[num1][1].ToString());  
  }  
   
  <asp:DropDownList   id="DropDownList1"     DataValueField="dep_Id"   DataTextField="dep_Name"   runat="server"></asp:DropDownList>

查询功能代码(包括普通查询和全部查询):protected void Button2_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DataBS(ds, strsql); GridView1.DataSource = ds.Tables["table"]; GridView1.DataBind(); DropDownList1.SelectedValue = "不限"; DropDownList2.SelectedValue = "不限"; DropDownList3.SelectedValue = "不限"; DropDownList4.SelectedValue = "不限"; DropDownList5.SelectedValue = "不限"; Label8.Text = "查询结果: 共" + ds.Tables[0].Rows.Count + "条记录"; } protected void Button1_Click(object sender, EventArgs e) { string str = ""; string str1 = ""; if (DropDownList1.SelectedItem.Text != "不限") str += " and CourseGrade='" + DropDownList1.SelectedValue + "'"; if (DropDownList2 .SelectedItem .Text !="不限") str +=" and CourseTerm='" + DropDownList2.SelectedValue + "'"; if (DropDownList3.SelectedItem.Text != "不限") str += " and CourseSort='" + DropDownList3.SelectedValue + "'"; if (DropDownList4.SelectedItem.Text != "不限") str += " and SpecialtyDirection='" + DropDownList4.SelectedValue + "'"; if (DropDownList5.SelectedItem.Text != "不限") str += " and CourseTeacher='" + DropDownList5.SelectedValue + "'"; if (str != "") { str1 = str.Substring(5); strsql += " where " + str1; } DataSet ds = new DataSet(); DataBS(ds, strsql); if (ds.Tables[0].Rows.Count != 0) { GridView1.DataSource = ds.Tables["table"]; GridView1.DataBind(); } else { Response.Write("<script language=JavaScript>alert('没有符合条件的记录!');</script>"); GridView1.Visible = true ; } Label8.Text = "查询结果: 共" + ds.Tables[0].Rows.Count + "条记录"; }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值