Import Excel data in sql server using c# with Foreign key.

Last Reply 3 days ago By dharmendr

Posted 6 days ago

I have two table ,one table is item master File and second table is Order table,

here is my table structure

Item Master File

Item Code Item Name
1 Pen
2 Pencil
3 Apple
4 Car

Order Table

Order ID Item Code QTY
1 1 2
1 2 3
1 3 5

i have excel file in this format

Order ID Item Name QTY
1 Pen 2
1 Pencil 3
1 Apple 5
     

Please Guide ,during import data in table ,it also check that order ID and item Name exit in a table or not....Thanks

You are viewing reply posted by: dharmendr 4 days ago.