如何从数据库中选择下拉值 [英] How to select dropdown value from database

问题描述

我有一个下拉列表，值来自数据库，如何从数据库中选择下拉值



假设

下拉列表1,2,3,4,5将来

默认情况下应该选择3并且你不能选择那个

3将是用户之前选择的值，这存储在数据库中，并在下拉列表中进行检索

i have a dropdown list ,the values are coming from database ,how to select the dropdownvalue from database

suppose
in dropdown 1,2,3,4,5 will come
by default 3 should be selected and u can not select that one
3 will be the selected value by the user previous,this is stored in the database and retrivig it in dropdown

推荐答案

DataTable dt = ds_Job_Open.Tables [0];



if（dt.Rows.Count> 0）

{

ddljob.DataSource = dt;

ddljob.DataTextField =Job_Title;

ddljob.DataValueField =Job_Id;

ddljob.DataBind（）;



}

DataTable dt = ds_Job_Open.Tables[0];

if (dt.Rows.Count > 0)
{
ddljob.DataSource = dt;
ddljob.DataTextField = "Job_Title";
ddljob.DataValueField = "Job_Id";
ddljob.DataBind();

}

试试这个



@ Html.DropDownListFor（model => model.xyz，new SelectList（new List<） ;对象> {

new {key =，value =Choose}，

new {key = 1，value =1}，
new {key = 2，value =2}，

new {key = 3，value =3}，

new {key = 4，value =4}

}，key，Value，3），new {@class =form-control}）

Try This

@Html.DropDownListFor(model => model.xyz, new SelectList(new List<Object>{
new { key= "" , value = "Choose" },
new { key= 1 , value = "1" },
new { key= 2 , value = "2" },
new { key= 3 , value = "3" },
new { key= 4 , value = "4" }
}, "key", "Value",3), new { @class = "form-control" })

这篇关于如何从数据库中选择下拉值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！