Re: Query Problems

Tech-Archive recommends: Speed Up your PC by fixing your registry

thanks

The Grand Master

FishingScout wrote:
He did thank you, you illiterate putz! Read his message.

I am impressed that you actually help someone. (by the way, you don't
need to thank me for that nice comment)

Master Programmer wrote:
"Thanks for your help" would have been nice. Ignorant *** !

jimmy wrote:
Hi

In my application i have a dataSet which has been created by the
designer. I have added the following query to one of the tables;

------------------------------------------------------------------------------------------------------------------------------------------------

INSERT INTO reservationsTbl
(OrderID, CustomerID, Time, PartySize, Date)
VALUES (@OrderID, @CustomerID,@Time,@PartySize,@Date)

------------------------------------------------------------------------------------------------------------------------------------------------

I now have the following code to try and execute this query;

------------------------------------------------------------------------------------------------------------------------------------------------

Dim reservationsAdapter As New
dsTableAdapters.reservationsTblTableAdapter
Try
reservationsAdapter.InsertReservation(10, ID,
TimeTxt.Text, PartySizeTxt.Text, DatePicker.Value)
Catch ex As Exception
MsgBox("Inserting new record failed. " + ex.Message)
End Try

------------------------------------------------------------------------------------------------------------------------------------------------

No error message is shown when the code is executed however the record
is not inserted. Can anyone help?

Thanks in advance!

.

Quantcast