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

mike

10y1kSQL

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

ali tuncer10y ago
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 Info,like name/lastname, because inOrder Table, we only keep CustomerID..
0
mike10y ago
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?
0
Vincent Maverick Durano10y ago
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.
0
ali tuncer10y ago
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, ProductName,Quantity, 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..
+1