Using a ControlParameter in FilterParameters when the property is null

Posted by end-user on Stack Overflow See other posts from Stack Overflow or by end-user
Published on 2010-04-21T18:39:41Z Indexed on 2010/04/21 18:43 UTC
Read the original article Hit count: 294

Filed under:

controlparameter

|

null

|

selectedvalue

|

datalist

I have a DataList and FormView; they have separate datasources, though they pull the same info. The FormView's datasource has a FilterExpression to pull whatever's been selected on the DataList. On first load, the SelectedValue of the DataList is null (naturally). I expect the FilterExpression to result in zero rows, but it doesn't. If I set the DefaultValue to 0, it does, but then the parameter never updates when I select something from the DataList. Am I doing it wrong?

© Stack Overflow or respective owner

Related posts about controlparameter

Using a ControlParameter in FilterParameters when the property is null

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a DataList and FormView; they have separate datasources, though they pull the same info. The FormView's datasource has a FilterExpression to pull whatever's been selected on the DataList. On first load, the SelectedValue of the DataList is null (naturally). I expect the FilterExpression… >>> More
Accessing and Updating Data in ASP.NET: Filtering Data Using a CheckBoxList

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
Filtering Database Data with Parameters, an earlier installment in this article series, showed how to filter the data returned by ASP.NET's data source controls. In a nutshell, the data source controls can include parameterized queries whose parameter values are defined via parameter controls. For… >>> More
Accessing and Updating Data in ASP.NET: Filtering Data Using a CheckBoxList

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
Filtering Database Data with Parameters, an earlier installment in this article series, showed how to filter the data returned by ASP.NET's data source controls. In a nutshell, the data source controls can include parameterized queries whose parameter values are defined via parameter controls. For… >>> More
Control Parameters and DropDownList Text

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
This is something that I rarely need to do, grab a DropDownList’s selected item’s text for use in a datasource’s ControlParameter. To allow for this use SelectedItem.Text instead of the more common SelectedValue for the PropertyName. <asp:ControlParameter ControlID="ddlStuff" Name="stuffName"… >>> More
ASP.NET control in one content area needs to reference a control in another content area

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a master page that divides the main content into two areas. There are two asp:ContentPlaceHolder controls in the body section of the master page with IDs cphMain and cphSideBar respectively. One of the corresponding content pages has a control in cphMain that needs to refer to a control in… >>> More

Related posts about null

How do I fix a noisy input device (Internal Mic)? snd_hda_intel - debug included

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
As the title says, I'm having trouble with a very noisy audio input device - the internal mic or any plugged in mics. So far I've narrowed it down to an problem in ALSA since my debug info is showing a lot of "null" values. Can anyone help? Debug Info: http://www.alsa-project.org/db/?f=e0c6fb7e10624bf7691aa2b405cf0d3968e56c63 Exert… >>> More
So which null equals this null, that null? maybe this null, or is it this null?

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude of Foreign Key constraints on a table, now… >>> More
MySql query optimization help

as seen on Stack Overflow - Search for 'Stack Overflow'
I have few queries and am not able to figure out how to optimize them, QUERY 1 select * from t_twitter_tracking where classified is null and tweetType='ENGLISH' order by id limit 500; QUERY 2 Select count(*) as cnt, DATE_FORMAT(CONVERT_TZ(wrdTrk.createdOnGMTDate,'+00:00','+05:30'),'%Y-%m-%d')… >>> More
MySQL Database Query Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample of my DB Table #---------------------------- #… >>> More
Null check error message as "is null" or "was null"

as seen on Stack Overflow - Search for 'Stack Overflow'
When doing null checks in Java code, and you throw IllegalArgumentExceptions for null values, what kind of message template do you use? We tend to use something like this public User getUser(String username){ if (username == null){ throw new IllegalArgumentException("username is null");… >>> More