Data binding question

[FlorianS]

Hi I have a question related to data binding. I have a dropdown list defined like this: Ontario Manitoba British Columbia Quebec The SqldataSource object has a query “Select …, ProvinceId,…..” I would like to show all the time the proper Province selected when the page is loaded. It is possible to do an auto binding for this? Thanks, Florian Szoke

[enjoycrack]

Hi there, Not got ur clue yet. But I think you mean that you want to do binding when the Province drop down list selection is changed, right? if so, you can set auto post back attribute of this control is true << >>

[Prasad Babu A]

Hi, You need to populate Province DropDownList at Page_Load event. Bye Pessi

[FlorianS]

The DropDownList is populated in the definition. When the page is loaded I want to be selected the proper province in the dropdown list. For example if in the database the the row that I am fetching has providerid = 2 , the drop down list should show "Manitoba" I forget to mention , the SqlDataSource will have just one record to fetch.

[FlorianS]

I found out how to do it, and it is very simple: :) In the declaration of DropDownList we have to declare : SelectedValue='<%# Bind("ProvinceId")'