C#

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

/// <summary>
 /// Clean up any resources being used.
 /// </summary>
 /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
 protected override void Dispose(bool disposing)
 {
     if (disposing && (components != null))
     {
         foreach (ItemSelectedEventHandler eventDelegate in ItemSelected.GetInvocationList())
         {
             ItemSelected -= eventDelegate;
         }
         components.Dispose();
     }
     base.Dispose(disposing);
 }