public void DeleteMainDisplayMenu()
{
string query, MenuName, GroupNo;
SqlCommand command;
connection = new SqlConnection(connectionString);
connection.Open();
query = "select Menu_Name from tblSelectMenu";
command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
MenuName = reader.GetName(0);
GroupNo = reader.GetName(1);
while (reader.Read())
{
MenuName = reader.GetString(0);
GroupNo = reader.GetString(1);
MenuName = MenuName.Trim();
GroupNo = GroupNo.Trim();
if (MenuName != "")
{
query = "DELETE FROM tblDisplayMenu WHERE Menu_Name='" + MenuName + "'";
DeleteItemFromTable(query);
}
}
reader.NextResult();
}
reader.Close();
query = "DELETE tblSellectMenu";
DeleteItemFromTable(query);
connection.Close();
}
