public void GetFoodOperandis() { if (FoodOperandisBtnList != null) { FoodOperandisBtnList.RemoveAll(); FoodOperandisBtnList = null; } FoodOperandisBtnList = new FoodOperandisButtonList(Panel1, 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 foodoperandi"; 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++) { FoodOperandisBtnList.AddNewButton(dbDS.Tables[0].Rows[i]["name"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } }