ASP.NET

williammcq wrote:

VPODS.InsertCommandType = SqlDataSourceCommandType.Text

williammcq wrote:

I have setup a insert command that includes a dollar value like so:

VPODS.InsertCommandType = SqlDataSourceCommandType.Text
VPODS.InsertCommand = "INSERT INTO [VPO] ([OrderDate], [Project], [Supplies], [NoExceed])VALUES (@OrderDate, @Project, @Supplies, @NoExceed)"

VPODS.InsertParameters.Add("OrderDate", Now())
VPODS.InsertParameters.Add("Project", Project)
VPODS.InsertParameters.Add("Supplies", TypeCode.Boolean, Supplies)
VPODS.InsertParameters.Add("NoExceed", TypeCode.Decimal, NoExceed)

rowsAffected = VPODS.Insert()

It is posting to an Access DB and the NoExceed file is of DataType Dollar.

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.

 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.