G
Guest
Hi there,
I'm using framework 2 with web application project, one of my page have 5
dropdownlist and one gridview. The dropdownlists data are stored in SQL
Server (data may grow more in the future)
1. sector (about 4 items)
2. business type (39 items) depend on sector selected
3. building type ( 57 items) depend on sector selected
4. electric (1704 items) depend on other textbox entered
5. gas (1026 items) depend on other textbox entered
I'm using SqlDataAdapter to populate all dropdownlists when the page load
and using viewstate for postback. Every time postback happened I must
re-populate dropdownlist whatever values changes. I just wonder there is
better way to handle this solution. I'm thinking about SqlDataSourec for each
dropdownlist but what is the pro vs con for using SqlDataSource. When
postback happen, does each SqlDatasourec calls database? My gridview is
using SqlDataSource now.
Any suggestions. Thanks.
I'm using framework 2 with web application project, one of my page have 5
dropdownlist and one gridview. The dropdownlists data are stored in SQL
Server (data may grow more in the future)
1. sector (about 4 items)
2. business type (39 items) depend on sector selected
3. building type ( 57 items) depend on sector selected
4. electric (1704 items) depend on other textbox entered
5. gas (1026 items) depend on other textbox entered
I'm using SqlDataAdapter to populate all dropdownlists when the page load
and using viewstate for postback. Every time postback happened I must
re-populate dropdownlist whatever values changes. I just wonder there is
better way to handle this solution. I'm thinking about SqlDataSourec for each
dropdownlist but what is the pro vs con for using SqlDataSource. When
postback happen, does each SqlDatasourec calls database? My gridview is
using SqlDataSource now.
Any suggestions. Thanks.