/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

28 votes127 views2 answers
Unity check if gameobject is active
C#
2 votes121 views2 answers
Difference between alpha and beta testing
C#
0 vote117 views1 answer
How to make a 3d object do something when clicked on
C#
0 vote127 views1 answer
C# calendar button random dates
C#
0 vote161 views1 answer
Unity oculus vibrate
C#Unity
2 votes114 views1 answer
Calling stored procedure in c# entity framework
C#
2 votes118 views1 answer
Windows form rounded corners
C#
1 vote118 views1 answer
C# zeitverzögerung
C#
0 vote112 views1 answer
How to change something in the window using a thread wpf
C#
3 votes145 views1 answer
Unity how to change the text on a button
C#Unity