How do you update the value of a agetextbox in a ASP.net 2.0 formview with a calculated age using VB.net

I have two text boxes in my asp.net formview.  Birthday and AGE.  I want to calculate the age whenever a DOB is entered in the Birthday field and auto fill the AGE textbox with the calculated age.  Any assistance is greatly appreciated
pgkdavefddAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BTosonCommented:
Hi,
Try this:
Dim BirthdayDate As DateTime
If IsDate(Birthday.Text) AndAlso DateTime.TryParse(Birthday.Text, BirthdayDate) Then
	 Age.Text = DateDiff(DateInterval.Year, BirthdayDate, Now)
End If

Open in new window

0
AswinKrishnanCommented:
you can use javascript and specify the script to get triggered on 'onblur' of the Birthday textbox  and fill the corresponding value in age textbox.
0
pgkdavefddAuthor Commented:
BToson,  I have no problem doing it in VB6.  However this is my first time tring something like this in ASP.net.   So this is going to sound a little dumb but where do I put the code you suggested?  Attached is a my source code for the asp.net form with the form view.  
<%@ Page Language="VB" MasterPageFile="~/Default.master" Title="Untitled Page" %>
 
<script runat="server">
 
Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs)
        Response.Redirect("~/Council/Knights.aspx")
    End Sub
 
    Protected Sub birthdayTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
 
    End Sub
