.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SqlDataSource WHERE Parameters - QueryString and Default value not working correctly?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net
 

This is really easy, but I can't seem to get this working correctly...

 

When using SqlDataSource and press on Configure Data Source, I have selected my data source.

I have selected * all records and pressed the WHERE button  (so it starts to bulld a query).

 

 

I have set the following values:

 

Column: NewOrUsed (only contains 1 of 2 values, either "New" or "Used")

Operator: =

Source: QueryString

QueryString Field: (Eval("NewOrUsed").ToString)

Default Value: New

 

 

However it doesn't seem to work, always returns no records even though I know there are a number of records matching "New"

 

 

What am I doing wrong?




View Complete Post


More Related Resource Links

SqlDataSource and Parameters query

  

Hi everyone,

I'm on the edge wondering is it possible ? I have got 2 questions. Please help me out.

1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like

SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.

Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).

2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query

(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).

If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.  I am stucked and desparately looking for help. Thanks all.


Is there any way to set a default value to queryString on pageload?

  

I'm using Response.Redirect for empty QueryString.

   string var1 = "1";
            string var2 = "default.aspx?Page=" + var1;
            Response.Redirect(var2);


I'm not sure if this is the best way to do this. Thanks in advance for any help:)


Replication stored procedures not being passed parameters- default appears instead

  
Hi I am setting up transactional replication from Oracle to SQL Server, it is working fine for 9 tables, but for one it fails on updating and deleting with a message like this: Procedure or function 'spu_VGSM_SUBMISSION_CONTACT' expects parameter '@pkc1', which was not supplied. This is correct, in that the sp should be being passed this parameter, but when I do a trace it will show something like: exec "spd_VGSM_SUBMISSION_CONTACT" '12-3456-10','BLOGGS','S', '2010-07-01 12:43:43', 'M123456' default In other words, the old primary key values which should be being passed in are being replaced with "default". I am using the CALL syntax for the update sp. If anyone can suggest why this is I would be very grateful. This is the publication: exec sp_addpublication @publication = N'_Submission_Contact', @description = N'Transactional publication from Oracle Publisher.', @sync_method = N'concurrent_c', @retention = 0, @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'false', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true', @immediate_sync = N'

Trying to get basic Http URL with querystring parameters processed in WCF service

  
I'm trying to process a post by a third party server (Paypal) processed by my server through a WCF service. All I need is to get and process the values with the query string. This sounds incredibly easy, but after a weekend, I'm still stumped.  Any help would be greatly appreciated. Passing the following URL from my browser to the service causes a AddressFilter mismatch fault (below). http://localhost:9409/PPInfo.svc/ReadResponse?RESULT=0&AUTHCODE=10001&RESPMSG=APROVED&PNREF=12345 produces <Fault xmlns="http://schemas.microsoft.com/ws/2005/05/envelope/none"> - <Code>   <Value>Sender</Value> - <Subcode>   <Value xmlns:a="http://schemas.microsoft.com/ws/2005/05/addressing/none">a:DestinationUnreachable</Value>   </Subcode>   </Code> - <Reason>   <Text xml:lang="en-US">The message with To 'http://localhost:9409/PPInfo.svc/ReadResponse?RESULT=0&AUTHCODE=10001&RESPMSG=APROVED&PNREF=12345' cannot be processed at the receiver, due to an AddressFilter mismatch at the EndpointDispatcher. Check that the sender and receiver's EndpointAddresses agree.</Text>   </Reason>   </Fault> // web.config  <system.serviceModel>     <behaviors>       <servic

Mapping SqlDataSource Parameters to Formview with Multiple DataKeys

  
Hi I have:a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2Thus representing a simple "1 to many" or "parent/child" relationship in the database!SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there). SqlDataSource2 has parameters that  filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.HOWEVER - THE PROBLEM ARISES...The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.Any ideas how to do this?I've tried setting the SqlDataSource2 parameters to:<SelectParameters>   <asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />   <asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />   <asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataK

Mapping SqlDataSource Parameters to Formview with multiple DataKeys

  
Hi I have:a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2Thus representing a simple "1 to many" or "parent/child" relationship in the database!SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there). SqlDataSource2 has parameters that  filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.HOWEVER - THE PROBLEM ARISES...The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.Any ideas how to do this?I've tried setting the SqlDataSource2 parameters to:<SelectParameters>   <asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />   <asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />   <asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataK

