I have a table in my database called "Profiles". This holds data on Female and Male personal characteristics.
On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select method
which retrieves data from the "Profiles" Table via a DAL.
The "Profiles" table has some columns which relates to females only and some just males and some are generic to both.
See example below
UserId - / of Type GUID
GenreId / of Type BOOL.
Hip Size (For females)
Dress Size ( For Females)
ChestSize (For Men )
TrouserSize (For Men)
Weight ( For both )
When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists which
are binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc.
If a female user logs in I just want to show them the (Hip Size) DDL and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or TrouserSize DDL.
At present the GetProfileByUserId returns all colums from the table
My question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the user
may not have selected an item in the previous form so they could also be
View Complete Post