Order Importer - Notification Page

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">

   protected void Page_Load(object sender, System.EventArgs e)

   {

       if (Request["OrderIDString"] != null)

       {

           //connect to database

           OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.PhysicalApplicationPath + "\\DemoData\\SageDemoData.mdb;Persist Security Info=False");

           Conn.Open();          

           OleDbCommand Cmd = new OleDbCommand("UPDATE Orders SET ExportedToSage=1 WHERE OrderID IN(" + Request["OrderIDString"] + ")", Conn);

           Cmd.ExecuteNonQuery();

           //disconnect from database

           Conn.Close();      

       }

   }

</script>