CAST Problem Continued

Thanks for previous help, I am however continuing to have problems as I  attempt to search a table for a value keyed by the user (e.g. AccessionPresent= 3624-01).  The input value that is being searched against is stored in the table as an INT.  I have cast the INT to a VARCHAR on the line described as "MSQL=....

Can anyone ascertain why I get the error, described below?  The query works in the Query Analyzer?? What am I doing incorrectly... Any assistance will be appreciated...

Thanks !  

Dim DS As DataSet
Dim MyCommand As SqlDataAdapter
Dim AccessionPresent, strsearchedfor, strsearchresult As String
Dim RcdCount As Integer
Dim ResultCount As Integer
AccessionPresent = Accession.Text
strsearchedfor = "The Keyed Accession Number "
strsearchresult = " Does Not Exist. Please Verify Your Entry. "
ErrorLabel.Text = String.Format("{1}<b><font size=ex-small color=003399>{0}</b></font>{2}", AccessionPresent, strsearchedfor, strsearchresult)
Dim MySQL As String

MySQL = "SELECT * FROM ClinicalSpecimen WHERE CAST(SpecimenID AS varchar(50))='" & AccessionPresent & "'"Dim objConnValidate As SqlConnection
Dim mySettingsValidate As New NameValueCollection
mySettingsValidate = AppSettings
Dim strConn As String
strConn = mySettingsValidate("connString")
objConnValidate = New SqlConnection(strConn)

MyCommand = New SqlDataAdapter(MySQL, strConn)
DS = New DataSet
MyCommand.Fill(DS, "SpecimenID")
RcdCount = DS.Tables("SpecimenID").Rows.Count.ToString()If DS.Tables(0).Rows.Count > 0 Then
Response.Redirect("Accession_Result.aspx?AccessionResult=" & AccessionPresent)

ElseIf DS.Tables(0).Rows.Count = 0 Then
Response.Redirect(http://www.aol.com)

 

IS CAUSING THE FOLLOWING ERROR:


Server Error in '/ClinicTest2' Application.


Syntax error converting the nvarchar value '3624-01' to a column of data type int.

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.Data.SqlClient.SqlException: Syntax error converting the nvarchar value '3624-01' to a column of data type int.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[SqlException (0x80131904): Syntax error converting the nvarchar value '3624-01' to a column of data type int.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.HasMoreRows() +194
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +262
System.Data.SqlClient.SqlDataReader.Read() +29
System.Data.ProviderBase.DataReaderContainer.Read() +26
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +240
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +257
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +383
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +251
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2859
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +153
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
System.Web.UI.WebControls.GridView.DataBind() +23
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +92
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +100
System.Web.UI.Control.EnsureChildControls() +134
System.Web.UI.Control.PreRenderRecursiveInternal() +109
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4436