Hi All

Do you have any samples or documentation on using sprocs to do data manipulation through a business object?

I'm using a sproc to fill the datatable and I see options in the business objects for DeleteUsingStoredProceure / DeleteStoredProcedureName etc but I'm not sure how these work.

I've not had a chance to test this but I'm assuming that I'll need to leave dbWriter permissions open to the tables if I'm going to allow the BO to do the data manipulation. Is this correct?

Thanks much

Clay

Just name and type... the order is irrelavent. On the parameter names, you can add any prefix to the field name you like. For instance, if your primary key field is UserID, then you can set your parameter name to @p_UserID or just @UserID. Just set the StoredProcedureParameterNamePrefix property to the correct value...