private void GetCancels()
{
if (CancelFoodRsnBtnList != null)
{
CancelFoodRsnBtnList.RemoveAll();
CancelFoodRsnBtnList = null;
}
CancelFoodRsnBtnList = new CancelFoodRsnButtonList(Panel1, 74, 40, Color.LightBlue, Color.FromArgb(255, 128, 128), 4);
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = rms_var.ConnStr;
try
{
SqlCommand selectCMD = new SqlCommand("SELECT * FROM CancelReason", conn);
selectCMD.CommandTimeout = 30;
SqlDataAdapter dbDA = new SqlDataAdapter();
dbDA.SelectCommand = selectCMD;
conn.Open();
DataSet dbDS = new DataSet();
dbDS.Clear();
dbDA.Fill(dbDS, "t");
for (int i = 0; i <= dbDS.Tables[0].Rows.Count - 1; i++)
{
CancelFoodRsnBtnList.AddNewButton(dbDS.Tables[0].Rows[i]["reason"].ToString());
}
CancelReason = dbDS.Tables[0].Rows[0]["reason"].ToString();
CancelFoodRsnBtnList.SelectItem(0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
private void GetCancels()
{
if (CancelFoodRsnBtnList != null)
{
CancelFoodRsnBtnList.RemoveAll();
CancelFoodRsnBtnList = null;
}
CancelFoodRsnBtnList = new CancelFoodRsnButtonList(Panel1, 74, 40, Color.LightBlue, Color.FromArgb(255, 128, 128), 4);
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = rms_var.ConnStr;
try
{
SqlCommand selectCMD = new SqlCommand("SELECT * FROM CancelReason", conn);
selectCMD.CommandTimeout = 30;
SqlDataAdapter dbDA = new SqlDataAdapter();
dbDA.SelectCommand = selectCMD;
conn.Open();
DataSet dbDS = new DataSet();
dbDS.Clear();
dbDA.Fill(dbDS, "t");
for (int i = 0; i <= dbDS.Tables[0].Rows.Count - 1; i++)
{
CancelFoodRsnBtnList.AddNewButton(dbDS.Tables[0].Rows[i]["reason"].ToString());
}
CancelReason = dbDS.Tables[0].Rows[0]["reason"].ToString();
CancelFoodRsnBtnList.SelectItem(0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
