By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,310 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,310 IT Pros & Developers. It's quick & easy.

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

P: n/a
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").ToS tring(), 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").To String(), 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;databas e=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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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()
%>





Nov 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I should also say that the error only appears to be happening when
vehiclewarrantyyear field has a value of 0 in the database.

Thanks!

"Todd Perkins" <to**@static9.com> wrote in message
news:pZ*******************@bignews5.bellsouth.net. ..
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").ToS tring(), 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").To String(), 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;databas e=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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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()
%>





Nov 18 '05 #2

P: n/a
Is it a 0 or a NULL ?
Also, step through the code and find the line causing the error.
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Todd Perkins" <to**@NOSPAMstatic9.com> wrote in message
news:Ja*******************@bignews5.bellsouth.net. ..
I should also say that the error only appears to be happening when
vehiclewarrantyyear field has a value of 0 in the database.

Thanks!

"Todd Perkins" <to**@static9.com> wrote in message
news:pZ*******************@bignews5.bellsouth.net. ..
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").ToS tring(), 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").To String(), 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;databas e=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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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="^[^,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ!@#$%^&*.]*$"
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()
%>






Nov 18 '05 #3

P: n/a
I gave a longer answer that might be lost in the ether somewhere. Shorter
version, looks like you're setting SelectedValue of vehiclewarrantyyears
dropdown to "0", but that's not a valid value in the list (there's "please
choose" and "1", but no "0"). Use FindByValue to make sure the entry is in
the list, even when you "know" it should be.

hth,

Bill

Nov 18 '05 #4

P: n/a
My goodness, YOU WERE RIGHT!!!!

I feel like a complete tool lol. Thank you so very much Bill for taking the
time to step through this!

Todd

"Bill Borg" <Bi******@discussions.microsoft.com> wrote in message
news:8F**********************************@microsof t.com...
I gave a longer answer that might be lost in the ether somewhere. Shorter
version, looks like you're setting SelectedValue of vehiclewarrantyyears
dropdown to "0", but that's not a valid value in the list (there's "please
choose" and "1", but no "0"). Use FindByValue to make sure the entry is in
the list, even when you "know" it should be.

hth,

Bill

Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.