ExecuteNonQuery() - ASP / Active Server Pages

As i'm a beginner,I'm sure am missing something quite simple but i cant seem to find it or figure it out.

Expand|Select|Wrap|Line Numbers

 <%@ Page Language="vb" AutoEventWireup="True" Debug="True"%>

<%@ IMPORT namespace="System.Data" %>

<%@ IMPORT namespace="System.Data.OleDb" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insert Product, Admin Level</title>

<script language="vb" runat="server">

Dim connectioncw01 as OleDbConnection 

Dim commandcw01 as OleDbCommand 

Dim readercw01 as OleDbDataReader
 
Private Sub Page_Load(Sender as Object, EventArg As EventArgs)
 
  connectioncw01 = New OleDbConnection ("provider=microsoft.jet.oledb.4.0; data source=" + Server.MapPath(".") + "\cw01.mdb;")
 
End Sub
 
Private Sub ButtonInsert_Click(Sender as Object, EventArg As EventArgs)
 
  commandcw01 = new OleDbCommand("INSERT INTO Products ([ProductID], [ProductName], [Supplier], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [Reorderlevel]) VALUES (@ID, @Name, @Supplier, @QuantityPerUnit, @UnitPrice, @UnitsInStock, @UnitsOnOrder, @Reorderlevel  );")

  commandcw01.Parameters.Add(new OleDbParameter("@ID", OleDbType.Integer))

  commandcw01.Parameters("@ID").Value = TextProductID.Text

  commandcw01.Parameters.Add(new OleDbParameter("@ProductName", OleDbType.Char))

  commandcw01.Parameters("@ProductName").Value = TextProductName.Text

  commandcw01.Parameters.Add(new OleDbParameter("@Supplier", OleDbType.Char))

  commandcw01.Parameters("@Supplier").Value = TextSupplier.Text

  commandcw01.Parameters.Add(new OleDbParameter("@QuantityPerUnit", OleDbType.Char))

  commandcw01.Parameters("@QuantityPerUnit").Value = TextQuantityPerUnit.Text

  commandcw01.Parameters.Add(new OleDbParameter("@UnitPrice", OleDbType.Integer))

  commandcw01.Parameters("@UnitPrice").Value = NumberUnitPrice.Text

  commandcw01.Parameters.Add(new OleDbParameter("@UnitsInStock", OleDbType.Integer))

  commandcw01.Parameters("@UnitsInStock").Value = NumberUnitsInStock.Text

  commandcw01.Parameters.Add(new OleDbParameter("@UnitsOnOrder", OleDbType.Integer))

  commandcw01.Parameters("@UnitsOnOrder").Value =NumberUnitsOnOrder.Text

  commandcw01.Parameters.Add(new OleDbParameter("@Reorderlevel", OleDbType.Integer))

  commandcw01.Parameters("@Reorderlevel").Value =NumberReorderlevel.Text
 
  commandcw01.Connection = connectioncw01

  connectioncw01.Open()

  commandcw01.ExecuteNonQuery()

  connectioncw01.Close() 

  Server.Transfer("Admin_Main.aspx")

End Sub
 
Private Sub ButtonBack_Click(Sender as Object, EventArg As EventArgs)

  Server.Transfer("Admin_Main.aspx")

End Sub
 
</script> 

<style type="text/css">

  .controlText {font-family: Verdana; font-size: 10pt; }

</style>
 
</head>

<body>

  <div align="center" class="controlText">

    Administration Level<br/>Adding a product</div>
 
  <form runat="server">

    <table width="100%" cellspacing="2" cellpadding="2" border="0" class="controlText">

      <tr>

        <td width="39%" align="right">Product ID</td>

        <td width="53%" align="left"><asp:TextBox CssClass="controlText" Width="100" ID="TextProductID" runat="server"/>

          <asp:Button CssClass="controlText" Width="60" ID="ButtonInsert" Text="Add" OnClick="ButtonInsert_Click" runat="server"/>          

          &nbsp;

        <asp:Button CssClass="controlText" Width="60" ID="Back" Text="Back" OnClick="ButtonBack_Click" runat="server"/></td>

        <td width="8%" align="left">&nbsp;        </td> 

      </tr>

                      <td align="right">Product Name</td> 

    <td align="left"><asp:TextBox ID="TextProductName" Type="text" Size="30" Maxlength="30" runat="server"/>

    <asp:RequiredFieldValidator ID="ProductNameRequired" runat="server" ControlToValidate="TextProductName"

    ErrorMessage="Please list the product name" Display="dynamic"> </asp:RequiredFieldValidator>

    <br />
 
      <tr>

      <td align="right">Supplier:</td> 

    <td align="left"><asp:TextBox ID="TextSupplier" Type="text" Size="30" Maxlength="30" runat="server"/>

    <asp:RequiredFieldValidator ID="SupplierRequired" runat="server" ControlToValidate="TextSupplier"

    ErrorMessage="Supplier Is Required" Display="dynamic"> </asp:RequiredFieldValidator>

    <br />

    </td>

      </tr>

            <td align="right">Quantity Per Unit</td> 

    <td align="left"><asp:TextBox ID="TextQuantityPerUnit" Type="text" Size="30" Maxlength="30" runat="server"/>

    <asp:RequiredFieldValidator ID="QuantityRequired" runat="server" ControlToValidate="TextQuantityPerUnit"

    ErrorMessage="Please list the quantity" Display="dynamic"> </asp:RequiredFieldValidator>

    <br />

    </td>
 
      </tr>

            <tr>

      <td align="right">Unit Price (£)</td> 

    <td align="left"><asp:TextBox ID="NumberUnitPrice" Type="number" Size="10" Maxlength="10" runat="server" Text='00.00'/>

