Error adding to the OleDbParameterCollection object

TheMSsForum.com: The Microsoft Software Forum

Thanks for any thoughts on this

I receive the following error when I run the code snippet below:

An OleDbParameter with ParameterName 'CateroryID_New' is not contained by
this OleDbParameterCollection.


Private Function CreateUpdateCommand() As System.Data.OleDb.OleDbCommand
Dim StrSQL As String
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;
Ole DB Services=-4; Data Source=C:\Program File"& _

"s\Microsoft.NET\SDK\v2.0\QuickStart\aspnet\samples\data\App_Data\Northwind.mdb"
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)


strSQL = "UPDATE [Categories] SET CategoryName=?, Description=?
WHERE CategoryID=?"

Dim cmd As New System.Data.OleDb.OleDbCommand (strSQL, dbConnection)

Dim pc As System.Data.OleDb.OleDbParameterCollection = cmd.Parameters

pc.Add("CategoryID_New", System.Data.OleDb.OleDbType.Integer)
pc.Add("CategoryName_New", System.Data.OleDb.OleDbType.BSTR)
pc.Add("Description_New", System.Data.OleDb.OleDbType.BSTR)

pc.Add("CategoryID_Orig", System.Data.OleDb.OleDbType.Integer)
pc.Add("CategoryName_Orig", System.Data.OleDb.OleDbType.BSTR)
pc.Add("Description_Orig", System.Data.OleDb.OleDbType.BSTR)

Return cmd
End Function
Top

Re: Error adding to the OleDbParameterCollection object by Jim

Jim
Fri Mar 24 15:08:43 CST 2006

Comment out the line:

> pc.Add("CategoryID_New", System.Data.OleDb.OleDbType.Integer)

since there won't be a new id


"glenn" <glenn@discussions.microsoft.com> wrote in message
news:CCE13581-7ED4-4901-BEEE-F81EEB7F32AF@microsoft.com...
> Thanks for any thoughts on this
>
> I receive the following error when I run the code snippet below:
>
> An OleDbParameter with ParameterName 'CateroryID_New' is not contained by
> this OleDbParameterCollection.
>
>
> Private Function CreateUpdateCommand() As
System.Data.OleDb.OleDbCommand
> Dim StrSQL As String
> Dim connectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;
> Ole DB Services=-4; Data Source=C:\Program File"& _
>
>
"s\Microsoft.NET\SDK\v2.0\QuickStart\aspnet\samples\data\App_Data\Northwind.
mdb"
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.OleDb.OleDbConnection(connectionString)
>
>
> strSQL = "UPDATE [Categories] SET CategoryName=?, Description=?
> WHERE CategoryID=?"
>
> Dim cmd As New System.Data.OleDb.OleDbCommand (strSQL,
dbConnection)
>
> Dim pc As System.Data.OleDb.OleDbParameterCollection =
cmd.Parameters
>
> pc.Add("CategoryID_New", System.Data.OleDb.OleDbType.Integer)
> pc.Add("CategoryName_New", System.Data.OleDb.OleDbType.BSTR)
> pc.Add("Description_New", System.Data.OleDb.OleDbType.BSTR)
>
> pc.Add("CategoryID_Orig", System.Data.OleDb.OleDbType.Integer)
> pc.Add("CategoryName_Orig", System.Data.OleDb.OleDbType.BSTR)
> pc.Add("Description_Orig", System.Data.OleDb.OleDbType.BSTR)
>
> Return cmd
> End Function
>


Top

RE: Error adding to the OleDbParameterCollection object by BradRoberts56nojunk

BradRoberts56nojunk
Sun Mar 26 16:50:00 CST 2006

Try pc.Add(new oledbParameter(...))

The parameters collection expects a parameter object in the Add().
--
Brad


"glenn" wrote:

> Thanks for any thoughts on this
>
> I receive the following error when I run the code snippet below:
>
> An OleDbParameter with ParameterName 'CateroryID_New' is not contained by
> this OleDbParameterCollection.
>
>
> Private Function CreateUpdateCommand() As System.Data.OleDb.OleDbCommand
> Dim StrSQL As String
> Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;
> Ole DB Services=-4; Data Source=C:\Program File"& _
>
> "s\Microsoft.NET\SDK\v2.0\QuickStart\aspnet\samples\data\App_Data\Northwind.mdb"
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.OleDb.OleDbConnection(connectionString)
>
>
> strSQL = "UPDATE [Categories] SET CategoryName=?, Description=?
> WHERE CategoryID=?"
>
> Dim cmd As New System.Data.OleDb.OleDbCommand (strSQL, dbConnection)
>
> Dim pc As System.Data.OleDb.OleDbParameterCollection = cmd.Parameters
>
> pc.Add("CategoryID_New", System.Data.OleDb.OleDbType.Integer)
> pc.Add("CategoryName_New", System.Data.OleDb.OleDbType.BSTR)
> pc.Add("Description_New", System.Data.OleDb.OleDbType.BSTR)
>
> pc.Add("CategoryID_Orig", System.Data.OleDb.OleDbType.Integer)
> pc.Add("CategoryName_Orig", System.Data.OleDb.OleDbType.BSTR)
> pc.Add("Description_Orig", System.Data.OleDb.OleDbType.BSTR)
>
> Return cmd
> End Function
>
Top