SqlDataSource ControlParameter textBox:Not Working

  
I have a stored procedure that returns 3 searches1) ALL records2) Records staring with something3) Records containing somethingThe stored Proc works finehere is the proc header:CREATE PROCEDURE [dbo].[procGetOHLCSymbolReferenceQuick](@SearchContains VARCHAR(20)='X1234',@SearchStartsWith VARCHAR(20)='X1234')THE ISSUEI have a gridview on a user control, with two texboxes. The gridview is supplied by a SQLDataSource. The textboxes provide that Users Filter demands. The TEXT BOXES<asp:TextBox ID="txtNameStartsWith" runat="server" Width="75px" TextMode="SingleLine"  BackColor="#FFF6CD" /><ajaxtoolkit:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" runat="server" TargetControlID="txtNameStartsWith" FilterType="LowercaseLetters,UppercaseLetters,Numbers,Custom"  ValidChars=" @$.^!" /><asp:TextBox ID="txtNameContains" runat="server" Width="75px" TextMode="SingleLine"  BackColor="#FFF6CD" /><ajaxtoolkit:FilteredTextBoxExtender ID="FilteredTextBoxExtender2" runat="server" TargetControlID="txtNameContains" FilterType="LowercaseLetters,UppercaseLetters,Numbers,Custom"  ValidChars=" @$.^!" />THE SQLPARAMETERS<SelectParameters&g

ReportViewer Print Button not working correctly with windows 7 clients

  
I need some help being pointed in the right direction to fix the following issue: - After building several reports using reportviewer and testing with windows XP clients everything seemed to be fine.  I noticed that the first time the client loaded the asp.net website and clicked the print button it asked permission to install a small file (I assume this is to allow the reportviewer to access the clients printers).   - The problem I have is on Windows 7 Clients.  They can view/export the reports with no problem, but when they click the print button it ask permission to install the small file, but a error is given during the install process and the file is not installed.   If anyone has a solution or can point me in the right direction it would be helpfull.  I am using Visual Studios 2008 on Windows XP PRO and the site is hosted on Windows Server 2003 R3   Thanks 

How to add WebMatrix default parameters?

  
That subject may not do this questions justice.I am trying to limit what I write on all my .cshtml pages.For example, on everypage I am @using myDLL and "connecting" to sql server.I write that out like @using System.myDLL; @{ myDLL dll = new myDLL(); dll.ConnectionString = "blablabla"; } How can I remove the need to do that to every single page? I think I can create a web.config and do some funky stuff... can someone show examples?

SqlDataSource with a lot of parameters

  
Hi everyone,I have asked similiar question before where I have two control on the page header says "username" and "gender". User can select both the control or either one and the page will execute searching based on the criteria supplied. So if username suppliedSELECT * FROM [this_table] WHERE username = @username and if gender suppliedSELECT * FROM [this_table] WHERE gender = @gender and if both supplied SELECT * FROM [this_table] WHERE username = @username AND gender = @genderI know this sounds not very complicated but in my case, I am having like more than 10 controls up there. It is something like username, gender, age, date of brith, title, father name, frst name, last name, blur blur blur and it's a lot then I started to lost. if i were to use if else caluse on code-behind and produce query, it would end up writing a lot of if-else and if i use stored procedure (with if-else) then my stored procedure would contains a lot of if-else statement. I am fairly new to this concept and if I'm on the wrong track, please correct me. Is there any better way to save my hair without actually going through each if-else statement to build the query ? Thanks all.p.s. I'm using GridView and SqlDataSource command to display the result back on .aspx page.

SqlDataSource : in what order do parameters get fed to stored proc?

  
Hello, I'm wondering if someone can explain how a SqlDataSource determines the order in which parameters are fed to a stored procedure. I'm not able to find clear documentation.So suppose a proc has: CREATE PROCEDURE  updateOneCar@CarActiveFlagCheck int, @CommentsForCar varchar(1500) = NULL, @manufacturerID int...and then suppose the ASP.NET page has the manufacturerID supplied by a querystring, and has a FormView as follows: <asp:FormView ID="FormView1" runat="server" DataSourceID="SQL01"          DataKeyNames="manufacturerID" EditRowStyle-Wrap="False" RenderOuterTable="False">         <EditItemTemplate>         <div>             manufacturerID: <%# Eval("manufacturerID")%>             <br />             Is my Car on?: <%# Eval("carFlag")%>             <br />             Is my car Active Flag:             <asp:CheckBox ID="CarActiveFlagCheckBox" runat="server"              

