I am here trying to find if GridView has some solution to my problem.
I have a table 'Contacts' with has fields like
PresentAddress|CityID|StateID|CountryID|ZoneID
PermanentAddress|CityID|StateID|CountryID|ZoneID
DepartmentID
DesignationID
DivisionID.
Now all above fields are foreign keys in contacts table. Currently i am retrieving data using Joins and displaying in Gridview.
One of my problem is that CityID|StateID|CountryID|ZoneID tables are used twice in joins with different alias to fill up their associated values for PresentAddress & PermanentAddress fields. so overall 11 to 12 tables in a join. I am sure performance will shout as no of records will increase.
I am thinking if i retrieve from database those Individual master tables (City,State,Country,Zone etc and Contact table) into DataSet (without joins) then CAN GridView help me to retrieve associate data and display. which mean whereever it finds a column CityID, it brings CityName from CityMaster table and display in place of CityID column.
Regards
I have a table 'Contacts' with has fields like
PresentAddress|CityID|StateID|CountryID|ZoneID
PermanentAddress|CityID|StateID|CountryID|ZoneID
DepartmentID
DesignationID
DivisionID.
Now all above fields are foreign keys in contacts table. Currently i am retrieving data using Joins and displaying in Gridview.
One of my problem is that CityID|StateID|CountryID|ZoneID tables are used twice in joins with different alias to fill up their associated values for PresentAddress & PermanentAddress fields. so overall 11 to 12 tables in a join. I am sure performance will shout as no of records will increase.
I am thinking if i retrieve from database those Individual master tables (City,State,Country,Zone etc and Contact table) into DataSet (without joins) then CAN GridView help me to retrieve associate data and display. which mean whereever it finds a column CityID, it brings CityName from CityMaster table and display in place of CityID column.
Regards
2 Answers, 1 is accepted
0
Lee
Top achievements
Rank 1
Rank 1
answered on 04 Mar 2010, 05:29 PM
sheesh...
Got answer to my question myself.
LookupColumns is the answer.
Regards
Leee.
Got answer to my question myself.
LookupColumns is the answer.
Regards
Leee.
0
Hello Lee,
We are happy that you resolved the issue on your own. You can use one of the following columns: GridViewLookUpColumn, GridViewComboBoxColumn, or GridViewMultiComboBoxColumn. You can read more about different types of columns in this documentation article.
If you have further questions, feel free to contact us back.
Regards,
Svett
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
We are happy that you resolved the issue on your own. You can use one of the following columns: GridViewLookUpColumn, GridViewComboBoxColumn, or GridViewMultiComboBoxColumn. You can read more about different types of columns in this documentation article.
If you have further questions, feel free to contact us back.
Regards,
Svett
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.