C#

LAPEC wrote:

im having another problem

public partial class DtposMDIParentSystem : Form
    {
        
        List<MenuItems>; menuItems = new List<MenuItems>();

        
        public DtposMDIParentSystem()
        {
            InitializeComponent();

            //create the database connection
            OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposDatabase.accdb;");

            //create the command object and store the sql query
            OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Food", aConnection);

            try
            {
                aConnection.Open();

                //create the datareader object to connect to table
                OleDbDataReader reader = aCommand.ExecuteReader();
                while (reader.Read()) 
                {
                    MenuItems mi = new MenuItems();
                    mi.ItemName = reader["Name"].ToString();
                    mi.ItemPrice = Double.Parse(reader["Price"].ToString());

                    menuItems.Add(mi);
                }
                reader.Close();
                aConnection.Close();
            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show("Invalid Masseage = " + ex.Message);
            } 
        }

UserControl1 userC = new UserControl();
//====================================\\
private void cmdStarters_Click(object sender, EventArgs e)
{
    this.StartersPanel.Visible = true;
    this.userC.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
    this.userC.Location = new System.Drawing.Point(0, 0);
    this.userC.Size = new System.Drawing.Size(696, 556);
    this.userC.Enabled = true;
    this.userC.Visible = true;
    this.StartersPanel.Controls.Add(userC);
}

private void cmdOlives_Click(object sender, EventArgs e)
{
    if (menuItems.Count > 0)
    {
        System.Windows.Forms.ListViewItem newItem = new System.Windows.Forms.ListViewItem(menuItems[1].ToString());


        for (int i = 1; i < menuItems[1].ItemName.Length; i++)
        {
            newItem.SubItems.Add(menuItems[i].ToString());
            //newItem.SubItems.Add(menuItems[1].ToString());
        }

        TableOrderListView.Items.Add(newItem);
    }
}

string starterSql = @"SELECT * FROM Food WHERE Food_Type = 'Starter'";
string mainSql = @"SELECT * FROM Food WHERE Food_Type = 'Main'";
// add a statement for each of Dessert, Side Order etc.


using (SqlConnection conn = new SqlConnection(connString))
{
    try
    {
        conn.Open();
        SqlDataAdapter starterDa = new SqlDataAdapter(starterSql, conn);
        starterDa.Fill(menuDS, "Starter");
        SqlDataAdapter mainDa = new SqlDataAdapter(mainSql, conn);
        mainDa.Fill(menuDS, "Main");
        SqlDataAdapter dessertDa = new SqlDataAdapter(dessertSql, conn);
        dessertDa.Fill(menuDS, "Dessert");
        // repeat as necessary

        starterTable = menuDS.Tables["Starter"];
        mainTable = menuDS.Tables["Main"];
        dessertTable = menuDS.Tables["Dessert"];
        // repeat
    }
    catch (Exception e)
    {
        Console.WriteLine("Error: " + e);
    }
}

DtposDatabaseBS.DataSource = foodTable;

mainsUC.ItemSelected += new DtposApplication.Events.ItemSelectedEventHandler(mainsUC_ItemSelected);