C# Programming
07-04-2009, 04:20 PM
Hello Guys :
i really in a deep trouble an tried many way to solve it but couldn't find a solution.
1st am getting my data from xml file....when my application load the dataset reads the data from the xml file.
in the xml file i have two tables : (Product) and (ProductInfo)
tables product consist of (ID"Pk",Type).
and productInfo consist of (ID,Description,Brand,PructType"Fk").
there is a relation between those two tables.
now the problem is i want to show the table (ProductInfo) in the Daragrid but get the type from the Product Table.in other words i want to show coulmns from multiple tables in 1 Datagrid and in 1 view through the relation.i mean i want the Datagrid to view (ID,Description,Brand,Type)
the first 3 from ProductInfoTable an the last one from the Product table
i did that before but i was using SQL Server Database and made View and selected teh coulmns i needed from different tables and the view were like another new table but with the two tables data....and i selected the datasource infor my datagrid that View and with table styles i hid what i wanted to hid.but even now tablestyles not working.....any help or idea will be apprciated.
i really in a deep trouble an tried many way to solve it but couldn't find a solution.
1st am getting my data from xml file....when my application load the dataset reads the data from the xml file.
in the xml file i have two tables : (Product) and (ProductInfo)
tables product consist of (ID"Pk",Type).
and productInfo consist of (ID,Description,Brand,PructType"Fk").
there is a relation between those two tables.
now the problem is i want to show the table (ProductInfo) in the Daragrid but get the type from the Product Table.in other words i want to show coulmns from multiple tables in 1 Datagrid and in 1 view through the relation.i mean i want the Datagrid to view (ID,Description,Brand,Type)
the first 3 from ProductInfoTable an the last one from the Product table
i did that before but i was using SQL Server Database and made View and selected teh coulmns i needed from different tables and the view were like another new table but with the two tables data....and i selected the datasource infor my datagrid that View and with table styles i hid what i wanted to hid.but even now tablestyles not working.....any help or idea will be apprciated.