hi i have three tables, Stock, InStock, OutStock
tables columns:
- Stock: IdStock,CodeStock, Date
- InStock: Id_InStock, IdStock, mount_InStock
- OutStock: Id_OutStock, IdStock, mount_OutStock
Table relationship:
- Stock 1:N InStock (FK IdStock)
- Stock 1:N OutStock (FK IdStock)
**Stock sample data:**
IdStock,CodeStock, Date
- 8 , st10 , 03/12/2014
- 11 , st20 , 02/12/2014
- 12 , st25 , 09/12/2014
- 14 , st27 , 03/12/2014
**InStock sample data**
Id_InStock, IdStock, mount_InStock
- 2, 8, 1250
- 3, 8, 100
- 5, 11, 250
**OutStock sample data**
Id_OutStock, IdStock, mount_OutStock
- 1, 8, 350
- 6, 12, 1100
- 7, 12, 750
i'd like to export all the data (InStock & OutStock) where date of stock between (02/12/2014 & 03/12/2014) in the same gridview
like my gridview column contains:
CodeStock | Date | mount
st10 | 03/12/2014 | 1250
st10 | 03/12/2014 | 100
st20 | 02/12/2014 | 250
st10 | 03/12/2014 | 350
The first three line from
InStock
table and the last line from
OutStock
Table
so can you help me about the request should write to give this result and to bind the result in my gridview