/C#/Assign datasource to dropdownlist in c#

Assign datasource to dropdownlist in c#

cmd.CommandText = " Select * From GetUsersID";
        cmd.Connection = conn;
        conn.Open();
        DataTable dt  = new DataTable();

        dt.Load(cmd.ExecuteReader());
        conn.Close();

        DropDownList1.DataSource = dt;
        DropDownList1.DataTextField = "Name";
        DropDownList1.DataValueField = "ID";
        DropDownList1.DataBind();

Source: codeproject.com

Similar codes

1 vote202 views1 answer
Unity lookrotation lerp
C#
1 vote204 views1 answer
Unity script detect if in prefab edition mode
C#
6 votes209 views1 answer
Oncollisionenter unity
C#
6 votes242 views1 answer
How to play video in ui unity
C#
1 vote266 views1 answer
Struct constructor c#
C#
0 vote229 views1 answer
Create class for database connection in c#
C#
0 vote252 views1 answer
Difference between Math.Floor() and Math.Truncate()
C#
3 votes191 views2 answers
Unity mouse click m
C#
53 votes216 views6 answers
Load scene unity
C#
0 vote249 views1 answer
Csharp attributes as generics constraints
C#