Browse Site by Tags - CodeSmith Community

Custom stored procedure that calls a view

Hi There I am having trouble with the netiers component of codesmith. My main problem is that I have a view and would like to search on that view using a like % clause. I cant see any built in methods that allows you do do this. I wrote a custom stored procedure that calls that view and filters on string...

Posted to .netTiers - General Support (Forum) by StantonR on 06-02-2008
Filed under: Custom Stored Procedure, VList, ParameterizedFilters, LIKE, vlist find

NetTiers newbie question - How to use parameter builder to compare column values

I want to use parameter builder to replicate this SQL query: select * from viewSessionDetails where StartDate >= 'August 3, 2007' AND CourseID = 149 AND MaxEnrollment > Registrants So far my code is: InUnison.EnvisionU.Data.Bases. ViewSessionDetailsParameterBuilder SessionDetailsParams...

Posted to .netTiers - General Support (Forum) by turbocode on 08-03-2007
Filed under: .netTiers, ParameterizedFilters

Re: Filter on referenced table

Abhijit, Here is an example (Northwind DB) <data:ProductsDataSource ID="ProductsDataSource" runat="server" SelectMethod="GetPaged" EnablePaging="True" EnableSorting="True" > <Parameters> <data:SqlParameter UseParameterizedFilters="false"...

Posted to .netTiers - General Support (Forum) by mike123 on 07-11-2007
Filed under: BuilderExpression, ParameterizedFilters