ASP.NET

21-Jun-14 15:05

Hello

I have three files in my simple 'Registration form' project - it inserts new user details into a MS Access database - comprising
an aspx, aspx.vb, and a Web.config file.

If I may post some of the code here, I was wondering if I can delete the following Sub Page_Load() from my aspx.vb file since I
can't see the purpose of it. In that aspx.vb file, I have:

Sub Page_Load()

        Dim myMDBConnection As OleDbConnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("Register").ToString().Trim())
        myMDBConnection.Open()
        'do stuff here
        myMDBConnection.Close()
    End Sub


    Protected Sub CreateUser_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\myDatabase.mdb;")
        Using conn

            Dim Sql As String = "INSERT INTO userlist (username,password, strEmail) VALUES (@username,@password, @strEmail)"
            Dim cmd As New OleDbCommand(Sql, conn)
            conn.Open()
            cmd.Parameters.AddWithValue("@username", username.Text)
            cmd.Parameters.AddWithValue("@password", password.Text)
            cmd.Parameters.AddWithValue("@strEmail", strEmail.Text)
            cmd.ExecuteNonQuery()
            conn.Close()

        End Using
    End Sub

End Class

And in my Web.config file I have:

<?xml version="1.0"?>

    <configuration>
      <connectionStrings>       
          
            <add name="Register" providerName="Microsoft.Jet.OLEDB.4.0;" 
                 connectionString="C:\myDatabase.mdb;" />
     
          </connectionStrings>
     </configuration>

Would it be 'safe' to remove that Sub Page_Load()?

Thank you for any advice.

jkirkerx23-Jun-14 10:39

23-Jun-14 10:39

Look safe to me to delete, I don't see it really doing anything

Member 876166723-Jun-14 11:16

23-Jun-14 11:16

Thanks jkirkerx Thumbs Up | :thumbsup:

Just removed it and all looks well!

Best regards

jkirkerx23-Jun-14 11:40

23-Jun-14 11:40

Right On!

You only needs page events if your going to use them.

Just as a rule, I use Page.Load to load data
and Page.Init to load controls or HTML in code behind.

Member 876166723-Jun-14 12:01

23-Jun-14 12:01

So I could have used:

Protected Sub Page_Init(ByVal sender As Object, _
    ByVal e As System.EventArgs)
        username.Focus()
    End Sub

jkirkerx23-Jun-14 13:03

23-Jun-14 13:03

No,

you create things that you want to persist during the page lifecycle.

So if you need a textbox, you make it in Page.Init, so when you post back to the server, the textbox and it's value will live through the postback.

If you make the textbox in page.load, it will show, but the textbox will die during postback, causing the value to die as well.

Make Sense?

You use Page.Load to load data the first time the form is shown, and to make adjustments to the form elements for first time viewing.

Member 876166723-Jun-14 14:18

23-Jun-14 14:18

Errrrrrrrrrmmm

I have had a quick look at this:

http://msdn.microsoft.com/en-us/library/vstudio/ms178472(v=vs.100).aspx[^]

In baby-speak, Page.Init is more 'permanent'?

It will take some reading and time to digest it!

But Page.Init and Page Load are not interchangeable, anyway.

jkirkerx23-Jun-14 16:02

23-Jun-14 16:02

It's really important to learn the page lifecycle, before you get really fancy with your web apps. Otherwise you'll be posting many questions or headaches that don't make sense at that moment in time.

Member 876166723-Jun-14 16:23