Run A SQL Query With A List Of String Values Using The "WHERE [columnname] IN [values]" Format?

Mar 11, 2011

I have a SQL query I'm running in an ASP.NET page. The final parsed SQL needs to contain a list of string values in the WHERE [columnname] IN [values] format. For example, the final query might look something like this:


However, the string values in the WHERE clause need to be dynamic. Normally I use parametrized queries to make my code convenient and safe, so conceptually I'd like to do something like this:

String[] productCodes = { "ABC", "DEF", "GHI", "JKL" };
cmd.Parameters.Add("@ProductCodes", productCodes);

However, this sort of functionality doesn't appear to exist in .NET. How should I go about implementing this? I could use a foreach loop on the array and run a query with a single value as a parameter for each value, but there could potentially be a hundred or so different values in the array and it seems like querying them separately would be very inefficient.

I've read another question where someone suggested a solution for strongly-typed int parameters, but that method would make me nervous about SQL injection when used with String values, especially since the client may very well be able to influence the input values.

How would you implement this query functionality?

EDIT with DB Details:

The database is SQL Server 2005.

View 5 Replies

Similar Messages:

Query String Parameters With No Values?

Jun 28, 2010

I am trying to set up a page that has two behaviors. I'm seperating them by URL: One behavior is accessed via /some-controller/some-action, the other is via /some-controller/some-action?customize. It doesn't look like the Request.QueryString object contains anything, though, when I visit the second URL...I mean, the keys collection has one element in it, but it's null, not 'customize'. Anyone have any ideas about this or how to enable this. I'd like to avoid manually parsing the query string at all costs :).

View 2 Replies

How To Pass More Than One (multiple) Values In Query String

Mar 26, 2013

how to pass more than one value in query string??

Response.Redirect("wardno180.aspx?ab=" + TextBox3.Text);

i want to pass the value of one more text box in this query string

what changes should i make??

View 1 Replies

How To Pass The Integer Values Using Query String To Other Pages

Feb 8, 2011

i dont understand where is the problem with my code. i need to pass the request_id to another page but it is always passing the integer values as 0. whenever it comes to pass integer values it is passing it as 0 even if i perform conversion of string to int.


View 6 Replies

ADO.NET :: How To Pass String Values To Parametrized Sql Query In Clause

Sep 14, 2010

I'm using parameterized sql query to get data from database

string query = "Select * from employee where employee_city in (@value)";

strign city ="'NewDelhi','Bangalore','Mumbai'";

I'm using following code to achive this


But this is not giving the result. If run the query in SQLServer query window as "Select * from employee where employee_city in ('NewDelhi','Bangalore','Mumbai')", records are there.

But the same query will not return any records from ADO.Net.

View 4 Replies

Return All Values From Table If Query String Is Empty

Jan 1, 2010

I have a page that lists products from a table based on the querystring. So if I say foo.aspx?fam=1 all the products from family 1 will be listed. How can I make my code list all the values if query string is empty? My SQL command would have to be different...can't really see how I can do this.

<asp:SqlDataSource ID="ds_produtos" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalSqlServer2 %>"
SelectCommand="SELECT DISTINCT [IdProduct], [Name], [Description], [IdFamily], [Price], [Stock] FROM [Product] WHERE ([IdFamily] = @IdFamily )">
<asp:QueryStringParameter Name="IdFamily" QueryStringField="fam" Type="Int32" />

View 2 Replies

Web Forms :: Hiding Query String Parameter Values In URL

Aug 7, 2013

Need to hide query string values from web URL, So that no one should be able to recognize what values are passing from one page to another.

View 1 Replies

Web Forms :: How To Send Values In Query String Using Windows.form

May 19, 2010

i am working on a web form. now i am opening a pop up window using Now i want to send the id to that new window. the link button is in my Data list view so that my code is something like this:

