hi ,
u am having a datagrid PkgItem
and it has 6 coloumns and it gets data from 2 tables i.e itemMaster and table PKgOrderItem.
i m getting data from tble pkgOrdrItem but unable to get data from ItemMaster.
can u help
thank u.
mahesh
Printable View
hi ,
u am having a datagrid PkgItem
and it has 6 coloumns and it gets data from 2 tables i.e itemMaster and table PKgOrderItem.
i m getting data from tble pkgOrdrItem but unable to get data from ItemMaster.
can u help
thank u.
mahesh
You are goint to have to explain you problem better. We have know idea what pkgOrdrItem is. Show us some code or explain yourself better. Or both.
Me.objdsOrderItems = getPopulatedDataSet("select POI.ItemNo ,POI.Quantity,POI.UnitRate,POI.ItemValue,POI.DeliveryDt,im.ItemDesc,im.Unit from PkgOrderItem POI,ItemMast im where POI.ItemNo=im.ItemNo ", Me.objdsPkgItemMast, Me.OleDbConnection1)
***PkgOrderItem is a table