I have a problem which brings 2 technical questions.
I have a Products table with language independent values (like some ID-s, numeric and DateTime values) and
ProductDetails table with language dependent values (like Name, Description, etc.).
The 2nd table has a column which identifies the language with LCID. The tables have one ot many connection. So I have only one language table no matter how many language I want to support.
The first question is how can I display data from ProductDetails depending on the current locale settings? How can I JOIN these tables in the List template view? I also have to display data from the
Products table in the same gridview. So if I click on Products
in Default.aspx (My tables) I should see rows from Products with values from
ProductDetails on the selected language.
The secound question is how should I create a form which display input fileds for every language? This Insert/Update template view should display fields for
Products table and multiple fields for different languages separated by a tabcontrol (or similar). This form should submit all values at once and insert one row to
Products and several to ProductDetails.
FTeR
Member
8 Points
22 Posts
LCID: how to scaffold language dependent fields from separate tables?
Jul 28, 2008 02:59 PM|LINK
Hi,
I have a problem which brings 2 technical questions.
I have a Products table with language independent values (like some ID-s, numeric and DateTime values) and ProductDetails table with language dependent values (like Name, Description, etc.).
The 2nd table has a column which identifies the language with LCID. The tables have one ot many connection. So I have only one language table no matter how many language I want to support.
The first question is how can I display data from ProductDetails depending on the current locale settings? How can I JOIN these tables in the List template view? I also have to display data from the Products table in the same gridview. So if I click on Products in Default.aspx (My tables) I should see rows from Products with values from ProductDetails on the selected language.
The secound question is how should I create a form which display input fileds for every language? This Insert/Update template view should display fields for Products table and multiple fields for different languages separated by a tabcontrol (or similar). This form should submit all values at once and insert one row to Products and several to ProductDetails.
ex.:
_____________
_____________
Thanks.
Dynamic Data Insert List.aspx Edit scaffold LCID