</script>
 
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="pkid" DataSourceID="SqlDataSource1" DefaultMode="Insert" OnItemInserted="FormView1_ItemInserted">
        <EditItemTemplate>
            pkid:
            <asp:Label ID="pkidLabel1" runat="server" Text='<%# Eval("pkid") %>'></asp:Label><br />
            membernum:
            <asp:TextBox ID="membernumTextBox" runat="server" Text='<%# Bind("membernum") %>'>
            </asp:TextBox><br />
            prefix:
            <asp:TextBox ID="prefixTextBox" runat="server" Text='<%# Bind("prefix") %>'>
            </asp:TextBox><br />
            firstname:
            <asp:TextBox ID="firstnameTextBox" runat="server" Text='<%# Bind("firstname") %>'>
            </asp:TextBox><br />
            mi:
            <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'>
            </asp:TextBox><br />
            lastname:
            <asp:TextBox ID="lastnameTextBox" runat="server" Text='<%# Bind("lastname") %>'>
            </asp:TextBox><br />
            suffix:
            <asp:TextBox ID="suffixTextBox" runat="server" Text='<%# Bind("suffix") %>'>
            </asp:TextBox><br />
            name:
            <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>'>
            </asp:TextBox><br />
            address1:
            <asp:TextBox ID="address1TextBox" runat="server" Text='<%# Bind("address1") %>'>
            </asp:TextBox><br />
            address2:
            <asp:TextBox ID="address2TextBox" runat="server" Text='<%# Bind("address2") %>'>
            </asp:TextBox><br />
            city:
            <asp:TextBox ID="cityTextBox" runat="server" Text='<%# Bind("city") %>'>
            </asp:TextBox><br />
            state:
            <asp:TextBox ID="stateTextBox" runat="server" Text='<%# Bind("state") %>'>
            </asp:TextBox><br />
            postalcd:
            <asp:TextBox ID="postalcdTextBox" runat="server" Text='<%# Bind("postalcd") %>'>
            </asp:TextBox><br />
            homephone:
            <asp:TextBox ID="homephoneTextBox" runat="server" Text='<%# Bind("homephone") %>'>
            </asp:TextBox><br />
            homeac:
            <asp:TextBox ID="homeacTextBox" runat="server" Text='<%# Bind("homeac") %>'>
            </asp:TextBox><br />
            altphone:
            <asp:TextBox ID="altphoneTextBox" runat="server" Text='<%# Bind("altphone") %>'>
            </asp:TextBox><br />
            altac:
            <asp:TextBox ID="altacTextBox" runat="server" Text='<%# Bind("altac") %>'>
            </asp:TextBox><br />
            alttype:
            <asp:TextBox ID="alttypeTextBox" runat="server" Text='<%# Bind("alttype") %>'>
            </asp:TextBox><br />
            ssn:
            <asp:TextBox ID="ssnTextBox" runat="server" Text='<%# Bind("ssn") %>'>
            </asp:TextBox><br />
            birthday:
            <asp:TextBox ID="birthdayTextBox" runat="server" Text='<%# Bind("birthday") %>'>
            </asp:TextBox><br />
            bmonth:
            <asp:TextBox ID="bmonthTextBox" runat="server" Text='<%# Bind("bmonth") %>'>
            </asp:TextBox><br />
            deceaseddt:
            <asp:TextBox ID="deceaseddtTextBox" runat="server" Text='<%# Bind("deceaseddt") %>'>
            </asp:TextBox><br />
            age:
            <asp:TextBox ID="ageTextBox" runat="server" Text='<%# Bind("age") %>'>
            </asp:TextBox><br />
            type:
            <asp:TextBox ID="typeTextBox" runat="server" Text='<%# Bind("type") %>'>
            </asp:TextBox>
            <br />
            class:
            <asp:TextBox ID="classTextBox" runat="server" Text='<%# Bind("class") %>'>
            </asp:TextBox><br />
            annualdues:
            <asp:TextBox ID="annualduesTextBox" runat="server" Text='<%# Bind("annualdues") %>'>
            </asp:TextBox><br />
            marital:
            <asp:TextBox ID="maritalTextBox" runat="server" Text='<%# Bind("marital") %>'>
            </asp:TextBox><br />
            parish:
            <asp:TextBox ID="parishTextBox" runat="server" Text='<%# Bind("parish") %>'>
            </asp:TextBox><br />
            fourth:
            <asp:CheckBox ID="fourthCheckBox" runat="server" Checked='<%# Bind("fourth") %>' /><br />
            assemblynm:
            <asp:TextBox ID="assemblynmTextBox" runat="server" Text='<%# Bind("assemblynm") %>'>
            </asp:TextBox><br />
            firstdeg:
            <asp:TextBox ID="firstdegTextBox" runat="server" Text='<%# Bind("firstdeg") %>'>
            </asp:TextBox><br />
            seconddeg:
            <asp:TextBox ID="seconddegTextBox" runat="server" Text='<%# Bind("seconddeg") %>'>
            </asp:TextBox><br />
            thirddeg:
            <asp:TextBox ID="thirddegTextBox" runat="server" Text='<%# Bind("thirddeg") %>'>
            </asp:TextBox><br />
            fourthdeg:
            <asp:TextBox ID="fourthdegTextBox" runat="server" Text='<%# Bind("fourthdeg") %>'>
            </asp:TextBox><br />
            degree:
            <asp:TextBox ID="degreeTextBox" runat="server" Text='<%# Bind("degree") %>'>
            </asp:TextBox><br />
            senddegnot:
            <asp:TextBox ID="senddegnotTextBox" runat="server" Text='<%# Bind("senddegnot") %>'>
            </asp:TextBox><br />
            office:
            <asp:TextBox ID="officeTextBox" runat="server" Text='<%# Bind("office") %>'>
            </asp:TextBox><br />
            offnum:
            <asp:TextBox ID="offnumTextBox" runat="server" Text='<%# Bind("offnum") %>'>
            </asp:TextBox><br />
            fratyear:
            <asp:TextBox ID="fratyearTextBox" runat="server" Text='<%# Bind("fratyear") %>'>
            </asp:TextBox><br />
            billmessg1:
            <asp:TextBox ID="billmessg1TextBox" runat="server" Text='<%# Bind("billmessg1") %>'>
            </asp:TextBox><br />
            billmessg2:
            <asp:TextBox ID="billmessg2TextBox" runat="server" Text='<%# Bind("billmessg2") %>'>
            </asp:TextBox><br />
            billstatus:
            <asp:TextBox ID="billstatusTextBox" runat="server" Text='<%# Bind("billstatus") %>'>
            </asp:TextBox><br />
            bstatdate:
            <asp:TextBox ID="bstatdateTextBox" runat="server" Text='<%# Bind("bstatdate") %>'>
            </asp:TextBox><br />
            retcommdt:
            <asp:TextBox ID="retcommdtTextBox" runat="server" Text='<%# Bind("retcommdt") %>'>
            </asp:TextBox><br />
            former_sqr:
            <asp:CheckBox ID="former_sqrCheckBox" runat="server" Checked='<%# Bind("former_sqr") %>' /><br />
            Email:
            <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>'>
            </asp:TextBox><br />
            paystat:
            <asp:TextBox ID="paystatTextBox" runat="server" Text='<%# Bind("paystat") %>'>
            </asp:TextBox><br />
            nobill:
            <asp:CheckBox ID="nobillCheckBox" runat="server" Checked='<%# Bind("nobill") %>' /><br />
            dead:
            <asp:CheckBox ID="deadCheckBox" runat="server" Checked='<%# Bind("dead") %>' /><br />
            duespaid:
            <asp:CheckBox ID="duespaidCheckBox" runat="server" Checked='<%# Bind("duespaid") %>' /><br />
            paidthru:
            <asp:TextBox ID="paidthruTextBox" runat="server" Text='<%# Bind("paidthru") %>'>
            </asp:TextBox><br />
            balancedue:
            <asp:TextBox ID="balancedueTextBox" runat="server" Text='<%# Bind("balancedue") %>'>
            </asp:TextBox><br />
            Contact:
            <asp:TextBox ID="ContactTextBox" runat="server" Text='<%# Bind("Contact") %>'>
            </asp:TextBox><br />
            Memo:
            <asp:TextBox ID="MemoTextBox" runat="server" Text='<%# Bind("Memo") %>'>
            </asp:TextBox><br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="Update">
            </asp:LinkButton>
            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                Text="Cancel">
            </asp:LinkButton>
        </EditItemTemplate>
        <InsertItemTemplate>
            membernum:
            <asp:TextBox ID="membernumTextBox" runat="server" Text='<%# Bind("membernum") %>'>
            </asp:TextBox><br />
            prefix:&nbsp;
            <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind("prefix") %>'>
                <asp:ListItem Value="' '"></asp:ListItem>
                <asp:ListItem Selected="True">Dr</asp:ListItem>
                <asp:ListItem>Dcn</asp:ListItem>
                <asp:ListItem>Mr</asp:ListItem>
                <asp:ListItem>Mrs</asp:ListItem>
                <asp:ListItem>Msgr</asp:ListItem>
                <asp:ListItem>Rev</asp:ListItem>
                <asp:ListItem>SK</asp:ListItem>
            </asp:DropDownList><br />
            firstname:
            <asp:TextBox ID="firstnameTextBox" runat="server" Text='<%# Bind("firstname") %>'>
            </asp:TextBox><br />
            mi:
            <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'>
            </asp:TextBox><br />
            lastname:
            <asp:TextBox ID="lastnameTextBox" runat="server" Text='<%# Bind("lastname") %>'>
            </asp:TextBox><br />
            suffix:&nbsp;
            <asp:DropDownList ID="DropDownList3" runat="server">
                <asp:ListItem></asp:ListItem>
                <asp:ListItem>DDS</asp:ListItem>
                <asp:ListItem>Jr</asp:ListItem>
                <asp:ListItem>Sr</asp:ListItem>
                <asp:ListItem>PGK</asp:ListItem>
                <asp:ListItem>PGK,FDD</asp:ListItem>
            </asp:DropDownList><br />
            name:
            <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>'>
            </asp:TextBox><br />
            address1:
            <asp:TextBox ID="address1TextBox" runat="server" Text='<%# Bind("address1") %>'>
            </asp:TextBox><br />
            address2:
            <asp:TextBox ID="address2TextBox" runat="server" Text='<%# Bind("address2") %>'>
            </asp:TextBox><br />
            city:
            <asp:TextBox ID="cityTextBox" runat="server" Text='<%# Bind("city") %>'>
            </asp:TextBox><br />
            state:
            <asp:TextBox ID="stateTextBox" runat="server" Text='<%# Bind("state") %>'>
            </asp:TextBox><br />
            postalcd:
            <asp:TextBox ID="postalcdTextBox" runat="server" Text='<%# Bind("postalcd") %>'>
            </asp:TextBox><br />
            homephone:
            <asp:TextBox ID="homephoneTextBox" runat="server" Text='<%# Bind("homephone") %>'>
            </asp:TextBox><br />
            homeac:
            <asp:TextBox ID="homeacTextBox" runat="server" Text='<%# Bind("homeac") %>'>
            </asp:TextBox><br />
            altphone:
            <asp:TextBox ID="altphoneTextBox" runat="server" Text='<%# Bind("altphone") %>'>
            </asp:TextBox><br />
            altac:
            <asp:TextBox ID="altacTextBox" runat="server" Text='<%# Bind("altac") %>'>
            </asp:TextBox><br />
            alttype:
            <asp:TextBox ID="alttypeTextBox" runat="server" Text='<%# Bind("alttype") %>'>
            </asp:TextBox><br />
            ssn:
            <asp:TextBox ID="ssnTextBox" runat="server" Text='<%# Bind("ssn") %>'>
            </asp:TextBox><br />
            birthday:
            <asp:TextBox ID="birthdayTextBox" runat="server" Text='<%# Bind("birthday", "{0:d}") %>' OnTextChanged="birthdayTextBox_TextChanged"></asp:TextBox><br />
            bmonth:
            <asp:TextBox ID="bmonthTextBox" runat="server" Text='<%# Bind("bmonth") %>'>
            </asp:TextBox><br />
            deceaseddt:
            <asp:TextBox ID="deceaseddtTextBox" runat="server" Text='<%# Bind("deceaseddt", "{0:d}") %>'></asp:TextBox><br />
            age:
            <asp:TextBox ID="ageTextBox" runat="server" Text='<%# Bind("age") %>'>
            </asp:TextBox><br />
            type:&nbsp;
            <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind("type") %>'>
                <asp:ListItem Selected="True">ASSOCIATE</asp:ListItem>
                <asp:ListItem>INSURANCE   </asp:ListItem>
                <asp:ListItem>INACTIVE  </asp:ListItem>
                <asp:ListItem>APPLICANT</asp:ListItem>
                <asp:ListItem>CANDIDATE</asp:ListItem>
                <asp:ListItem>MAIL LIST                     </asp:ListItem>
                <asp:ListItem>SUSPENDED-NON PAYMENT</asp:ListItem>
                <asp:ListItem>SUSPENDED-BOARD ACTION </asp:ListItem>
                <asp:ListItem>WITHDRAWAL</asp:ListItem>
                <asp:ListItem>TRANSFER OUT</asp:ListItem>
                <asp:ListItem>DECEASED </asp:ListItem>
                <asp:ListItem>PENDING-SUSPENSION    </asp:ListItem>
            </asp:DropDownList><br />
            class:&nbsp;
            <asp:DropDownList ID="DropDownList4" runat="server" SelectedValue='<%# Bind("class") %>'>
                <asp:ListItem Selected="True">NONE</asp:ListItem>
                <asp:ListItem>REGULAR</asp:ListItem>
                <asp:ListItem>INSURANCE</asp:ListItem>
                <asp:ListItem>HONORARY </asp:ListItem>
                <asp:ListItem>HONORARY LIFE </asp:ListItem>
                <asp:ListItem>DISABLED            </asp:ListItem>
                <asp:ListItem>DISABLED HONORARY </asp:ListItem>
                <asp:ListItem>Under26</asp:ListItem>
            </asp:DropDownList><br />
            annualdues:
            <asp:TextBox ID="annualduesTextBox" runat="server" Text='<%# Bind("annualdues", "{0:C}") %>'></asp:TextBox><br />
            marital:&nbsp;
            <asp:DropDownList ID="DropDownList6" runat="server" SelectedValue='<%# Bind("marital") %>'>
                <asp:ListItem Value="' '"></asp:ListItem>
                <asp:ListItem Selected="True">Clergy</asp:ListItem>
                <asp:ListItem>Single</asp:ListItem>
                <asp:ListItem>Married</asp:ListItem>
            </asp:DropDownList><br />
            parish:
            <asp:TextBox ID="parishTextBox" runat="server" Text='<%# Bind("parish") %>'>
            </asp:TextBox><br />
            fourth:
            <asp:CheckBox ID="fourthCheckBox" runat="server" Checked='<%# Bind("fourth") %>' /><br />
            assemblynm:
            <asp:TextBox ID="assemblynmTextBox" runat="server" Text='<%# Bind("assemblynm") %>'>
            </asp:TextBox><br />
            firstdeg:
            <asp:TextBox ID="firstdegTextBox" runat="server" Text='<%# Bind("firstdeg", "{0:d}") %>'></asp:TextBox><br />
            seconddeg:
            <asp:TextBox ID="seconddegTextBox" runat="server" Text='<%# Bind("seconddeg", "{0:d}") %>'></asp:TextBox><br />
            thirddeg:
            <asp:TextBox ID="thirddegTextBox" runat="server" Text='<%# Bind("thirddeg", "{0:d}") %>'></asp:TextBox><br />
            fourthdeg:
            <asp:TextBox ID="fourthdegTextBox" runat="server" Text='<%# Bind("fourthdeg", "{0:d}") %>'></asp:TextBox><br />
            degree:&nbsp;
            <asp:DropDownList ID="DropDownList5" runat="server" SelectedValue='<%# Bind("degree") %>'>
                <asp:ListItem Selected="True">NONE</asp:ListItem>
                <asp:ListItem>1ST</asp:ListItem>
                <asp:ListItem>2ND</asp:ListItem>
                <asp:ListItem>3RD</asp:ListItem>
                <asp:ListItem>4TH</asp:ListItem>
            </asp:DropDownList><br />
            senddegnot:
            <asp:TextBox ID="senddegnotTextBox" runat="server" Text='<%# Bind("senddegnot") %>'>
            </asp:TextBox><br />
            office:
            <asp:TextBox ID="officeTextBox" runat="server" Text='<%# Bind("office") %>'>
            </asp:TextBox><br />
            offnum:
            <asp:TextBox ID="offnumTextBox" runat="server" Text='<%# Bind("offnum") %>'>
            </asp:TextBox><br />
            fratyear:
            <asp:TextBox ID="fratyearTextBox" runat="server" Text='<%# Bind("fratyear") %>'>
            </asp:TextBox><br />
            billmessg1:
            <asp:TextBox ID="billmessg1TextBox" runat="server" Text='<%# Bind("billmessg1") %>'>
            </asp:TextBox><br />
            billmessg2:
            <asp:TextBox ID="billmessg2TextBox" runat="server" Text='<%# Bind("billmessg2") %>'>
            </asp:TextBox><br />
            billstatus:
            <asp:TextBox ID="billstatusTextBox" runat="server" Text='<%# Bind("billstatus") %>'>
            </asp:TextBox><br />
            bstatdate:
            <asp:TextBox ID="bstatdateTextBox" runat="server" Text='<%# Bind("bstatdate") %>'>
            </asp:TextBox><br />
            retcommdt:
            <asp:TextBox ID="retcommdtTextBox" runat="server" Text='<%# Bind("retcommdt") %>'>
            </asp:TextBox><br />
            former_sqr:
            <asp:CheckBox ID="former_sqrCheckBox" runat="server" Checked='<%# Bind("former_sqr") %>' /><br />
            Email:
            <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>'>
            </asp:TextBox><br />
            paystat:
            <asp:TextBox ID="paystatTextBox" runat="server" Text='<%# Bind("paystat") %>'>
            </asp:TextBox><br />
            nobill:
            <asp:CheckBox ID="nobillCheckBox" runat="server" Checked='<%# Bind("nobill") %>' /><br />
            dead:
            <asp:CheckBox ID="deadCheckBox" runat="server" Checked='<%# Bind("dead") %>' /><br />
            duespaid:
            <asp:CheckBox ID="duespaidCheckBox" runat="server" Checked='<%# Bind("duespaid") %>' /><br />
            paidthru:
            <asp:TextBox ID="paidthruTextBox" runat="server" Text='<%# Bind("paidthru", "{0:d}") %>'></asp:TextBox><br />
            balancedue:
            <asp:TextBox ID="balancedueTextBox" runat="server" Text='<%# Bind("balancedue", "{0:C}") %>'></asp:TextBox><br />
            Contact:
            <asp:TextBox ID="ContactTextBox" runat="server" Text='<%# Bind("Contact") %>'>
            </asp:TextBox><br />
            Memo:
            <asp:TextBox ID="MemoTextBox" runat="server" Text='<%# Bind("Memo") %>'>
            </asp:TextBox><br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                Text="Insert">
            </asp:LinkButton>
            <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                Text="Cancel">
            </asp:LinkButton>
        </InsertItemTemplate>
        <ItemTemplate>
            pkid:
            <asp:Label ID="pkidLabel" runat="server" Text='<%# Eval("pkid") %>'></asp:Label><br />
            membernum:
            <asp:Label ID="membernumLabel" runat="server" Text='<%# Bind("membernum") %>'></asp:Label><br />
            prefix:
            <asp:Label ID="prefixLabel" runat="server" Text='<%# Bind("prefix") %>'></asp:Label><br />
            firstname:
            <asp:Label ID="firstnameLabel" runat="server" Text='<%# Bind("firstname") %>'></asp:Label><br />
            mi:
            <asp:Label ID="miLabel" runat="server" Text='<%# Bind("mi") %>'></asp:Label><br />
            lastname:
            <asp:Label ID="lastnameLabel" runat="server" Text='<%# Bind("lastname") %>'></asp:Label><br />
            suffix:
            <asp:Label ID="suffixLabel" runat="server" Text='<%# Bind("suffix") %>'></asp:Label><br />
            name:
            <asp:Label ID="nameLabel" runat="server" Text='<%# Bind("name") %>'></asp:Label><br />
            address1:
            <asp:Label ID="address1Label" runat="server" Text='<%# Bind("address1") %>'></asp:Label><br />
            address2:
            <asp:Label ID="address2Label" runat="server" Text='<%# Bind("address2") %>'></asp:Label><br />
            city:
            <asp:Label ID="cityLabel" runat="server" Text='<%# Bind("city") %>'></asp:Label><br />
            state:
            <asp:Label ID="stateLabel" runat="server" Text='<%# Bind("state") %>'></asp:Label><br />
            postalcd:
            <asp:Label ID="postalcdLabel" runat="server" Text='<%# Bind("postalcd") %>'></asp:Label><br />
            homephone:
            <asp:Label ID="homephoneLabel" runat="server" Text='<%# Bind("homephone") %>'></asp:Label><br />
            homeac:
            <asp:Label ID="homeacLabel" runat="server" Text='<%# Bind("homeac") %>'></asp:Label><br />
            altphone:
            <asp:Label ID="altphoneLabel" runat="server" Text='<%# Bind("altphone") %>'></asp:Label><br />
            altac:
            <asp:Label ID="altacLabel" runat="server" Text='<%# Bind("altac") %>'></asp:Label><br />
            alttype:
            <asp:Label ID="alttypeLabel" runat="server" Text='<%# Bind("alttype") %>'></asp:Label><br />
            ssn:
            <asp:Label ID="ssnLabel" runat="server" Text='<%# Bind("ssn") %>'></asp:Label><br />
            birthday:
            <asp:Label ID="birthdayLabel" runat="server" Text='<%# Bind("birthday") %>'></asp:Label><br />
            bmonth:
            <asp:Label ID="bmonthLabel" runat="server" Text='<%# Bind("bmonth") %>'></asp:Label><br />
            deceaseddt:
            <asp:Label ID="deceaseddtLabel" runat="server" Text='<%# Bind("deceaseddt") %>'>
            </asp:Label><br />
            age:
            <asp:Label ID="ageLabel" runat="server" Text='<%# Bind("age") %>'></asp:Label><br />
            type:
            <asp:Label ID="typeLabel" runat="server" Text='<%# Bind("type") %>'></asp:Label><br />
            class:
            <asp:Label ID="classLabel" runat="server" Text='<%# Bind("class") %>'></asp:Label><br />
            annualdues:
            <asp:Label ID="annualduesLabel" runat="server" Text='<%# Bind("annualdues") %>'>
            </asp:Label><br />
            marital:
            <asp:Label ID="maritalLabel" runat="server" Text='<%# Bind("marital") %>'></asp:Label><br />
            parish:
            <asp:Label ID="parishLabel" runat="server" Text='<%# Bind("parish") %>'></asp:Label><br />
            fourth:
            <asp:CheckBox ID="fourthCheckBox" runat="server" Checked='<%# Bind("fourth") %>'
                Enabled="false" /><br />
            assemblynm:
            <asp:Label ID="assemblynmLabel" runat="server" Text='<%# Bind("assemblynm") %>'>
            </asp:Label><br />
            firstdeg:
            <asp:Label ID="firstdegLabel" runat="server" Text='<%# Bind("firstdeg") %>'></asp:Label><br />
            seconddeg:
            <asp:Label ID="seconddegLabel" runat="server" Text='<%# Bind("seconddeg") %>'></asp:Label><br />
            thirddeg:
            <asp:Label ID="thirddegLabel" runat="server" Text='<%# Bind("thirddeg") %>'></asp:Label><br />
            fourthdeg:
            <asp:Label ID="fourthdegLabel" runat="server" Text='<%# Bind("fourthdeg") %>'></asp:Label><br />
            degree:
            <asp:Label ID="degreeLabel" runat="server" Text='<%# Bind("degree") %>'></asp:Label><br />
            senddegnot:
            <asp:Label ID="senddegnotLabel" runat="server" Text='<%# Bind("senddegnot") %>'>
            </asp:Label><br />
            office:
            <asp:Label ID="officeLabel" runat="server" Text='<%# Bind("office") %>'></asp:Label><br />
            offnum:
            <asp:Label ID="offnumLabel" runat="server" Text='<%# Bind("offnum") %>'></asp:Label><br />
            fratyear:
            <asp:Label ID="fratyearLabel" runat="server" Text='<%# Bind("fratyear") %>'></asp:Label><br />
            billmessg1:
            <asp:Label ID="billmessg1Label" runat="server" Text='<%# Bind("billmessg1") %>'>
            </asp:Label><br />
            billmessg2:
            <asp:Label ID="billmessg2Label" runat="server" Text='<%# Bind("billmessg2") %>'>
            </asp:Label><br />
            billstatus:
            <asp:Label ID="billstatusLabel" runat="server" Text='<%# Bind("billstatus") %>'>
            </asp:Label><br />
            bstatdate:
            <asp:Label ID="bstatdateLabel" runat="server" Text='<%# Bind("bstatdate") %>'></asp:Label><br />
            retcommdt:
            <asp:Label ID="retcommdtLabel" runat="server" Text='<%# Bind("retcommdt") %>'></asp:Label><br />
            former_sqr:
            <asp:CheckBox ID="former_sqrCheckBox" runat="server" Checked='<%# Bind("former_sqr") %>'
                Enabled="false" /><br />
            Email:
            <asp:Label ID="EmailLabel" runat="server" Text='<%# Bind("Email") %>'></asp:Label><br />
            paystat:
            <asp:Label ID="paystatLabel" runat="server" Text='<%# Bind("paystat") %>'></asp:Label><br />
            nobill:
            <asp:CheckBox ID="nobillCheckBox" runat="server" Checked='<%# Bind("nobill") %>'
                Enabled="false" /><br />
            dead:
            <asp:CheckBox ID="deadCheckBox" runat="server" Checked='<%# Bind("dead") %>' Enabled="false" /><br />
            duespaid:
            <asp:CheckBox ID="duespaidCheckBox" runat="server" Checked='<%# Bind("duespaid") %>'
                Enabled="false" /><br />
            paidthru:
            <asp:Label ID="paidthruLabel" runat="server" Text='<%# Bind("paidthru") %>'></asp:Label><br />
            balancedue:
            <asp:Label ID="balancedueLabel" runat="server" Text='<%# Bind("balancedue") %>'>
            </asp:Label><br />
            Contact:
            <asp:Label ID="ContactLabel" runat="server" Text='<%# Bind("Contact") %>'></asp:Label><br />
            Memo:
            <asp:Label ID="MemoLabel" runat="server" Text='<%# Bind("Memo") %>'></asp:Label><br />
            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                Text="Edit">
            </asp:LinkButton>
            <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
                Text="Delete">
            </asp:LinkButton>
            <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
                Text="New">
            </asp:LinkButton>
        </ItemTemplate>
    </asp:FormView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SQLFSPCConnectionString %>"
        DeleteCommand="DELETE FROM [Knights] WHERE [pkid] = @pkid" InsertCommand="INSERT INTO [Knights] ([membernum], [prefix], [firstname], [mi], [lastname], [suffix], [name], [address1], [address2], [city], [state], [postalcd], [homephone], [homeac], [altphone], [altac], [alttype], [ssn], [birthday], [bmonth], [deceaseddt], [age], [type], [class], [annualdues], [marital], [parish], [fourth], [assemblynm], [firstdeg], [seconddeg], [thirddeg], [fourthdeg], [degree], [senddegnot], [office], [offnum], [fratyear], [billmessg1], [billmessg2], [billstatus], [bstatdate], [retcommdt], [former_sqr], [Email], [paystat], [nobill], [dead], [duespaid], [paidthru], [balancedue], [Contact], [Memo]) VALUES (@membernum, @prefix, @firstname, @mi, @lastname, @suffix, @name, @address1, @address2, @city, @state, @postalcd, @homephone, @homeac, @altphone, @altac, @alttype, @ssn, @birthday, @bmonth, @deceaseddt, @age, @type, @class, @annualdues, @marital, @parish, @fourth, @assemblynm, @firstdeg, @seconddeg, @thirddeg, @fourthdeg, @degree, @senddegnot, @office, @offnum, @fratyear, @billmessg1, @billmessg2, @billstatus, @bstatdate, @retcommdt, @former_sqr, @Email, @paystat, @nobill, @dead, @duespaid, @paidthru, @balancedue, @Contact, @Memo)"
        SelectCommand="SELECT * FROM [Knights]" UpdateCommand="UPDATE [Knights] SET [membernum] = @membernum, [prefix] = @prefix, [firstname] = @firstname, [mi] = @mi, [lastname] = @lastname, [suffix] = @suffix, [name] = @name, [address1] = @address1, [address2] = @address2, [city] = @city, [state] = @state, [postalcd] = @postalcd, [homephone] = @homephone, [homeac] = @homeac, [altphone] = @altphone, [altac] = @altac, [alttype] = @alttype, [ssn] = @ssn, [birthday] = @birthday, [bmonth] = @bmonth, [deceaseddt] = @deceaseddt, [age] = @age, [type] = @type, [class] = @class, [annualdues] = @annualdues, [marital] = @marital, [parish] = @parish, [fourth] = @fourth, [assemblynm] = @assemblynm, [firstdeg] = @firstdeg, [seconddeg] = @seconddeg, [thirddeg] = @thirddeg, [fourthdeg] = @fourthdeg, [degree] = @degree, [senddegnot] = @senddegnot, [office] = @office, [offnum] = @offnum, [fratyear] = @fratyear, [billmessg1] = @billmessg1, [billmessg2] = @billmessg2, [billstatus] = @billstatus, [bstatdate] = @bstatdate, [retcommdt] = @retcommdt, [former_sqr] = @former_sqr, [Email] = @Email, [paystat] = @paystat, [nobill] = @nobill, [dead] = @dead, [duespaid] = @duespaid, [paidthru] = @paidthru, [balancedue] = @balancedue, [Contact] = @Contact, [Memo] = @Memo WHERE [pkid] = @pkid">
        <DeleteParameters>
            <asp:Parameter Name="pkid" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="membernum" Type="Decimal" />
            <asp:Parameter Name="prefix" Type="String" />
            <asp:Parameter Name="firstname" Type="String" />
            <asp:Parameter Name="mi" Type="String" />
            <asp:Parameter Name="lastname" Type="String" />
            <asp:Parameter Name="suffix" Type="String" />
            <asp:Parameter Name="name" Type="String" />
            <asp:Parameter Name="address1" Type="String" />
            <asp:Parameter Name="address2" Type="String" />
            <asp:Parameter Name="city" Type="String" />
            <asp:Parameter Name="state" Type="String" />
            <asp:Parameter Name="postalcd" Type="String" />
            <asp:Parameter Name="homephone" Type="String" />
            <asp:Parameter Name="homeac" Type="String" />
            <asp:Parameter Name="altphone" Type="String" />
            <asp:Parameter Name="altac" Type="String" />
            <asp:Parameter Name="alttype" Type="String" />
            <asp:Parameter Name="ssn" Type="String" />
            <asp:Parameter DbType="DateTime" Name="birthday" />
            <asp:Parameter Name="bmonth" Type="String" />
            <asp:Parameter DbType="DateTime" Name="deceaseddt" />
            <asp:Parameter Name="age" Type="Decimal" />
            <asp:Parameter Name="type" Type="String" />
            <asp:Parameter Name="class" Type="String" />
            <asp:Parameter Name="annualdues" Type="Decimal" />
            <asp:Parameter Name="marital" Type="String" />
            <asp:Parameter Name="parish" Type="String" />
            <asp:Parameter Name="fourth" Type="Boolean" />
            <asp:Parameter Name="assemblynm" Type="Decimal" />
            <asp:Parameter DbType="DateTime" Name="firstdeg" />
            <asp:Parameter DbType="DateTime" Name="seconddeg" />
            <asp:Parameter DbType="DateTime" Name="thirddeg" />
            <asp:Parameter DbType="DateTime" Name="fourthdeg" />
            <asp:Parameter Name="degree" Type="String" />
            <asp:Parameter Name="senddegnot" Type="String" />
            <asp:Parameter Name="office" Type="String" />
            <asp:Parameter Name="offnum" Type="Decimal" />
            <asp:Parameter Name="fratyear" Type="Decimal" />
            <asp:Parameter Name="billmessg1" Type="String" />
            <asp:Parameter Name="billmessg2" Type="String" />
            <asp:Parameter Name="billstatus" Type="String" />
            <asp:Parameter DbType="DateTime" Name="bstatdate" />
            <asp:Parameter DbType="DateTime" Name="retcommdt" />
            <asp:Parameter Name="former_sqr" Type="Boolean" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="paystat" Type="String" />
            <asp:Parameter Name="nobill" Type="Boolean" />
            <asp:Parameter Name="dead" Type="Boolean" />
            <asp:Parameter Name="duespaid" Type="Boolean" />
            <asp:Parameter DbType="DateTime" Name="paidthru" />
            <asp:Parameter Name="balancedue" Type="Decimal" />
            <asp:Parameter Name="Contact" Type="String" />
            <asp:Parameter Name="Memo" Type="String" />
            <asp:Parameter Name="pkid" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="membernum" Type="Decimal" />
            <asp:Parameter Name="prefix" Type="String" />
            <asp:Parameter Name="firstname" Type="String" />
            <asp:Parameter Name="mi" Type="String" />
            <asp:Parameter Name="lastname" Type="String" />
            <asp:Parameter Name="suffix" Type="String" />
            <asp:Parameter Name="name" Type="String" />
            <asp:Parameter Name="address1" Type="String" />
            <asp:Parameter Name="address2" Type="String" />
            <asp:Parameter Name="city" Type="String" />
            <asp:Parameter Name="state" Type="String" />
            <asp:Parameter Name="postalcd" Type="String" />
            <asp:Parameter Name="homephone" Type="String" />
            <asp:Parameter Name="homeac" Type="String" />
            <asp:Parameter Name="altphone" Type="String" />
            <asp:Parameter Name="altac" Type="String" />
            <asp:Parameter Name="alttype" Type="String" />
            <asp:Parameter Name="ssn" Type="String" />
            <asp:Parameter DbType="DateTime" Name="birthday" />
            <asp:Parameter Name="bmonth" Type="String" />
            <asp:Parameter DbType="DateTime" Name="deceaseddt" />
            <asp:Parameter Name="age" Type="Decimal" />
            <asp:Parameter Name="type" Type="String" />
            <asp:Parameter Name="class" Type="String" />
            <asp:Parameter Name="annualdues" Type="Decimal" />
            <asp:Parameter Name="marital" Type="String" />
            <asp:Parameter Name="parish" Type="String" />
            <asp:Parameter Name="fourth" Type="Boolean" />
            <asp:Parameter Name="assemblynm" Type="Decimal" />
            <asp:Parameter DbType="DateTime" Name="firstdeg" />
            <asp:Parameter DbType="DateTime" Name="seconddeg" />
            <asp:Parameter DbType="DateTime" Name="thirddeg" />
            <asp:Parameter DbType="DateTime" Name="fourthdeg" />
            <asp:Parameter Name="degree" Type="String" />
            <asp:Parameter Name="senddegnot" Type="String" />
            <asp:Parameter Name="office" Type="String" />
            <asp:Parameter Name="offnum" Type="Decimal" />
            <asp:Parameter Name="fratyear" Type="Decimal" />
            <asp:Parameter Name="billmessg1" Type="String" />
            <asp:Parameter Name="billmessg2" Type="String" />
            <asp:Parameter Name="billstatus" Type="String" />
            <asp:Parameter DbType="DateTime" Name="bstatdate" />
            <asp:Parameter DbType="DateTime" Name="retcommdt" />
            <asp:Parameter Name="former_sqr" Type="Boolean" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="paystat" Type="String" />
            <asp:Parameter Name="nobill" Type="Boolean" />
            <asp:Parameter Name="dead" Type="Boolean" />
            <asp:Parameter Name="duespaid" Type="Boolean" />
            <asp:Parameter DbType="DateTime" Name="paidthru" />
            <asp:Parameter Name="balancedue" Type="Decimal" />
            <asp:Parameter Name="Contact" Type="String" />
            <asp:Parameter Name="Memo" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
