FilterExpression in ASP.NET SqlDataSource

The FilterExpression tag in ASP.NET does not support the between operator. If you try to specify a clause like “between x and y” as your filter expression, you’ll get the error message:  The expression contains unsupported operator ‘Between’

Reading a Binary XML stream in WCF

If you don’t provide a dictionary to read the XML stream with, you will get a weird and unhelpful exception that says “the input source is not correctly formatted”, and googling around will only bring you to posts telling you that “your client/server endpoints are not matched” or “you need to use the basicHttpBinding”. This is not a binding issue – it’s a deserialization issue that comes up when i make an attempt to inspect the soap messages coming in to (or going out of) my WCF service.

Using an SQL join in a SQL delete statement

I found this post by Ben Nadel when I was looking for a way to delete the rows in a table based on a foreign key column. I needed this to clear answers provided by a particular user in an online quiz I was developing. It was a real timesaver – the other options were […]

Posted in Tech Tips. Tags: , , , . No Comments »

Accessing Controls in a DIV with the runat=server attribute

When you use the runat=”server” attribute with a div tag in, any controls nested in the div will not be accessible directly via the page’s Controls collection. They will be in the Controls collection of the div.

Posted in Tech Tips. Tags: , . No Comments »