Hi
I am trying to follow the walkthrough on MSDN
http://msdn.microsoft.com/library/en...InWebForms.asp
however, as I do not have a working version of SQL server available (which
is another story . . ) I have tried to modify the code to use OLEconnection
and OLECommand with the Jet 4.0 data link provider.
The connection seems to work OK - the page loads with the first record of
the dataset. However when I select the category ID of any other item, I get
this error:
An OleDbParameter with ParameterName 'categoryid' is not contained by this
OleDbParameterC ollection.
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.IndexOut OfRangeExceptio n: An OleDbParameter with
ParameterName 'categoryid' is not contained by this OleDbParameterC ollection.
Source Error:
Line 91: Categoryid = ddlCategoryID.S electedItem.Tex t
Line 92:
Line 93: cmdCategoriesBy ID.Parameters(" categoryid").Va lue = Categoryid
Line 94:
Line 95: OleDbConnection 1.Open()
Here is the full code for what I guess is the relevant bit:
Private Sub ddlCategoryID_S electedIndexCha nged(ByVal sender As
System.Object, ByVal e As System.EventArg s) Handles
ddlCategoryID.S electedIndexCha nged
Dim Categoryid As String
Categoryid = ddlCategoryID.S electedItem.Tex t
cmdCategoriesBy ID.Parameters(" categoryid").Va lue = Categoryid
OleDbConnection 1.Open()
Dim dReader As System.Data.Ole Db.OleDbDataRea der
dreader = cmdCategoriesBy ID.ExecuteReade r(CommandBehavi or.SingleRow)
If dreader.Read() Then
txtCategoryName .Text = dreader(1)
txtCategoryDesc ription.Text = dreader(2)
End If
dreader.Close()
OleDbConnection 1.Close()
End Sub
Anyone have any thoughts on why it won't work?
Thanks.
--
one door shuts, another closes . .