|
I am getting an ASP.Net error. I got the code from a college professor's example. I don't understand what's wrong. I have pasted some of my code below.
Here's the error message:
Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Source Error:
Line 55:
Line 56: 'Execute the SQL statement -- using the command object -- to populate the DataReader
Line 57: m_dtrMusic = objCommand.ExecuteReader()
Line 58:
Line 59: 'Read the record into the DataReader object |
Let me give you parts of the code for modify_record2.aspx that are significant to why I may be getting this error message:
<%@ Page Language="VB" Debug="True" Trace="True" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
'Make this DataReader object module-leve in scope so that we
'can bind directly to its field values
dim m_dtrMusic As OleDbDataReader
'---------------------------------------------
' name: DisplayRecord(strProdID as String)
'---------------------------------------------
Sub DisplayRecord(strProdID as String)
Dim strConnect As String
Dim objConnect As New OleDbConnection()
Dim strSQL as String
Dim objCommand As New OleDbCommand()
Dim path
Dim databaseName
databaseName = ""
path = ""
'Create Connection object
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data " _
& "Source=" & path & "\" & databaseName
objConnect.ConnectionString = strConnect
objConnect.Open()
'Build SQL string
strSQL = "Select * From MusicInventory " & _
" Where ID=" & "'" & strProdID & "'"
|