Browse by Tags

Datasource Filter and NULL

I have the following Datasource below. I require the selection of records from the datasource where the PK is null; is this possible? What would be the syntax. < data : SyndicatorsDataSource ID ="SyndicatorDataSource" runat ="server" SelectMethod ="GetAll" Filter ="Pk is not null" / > Thanks Matt

Posted to .netTiers - General Support (Forum) by matt@kiwilamb.com on 05-25-2007
Filed under: Filter, Filters, DataSource
VList RemoveFilter doesn't work when ApplyFilter with Predicate is used

Hello, When a string filter is used in the list filtered items will be captured in the exclude list. This also works when applying a filter with a delegate (predicate) . Removing the filter when a string filter is used works fine, but when a predicate is used. The RemoveFilter() method doesn't restore...

Posted to .netTiers - Bug Reports (Forum) by bfaassen on 06-08-2007
Filed under: Filter
Re: SqlParameter

Hi Mike! Ok! Thanks for the reply! I misunderstood what you had done. I re-tried your code, now that I understand, and it is working beautifully with GetPaged: < data : RechercheAvanceeDataSource ID ="RechercheAvanceeDataSource" SelectMethod ="GetPaged" EnablePaging ="false" Sort ="ClientNom" OnDataBinding...

Posted to .netTiers - General Support (Forum) by velum on 04-30-2007
Filed under: Filter, Session, SessionField
SqlParameter

Hi! Why isn't it possible to use <asp:QueryStringParameter Name=" ClientID " Type="String" asp:QueryString Field="clientid" /> or <asp:SessionParameter Name=" ClientID " Type="Object" asp:Session Field="clientid" /> as SQL Parameter Filter when using GetPaged as SelectMethod? It is however...

Posted to .netTiers - General Support (Forum) by velum on 04-12-2007
Filed under: Filter, GetPaged, SqlParameter, SessionParameter, QueryStringParameter
Advance Search Problem

Hi. Im building a contact manager and i have the table Contact, Category and ContactInCategory. I don't know what to do a advanced search, in one page i can search by Name, Last Name, Phone or Category. I generate the querystring and in other page show the results in a gridview. The problem is that i...

Posted to .netTiers - General Support (Forum) by elfederiko on 03-28-2007
Filed under: .netTiers, GridView, Filter, Filters, DataSource, Nettiers, GridViewSearchPanel, .net 2.0
Using SqlFilterBuilder to find db columns with empty strings

I need my sql query to exclude records that contain an empty string in the Jobtitle column, so I try query.AppendNotEquals( AdjusterColumn .Jobtitle, String .Empty) but all the Appendxxx methods first check if ( ! String .IsNullOrEmpty(value) ) so the where clause isn't modified. Is there a better way...

Posted to .netTiers - General Support (Forum) by RCouchman on 02-16-2007
Filed under: Filter
Find method treats semi-colon as special character?

I've noticed that the SqlProviders.generated.cs files do something special with a semi-colon, as in: if (whereClause.IndexOf( ";" ) > -1) return new Tygart.MatchBox.Entities. TList < Trait >(); So, an empty TList is returned if any part of the WHERE clause (including the data) has a semi-colon...

Posted to .netTiers - General Support (Forum) by davem1958@gmail.com on 02-08-2007
Filed under: Filter
DataSources, ApplyFilter, and an OR statement

Hi All, Sorry if this post is a repeat, normally I would ask google first but search for the phrase OR just seems like a bad idea. Can someone please clarify for me how to us an OR condition in a filter on a DataSource? As far as I can tell, the expression is being parsed correctly in Expressions.SplitFilter...

Posted to .netTiers - General Support (Forum) by nickhoggard on 01-18-2007
Filed under: DataSource, Filter
Re: EntityDataSource.Filter ~ DataList

Ryan, Sorry it's totally slipped my mind , you should fine just use asterisk instead of percentage when you construct your LIKE clause protected void SearchButton_Click( object sender, EventArgs e) { ClearSearchButton.Enabled = true ; GlossaryDataSource1.Filter = String .Format( "Term LIKE '{0}*'" ,...

Posted to .netTiers - General Support (Forum) by mike123 on 12-13-2006
Filed under: EntityDataSource, Filter
Re: Collections in TList

YES! Thanks alot, worked perfectly. Another question I only want to show the tradecodes which has a Ad. It must be possible to create a filter for that, but i cant find any good documentation on how to write my own filter class. Ive written a sorter, " public class TradeCodeSort : System.Collections...

Posted to .netTiers - General Support (Forum) by hkraft on 10-16-2006
Filed under: Filter

Page 1 of 2 (16 items) 1 2 Next >