protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindDropdownlist();
GetNumber(0,num);
}
} //绑定下拉类别
private void BindDropdownlist()
{
drpSelect.Items.Insert(0, new ListItem("111", "111"));
drpSelect.Items.Insert(0, new ListItem("222", "222"));
drpSelect.Items.Insert(0, new ListItem("333", "333"));
drpSelect.Items.Insert(0, new ListItem("444", "444"));
drpSelect.Items.Insert(0, new ListItem("555", "555"));
drpSelect.Items.Insert(0, new ListItem("666", "666"));
}
private void GetNumber()
{
OleDbConnection MyConn;
MyConn = new OleDbConnection(ConfigurationManager.AppSettings["myconnstring"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mydbpath"]));
MyConn.Open();
string cmdText = "SELECT * FROM [Number] where [number] like '%" + drpSelect.SelectedValue.ToString() + "%' ORDER BY Id DESC";
if (Keyword.Text.ToString() != null)
{
cmdText = "SELECT * FROM [Number] where [number] like '%" + Keyword.Text.ToString() + "%' ORDER BY Id DESC";
}
protected void Button2_Click(object sender, EventArgs e)
{
int from = Int32.Parse(lblCurrentpage.Text.ToString()) - 1;
GetNumber(from * num, num);
}为什么按钮按了以后,文本框内的关键词能筛选出来,下拉中的词就是筛选不出来
{
if (!Page.IsPostBack)
{
BindDropdownlist();
GetNumber(0,num);
}
} //绑定下拉类别
private void BindDropdownlist()
{
drpSelect.Items.Insert(0, new ListItem("111", "111"));
drpSelect.Items.Insert(0, new ListItem("222", "222"));
drpSelect.Items.Insert(0, new ListItem("333", "333"));
drpSelect.Items.Insert(0, new ListItem("444", "444"));
drpSelect.Items.Insert(0, new ListItem("555", "555"));
drpSelect.Items.Insert(0, new ListItem("666", "666"));
}
private void GetNumber()
{
OleDbConnection MyConn;
MyConn = new OleDbConnection(ConfigurationManager.AppSettings["myconnstring"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mydbpath"]));
MyConn.Open();
string cmdText = "SELECT * FROM [Number] where [number] like '%" + drpSelect.SelectedValue.ToString() + "%' ORDER BY Id DESC";
if (Keyword.Text.ToString() != null)
{
cmdText = "SELECT * FROM [Number] where [number] like '%" + Keyword.Text.ToString() + "%' ORDER BY Id DESC";
}
protected void Button2_Click(object sender, EventArgs e)
{
int from = Int32.Parse(lblCurrentpage.Text.ToString()) - 1;
GetNumber(from * num, num);
}为什么按钮按了以后,文本框内的关键词能筛选出来,下拉中的词就是筛选不出来
1.那个Dropdownlist是静态的为什么不直接在页面上写
2.你的那个GetNumber() 只是拼了SQL没有执行?
我很奇怪你到底要做什么功能