Incomming Email Not Working Correctly in SharePoint 2010

  
Hello everyone, We recently upgraded from SharePoint 2007 to 2010. Prior to the upgrade I had two SharePoint Document libraries setup to receive incoming emails. We had two reports scheduled in Reporting Services and each report emailed a document library once a week. After the upgrade this stopped working. The reason this stopped working was because the file names of the attachments were the same each week, however in 2007, sharepoint would append a random 4 digits to the end of the file name. Was the removed from 2010 on purpose? After discovering this didn't work, I decided to create a workflow on these lists that anytime and item is added go change the file name to include the list ID to ensure that the file names will be unique. Only to find out that items added to the list from the incomming emails do not trigger the workflow. Doing some research on this and it looks like it was turned into Mircosoft as a bug in 2007 which had a fix, but the fix is only for 2007 is doesn't say it applies to SharePoint 2010 so I don't want to install it. Anyone know if there is a fix for this in SharePoint 2010? Thanks in advance, Matt

Return QueryString id to a FB tag not working

  
Here's my FB tag Asp.net<fb:like href="https://www.mysite.com/alumni/eventDetails.aspx?dateID=<%# getID() %>" width="200"> </fb:like> JavaScript:<script> window.fbAsyncInit = function () { FB.init({ appId: 'your app id', status: true, cookie: true, xfbml: true }); }; (function () { var e = document.createElement('script'); e.async = true; e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js'; document.getElementById('fb-root').appendChild(e); } ()); </script> And here's the getID() code behind:protected string getID() { string strID = Request.QueryString["dateID"].ToString(); return strID; } For some reason, I did not get an ID in the Facebook like link.

What service is responsible for Calendar Overlay working correctly?

  
I'm having 2 issues with my SharePoint server.  User Profile Sync stuck on starting and Calendar Overlay not working. I created a calendar overlay a month ago, containing 7 other calendars and it works fine.  It currently still works if I add items to one of the 7 calendars, those items show up on the calendar with the overaly. But if I try and create a new calendar and add overlay to it - containing different calendars, nothing appears.   No calendar items from the overlay calendars that I've added. This has only started happening since my User Profile Sync stopped working - are the two related, somehow? I get no errors at all - just a blank calendar!  Frustrating!! Thanks for any help.  

EventSetter not working correctly?

  
I have a resource dictionary with a bunch of styles in it, here is a portion of the dictionary: <ResourceDictionary x:Class="CustomWindowStyle.WhelenWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:local="clr-namespace:CustomWindowStyle"> <Style x:Key="TestWindowStyle" TargetType="{x:Type Window}"> <EventSetter Event="LayoutUpdated" Handler="TestWindow_LayoutUpdatedEvent"/> <Setter Property="AllowsTransparency" Value="true" /> <Setter Property="WindowStyle" Value="None" /> <Setter Property="Background" Value="Transparent" /> <Setter Property="ResizeMode" Value="CanResizeWithGrip" /> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type Window}"> <Grid> <Border Style="{StaticResource MainBorder}" Width="Auto" Height="Auto"> <DockPanel HorizontalAlignment="Stretch" Background="Transparent" VerticalAlignment="Stretch"> <local:TitleBa

InfoPath 2010 Not Allowing Default Parameters Anymore?

  
It appears that InfoPath 2010 no longer allows you to set the default parameter values for secondary WebService data sources before they are automatically called during the form startup. When you set up a secondary data source to a standard web service call that takes parameters, you get prompted for the sample values.  However, when you run the form, these sample values are not sent to the web service, as you would expect. Furthermore, because the secondary datasource is automatically called when the form starts up, you are not able to set the values before the automatic call because the rules processing occurs AFTER the initial call to the web service. I realize that I could do this in code in the Startup routine, but the problem is that we have users who want to stay away from coding and want to use the functionality of InfoPath and it's "easy to use interface" to be able to create forms.   Now I have to tell them that they need to start to learn C#? Am I doing something wrong here?    Or is this a big oversight on this release of InfoPath? Microsoft: If you are listening...could you please comment on this?   I would consider this a bug.

Why Search Option is not working correctly in the People Search Box?

  

I have SharePoint Server 2010 Enterprise based intra.
I have added People search box.

Why I click the Search Options, it opens the fields top of the webpart below the search box.
So basically 2 webpart looks like they are top of each others.


Kenny_I
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend