Lesson 11 Adding Record To Your Database Adding

Lesson 11 Adding Record To Your Database

Adding Records l Create a new page and call it Add. Records. aspx

Add to your workspace area l l l l l Type and center More Movie Data: On the left side of the workspace type the following: Enter Movie Name: Enter Actor: Enter Actress: Enter Director: Enter Release Date: Enter Rating: Enter MPAA: Enter Run Time:

Add Textbox l Drag a Text. Box and place it to the right of field names you just entered (Use Absolute Position found under the Layout menu for placement

Add a button l Drag a button and place in the middle

Label Message l l l Drag a Label and place it below the button On the label properties, do the following: To the right of ID type label. Message Select Fore Color to be Red Aside of Text Delete the word Label

Adding Button. Event Code l l Click on Code View Drag an INSERT Data Method Select the Movies Database and click OK Click Next and name the Method Add. Movie. Record

Insert Code l l l l l Go back to Design View and double click the button Before the End Sub type Dim Movie. Name As String Dim Actor As String Dim Actress As String Dim Director As String Dim Release. Date As Date. Time Dim Rating As String Dim MPAA As String Dim Run. Time As String You have just created variables for all your fields used in the database

More Code To Add l l l l Movie. Name= Server. Html. Encode (Text. Box 1. Text) Actor= Server. Html. Encode (Text. Box 2. Text) Actress= Server. Html. Encode (Text. Box 3. Text) Director= Server. Html. Encode (Text. Box 4. Text) Release. Date= Server. Html. Encode (Text. Box 5. Text) Rating= Server. Html. Encode (Text. Box 6. Text) MPAA= Server. Html. Encode (Text. Box 7. Text) Run. Time= Server. Html. Encode (Text. Box 8. Text)

Server. Html. Encode Coversion l l For the variables you created you must then pass the information to those variables with this conversion Remember the Add. Movie. Record method you created? This is now going to be used in your code

Passing Values To Your Database l l l l Continue to type this code: Try Add. Movie. Record (Movie. Name, Actor, Actress, Director, Release. Date, Rating, MPAA, Run. Time) label. Message. Text= "Your movie record has been updated, Thanks" Button 1. Enabled = False Catch label. Message. Text= "Please submit again there was an error" End Try

Error Checking Code l l The Try-Catch block is for error checking You can see the two messages that were created and will be displayed in entries were successful or unsuccessful

Entering Records l l Press F 5 and load the new page Enter the following record to your Movie database

Update l l You can see that your movie record has been updated successfully For now you can go back to Web Matrix and click on data and view the updated James. Bond. Series Table with your new record