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