<asp:LinkButton id="checkdetsail" runat="server" Text="Show Image >>>" OnClientClick="'Images.aspx?aid=<%# DataBinder.Eval(Container, "DataItem.StoreCode") %>' ,null, 'height=550, top=100, left=200, width=900, status=no, resizable= no, scrollbars=
yes, toolbar= no,location= no, menubar= no')"></asp:LinkButton>

but this is not working. solve my problem.

View 5 Replies

Configuration :: URL Rewrite - Destination Page Not Getting Query String Values?

Oct 14, 2010

I'm trying to implement URL Rewriting into my existing application and have managed to get the page and links working except that my destination page does not get the query string values.Mycde is based on the example below: I have a default.aspx page with links to another page; directory_item.aspx?Item_Id=1&Category_Id=1 directory_item.aspx?Item_Id=2&Category_Id=1 and so on... The code in my web config is as follows;


View 3 Replies

Data Controls :: Append Query String Parameter Values In URL?

May 7, 2015

Append Query String Parameter Values in Current URL.

I have added Hyperlink in data list.which is Bind with their Respective data.When I Click that Hyperlink it Will Pass Url like this.

Area_id,Cuisine_Id and Veg_Id Bind in Datalist


I want to Built a Filter Page Which Includes Area_id, Cuisine_Id and Veg_Idso when i Click to Hyperlink of Area then url like this. [URL] And then After i click to hyperlink of Cuisine then URL Like this.


Similar Way


So Basically I want Filter Data With Clickable query Strings Parameter Values

Problem : How can i Make Url Like this and it is Dynamic


I want to Do Something like this SitePage Filter


View 1 Replies

State Management :: Passing Multiple Array Values Through A Query String?

Feb 16, 2011

I have a query string which contains the value of more than one Array, I want to pass these values from Page 1 to Page 2 and then distribute the array values into new arrays on Page 2.

Here is what I have so far.

Page 1



Page 2


All that I get returned in EFFinal and IFFinal is System.String?

View 5 Replies

DataSource Controls :: Using Values Selected From A "check Box List' In A SQL Select Query?

Jul 5, 2010

I have a table called 'Customer' that contains customer information. One of the fields is named "CustomerType". Each record in the 'Customer' table will contain the value of either "C", "I", or "O".

I have a form that contains a "check box list" named "Type". There are 3 values in the "check box list". The values are "C", "I", and "O". The user can select one or more of these values. I have a button on the form named "btnRunQuery.

When the user clicks on the button "btnRunQuery" I want to exectute a query that selects the records contained in the "Customer" table where the value in the field "CustomerType" equal the values the user selected in the "check box list". Example: If the user selected "C" and "O", then I want the select query to select all records that contain either "C" or "O" in the field "CustomerType".

I assume that what I need to do is to capture the values that the user selected in the "check box list" and put them in a variable. Then I need to format the "Where" statement in the query and add a "Parameters.AddWithValue" command.

View 2 Replies

Web Forms :: Timer Control - Reload Page Every 60 Seconds But Change Url Query String Between 3 Values

Aug 27, 2010

I am trying to get my head around the ASP timer control. What I am trying to achieve is to get a page to reload every 60 seconds but change the url querystring everytime between 3 values

i.e. scroll through

how I have though to do this is to use ASP code to grab the querystring value, and then create the next url. But I am having trouble passing that newly created url to a refresh control. im guessing HTML meta refresh is out of the question as I am using a variable. So from what I can see my option is to use the ASP timer control to count down (after the page has loaded) and after 60seconds load the next url.

View 7 Replies

Forms Data Controls :: E.values Updating Values But Not After Manipulating The String?

Nov 19, 2010

I am using 3.5 listview control. In item_updating event I am using this code...

dim country as string = Dim country As String = e.NewValues("country_name").ToString.Replace(" ", "")

It's updating record correctly. for example if I update USA to USA 1 1 then it's updating like as it. But I want it to be USA11

View 2 Replies

