ASP.NET

 OleDbConnection dbConn = new OleDbConnection ("connectionstring");<br />
            dbConn.Open ();<br />
            OleDbCommand cmd = new OleDbCommand ();<br />
            cmd.Connection = dbConn;<br />
            cmd.CommandText = "INSERT INTO [VPO] ([OrderDate], [Project], [Supplies], [NoExceed])VALUES (@OrderDate, @Project, @Supplies, @NoExceed)";<br />
<br />
            cmd.Parameters.Add("OrderDate", OleDbType.Date, Now());<br />
            cmd.Parameters.Add("Project", Project);<br />
            cmd.Parameters.Add ("Supplies", OleDbType.Boolean, Supplies);<br />
            cmd.Parameters.Add("NoExceed", OleDbType.Currency , NoExceed); //I assumed that the datatype of this column in MS Access is "Currency".<br />
<br />
            cmd.ExecuteNonQuery ();<br />
<br />
            cmd.Dispose ();<br />
            dbConn.Close ();

williammcq wrote:

Doe the fact that this is a Access DB and not a SQL DB causing a problem?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

<br />
public class Clients : IDisposable<br />
{<br />
<br />
   private SqlConnection _Connection = null;<br />
<br />
   public Clients()<br />
   {<br />
      _Connection = new SqlConnection("ConnectionString") // ConnectionString is a setting ofcourse!<br />
   }<br />
<br />
   public DataTable GetAllClients()<br />
   {<br />
       // Code to return all your clients<br />
   }<br />
<br />
   public DataRow GetClient(int ClientID)<br />
   {<br />
       // Code to return a single client<br />
   }<br />
<br />
   public int CreateClient(string Name)<br />
   {<br />
       // Code to create a client<br />
   }<br />
<br />
   public bool UpdateClient(int ClientID, string Newname)<br />
   {<br />
      // Code to update your client<br />
   }<br />
<br />
   public bool RemoveClient(int ClientId)<br />
   {<br />
      // Code to remove the client<br />
   }<br />
<br />
   public void Dispose()<br />
   {<br />
      if (_Connection != null)<br />
         _Connection.Dispose();<br />
      _Connection = null;<br />
   }<br />
}<br />
<br />

Dim jsScript As String
jsScript = "jsVar = '" & VBVar & "';"
Dim cs As ClientScriptManager = Page.ClientScript
If (Not cs.IsStartupScriptRegistered("InitJSVar")) Then
   cs.RegisterStartupScript(Page.GetType(), "InitJSVar", jsScript, True)
End If

you can use server-side hidden field to communicate between client-side and server-side.

<input id="Hidden1" type="hidden" runat="server"/>



In Form_load

<br />
protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        Hidden1.Value = "13";<br />
    }

You can set like that..

In Client-side ~

<script language="javascript" type="text/javascript"><br />
      function getvalue(){<br />
        var var1 = document.getElementById('Hidden1').value;<br />
        //do something.<br />
      }<br />
    </script><br />

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.