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();
}
}
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();
}
}
