How to add value from database to combobox

To add data from mysql table to combobox in c#

Private void Form1_load(Object sender,EventArgs e){

 

MysqlConnection conn = New MysqlConnection();

MysqlCommand comm = New MysqlCommand();

MysqlAdapter adapat = New MysqlAdapter;

MysqlDataReader reader;

string Connection = “Server=YourSeverName ; user = youruser;database = yourdatabase;”;

conn = new MysqlConnection(Connection);

conn.Open();

comm = conn.CreateCommand();

comm.CommandText  = “select column_name from tablename;”;

adapat = New MysqlDataAdapter(comm);

reader = comm.ExecuteReader();

while (reader.Read()){

string skode = reader.GetString(“Kodebarang”);

combobox1.Items.Add(skode);

 

}

conn.close()

 

}