Add Database colomn names to DropDownlist using c#

Step1) Take Name Space

using System.Data.SqlClient;

Step2) give the connection to database

SqlConnection cn = new SqlConnection("server=.;database=dbname;uid=root;pwd=root");

Step3)Write below code in Page_Load



 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            MySqlDataReader dr;
            MySqlCommand cmd = new MySqlCommand("select RoomsID as rID,HostelID as hID,BuildingID as bID,FloorID as fID,RoomName as rname,AvailableBeds as Abeds,Status as ST from tblhostelrooms", cn);
            cn.Open();
            dr = cmd.ExecuteReader();
            for (int i = 0; i < dr.FieldCount; i++)
            {
                DropDownList1.Items.Add(dr.GetName(i));
            }
            cn.Close();
        }
    }