• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

VB.net insert multiple records into table on insert based on Order Number

I have a table Order_No with Order_No (Auto Increment) and Date Ordered
I also have another table Order with ID, Order_No (Which needs to be populated of the next available number from the Order_No table)

Then I also need to know how to loop through on insert for my Orders table based on ProductID. Each Product has unique values and all items will be tied together by Order_No.  I have done simple inserts into a table before, but never one like this...


            Dim insertOrder As New Data.SqlClient.SqlCommand("INSERT INTO Orders(Order_No,AssociationID,Customer_ID,ProductID,Options,Rate,RateOvveride) VALUES (@Order_No,@AssociationID,@Customer_ID,@ProductID,@Options,@Rate,@RateOvveride); SELECT SCOPE_IDENTITY();", myConnection)
            insertOrder.Parameters.AddWithValue("@AssociationID", ddlAssociation.SelectedValue)
            insertOrder.Parameters.AddWithValue("@Customer_ID", ddlExhibitor.SelectedValue)
            insertOrder.Parameters.AddWithValue("@ProductID", txtDirProdID.Text)
            insertOrder.Parameters.AddWithValue("@Options", ddlDirSize.SelectedValue)
        Catch ex As Exception
            lblConfirmation.Text = "Error saving: " & ex.Message.ToString
        End Try

Open in new window

1 Solution
Bob HoffmanDeveloperCommented:
You'd be better off writing a stored procedure to do all this. Execute the stored procedure from your vb.net app. That way all the wrok is executed on the server from a single client-side call.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now