Hi,

I am trying to stop a duplication of a order being processed by querying the database to see if the duplicate order number exists and then use an IF statement to provide a message to stop it being duplicated.

I am able to open the connection to the database as follows but not sure on how to query it to find out if this particular order number exists to be able to then include the IF statement: -

DBConnection = New OleDbConnection ( _
  ConfigurationSettings.AppSettings("ConnectionStrin g"))
DBConnection.Open()
SQLString = "SELECT * FROM ShopBasket INNER JOIN Products " & _
 "ON ShopBasket.ItemNumber = Products.ItemNumber " & _
 "WHERE OrderNumber = '" & Session("OrderNumber") & "' " & _
 "ORDER BY ShopBasket.ItemNumber"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBConnection.Close()

Please can anyone assist me with this problem.

Many Thanks
Sharon

You can use the SQL syntax

if exists
(
  <sql query>
)
<do something>
else
<do something else>

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========