Specified argument was out of the range of valid values. Parameter name: 0

Discussion in 'ASP .Net' started by Todd Perkins, Sep 15, 2004.

  1. Todd Perkins

    Todd Perkins Guest

    Hello all, surprisingly enough, this is my first newsgroup post, I usually
    rely on google. So I hope I have enough info contained. Thank you in
    advance for any help!

    Problem:

    I am getting this error when I try to pull up my edit page to display the
    current database information in the form, and then edit it on click:


    Server Error in '/' Application.
    --------------------------------------------------------------------------------

    Specified argument was out of the range of valid values. Parameter name: 0
    Description: An unhandled exception occurred during the execution of the
    current web request. Please review the stack trace for more information
    about the error and where it originated in the code.

    Exception Details: System.ArgumentOutOfRangeException: Specified argument
    was out of the range of valid values. Parameter name: 0






    The field that I have tracked down that is causing the error appears to be
    vehiclewarrantyyears - the field in the db is Int field with 4 chars
    allowing nulls.

    Any Ideas would be VERY much appreciated!!!! Thanks!




    Here is my code:



    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Web" %>
    <%@ Import Namespace="System.IO" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <%@ Import Namespace="System.Data.SqlClient" %>
    <%@ Import Namespace="System.Drawing.Imaging" %>


    <%
    Dim conSiteData As SqlConnection
    Dim cmdSelectAll As SqlCommand
    Dim dtrSiteDetails As SqlDataReader
    Dim conSelectRow As SqlConnection
    Dim cmdSelectRow As SqlCommand
    Dim dtrRowData As SqlDataReader


    conSiteData = New SqlConnection( "Server info here" )
    conSiteData.Open()
    cmdSelectAll = New SqlCommand( "SELECT * FROM sitedata",conSiteData )
    dtrSiteDetails = cmdSelectAll.ExecuteReader()
    dtrSiteDetails.Read()


    conSelectRow = New SqlConnection( "server info here" )
    conSelectRow.Open()
    cmdSelectRow = New SqlCommand( "SELECT * FROM vehicles WHERE ID=" &
    Request.QueryString("ID"), conSelectRow )
    dtrRowData = cmdSelectRow.ExecuteReader()
    dtrRowData.Read()

    If dtrRowData.HasRows = False Then
    Session("error") = "true"
    Response.Redirect( "editvehicle.aspx" )
    End If


    vehiclelocation.SelectedValue = dtrRowData("vehiclelocation").ToString()
    vehicleyear.SelectedValue = dtrRowData("vehicleyear").ToString()
    vehiclesellingprice.Text =
    FormatNumber(dtrRowData("vehiclesellingprice").ToString(), 0,,,false)
    vehiclemileage.Text = FormatNumber(dtrRowData("vehiclemileage").ToString(),
    0,,,false)
    vehicleexteriorcolor.Text = dtrRowData("vehicleexteriorcolor").ToString()
    vehicletransmission.SelectedValue =
    dtrRowData("vehicletransmission").ToString()
    vehiclevinnumber.Text = dtrRowData("vehiclevinnumber").ToString()
    vehiclestocknumber.Text = dtrRowData("vehiclestocknumber").ToString()

    vehiclewarrantyyears.SelectedValue =
    dtrRowData("vehiclewarrantyyears").ToString()

    vehiclewarrantymiles.Text =
    FormatNumber(dtrRowData("vehiclewarrantymiles").ToString(), 0,,,false)
    vehicleenginetype.Text = dtrRowData("vehicleenginetype").ToString()
    vehiclebodystyle.SelectedValue = dtrRowData("vehiclebodystyle").ToString()
    vehicleinteriortype.SelectedValue =
    dtrRowData("vehicleinteriortype").ToString()
    vehicleinteriorcolor.Text = dtrRowData("vehicleinteriorcolor").ToString()
    vehicleequipment.Text = dtrRowData("vehicleequipment").ToString()

    Dim strSpecial As String
    strSpecial = dtrRowData("specialvehicle")

    If strSpecial = 0 Then
    specialvehicle.Checked = False
    ElseIf strSpecial = 1 Then
    specialvehicle.Checked = True
    End If

    lblManu.Text = dtrRowData("vehiclemanufacturer").ToString()
    lblModel.Text = dtrRowData("vehiclemodel").ToString()

    %>


    <SCRIPT Runat="Server">


    Sub btnSubmitNoPic_Click( s As Object, e As EventArgs )
    If IsValid Then
    Dim conMyCn As SqlConnection
    Dim strUpdate As String
    Dim cmdUpdate As SqlCommand


    conMyCn = New SqlConnection(
    "Server=S39800\CARSDELUXE;uid=sa;pwd=dev04;database=uvims_hondaofhawaii" )

    strUpdate = "Update vehicles Set vehiclelocation=@vehiclelocation,
    vehicleyear=@vehicleyear, vehiclesellingprice=@vehiclesellingprice,
    vehiclemileage=@vehiclemileage, vehicleexteriorcolor=@vehicleexteriorcolor,
    vehicletransmission=@vehicletransmission,
    vehiclevinnumber=@vehiclevinnumber, vehiclestocknumber=@vehiclestocknumber,
    vehiclewarrantyyears=@vehiclewarrantyyears,
    vehiclewarrantymiles=@vehiclewarrantymiles,
    vehicleenginetype=@vehicleenginetype, vehiclebodystyle=@vehiclebodystyle,
    vehicleequipment=@vehicleequipment,
    vehicleinteriortype=@vehicleinteriortype,
    vehicleinteriorcolor=@vehicleinteriorcolor, specialvehicle=@specialvehicle
    WHERE ID=" & Request.QueryString("ID")
    cmdUpdate = New SqlCommand( strUpdate, conMyCn )

    cmdUpdate.Parameters.Add( "@vehiclelocation",
    vehiclelocation.SelectedValue )
    cmdUpdate.Parameters.Add( "@vehicleyear", SqlDbType.Int ).Value =
    vehicleyear.SelectedItem.Value
    cmdUpdate.Parameters.Add( "@vehiclesellingprice", SqlDbType.Money ).Value =
    vehiclesellingprice.Text
    cmdUpdate.Parameters.Add( "@vehiclemileage", SqlDbType.Int ).Value =
    vehiclemileage.Text
    cmdUpdate.Parameters.Add( "@vehicleexteriorcolor",
    vehicleexteriorcolor.Text )
    cmdUpdate.Parameters.Add( "@vehicletransmission",
    vehicletransmission.SelectedItem.Value )
    cmdUpdate.Parameters.Add( "@vehiclevinnumber", vehiclevinnumber.Text )
    cmdUpdate.Parameters.Add( "@vehiclestocknumber", vehiclestocknumber.Text )



    cmdUpdate.Parameters.Add( "@vehiclewarrantyyears", SqlDbType.Int ).Value =
    vehiclewarrantyyears.SelectedItem.Value




    cmdUpdate.Parameters.Add( "@vehiclewarrantymiles", SqlDbType.Int ).Value =
    vehiclewarrantymiles.Text
    cmdUpdate.Parameters.Add( "@vehicleenginetype", vehicleenginetype.Text )
    cmdUpdate.Parameters.Add( "@vehiclebodystyle",
    vehiclebodystyle.SelectedItem.Value )
    cmdUpdate.Parameters.Add( "@vehicleequipment", vehicleequipment.Text )
    cmdUpdate.Parameters.Add( "@vehicleinteriortype",
    vehicleinteriortype.SelectedItem.Value )
    cmdUpdate.Parameters.Add( "@vehicleinteriorcolor",
    vehicleinteriorcolor.Text )
    If specialvehicle.Checked Then
    cmdUpdate.Parameters.Add( "@specialvehicle", SqlDbType.Int ).Value = 1
    Else
    cmdUpdate.Parameters.Add( "@specialvehicle", SqlDbType.Int ).Value = 0
    End If



    conMyCn.Open()
    cmdUpdate.ExecuteNonQuery()
    conMyCn.Close()

    Session("success") = "true"
    Response.Redirect( "editvehicle.aspx" )
    End If
    End Sub











    </SCRIPT>


    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><%=(dtrSiteDetails("sitepagetitles"))%></title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <meta NAME="keywords" CONTENT="<%=(dtrSiteDetails("sitemetakeywords"))%>">
    <meta NAME="description"
    CONTENT="<%=(dtrSiteDetails("sitemetadescription"))%>">

    </head>

    <body topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
    <td bgcolor="#CC0000"><img src="../images/admin_logo.gif" border="0"></td>
    </tr>
    </table>
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>

    <td bgcolor="#000000"><img src="../images/admin_navigation.jpg"
    border="0" usemap="#Map"></td>
    </tr>
    </table>





    <table width="750" border="0" cellpadding="10" cellspacing="0">
    <tr>
    <td>

    <table width="100%" cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td bgcolor="#F7F7F7">

    <img src="../images/headereditvehicle2.jpg">

    </td>
    </tr>
    </table>

    <p>

    <form EncType="multipart/form-data" Runat="Server">

    <asp:ValidationSummary
    HeaderText="There are problems within the form."
    DisplayMode="BulletList"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    Runat="Server" />

    <asp:Label
    ID="lblManu"
    Font-Size="24pt"
    ForeColor="#777777"
    Font-Names="Arial,Helvetica"
    Runat="Server" />

    <asp:Label
    ID="lblModel"
    Font-Size="14pt"
    ForeColor="#777777"
    Font-Names="Arial,Helvetica"
    Font-Italic="True"
    Runat="Server" />

    <p>

    <table width="100%" cellpadding="0" cellspacing="0" border="0">
    <tr>
    <td bgcolor="#000000"> <table width="100%" border="0" cellspacing="0"
    cellpadding="3">
    <tr>
    <td width="60%" valign="top" bgcolor="#CC0000">
    <table width="423" border="0" cellspacing="0"
    cellpadding="0">
    <tr>
    <td width="211"> <asp:Label
    Text="Year"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:DropDownList
    ID="vehicleyear"
    Runat="Server">
    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="1950" />
    <asp:ListItem Text="1951" />
    <asp:ListItem Text="1952" />
    <asp:ListItem Text="1953" />
    <asp:ListItem Text="1954" />
    <asp:ListItem Text="1955" />
    <asp:ListItem Text="1956" />
    <asp:ListItem Text="1957" />
    <asp:ListItem Text="1958" />
    <asp:ListItem Text="1959" />
    <asp:ListItem Text="1960" />
    <asp:ListItem Text="1961" />
    <asp:ListItem Text="1962" />
    <asp:ListItem Text="1963" />
    <asp:ListItem Text="1964" />
    <asp:ListItem Text="1965" />
    <asp:ListItem Text="1966" />
    <asp:ListItem Text="1967" />
    <asp:ListItem Text="1968" />
    <asp:ListItem Text="1969" />
    <asp:ListItem Text="1970" />
    <asp:ListItem Text="1971" />
    <asp:ListItem Text="1972" />
    <asp:ListItem Text="1973" />
    <asp:ListItem Text="1974" />
    <asp:ListItem Text="1975" />
    <asp:ListItem Text="1976" />
    <asp:ListItem Text="1977" />
    <asp:ListItem Text="1978" />
    <asp:ListItem Text="1979" />
    <asp:ListItem Text="1980" />
    <asp:ListItem Text="1981" />
    <asp:ListItem Text="1982" />
    <asp:ListItem Text="1983" />
    <asp:ListItem Text="1984" />
    <asp:ListItem Text="1985" />
    <asp:ListItem Text="1986" />
    <asp:ListItem Text="1987" />
    <asp:ListItem Text="1988" />
    <asp:ListItem Text="1989" />
    <asp:ListItem Text="1990" />
    <asp:ListItem Text="1991" />
    <asp:ListItem Text="1992" />
    <asp:ListItem Text="1993" />
    <asp:ListItem Text="1994" />
    <asp:ListItem Text="1995" />
    <asp:ListItem Text="1996" />
    <asp:ListItem Text="1997" />
    <asp:ListItem Text="1998" />
    <asp:ListItem Text="1999" />
    <asp:ListItem Text="2000" />
    <asp:ListItem Text="2001" />
    <asp:ListItem Text="2002" />
    <asp:ListItem Text="2003" />
    <asp:ListItem Text="2004" />
    <asp:ListItem Text="2005" />
    <asp:ListItem Text="2006" /> </asp:DropDownList>

    <asp:RequiredFieldValidator
    Display="Dynamic"
    ControlToValidate="vehicleyear"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    InitialValue="Please Choose"
    ErrorMessage="You must select a vehicle year"
    Text="*"
    Runat="Server" />

    </td>
    <td width="212"> <asp:Label
    Text="Selling Price"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehiclesellingprice"
    MaxLength="8"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    ErrorMessage="Selling price should be entered as 5555 do not enter any
    characters other then numbers"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ControlToValidate="vehiclesellingprice"
    Text="*"
    ValidationExpression="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*.]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="You must enter a selling price"
    ControlToValidate="vehiclesellingprice"
    Text="*"
    Runat="Server" />



    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Mileage"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehiclemileage"
    MaxLength="8"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    ErrorMessage="Vehicle mileage should be entered as 55555 and cannot
    contain any characters other than numbers"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ControlToValidate="vehiclemileage"
    Text="*"
    ValidationExpression="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*.]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="You must include the vehicle mileage"
    ControlToValidate="vehiclemileage"
    Text="*"
    Runat="Server" />

    </td>
    <td> <asp:Label
    Text="Exterior Color"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehicleexteriorcolor"
    MaxLength="250"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Exterior color cannot contain any special characters"
    ControlToValidate="vehicleexteriorcolor"
    Text="*"
    ValidationExpression="^[^!@#$%^&*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="You must include an exterior color"
    ControlToValidate="vehicleexteriorcolor"
    Text="*"
    Runat="Server" />



    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Transmission Type"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br>

    <asp:DropDownList
    ID="vehicletransmission"
    Runat="Server">

    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="Automatic" />
    <asp:ListItem Text="Manual" />

    </asp:DropDownList>



    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="You must include the vehicle transmission type"
    InitialValue="Please Choose"
    ControlToValidate="vehicletransmission"
    Text="*"
    Runat="Server" />


    </td>
    <td> <asp:Label
    Text="Vin Number"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehiclevinnumber"
    MaxLength="250"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="VIN number cannot contain any special characters"
    ControlToValidate="vehiclevinnumber"
    Text="*"
    ValidationExpression="^[^!@#$%^&*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    ForeColor="#ffffff"
    Font-Size="8pt"
    ErrorMessage="You must include the vehicle VIN number"
    ControlToValidate="vehiclevinnumber"
    Text="*"
    Runat="Server" />

    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Stock Number"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehiclestocknumber"
    MaxLength="250"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Stock number cannot contain any special characters. Only
    letter and number combinations are accepted"
    ControlToValidate="vehiclestocknumber"
    Text="*"
    ValidationExpression="^[^!@#$%^&*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Please include a vehicle stock number"
    ControlToValidate="vehiclestocknumber"
    Text="*"
    Runat="Server" />

    </td>
    <td> <asp:Label
    Text="Warranty Years"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br>

    <asp:DropDownList
    ID="vehiclewarrantyyears"
    Runat="Server">

    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="1" />
    <asp:ListItem Text="2" />
    <asp:ListItem Text="3" />
    <asp:ListItem Text="4" />
    <asp:ListItem Text="5" />
    <asp:ListItem Text="6" />
    <asp:ListItem Text="7" />
    <asp:ListItem Text="8" />
    <asp:ListItem Text="9" />
    <asp:ListItem Text="10" />

    </asp:DropDownList>



    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Please select warranty years"
    InitialValue="Please Choose"
    ControlToValidate="vehiclewarrantyyears"
    Text="*"
    Runat="Server" />

    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Warranty Miles"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehiclewarrantymiles"
    MaxLength="8"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Warranty miles must contain only a number with no commas or
    periods"
    ControlToValidate="vehiclewarrantymiles"
    Text="*"
    ValidationExpression="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*.]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Please include warranty miles"
    ControlToValidate="vehiclewarrantymiles"
    Text="*"
    Runat="Server" />

    </td>
    <td> <asp:Label
    Text="Engine Type"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehicleenginetype"
    MaxLength="250"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Engine type must not contain any special characters"
    ControlToValidate="vehicleenginetype"
    Text="*"
    ValidationExpression="^[^!@#$%^&*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Please include an engine type"
    ControlToValidate="vehicleenginetype"
    Text="*"
    Runat="Server" />

    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Body Style"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br>

    <asp:DropDownList
    ID="vehiclebodystyle"
    Runat="Server">

    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="Convertible" />
    <asp:ListItem Text="Sedan" />
    <asp:ListItem Text="Coupe" />
    <asp:ListItem Text="SUV" />
    <asp:ListItem Text="HatchBack" />
    <asp:ListItem Text="Truck" />
    <asp:ListItem Text="Mini Van" />
    <asp:ListItem Text="Van" />
    <asp:ListItem Text="Wagon" />

    </asp:DropDownList>




    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Please select a body style"
    InitialValue="Please Choose"
    ControlToValidate="vehiclebodystyle"
    Text="*"
    Runat="Server" />


    </td>
    <td> <asp:Label
    Text="Interior Type"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br>

    <asp:DropDownList
    ID="vehicleinteriortype"
    Runat="Server">

    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="Fabric" />
    <asp:ListItem Text="Leather" />

    </asp:DropDownList>


    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Please select an interior type"
    InitialValue="Please Choose"
    ControlToValidate="vehicleinteriortype"
    Text="*"
    Runat="Server" />


    </td>
    </tr>
    <tr>
    <td> <asp:Label
    Text="Interior Color"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" /> <br> <asp:TextBox
    ID="vehicleinteriorcolor"
    MaxLength="250"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Interior color cannot contain any special characters"
    ControlToValidate="vehicleinteriorcolor"
    Text="*"
    ValidationExpression="^[^!@#$%^&*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Interior color is required"
    ControlToValidate="vehicleinteriorcolor"
    Text="*"
    Runat="Server" />

    </td>
    <td>&nbsp;</td>
    </tr>
    <tr>
    <td colspan="2">

    <asp:Label
    Text="Equipment"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" />

    <br>
    <asp:TextBox
    ID="vehicleequipment"
    Columns="43"
    Rows="7"
    TextMode="MultiLine"
    MaxLength="1000"
    Runat="Server" />

    <asp:RegularExpressionValidator
    Display="Dynamic"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    ErrorMessage="Vehicle equipment cannot contain any special characters"
    ControlToValidate="vehicleequipment"
    Text="*"
    ValidationExpression="^[^@#^*]*$"
    Runat="Server" />
    <asp:RequiredFieldValidator
    Display="Dynamic"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ErrorMessage="Please include vehicle equipment"
    ControlToValidate="vehicleequipment"
    Text="*"
    Runat="Server" />


    <p>

    <asp:CheckBox
    ID="specialvehicle"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Text="Put this vehicle on special"
    Runat="Server" />



    <asp:Label
    Text="Vehicle Location"
    Font-Size="8pt"
    ForeColor="#ffffff"
    Font-Names="Arial,Helvetica"
    Runat="Server" />

    <br>
    <asp:DropDownList
    ID="vehiclelocation"
    Runat="Server">

    <asp:ListItem Text="Please Choose" />
    <asp:ListItem Text="Kailua Kona" />
    <asp:ListItem Text="Hilo" />

    </asp:DropDownList>

    <asp:RequiredFieldValidator
    Display="Dynamic"
    ControlToValidate="vehiclelocation"
    Font-Names="Arial,Helvetica"
    Font-Size="8pt"
    ForeColor="#ffffff"
    InitialValue="Please Choose"
    ErrorMessage="You must select a vehicle location"
    Text="*"
    Runat="Server" />


    </td>
    </tr>
    </table>

    </td>
    <td width="40%" valign="top" align="center">

    <img src="../images/bigedit.jpg" border="0">


    </td>
    </tr>
    </table>







    </td>
    </tr>
    </table>









    <p>


    <asp:Button
    ID="btnSubmitNoPic"
    Text="Update Vehicle"
    OnClick="btnSubmitNoPic_Click"
    Runat="Server" />




















    </form>





    </td>
    </tr>
    </table>











    <map name="Map">
    <area shape="rect" coords="2,1,153,21" href="addvehicle.aspx">
    <area shape="rect" coords="155,0,294,32" href="deletevehicle.aspx">
    <area shape="rect" coords="295,0,436,28" href="editvehicle.aspx">
    <area shape="rect" coords="438,0,580,21" href="imagecenter.aspx">
    </map>


    </body>
    </html>

    <%
    dtrSiteDetails.Close()
    conSiteData.Close()
    dtrRowData.Close()
    conSelectRow.Close()
    %>
     
    Todd Perkins, Sep 15, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. subdhar
    Replies:
    9
    Views:
    27,891
    Subhashish Dhar
    Nov 9, 2004
  2. darrel
    Replies:
    0
    Views:
    8,430
    darrel
    Aug 14, 2006
  3. Chapi
    Replies:
    2
    Views:
    10,828
    Chapi
    May 26, 2008
  4. Dave
    Replies:
    0
    Views:
    1,760
  5. Dave
    Replies:
    11
    Views:
    859
    Jesse Houwing
    Jul 9, 2006
Loading...

Share This Page