Values on update do not save and return to default

[asmasm1]

hi
i have had a form in which 10-20 dropdownlists r present and it was working nice the values of these dropdownlists r derived from dbase
now when i am saving values of dropdownlists the value gets lost to default. as i'm using ajax &asp.net 2.0.onload event i have place code 4 getting dropdownlist values under if not ispostback condition i fail to solve this
plz solve my problem

[kenobewan]

Are you sure your sql update query is working correctly? If so, you need to rebind the new data after updating to reflect the new values...

[shweta123]

Hi,

I think values from dropdownlist boxes are getting saved into the database . So in order to show the updated values into dropdownlist you have to write the Select sql query to get the updated records from the database and display the records into dropdownlist.
e.g. In the page load event you can write the following code:

  Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
                 ''Get the updated data from db
                  Dim sql as string = "Select * from Tablename"
 
                 ''Fill the updated data into dataset   
 
                 Dim con as new oledbConnection
 
                  Dim ds as new dataset
                                 Dim da as new  OledbdataAdapter(Sql,con)
 
                  da.Fill(ds)
 
                  'Display updated data into dropdownlist  
                  dropdownlist1.datasource= ds
                  dropdownlist1.databind() 
                End Sub