/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

3 votes304 views2 answers
Unity pause coroutine
C#
1 vote271 views1 answer
Change partial view based on select asp.net core
C#
0 vote291 views1 answer
Id dublication exception c# .net core
C#
0 vote314 views1 answer
PUN 2 Network Transform View Jittery Movement
C#
31 votes348 views3 answers
Create new gameobject unity
C#Unity
0 vote289 views1 answer
Uninstall-SPSolution: This solution contains resources scoped for a Web application and must be retracted from one or more Web applications.
C#
0 vote285 views1 answer
Visual studio c# mark class deprecated
C#
1 vote313 views1 answer
How to close and reopen an app in c#
C#
0 vote338 views1 answer
How to delay execution in c#
C#
1 vote351 views1 answer
Loop through all enum values in C#
C#