Simple Update Page

I have been trying to create a simple page to update my SQL Express database with some text boxes that are auto filled.

If here is the code if you have any help for me it would be great. Partial Class Secured_Default2

Inherits System.Web.UI.PageProtected Sub Accept_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Accept.Click

SqlDataSource3.Update()

End SubProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

AcceptDate.Text = System.DateTime.Now.ToStringAcceptedBy.Text = Request.ServerVariables.Get("Logon_User")

StatusBox.Text = "2"End Sub

End Class<%@ Page Language="VB" MasterPageFile="~/Secured/MasterPage.master" AutoEventWireup="false" CodeFile="TEST.aspx.vb" Inherits="Secured_TEST" title="Untitled Page" %>

<%@ Import Namespace="System.Data.SqlClient" %><%@ Import Namespace="System.Data" %>

 

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<p>

<br />

&nbsp;&nbsp; Date:

<asp:TextBox ID="AcceptDate" runat="server" ></asp:TextBox>&nbsp; &nbsp; Accepted By:

<asp:TextBox ID="AcceptedByBox" runat="server" ></asp:TextBox><br />

Status:

<asp:TextBox ID="StatusBox" runat="server" Width="18px"></asp:TextBox>

&nbsp; &nbsp; &nbsp;&nbsp;

<asp:Button ID="Accept" runat="server" CommandName="Update" Text="Accept Ticket" /><br />

<br />

<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:HelpDeskConnectionString2 %>"

SelectCommand="SELECT TicketNUM, Accepted, AcceptedBy, Status FROM HelpDesk WHERE (TicketNUM = @TicketNUM)"

UpdateCommand="UPDATE HelpDesk SET Accepted = @UAccepted, AcceptedBy = @UAcceptedBy, Status = @UStatus WHERE (TicketNUM = @TicketNUM)">

 

<UpdateParameters>

<asp:FormParameter Name="UAccepted" FormField="AcceptedDate"/>

<asp:FormParameter Name="UAcceptedBy" FormField="AcceptedByBox" />

<asp:FormParameter Name="UStatus" FormField="StatusBox" />

<asp:QueryStringParameter Name="TicketNUM" QueryStringField="TicketNUM" />

</UpdateParameters>

<SelectParameters>

<asp:QueryStringParameter Name="TicketNUM" QueryStringField="TicketNUM" />

</SelectParameters>

</asp:SqlDataSource>

 </p>

</asp:Content>