如何从数据库分配Dropdownlist项目 [英] how to assign Dropdownlist item from database

问题描述

选择下拉列表项时，我必须启用某些按钮和文本框.
我通过查询从数据库中获取下拉列表项.
如果我必须从下拉列表中选择一个项目，在这种情况下，If循环将如何工作?
请帮助
感谢

Hi,
I have to enable certain buttons and textboxes on selecting a dropdownlist item.
I fetch the drop down list items from database through a query.
How a If loop will work in this case if i have to select an item from dropdownlist ??
Kindly help
thanks

推荐答案

使用此代码

DataTable datatable = logic.GetID();
如果(datatable！= null)
{
如果(datatable.Rows.Count> 0)
{
ddlTeacherID.DataSource =数据表;
ddlTeacherID.DataValueField = datatable.Columns [0] .ToString();
ddlTeacherID.DataTextField = datatable.Columns [0] .ToString();
ddlTeacherID.DataBind();

}
}


Hare GetID()方法包含您的查询

Use this code

DataTable datatable = logic.GetID();
if (datatable != null)
{
if (datatable.Rows.Count > 0)
{
ddlTeacherID.DataSource = datatable;
ddlTeacherID.DataValueField = datatable.Columns[0].ToString();
ddlTeacherID.DataTextField = datatable.Columns[0].ToString();
ddlTeacherID.DataBind();

}
}


Hare GetID() method contains your query

private void Fillddl()
    {
        DataTable dtNames = new DataTable();
        dtNames = GetNames();
        if (dtNames != null)
        {
            ddlid.DataSource = dtNames ;
            ddlid.DataTextField = "NAME";
            ddlid.DataValueField = "ROLL_NO";
            ddlid.DataBind();
        }
        ddlid.Items.Insert(0, "Select");
        ddlid.Items[0].Value = "-1";
    }

在GetNames()
通过两列NAME和ROLL_NO
获取数据表 使用任何数据库查询
如果返回

In GetNames()
Get datatable with two columns NAME and ROLL_NO
Using any of database query
IF it returns

NAME      ROLL_NO
-----------------
Manoj     456456
Roshan    789456

您的下拉列表将包含

选择
马诺伊
roshan

其值分别为卷号

Ur Drop down will contain

Select
Manoj
roshan

with value respective roll number

这篇关于如何从数据库分配Dropdownlist项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！