使用SQL Server(C＃ / ASP.NET)中的MASTER中的多个标准搜索栏 /按钮遇到麻烦

Question

嘿，我对变量从site.master的转移到另一个窗口的转移是一个小问题...

来自site.master的代码：

<div class="search">
        <asp:Label ID="LandID" runat="server" Text="LandID"/>
        &nbsp;<asp:TextBox ID="txtSearch" runat="server" />
        &nbsp;<asp:Label ID="CarBrand" runat="server" Text="CarBrand" />
        &nbsp;<asp:TextBox ID="txtSearch2" runat="server" />
        &nbsp;<asp:Label ID="Model" runat="server" Text="Model"/>
        &nbsp;<asp:TextBox ID="txtSearch3" runat="server" />
        &nbsp;<asp:Button ID="cmdSearch" runat="server" Text="Search" Style="width: 100px" OnClick="cmdSearch_Click" />
</div>

site.master.cs的代码：

public static string Text { get; set; }
public static string Text2 { get; set; }
public static string Text3 { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
    Text = txtSearch.Text;
    Text2 = txtSearch2.Text;
    Text3 = txtSearch3.Text;
    Response.Redirect("search.aspx");
}

search.aspx的代码：

   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
    OnSelectedIndexChanged="GridView1_SelectedIndexChanged" DataKeyNames="ID">
    <Columns>
        <asp:CommandField ShowSelectButton="True" />
        <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" InsertVisible="False"
            ReadOnly="True" />
        <asp:BoundField DataField="LandID" HeaderText="LandID" SortExpression="LandID" />
        <asp:BoundField DataField="Bilmaerk" HeaderText="Bilmaerk" SortExpression="Bilmaerk" />
        <asp:BoundField DataField="Model" HeaderText="Model" SortExpression="Model" />
        <asp:BoundField DataField="Variant" HeaderText="Variant" SortExpression="Variant" />
        <asp:BoundField DataField="StartYear" HeaderText="StartYear" SortExpression="StartYear" />
        <asp:BoundField DataField="SlutYear" HeaderText="SlutYear" SortExpression="SlutYear" />
        <asp:BoundField DataField="Volumen" HeaderText="Volumen" SortExpression="Volumen" />
        <asp:BoundField DataField="MaxDrej" HeaderText="MaxDrej" SortExpression="MaxDrej" />
        <asp:BoundField DataField="AntalCylindre" HeaderText="AntalCylindre" SortExpression="AntalCylindre" />
        <asp:BoundField DataField="TopHast" HeaderText="TopHast" SortExpression="TopHast" />
        <asp:BoundField DataField="Acceleration" HeaderText="Acceleration" SortExpression="Acceleration" />
        <asp:BoundField DataField="Beskrivelse" HeaderText="Beskrivelse" SortExpression="Beskrivelse" />
        <asp:BoundField DataField="Effekt" HeaderText="Effekt" SortExpression="Effekt" />
        <asp:BoundField DataField="Picture" HeaderText="Picture" SortExpression="Picture" />
    </Columns>
</asp:GridView>
<selectparameters>
<asp:ControlParameter ControlID="<%=Text1 %>"></asp:ControlParameter>
<asp:ControlParameter ControlID="<%=Text2 %>"></asp:ControlParameter>
<asp:ControlParameter ControlID="<%=Text3 %>"></asp:ControlParameter>
</selectparameters>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CarConnectionString %>"
    SelectCommand="SELECT * FROM [Bil] WHERE (([LandID] LIKE '%' +@LandID+ '%') AND ([Bilmaerk] LIKE '%' +@Bilmaerk+ '%') AND ([Model] LIKE '%' +@Model+ '%'))">
    <SelectParameters>
        <asp:ControlParameter ControlID="Text1" Name="LandID" PropertyName="Text" Type="String"
            DefaultValue="%" />
        <asp:ControlParameter ControlID="Text2" Name="Bilmaerk" PropertyName="Text" Type="String"
            DefaultValue="%" />
        <asp:ControlParameter ControlID="Text3" Name="Model" PropertyName="Text" Type="String"
            DefaultValue="%" />
    </SelectParameters>
</asp:SqlDataSource>

search.aspx.cs的相关代码：

   public partial class search : System.Web.UI.Page
   {
protected string Text1 { get; set; }
protected string Text2 { get; set; }
protected string Text3 { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
    Text1 = SiteMaster.Text;
    Text2 = SiteMaster.Text2;
    Text3 = SiteMaster.Text3;
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    Constructor.SelectedCar = GridView1.SelectedRow.Cells[1].Text;
    Response.Redirect("Selected.aspx");
}
}

Answer 1

在页面加载或基于页面的生命周期的主人的页面上，最初将不同搜索字段的文本框存储在会话变量中。

然后您可以在搜索按钮上访问这些变量，然后您可以进一步继续基本步骤，例如转到数据库并搜索相关字段等。

通过使用这些会话变量，您可以在任何页面中的任何地方访问它们，除非您更改值....

   public void search(object sender ,EventArgs e)
    {
        string Search = session["search"].toString();
        Search =  Search + "%";
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add("search", Search);
            Search = "%" + Search;//for user name ,user email,languages made the search criteria as anywhere in the word for others it is starting letter
            SqlDataSource1.SelectParameters.Clear();//again we have to clear and add since search is changed
            SqlDataSource1.SelectParameters.Add("search", Search);
            SqlDataSource1.SelectCommand = "SELECT [UserID], [UserName], [UserEmail], [UserContact], [UserAddress], [Gender], [Languages], [Status], [Passwords],[Image] FROM [Users_raghu] where [UserName] like @search";
    }

这是您可以在此处引用的示例，在您的情况下，您只给您一个搜索变量，您必须进行3个会话变量并进一步继续

希望这会有所帮助：D

Answer 2

为什么不使用会话将数据从一个页面传输到另一页。它很简单，

//this is how you will create the Session on master page 
{
   Session["text"] = txtearch.Text;
   Session["Text2"] = txtSearch2.Text;
   Session["Text3"] = txtSearch3.Text;
}
on another page just use it like
{
   string a = Session["text"].ToString();
   string b = Session["text2"].ToString();
   string c = Session["text3"].ToString();
}

Answer 3

尝试使用http获取方法，例如代码：

在您的stite.master.cs

上

protected void cmdSearch_Click(object sender, EventArgs e)
{
    Text = txtSearch.Text;
    Text2 = txtSearch2.Text;
    Text3 = txtSearch3.Text;
    Response.Redirect(string.Format("search.aspx?txtSearch={0}&txtSearch2={1}&txtSearch3={2}", Text, Text2, Tex3));
}

在您的search.aspx.cs

上

protected void Page_Load(object sender, EventArgs e)
{
    Text1 = Request["txtSearch"];
    Text2 = Request["txtSearch2"];
    Text3 = Request["txtSearch3"];
}

您还可以通过致电：

将获取参数添加到主页控制中

(Master.FindControl("txtSearch") as TextBox).Text = Request["txtSearch"];