I need to update my related database through a button click. What I want is, after I update the database, a message is postbacked and my page is freshed based on the updated database. However, what I get is, after I click the control, a message is sent back to the server, and the page get refreshed before my database get updated. Therefore, the change in the database does not show up in my page. I put break point in both Page_Load and Button_Click methods, the program stopped first at Page_Load and then at Button_Click. Do I have to manually ask the page to refresh itself after the database is updated? Or is there any better way? Thanks! 

May be you need to load your data again after the database is updated.

wessamzeidan wrote:

not sure what you're trying to do, but you can use response.redirect to redirect to the same page after you do the updates

gardener01 wrote:

I need to update my related database through a button click. What I want is, after I update the database, a message is postbacked and my page is freshed based on the updated database. However, what I get is, after I click the control, a message is sent back to the server, and the page get refreshed before my database get updated. Therefore, the change in the database does not show up in my page. I put break point in both Page_Load and Button_Click methods, the program stopped first at Page_Load and then at Button_Click. Do I have to manually ask the page to refresh itself after the database is updated? Or is there any better way? Thanks!

Thank you for your suggestion, Grz and joteke.

Of course I understand your logic. However, I am not sure it you guys test your method or not. In one of my previous post of this topic, I have already mentioned that I tried this way, it just does not work. I do not understand the reason since your logic is clear and reasonable.

After the button is clicked, the program goes to Page_Load method first and bypass BindTheData() because of postback. Then the program goes to Button_Click method. However, the database does not get updated!

If BindTheData() does get called in Page_Load, the database will be updated in Button_Click. However, even if BindTheData() is called at the end of Button_Click after database is updated, the page did not reflect the change of the database unless the refresh button of the browser is clicked!

Anyway, I will read life cycle of a webform and try to understand the issue.

gardener01 wrote:

Thank you for your suggestion, Grz and joteke. Of course I understand your logic. However, I am not sure it you guys test your method or not. In one of my previous post of this topic, I have already mentioned that I tried this way, it just does not work. I do not understand the reason since your logic is clear and reasonable. After the button is clicked, the program goes to Page_Load method first and bypass BindTheData() because of postback. Then the program goes to Button_Click method. However, the database does not get updated! If BindTheData() does get called in Page_Load, the database will be updated in Button_Click. However, even if BindTheData() is called at the end of Button_Click after database is updated, the page did not reflect the change of the database unless the refresh button of the browser is clicked! Anyway, I will read life cycle of a webform and try to understand the issue.

monolithx wrote:

Isn't it true that actually Button_Click is executed AFTER Page_Load?

Yes, that's correct. Take a look at the page life cycle.

Grz, Kris.

joteke wrote:

Hi,

the logic could be pretty much like this:

Sub Page_Load
   If Not Page.IsPostBack Then
      BindTheData()
   End If
End Sub

Sub Button_Click
   UpdateData()
   BindTheData()
End Sub

...

Makes sense?

Well, I had a similar issue with that, but that logic worked for me...

Here's the code I used:

**********************************************
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        '* Carga solamente una vez el formulario   / Loads only once the form (Listbox)
        If (IsPostBack = False) Then
            Call CargarTemasInteres()
        End If

    End Sub

************************************************
' Update Button

 Private Sub btnModificar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnModificar.Click

        If (lstCargador.SelectedIndex <> -1) Then

            Call modificarTema(CInt(lstCargador.SelectedItem.Value), CStr(txtInsertarTema.Text))

        End If

    End Sub

********************************************

    Private Sub modificarTema(ByVal intCodigoTema As Integer, ByVal strDescripcion As String)

        '* Consulta SQL para actualizar el item seleccionado en los Temas de Inter?s
        Dim strSQL As String = "Update .... "

        Try

            MyConnection = New SqlConnection("...")

            MyConnection.Open() 'Abre la coneccion
            Dim cmdCommand As SqlCommand = MyConnection.CreateCommand() 'Crea un objeto command

            cmdCommand.CommandText = strSQL
            cmdCommand.ExecuteNonQuery() 'Ejecuta la consulta sin devolver resultados

            '* Carga de nuevo el ListBox
            Call CargarTemasInteres()

        Catch ex As Exception 'Captura la excepciones que se puedan presentar

            Dim strError As String = String.Empty  ' Guarda el error que se pueda generar
            strError = ex.Message 'Mensaje de error

        End Try

    End Sub

********************************************

That's some of my code, and it work...  I hope this helps!!!

~ Luiscotiquicia

The logic flow as previously stated should/does work, I do it all the time.

Sub Page_Load
   If Not Page.IsPostBack Then
      BindTheData()
   End If
End Sub

Sub Button_Click
   UpdateData()
   BindTheData()
End Sub