</asp:Content>

Open in new window

0
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

BTosonCommented:
Withough going through all your code, Ithink this should work:
Protected Sub birthdayTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
	Dim BirthdayDate As DateTime
	If IsDate(birthdayTextBox.Text) AndAlso DateTime.TryParse(birthdayTextBox.Text, BirthdayDate) Then
		Age.Text = DateDiff(DateInterval.Year, BirthdayDate, Now)
	End If
End Sub

Open in new window

0
pgkdavefddAuthor Commented:
 BToson, I tried adding the following code as you suggested and I get an errors stating that
Name Textbox3 and Textbox1 have not been declared  

Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim BirthdayDate As DateTime
        If IsDate(TextBox3.Text) AndAlso DateTime.TryParse(TextBox3.Text, BirthdayDate) Then
           TextBox1.Text = DateDiff(DateInterval.Year, BirthdayDate, Now)
        End If

textbox1 is the textbox used in the edit item temp plate for Age and Textbox3 is the one used for Birthday.  I said that I am new to this.  What am I doing wrong?
    End Sub
0
BTosonCommented:
Unfortunately I don't use FormViews at all but this should work:
Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
	Dim Birthday = CType(FormView1.Row.FindControl("TextBox3"), TextBox).Text
	Dim BirthdayDate As DateTime
	If IsDate(Birthday) AndAlso DateTime.TryParse(Birthday, BirthdayDate) Then
		 CType(FormView1.Row.FindControl("TextBox1"), TextBox).Text = DateDiff(DateInterval.Year, BirthdayDate, Now)
	End If
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.