I'm using the ThingsForSale example as a starting point, but I'm running into trouble.  I want to be able to store everything in a single table like ThingsForSale, but I to limit the view so people could only see thier stuff.  It's for another type of application, this way an "administrator" could see all the records, but the person putting in the data could only see the data they put in.  But also check to make sure that the record was not already in the table.  So two people could not type in "fish".  I have this set on the database side, but can't seem to get a catch statement to work right. 

I thought I could add add a column in the table for the useID and store it and then with the stored procedure only pull back the records where (moduleID = @moduleID and userID=@userid), but that did not work.  I also tried just using the userID instead fo the moduleID, but that did not work either.  Here is what I added to the controller.  I modified the info as well to add the userID information and used a new Stored Procedure so I would not mess up the orginal one.

Any idea or an example I could look at?  It always seems that I can only find a portion of what I want to try and accomplish.

Thanks.

I tried:

<DataObjectMethod(DataObjectMethodType.Select)> _
Public Shared Function LandingPages_SelectAll(ByVal ModuleID As Integer, ByVal UserID As Integer) As List(Of LandingPagesInfo)
Return CBO.FillCollection(Of LandingPagesInfo)(CType(DataProvider.Instance().ExecuteReader("Stuff_SelectAll", ModuleID, UserID), IDataReader))