Inserting multiple records @ once trying to group with 1 Id

Question

I have a program where I'm inserting multiple records at once with an order. Some thing like if a customer is ordering multiple items. I'm trying to group the items with 1 Id so I can display them with 1 Customer and multiple Items. This is the code I'm using: http://www.c-sharpcorner.com/UploadFile/8c19e8/dynamically-adding-and-deleting-rows-in-gridview-and-saving/ I'm collecting the data I get from this code and putting it into my database. I have another table with customers. I'm trying to give the customers and the group of items the same Id so I can display the customers name and the items together. Thanks for any suggestions.

ali tuncer · Answer

You didn't give information about your database tables. How do you save records? I would keep 2 tables for Sales Order and OrderDetail columns would basically be like this(I am keeping it simple you might need more columns) Order- Id CustomerID Date TotalPrice OrderDetail-Id OrderID ProductNameQuantity Price So if I want to find a orders for a customer I would join Order and OrderDetail tables and use where to filter for customer..

ali tuncer · Answer

On the second table (OrderDetail) you will have a column OrderID it is a foreign key so when you create an order your tables will look like this here there are 2 orders.. For instance in Order table you can have this info : ID CustomerID OrderDate 1 5 5/17/2016 2 12 5/17/2016 In OrderDetail table you will have info like this : ID OrderID ProductName Quantity 1 1 Product A 1 2 1 ProductB 2 3 2 ProductC 1 We can see there are 2 orders by customers with ID 5 and 12(from Order table) First order is by customerID =5 from OrderDetail we can see he ordered 1 piece Product A and 2 piece ProductB(from OrderID column) I nquery you can join these 2 tables Order(ID) and OrderDetail(OrderID) You can also join Order Table to Customer Table to get customer Infolike name/lastname because inOrder Table we only keep CustomerID..

mike · Answer

Thanks for your reply. I have a separate table that collects all the data that is entered in by the code that allows the user to enter multiple entries. If you need to see the code I'm using this is the link: http://www.c-sharpcorner.com/UploadFile/8c19e8/dynamically-adding-and-deleting-rows-in-gridview-and-saving The thing is every new row added and entered has a new Primary Key Id. What I need is a Order Number that will group all the entries that are entered in by that user at that time to have 1 ID number Not from the Primary Key. If I add another table would that make it easier the group the entries together? Is there a SQL Statement that would do that or is it in my C# code?

Vincent Maverick Durano · Answer

I would agree with Ali that using two tables would be ideal. This way you could store customerid and orderid in your parent table and save the rest of the details in your child table.

Inserting multiple records @ once, trying to group with 1 Id