public void GetFoodTastes() { if (FoodTastesBtnList != null) { FoodTastesBtnList.RemoveAll(); FoodTastesBtnList = null; } FoodTastesBtnList = new FoodTastesButtonList(Panel2, 75, 45, Color.LightBlue, Color.FromArgb(255, 128, 128), 3); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); conn.ConnectionString = rms_var.ConnStr; try { SqlCommand selectCMD = new SqlCommand(); selectCMD.Connection = conn; selectCMD.CommandText = "SELECT name FROM foodtaste"; selectCMD.CommandTimeout = 30; SqlDataAdapter dbDA = new SqlDataAdapter(); dbDA.SelectCommand = selectCMD; conn.Open(); DataSet dbDS = new DataSet(); dbDA.Fill(dbDS, "t"); for (int i = 0; i <= dbDS.Tables[0].Rows.Count - 1; i++) { FoodTastesBtnList.AddNewButton(dbDS.Tables[0].Rows[i]["name"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } }