public void ReadListFood(string nameTable, string table = "Listtable")
{
try
{
String sqlQuery = "select * from " + table;
SqlCommand command = new SqlCommand(sqlQuery, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
if (reader.Read() == false)
{
break;
}
if (reader.GetString(0) == nameTable && reader.GetString(1) != "")
{
parent.Add_FoodINLIST(reader.GetString(1), reader.GetString(2), reader.GetString(4));
}
}
reader.Close();
}
catch
{
MessageBox.Show("Lỗi đọc dữ liệu");
}
}
public void OnPicter_click(object sender, EventArgs e)
{
if (!Exist(lName.Text))
{
//MessageBox.Show("Món " + lName.Text + " đã được chọn");
formQLBan.Add_FoodINLIST(lName.Text, lPrice.Text, "1");
formQLBan.SaveListFood();
//parent.CheckSelected(pSelected);
Tick();
}
}