asp.net parameter on datasource error

[icanhazburger]

I'm getting this error when trying to set a parameter on a access data source at run time, I want to do it dynamically, so ignore the code below trying to put a fixed date in, thats just me trying to get it to work for now, and that value works if its set as default for the parameter so I know that should not be causing a problem.

Error message -

Compiler Error Message: BC30545: Property access must assign to the property or use its value.

Where the error happens -

Protected Sub AccessDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
    e.Command.Parameters["D4_Date"].Value="31/12/2008"
    End Sub

Please save my sanity, I've wasted far to long trying to figure this one out.

[stytagm]

Compiler Error Message: BC30545: Property access must assign to the property or use its value.

I think it means you can only access the ".Value" property, not assign to it. Try the following instead:

Protected Sub AccessDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
    e.Command.Parameters["D4_Date"] = "31/12/2008"
    End Sub

Only add the .Value bit if you want to read it. Let us know if that works.

[yamangman]

Since when did VB have those crazy square brackets everyone else has been using!

[yamangman]

You might also want to look into ISO standard-format dates too. For your sanity.