下拉列表只需“选择”值不是选定的值 [英] dropdown take only "select" value not the selected value

问题描述

dropdownlist只选择第一个值而不是选中的值

这是我的代码

SqlConnection con = new SqlConnection（cn.ConnectionStrings）;

con.Open（）;

string bind =SELECT [PriId]，[Priority] FROM [WebCrm]。[dbo]。[tbl_Priority];

adp = new SqlDataAdapter（bind，con）;

DataTable dt = new DataTable（）;

adp.Fill（dt）;

ddlPriority1。 DataSource = dt;

ddlPriority1.DataValueField =PriId;

ddlPriority1.DataTextField =Priority;

ddlPriority1.DataBind（）;

ddlPriority1.Items.Insert（0，Select）;

ddlPriority1.SelectedIndex =（0）;

con.Close（） ;

dropdownlist select only first value not the selected value
This is my code
SqlConnection con = new SqlConnection(cn.ConnectionStrings);
con.Open();
string bind = "SELECT [PriId],[Priority] FROM [WebCrm].[dbo].[tbl_Priority]";
adp = new SqlDataAdapter(bind, con);
DataTable dt = new DataTable();
adp.Fill(dt);
ddlPriority1.DataSource = dt;
ddlPriority1.DataValueField = "PriId";
ddlPriority1.DataTextField = "Priority";
ddlPriority1.DataBind();
ddlPriority1.Items.Insert(0, "Select");
ddlPriority1.SelectedIndex = (0);
con.Close();

推荐答案

确保将该代码放入

Make sure you put that code inside of

if (!IsPostBack)
{

}

因为您可能每次页面发布时都会对您的下拉列表进行数据绑定背部。这将导致您丢失所选值。

because you are probably databinding your dropdown everytime the page posts back. That will cause you to lose the selected value.

如果您的页面获得回发，您已设置ddlPriority1.SelectedIndex =（0）;在您的密码中。



试试这个对您有所帮助。





if（！IsPostBack）

{

SqlConnection con = new SqlConnection（cn.ConnectionStrings）;

con.Open（）;

string bind =SELECT [PriId]，[Priority] FROM [WebCrm]。[dbo]。[tbl_Priority];

adp = new SqlDataAdapter（bind，con） ;

DataTable dt = new DataTable（）;

adp.Fill（dt）;

ddlPriority1.DataSource = dt;

ddlPriority1.DataValueField =PriId;

ddlPriority1.DataTextField =Priority;

ddlPriority1.DataBind（）;

ddlPriority1.Items.Insert（0，Select）;

ddlPriority1.SelectedIndex =（0）;

con.Close（）;

}

If your page getting postback,you have set ddlPriority1.SelectedIndex = (0); in your code.

Try this may be helpful for you.


if (!IsPostBack)
{
SqlConnection con = new SqlConnection(cn.ConnectionStrings);
con.Open();
string bind = "SELECT [PriId],[Priority] FROM [WebCrm].[dbo].[tbl_Priority]";
adp = new SqlDataAdapter(bind, con);
DataTable dt = new DataTable();
adp.Fill(dt);
ddlPriority1.DataSource = dt;
ddlPriority1.DataValueField = "PriId";
ddlPriority1.DataTextField = "Priority";
ddlPriority1.DataBind();
ddlPriority1.Items.Insert(0, "Select");
ddlPriority1.SelectedIndex = (0);
con.Close();
}

这篇关于下拉列表只需“选择”值不是选定的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！