/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 vote153 views1 answer
LAST ELEMT OF ARRAY
C#
0 vote158 views2 answers
C# To Pascal Case
C#
0 vote151 views1 answer
C# get all namespaces in assembly
C#
0 vote207 views1 answer
Unity only one component type
C#Unity
12 votes224 views2 answers
Doing void when gameobject setactive unity
C#Unity
0 vote210 views1 answer
How to play a random sound at the position that you want in unity
C#Unity
0 vote154 views3 answers
C sharp convert string time into 24 hours time
C#
0 vote164 views1 answer
C# take only int from string
C#
0 vote156 views1 answer
C# remove crlf from string
C#
7 votes146 views2 answers
How to make a character move in unity 3d
C#