/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

0 vote164 views1 answer
Take photo function in unity
C#Unity
4 votes125 views2 answers
Group by linq multiple columns C#
C#
0 vote162 views1 answer
C# modify dictionary in loop
C#
0 vote128 views1 answer
How to clip out ui element if they are not inside an element unity
C#Unity
0 vote176 views1 answer
C# if statement no braces
C#
0 vote123 views1 answer
Unity time.fixeddeltatime
C#
1 vote123 views1 answer
Unity Rotate around the real center
C#
0 vote131 views1 answer
Convert-integer-to-binary-in-c-sharp
C#
2 votes140 views1 answer
How to do a web request unity
C#
2 votes146 views1 answer
C# convert dictionary to anonymous object
C#