C# Programming
07-04-2009, 05:00 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.
to be exact i want to do something like the "JOIN" function in SQL Server.
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.
modified on Saturday, July 4, 2009 8:21 AM
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.
to be exact i want to do something like the "JOIN" function in SQL Server.
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.
modified on Saturday, July 4, 2009 8:21 AM