Old Mac,
Do you have a public get and set function for your parameter array? If so are the names and types identical to the names and types in your stored procedure?
*I could be wrong but I thought you used the DataSourceID property when connecting to a asp:SqlDataSource and the DataSource property when your filling the control with a IDataReader. That is why you don’t see DataSourceID used much in DotNetNuke controls.
*Another possible problem is:
Me.DataList1.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), UpdateParam, Nothing), IDataReader)
I believe ExecuteSQL() only takes two parameters… Try removing the “Nothing”.
*Another possible problem is, you don’t set the direction of your UpdateParam…
UpdateParam.Direction = ParameterDirection.Input
*Another thing to keep in mind if you edit the TableName_SelectAll stored procedure to not need the moduleid you need to delete @ModuleID int and the WHERE statement.
--Nathan Rover