在变量下拉列表中分配所选值



我有一个页码下拉列表,它从数据库查询中获取正确的值。此列表一切正常,除了我似乎无法弄清楚如何在下拉列表中保留所选值。页码通过查询字符串传递,我将其保留为 ViewState 变量。我可以通过返回.aspx来确认此变量是否正确保留。如何将该值设置为选定值,以便在加载新页面时下拉列表并不总是恢复为"1"?

我的代码隐藏:

public string proc;
public string page
{
    get { return ViewState["page"] as string; }
    set { ViewState["page"] = value; }
}
protected void Page_Load(object sender, EventArgs e)
{
    page = Request.QueryString["page"];
    Page_Numbers();
}
public void Page_Numbers()
{
    if (proc != null)
    {
        int totalRows;
        int totalPages;
        string sqlConn = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
        SqlConnection sqlConnection1 = new SqlConnection(sqlConn);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = (proc);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = sqlConnection1;
        sqlConnection1.Open();
        totalRows = Convert.ToInt32(cmd.ExecuteScalar());
        totalPages = ((totalRows / 1000) + 1);
        sqlConnection1.Close();
        for (int i = 1; i <= totalPages; i++)
        {
            PageDdl.Items.Add(new ListItem(i.ToString()));
            if (i == Convert.ToInt32(page))
            {
                PageDdl.SelectedItem.Value = page;
            }
        }
    }
}
protected void PageDdl_SelectedIndexChanged(object sender, EventArgs e)
{
    Response.Redirect("report.aspx?proc=" + proc + "&page=" + PageDdl.SelectedItem.Text);
}

我的aspx:

        <div class="totalPages">   
            <asp:DropDownList ID="PageDdl" runat="server" 
                onselectedindexchanged="PageDdl_SelectedIndexChanged" 
                AutoPostBack="True" Visible="True">
            </asp:DropDownList>
        </div>
        Page: <%=page %>

在我的aspx上,显示页面变量,以便我可以确认它已正确分配。

您可以在 for 循环中使用 1 行设置所选值:

for (int i = 1; i <= totalPages; i++)
{
    PageDdl.Items.Add(new ListItem() { Text = i.ToString(), Selected = i == Convert.ToInt32(page) });
}
每次

加载页面时都会清除视图状态。若要在重新加载页面时保留它,请改为将其存储在 Session 中。此外,您的Page_Load每次都会覆盖它。所以是的,你把它存储在ViewState中,但也许你想检查它是否在ViewState中而不是覆盖它?

最新更新