搜索的问题 laike.aspx页面
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
<a><%#Eval("type_name") %></a>
</ItemTemplate>
</asp:DataList>laike.aspx。cs文件
namespace Web
{
public partial class laike : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["StrWhere"] = "1=1";
showty( ViewState["StrWhere"].ToString());
if (Request.QueryString["a"] != null)
{
ViewState["StrWhere"] = ViewState["StrWhere"] + " and (type_name like '%" + (Request.QueryString["a"].ToString()) + "%')";
showty(ViewState["StrWhere"].ToString());
}
} }
protected void showty(string q)
{
DataList1.DataSource = new BLL.Products.type().GettypeAllList();
DataList1.DataBind();
}
}
}aaaa.aspx
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="搜索" OnClick="Button1_Click" />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="aaaaaaaa">
<asp:ListItem Value="1">你好</asp:ListItem>
<asp:ListItem Value="2">w hen</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server" OnSelectedIndexChanged="cccc">
<asp:ListItem Value="1">很好</asp:ListItem>
<asp:ListItem Value="2">w呵呵n</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownList3" runat="server">
</asp:DropDownList>
</div>
aaaa.aspx.csnamespace Web
{
public partial class aaaa : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//DropDownList1.Visible =false;
//ViewState["StrWhere"] = "1=1";
//DropDownList1.Items.IndexOf(0, new ListItem("请选择", ""));
DropDownList1.Items.Insert(0, new ListItem("请选择", "")); }
} protected void aaaaaaaa(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue.ToString() == "1")
{
DropDownList3.Visible =true;
DropDownList2.Visible = false;
}
else if (DropDownList1.SelectedValue.ToString() == "2")
{
DropDownList2.Visible = true;
DropDownList3.Visible = false;
}
else
{
DropDownList3.Visible = true;
DropDownList2.Visible = true;
}
} protected void cccc(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string k=DropDownList1.SelectedValue.Trim();
string a = TextBox1.Text.Trim();
if (k == "")
{
Response.Redirect("ak.aspx");
}
else
{
if (a == "")
{
Response.Redirect("laike.aspx");
}
else
{
Response.Redirect("laike.aspx?a="+a);
}
}
} }
}
ak.aspx 页面
<div>
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate><%#Eval("companyname")%></ItemTemplate>
</asp:DataList>
</div>
ak.aspx.cs 文件
namespace Web
{
public partial class ak : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack)
{
shocon(); }
}
protected void shocon()
{
DataList1.DataSource = new BLL.cop.company().GetAllList();
DataList1.DataBind();
}
}
}
我点击搜索,跳转到laike.aspx页面的时候,并不是我查询到的这个相应的集合,而是所有页面,怎么样才能将我想查询的集合显示出来啊 ,大虾教教我啊
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
<a><%#Eval("type_name") %></a>
</ItemTemplate>
</asp:DataList>laike.aspx。cs文件
namespace Web
{
public partial class laike : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["StrWhere"] = "1=1";
showty( ViewState["StrWhere"].ToString());
if (Request.QueryString["a"] != null)
{
ViewState["StrWhere"] = ViewState["StrWhere"] + " and (type_name like '%" + (Request.QueryString["a"].ToString()) + "%')";
showty(ViewState["StrWhere"].ToString());
}
} }
protected void showty(string q)
{
DataList1.DataSource = new BLL.Products.type().GettypeAllList();
DataList1.DataBind();
}
}
}aaaa.aspx
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="搜索" OnClick="Button1_Click" />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="aaaaaaaa">
<asp:ListItem Value="1">你好</asp:ListItem>
<asp:ListItem Value="2">w hen</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server" OnSelectedIndexChanged="cccc">
<asp:ListItem Value="1">很好</asp:ListItem>
<asp:ListItem Value="2">w呵呵n</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownList3" runat="server">
</asp:DropDownList>
</div>
aaaa.aspx.csnamespace Web
{
public partial class aaaa : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//DropDownList1.Visible =false;
//ViewState["StrWhere"] = "1=1";
//DropDownList1.Items.IndexOf(0, new ListItem("请选择", ""));
DropDownList1.Items.Insert(0, new ListItem("请选择", "")); }
} protected void aaaaaaaa(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue.ToString() == "1")
{
DropDownList3.Visible =true;
DropDownList2.Visible = false;
}
else if (DropDownList1.SelectedValue.ToString() == "2")
{
DropDownList2.Visible = true;
DropDownList3.Visible = false;
}
else
{
DropDownList3.Visible = true;
DropDownList2.Visible = true;
}
} protected void cccc(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string k=DropDownList1.SelectedValue.Trim();
string a = TextBox1.Text.Trim();
if (k == "")
{
Response.Redirect("ak.aspx");
}
else
{
if (a == "")
{
Response.Redirect("laike.aspx");
}
else
{
Response.Redirect("laike.aspx?a="+a);
}
}
} }
}
ak.aspx 页面
<div>
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate><%#Eval("companyname")%></ItemTemplate>
</asp:DataList>
</div>
ak.aspx.cs 文件
namespace Web
{
public partial class ak : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack)
{
shocon(); }
}
protected void shocon()
{
DataList1.DataSource = new BLL.cop.company().GetAllList();
DataList1.DataBind();
}
}
}
我点击搜索,跳转到laike.aspx页面的时候,并不是我查询到的这个相应的集合,而是所有页面,怎么样才能将我想查询的集合显示出来啊 ,大虾教教我啊
解决方案 »
- asp.net打印word的问题
- MenuItemClick事件响应问题
- 大家帮我看看这个sql语句哪里错了?
- 孟子等人...出来,我一次也没有晕倒~~~只是~!!!!!
- recordset转成asp.net中的什么东西?
- datagrid删除提示问题。看了好多我这个就是不行,大家帮个忙?
- [初次接触Infragistics,无法添加引用]
- 怎么设置ListBox和DropDownList的属性呀?
- 没分了,问一个问题,谢谢。
- 生成html页面后,读出是乱码
- 求自己写的类,怎样才能在Global中使用?
- 建ASP.NET三层架构的web时是不是不该使用Membership API来创建用户和角色管理?
如果你想根据上个页面的条件进行查询
可以利用Post或者url传值
或者cookie
还有asp.net好像还可以获取上一个页面的控件值从而在本页面进行查询
string sql=" where 1=1";
sql+=Request.QueryString["a"] == null?"":" and 条件 like '%"+Request.QueryString["a"].ToString()+"%'";