<asp:RegularExpressionValidator ID="UnitPrice" ControlToValidate="NumberUnitPrice" runat="server" ValidationExpression="(\d{1,}\.\d{1,}|\d{1,})"> Enter a price for the product (XX.XX) </asp:RegularExpressionValidator>

    <br />
 
            </tr>

            <tr>

      <td align="right">Units In Stock</td> 

    <td align="left"><asp:TextBox ID="NumberUnitsInStock" Type="number" Size="10" Maxlength="10" runat="server" Text='0'/>

<asp:RegularExpressionValidator ControlToValidate="NumberUnitsInStock" ValidationExpression="\d{1,}" EnableClientScript="true" ErrorMessage="Enter a range of 0 or more"

runat="server" /> </asp:RegularExpressionValidator>

    <br />

    </td>

          </tr>

                  </tr>

            <tr>

      <td align="right">Units On Order</td> 

    <td align="left"><asp:TextBox ID="NumberUnitsOnOrder" Type="number" Size="10" Maxlength="10" runat="server" Text='0'/>

<asp:RegularExpressionValidator ControlToValidate="NumberUnitsOnOrder" ValidationExpression="\d{1,}" EnableClientScript="true" ErrorMessage="Enter a range of 0 or more"

runat="server" /> </asp:RegularExpressionValidator>

    </td>

          </tr>

            <tr>

           <tr>

      <td align="right">Reorder Level</td> 

    <td align="left"><asp:TextBox ID="NumberReorderLevel" Type="number" Size="10" Maxlength="10" runat="server" Text='0'/>

<asp:RegularExpressionValidator ControlToValidate="NumberReorderLevel" ValidationExpression="\d{1,}" EnableClientScript="true" ErrorMessage="Enter a range of 0 or more!"

runat="server" /> </asp:RegularExpressionValidator>

    <br />

    </td>

          </tr>

            <tr>

          </table>

  </form>

</body>

</html>

Mar 14 '07 #1

Subscribe Post Reply

2886

Similar topics

ExecuteNonQuery SQLCommand

by: Mark | last post by:

Hi, I have a sqlCommand object that I use to execute an SQL statement. I thought I could use the ExecuteNonQuery to test for the number of rows returned by the sql command but it does not seem to...

.NET Framework

ExecuteReader() v. ExecuteNonQuery()

by: Mark | last post by:

It appears that you can only retrieve an Output parameter from a SQL Server stored procedure when using the ExecuteNonQuery of the SqlCommand class, and cannot use the ExecuteReader() method. In...

C# / C Sharp

?At a loss? ExecuteNonQuery executing my Insert Statement 3 times in debug mode

by: Mike | last post by:

I know this sounds strange but I am at a loss. I am calling a simple funtion that opens a connection to a SQL Server 2000 database and executes an Insert Statement. private void...

C# / C Sharp

SQLHeper ExecuteNonQuery - returning values

by: Paul Aspinall | last post by:

Hi I have a Stored Proc in SQL server, which creates a record key when a record is created. I want to return the value back to my code, once the record has been created. I am using SQLHelper...

C# / C Sharp

Run time error on: objCommand.ExecuteNonQuery()

by: Matthew Louden | last post by:

I just tried to create a simple ASP.NET application to add record to the SQL Server database. However, it has run time error on Line 88: objCommand.ExecuteNonQuery() Any ideas?? Please help!!...

ASP.NET

ExecuteNonQuery Update Not Working

by: johnnymack0730 | last post by:

Hello - I am currently working on an asp.net application that needs to be able to update an access table using ExecuteNonQuery method. I have all the code setup, it runs, there are no errors...

ASP.NET

"Operation must use an updateable query" on ExecuteNonQuery()

by: MDW | last post by:

Hey all. I'm confused. I'm trying to add a single record into an Access 2000 database using ASP.Net. Here is the code: objConn = New OleDbConnection(strConnect) objConn.Open objCommand =...

ASP.NET

Timing for ExecuteNonQuery

by: jdb | last post by:

Hi, I am adding a record to the database using an ExecuteNonQuery, which adds without problem. Now after the record is added I run a method passing in some info as well as the curretnly opened...

Visual Basic .NET

How to control what gets returned by command.ExecuteNonQuery()?

by: keithb | last post by:

What can I put in a stored procedure to control what gets returned by command.ExecuteNonQuery()? I already tried this: param = comm.CreateParameter(); param.ParameterName = "@Success"; ...

ASP.NET

Is it possible to "cache" the "parameterised" SQL text sent by SqlCommand.ExecuteNonquery() ?

by: TheSteph | last post by:

Hi I have a SQLCommand that do updates on a table. I have a loop where I set the parameters then I call ExecuteNonQuery. For . { . Set the SQLCommand's Params Values;

C# / C Sharp

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA