不同页面显示搜索的问题(蔡鸟类发问)
我要做两个网页temp1、temp2,我先开始在temp1网页里设置了两个下拉框和两个输入框还有一个按钮。
要实现的功能就是,选择相应的下拉框内容,并输入一些文字,然后点击按钮后可以根据这些内容在数据库中搜索。
下面是部分代码
temp1.aspx.cs中----------
string dd_US;
string dd_TS;
string tb_QD;
string tb_ZD;
dd_US = DropDownList1.Text.Trim();
dd_TS = DropDownList2.Text.Trim();
tb_QD = TextBox1.Text.ToString();
tb_ZD = TextBox2.Text.ToString();
string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["LocalSqlServer"]);
SqlConnection myconn = new SqlConnection(settings);
myconn.Open();
string strselect = "SELECT [InfoID], [Useraccount],[fromwhere],[towhere],[Pubdate] FROM [userinfo] WHERE ([Usertype] = @dd_US)and([Taketype]= @dd_TS) and ([fromwhere] like '%'+@tb_QD+'%') and ([towhere] like '%'+@tb_ZD+'%')";
SqlCommand mycmd = new SqlCommand(strselect, myconn);
mycmd.Parameters.Add("@dd_US", DropDownList1.Text.Trim());
mycmd.Parameters.Add("@dd_TS", DropDownList2.Text.Trim());
mycmd.Parameters.Add("@tb_QD", TextBox1.Text.ToString());
mycmd.Parameters.Add("@tb_ZD", TextBox2.Text.ToString());
SqlDataReader mydr = mycmd.ExecuteReader();
SearchGridView.DataSource = mydr;
SearchGridView.DataBind();
myconn.Close();
----------------
temp1.aspx中
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>乘客</asp:ListItem>
<asp:ListItem>车主</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>上下班</asp:ListItem>
<asp:ListItem>市内</asp:ListItem>
<asp:ListItem>长途</asp:ListItem>
<asp:ListItem>趴活</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /><br />
<asp:GridView ID="SearchGridView" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
现在我不想让搜索的结果在temp1中显示,我想要当点击按钮后在temp2中显示搜索结果。请问应如何改动呢?
用form提交表单怎么做?谢谢!