How To Check Box List Values To Be Stored In Binary Values

Aug 24, 2010

I have Check Box list in Asp.Net, contains week days like as (Monday to Sunday)

I want to store the checked values as 1, non checked values as 0, as Binary format.

Say for example: 0000011 (Monday ,Tuesday selected)


View 1 Replies

Forms Data Controls :: Want To Get The Values Of Textbox To A String When Enter Values To The Textbox

Dec 22, 2010

i have added one textbox as a template in my gridview.i want to get the values of textbox to a string when i enter values to the textbox.

View 1 Replies - Provide A String With A List Of Values To An "IN" Statement?

May 23, 2010

I am creating a string that is a list of comma-delimitted values by looping through the selections in a CheckBoxList.I am able to display this value, so I know that it is creating what I expect. I am attempting to pass this list to an IN statment in a SELECT query:


However,I do not understand when this would be converted to an INT. I have tried many different formatting attempts (such as encapsulating the string in parenthesis (e.g. "(4,5)" ) for the SELECT query, but I have yet to find the right one to make this work. It seems like formatting is the problem, but perhaps I am missing something else.

View 3 Replies

C# - Int Values Get Automatically Converted Into Float Values On Binding The Text Values In Gridview?

Jun 29, 2010

I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00

View 1 Replies

Javascript - Split A String That Taking String And Integer Values

Feb 15, 2011

I want to split a string that taking both string and integer values like (Cmp_12). I want to use them in Separately.

View 4 Replies

Select Values From A List, Where The Items Contain In A Different List Aswell?

Feb 5, 2010

Is it possible to select values from a List, where the items contain in a different list aswell?for example;


What I need are all the items from the first list "Items", where the string contains something from the second list "List".So I need something which returns the first 3 items (which contain the term "Item") from the first list.

View 3 Replies

WebMethod Return Values In JSON Format?

Jan 24, 2010

How to return values from Webmethod to the client in JSON format? There are two static int values that i want to return.Do I need to create new object with those 2 properties and return it?The GetStatus() method is called frequently and i don't like the idea of creating a special object each time just for json formatting...

public static int GetStatus()
int statusProcess,statusProcessTotal;
statusProcess=Status.Process; //Static field
statusProcessTotal=Status.ProcessTotal; //Static field
return ...
On client side I catch the return value in :
function OnSucceeded(result, userContext, methodName)
(PageMethods.GetStatus(OnSucceeded, OnFailed);)

View 1 Replies

Web Forms :: Manipulating DateTime Values Format In .NET?

Nov 10, 2010

All the date values on my website (whether from DB or returned by DateTime.Now) are represented in the format of mm/dd/yyyy hh:mm:ss AM/PM, even though the database values of the dates are not that way at all.I want to change the format of all the dates to dd/mm/yyyy hh:mm:ss without AM/PM.

How can I do that?

View 5 Replies

Web Forms :: Format Or Replace Eval Values?

Aug 4, 2010

Within my listview i have certain things that may not have a value returned.. I want to replace the empty fields with a value.

How can i format or replace my <%#Eval("contract_maintenance_period")%> with "N/A"

So if the <%#Eval("contract_maintenance_period")%> is empty, then in its place i want to display "N/A"

i would like to handle this within my aspx code.

View 3 Replies

SQL Server :: Insert Into TableName Default Values in Linq SQL Format?

Oct 19, 2010

I need to write this: INSERT INTO tableName DEFAULT VALUES in Linq SQL format, does it possible?

View 6 Replies

MVC :: Default Values On Query Strings?

Sep 18, 2010

I have alot of query strings on one of my seartch pages. The problem is that even if the corsponding setting is not set by the enduser it will be visible in the URL. Is there a way to avoid this?

In this case the Controller actions take an object of the following class :


Is it possible to avoid setting all the values in the URL when it is the default values that are used?

View 7 Replies

Copyrights 2005-15, All rights reserved