Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Objectdatasource parameters
Started 1 month, 2 weeks ago by craigbtx
Can I paramterize the following query to show only the records that have col1 = NOT NULL OR Show all records regardles of col1 values OR to show only the records that have col2 = NOT NULL OR Show all records regardles of col2 values ? I only to filter the results for 1 column at a time. I was thinking SELECT ReadingDate, AvgFeedWaterTempF, AvgCondensateTempF FROM...
Site: Forums - ASP.NET Forums  Forums - ASP.NET Forums - site profile
Forum: Data Access and ObjectDataSource Control  Data Access and ObjectDataSource Control - forum profile
Total authors: 1 author
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: asp.net

Other posts in this thread:

craigbtx replied 1 month, 2 weeks ago
You could do this.. SELECT ReadingDate, AvgCondensateTempF, AvgFeedWaterTempF FROM BoilersTestDataSupplyWaterAveragesPerDay WHERE (SystemID = 33) AND (ISNULL(AvgCondensateTempF, 0) <> @CT) AND (ISNULL(AvgFeedWaterTempF, 0) <> @FW1) ONLY one parameter can be 0 at a time. You can use 0 or any number the column is not equal too like 999999999 or -1. the column with...
Size: 716 bytes
Customize:  Customize "<b>Reply 1</b>: Objectdatasource parameters :: Data Access and ObjectDataSource Control :: Forums - ASP.NET Forums"

 

Top contributing authors

Name
Posts
craigbtx
2
user's latest post:
Objectdatasource parameters
Published (2009-11-13 19:43:15)
You could do this.. SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ReadingDate, AvgCondensateTempF, AvgFeedWaterTempF FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoilersTestDataSupplyWaterAveragesPerDay WHERE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SystemID = 33) AND (ISNULL(AvgCondensateTempF, 0)...

Related threads on "Forums - ASP.NET Forums":

ObjectDataSource Parameters are blank when runat=server...  Forums - ASP.NET Forums - site profile Data Presentation Controls - forum profile ObjectDataSource Parameters are blank when runat=server used in <TR>...
ObjectDataSource Parameters are blank when runat=server used in <TR>...
Dynamically set ObjectDataSource Method and parameters  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile Dynamically set ObjectDataSource Method and parameters
Dynamically set ObjectDataSource Method and parameters
How to set insert Parameters for ObjectDataSource?  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile How to set insert Parameters for ObjectDataSource?
How to set insert Parameters for ObjectDataSource?
How to set parameters for ObjectDataSource?  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile How to set parameters for ObjectDataSource?
How to set parameters for ObjectDataSource?
Need to set parameters for a ObjectDataSource update...  Forums - ASP.NET Forums - site profile ASP.NET AJAX Controls Toolkit - forum profile Need to set parameters for a ObjectDataSource update method thats...
Need to set parameters for a ObjectDataSource update method thats...
ObjectDataSource and Parameters  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile ObjectDataSource and Parameters
ObjectDataSource and Parameters
Multi-Value ListBox, ObjectDataSource and Passing Parameters  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile Multi-Value ListBox, ObjectDataSource and Passing Parameters
Multi-Value ListBox, ObjectDataSource and Passing Parameters
ObjectDataSource could not find a non-generic method that...  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile ObjectDataSource could not find a non-generic method that has parameters...
ObjectDataSource could not find a non-generic method that has parameters...
Passing parameters using an ObjectDataSource to Insert...  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile Passing parameters using an ObjectDataSource to Insert method - how...
Passing parameters using an ObjectDataSource to Insert method - how...
Parameters are not passed from GridView To ObjectDataSource  Forums - ASP.NET Forums - site profile Data Access and ObjectDataSource Control - forum profile Parameters are not passed from GridView To ObjectDataSource
Parameters are not passed from GridView To ObjectDataSource

Related threads on other sites:

ObjectDataSource 'ObjectDataSource1' could not find a...  C# Forum : C#, VB.NET, WCF, WPF, Silverlight, WF, XAML, .NET 3.0, .NET 3.5, Visual Studio 2008 Forums - site profile ASP.NET & Web Development - forum profile ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'Insert' that has parameters: ProductName, SupplierID, CategoryID, QuantityPerUnit, price, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued, UnitPrice. :(
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'Insert' that has parameters: ProductName, SupplierID, CategoryID, QuantityPerUnit, price, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued, UnitPrice. :(
Select Parameters in ObjectDataSource in DataGrid  Forums : The Official Microsoft Silverlight Site - site profile Getting Started - forum profile Select Parameters in ObjectDataSource in DataGrid
Select Parameters in ObjectDataSource in DataGrid
ObjectDataSource not returning all input parameters  CodeProject: Discussion Boards. Free source code and programming help - site profile ASP.NET - forum profile ObjectDataSource not returning all input parameters
ObjectDataSource not returning all input parameters
ObjectDataSource method parameters  MCSE braindumps - site profile ASP .NET - forum profile ObjectDataSource method parameters
ObjectDataSource method parameters
Objectdatasource with gridview: delete passes null...  ASPMessageboard.com - site profile Database (ADO/SQL/Access) - forum profile Objectdatasource with gridview: delete passes null parameters
Objectdatasource with gridview: delete passes null parameters
Cached ObjectDataSource avoids the update of their...  MSDN Forums - site profile .NET Base Class Library - forum profile Cached ObjectDataSource avoids the update of their parameters through OnSelecting event
Cached ObjectDataSource avoids the update of their parameters through OnSelecting event
Error: ObjectDataSource 'ObjectDataSource1' could not...  Discussions in microsoft.public.dotnet.framework.aspnet - site profile microsoft.public.dotnet.framework.aspnet - forum profile Error: ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'InsertState' that has parameters: UsState, UsStateAbbreviation, StateId. in microsoft.public.dotnet.framework.aspnet
Error: ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'InsertState' that has parameters: UsState, UsStateAbbreviation, StateId. in microsoft.public.dotnet.framework.aspnet
[General - Error] Help with GridView, ObjectDataSource...  ASP Free Forums - ASP Help, ASP Tutorials, ASP Programming, ASP Code, ASPHosting - site profile .NET Development - forum profile [General - Error] Help with GridView, ObjectDataSource and Delete with 2 Parameters
[General - Error] Help with GridView, ObjectDataSource and Delete with 2 Parameters
Typed Datasets and ObjectDataSource - clever solution to...  Discussions in microsoft.public.dotnet.framework.aspnet - site profile microsoft.public.dotnet.framework.aspnet - forum profile Typed Datasets and ObjectDataSource - clever solution to the scalar parameters problem? in microsoft.public.dotnet.framework.aspnet
Typed Datasets and ObjectDataSource - clever solution to the scalar parameters problem? in microsoft.public.dotnet.framework.aspnet
Thread profile page for "Objectdatasource parameters" on http://www.asp.net. This report page is a snippet summary view from a single thread "Objectdatasource parameters", located on the Message Board at http://www.asp.net. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity