DataSource Controls :: Using Multiple Values In A Parametrized Query?

Aug 13, 2010

SELECT ClientMaster.ClientName,*
FROM ProjectMaster LEFT JOIN ClientMaster
ON
ProjectMaster.ClientCode=ClientMaster.ClientCode
WHERE
ProjectMaster.RefCode IN (@refcode) AND ProjectMaster.ProjectStatus=@status

@refcode should be able to contain multiple values but how should I pass value to the parameterized query?

I have tried many ways such as @refcode = 'VALUE1','VALUE2', @refcode = VALUE1,VALUE2 but to no avail?

View 3 Replies


Similar Messages:

DataSource Controls :: Make Parametrized SqldataSource Query In C#?

Jun 10, 2010

I have a gridview which I connect by C# and SqldataSource. I use asp.net 2.0 - 3.5.

I want to parameterized the queries and how do I do this in the C# file ? how do I set the selectparameters in C# ?. I do not want to do this in the aspx fil.

My code in C# is:

SqlDataSourceMachineName.SelectParameters.Clear();
SqlDataSourceMachineName.SelectCommand = "Select MachineName from tblMachine inner join tblLocation on tblMachine.MachineLocationID = tblLocation.LocationID where tblLocation.LocationName = 'New York' and
tblMachine.StatusID = '1'";

View 9 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

[code]...

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

DataSource Controls :: How To Pass Multiple Values And Execute Query In Stored Procedure

Jun 2, 2010

basically i have two dropdown boxes to filter data and textbox with stored procedure bound to gridview.i want to be able to query data depending on the selected value passed,either using one or more parameter values.

i would like seperate sqlcommands to chose from depending on which controls i select to pass parameters.

i have included a parameter Select(control id) as this is declared by the wizard for stored procedure.

but i am not sure how it is defined on the page and passed to procedure.

[Code]....

View 2 Replies

Databases :: Getting Text Of Parametrized Query?

Apr 9, 2010

I have a the following code to get data from an oracle database using

a parameterized query:

conn = New OracleConnection(connectionstring)
comm = New OracleCommand("select name from Cust_name
from Name_Table Where last_name = :lastname", conn)
parmLastName = New OracleParameter("lastname", OracleDbType.Varchar2)
parmLastName.Value = "Jones"
comm.Parameters.Add(parmLastName)

I am trying to write an audit that will tell me what users are doing, so I would like to get the actual sql that is submitted. This is just one example of the query, there are many more so I would like to make it as general as possible. I would like to actually see "

select name from Cust_name from Name_Table

Where last_name = "Jones". I know I could just create the text

View 2 Replies

Call Oracle Function As Part Of Parametrized Query?

Nov 19, 2010

I have a number of automatically generated data access classes to handle things like inserts & updates. These look like:

cmd.CommandType = CommandType.Text
cmd.CommandText = "UPDATE myTable set f1 = :f1, f2 = :f2, f3 = :f3 where id = :id"
cmd.Parameters.AddWithValue(":f1", _f1)
cmd.Parameters.AddWithValue(":f2", _f2)
cmd.Parameters.AddWithValue(":f3", _f3)
cmd.ExecuteNonQuery()

If I were to re-write the sql to do what I want, it would look something like

cmd.CommandText = "UPDATE myTable set f1 = pkg.getMyValue, f2 = :f2, f3 = :f3 where id = :id"

Is there any way to do this by setting _f1 to a "special" value, without changing the update SQL or the way the parameters are set? Only in certain cases will I need to set the value of f1 - most of the time, it will be null.

Using .net 2.0, and system.data.oracleclient against oracle 11.

View 1 Replies

Forms Data Controls :: How To Use Multiple Selected Values From Listbox In Sql Query

Dec 29, 2010

I want to use multiple selected values from my list box to my sql query as how can i do this

i fill my listbox with following code to use selected multiple values in my sql delete query for deleting selected records

Dim connect, strsql As String

View 2 Replies

DataSource Controls :: SQL Select Statement - Values To Appear In Same Query

Feb 15, 2010

I am having difficulty selecting data from 2 tables that do no share a primary key value. For instance, I have an actual table, a forecast table, and a GLText table. I may have an actual value but not a forecast value but I need them to appear in the same Query (like the query results shown below). I can get all values to appear in each table but have been unsuccessful in getting all values from both tables.

View 5 Replies

DataSource Controls :: Multiple Like Statements In One Select Query

Mar 15, 2010

I need to write a select query where it will be doing "like" on one column with multiple strings.

Eg : Select * from tblCity where city like '%ABC%' and city like '%XYZ%'

I have set of strings.

View 5 Replies

DataSource Controls :: How To Optimize Query With Multiple Inner Joins

Mar 22, 2010

I have one question regarding how to make the below mentioned type of query more optimized so that mine query perfomace can be increased.

Select a.name1,a.address1,b.field3,c.field4,d.field6,e.field7
from a
inner join b on a.id=b.id
inner join c on c.id=b.id
inner join d on d.id=c.id
iner join e on e.id=d.id
union all
Select a1.name1,a1.address1,b1.field3,c.field4,d.field6,e.field7
from a1
inner join b1 on a1.id=b1.id
inner join c on c.id=b1.id
inner join d on d.id=c.id
iner join e on e.id=d.id
union all
Select a2.name1,a2.address1,b2.field3,c.field4,d.field6,e.field7
from a2
inner join b2 on a2.id=b2.id
inner join c on c.id=b2.id
inner join d on d.id=c.id
iner join e on e.id=d.id

All the above three select query at last using the same inner join condition, means last two inner join condition are the same for all the select query.

Is there any way so that this query can be optimized?

View 2 Replies

DataSource Controls :: How To Create A Query With Values From Calendar Control

Jan 18, 2010

What I want to do is create a parameterized query in the code behind with the parameters being values from the calendar control

I'm trying to modify the select command already declared in the sqldatasource so I think it should be something like

SqlDataSource2.SelectCommand = "SELECT * FROM Activities WHERE StartDate>@StartDate AND StartDate<@StartDate2"

but the main problem I am having is how to declare the value of @StartDate, I thought it would be simply calendarID.selecteddate but this doesn't seem to be right, I've tried different variations I've found in similar threads but can't get it right

I'm not sure if grouping my results is complicating matters but when I hard code dates in it works Ok so I don't think so

the code I was trying to get working is

Dim theFilter as String = "WHERE StartDate>@StartDate and StartDate<@StartDate2"
SqlDataSource2.SelectCommand= "SELECT DATENAME(month, StartDate) AS Expr1, YEAR(StartDate) AS Expr2, SUM(CGUPreSchool) AS Expr3, SUM(CGUPrimary) AS Expr4, SUM(CGUSecondary) AS Expr5, SUM(CGUYouth) AS Expr6, SUM(CGUAdult) AS Expr7 FROM Activities WHERE " & theFilter &
" GROUP BY YEAR(StartDate), DATENAME(month, StartDate)"

I am trying to build the filter part dynamically you see but can't get this right

View 3 Replies

DataSource Controls :: Number Of Query Values And Destination Fields Are Not The Same?

Sep 3, 2010

[Code]....

Does anyone have any ideas on this? I have 20 parameters.

View 3 Replies

DataSource Controls :: How To Get Query To Return Values From Xml Column In Table

Jun 24, 2010

I am trying to do a lookup in a table with a value stored in an xml column.

I tried this several ways but I can't get it to work.

Here is some code:

[Code]....

View 1 Replies

DataSource Controls :: Filtering Between 2 Values In A Query From Dropdownlist Select?

Feb 17, 2010

I have dropdownlist of dates and depending on the date that the user selects from list, I would like to filter records that fall between the startyear and finishyear columns in the datasource. (My the problem is that I do not know how to declare the Startyear and Endyear from the query in the code as they appear underlined - probably the BETWEEN syntax is wrong too).

yYear = DropDownList1.Text
Using connection As New SqlConnection("Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=TorGHL;Integrated Security=True")
Dim cmd As String
cmd = "SELECT BarDetails.*, MenuHeadingId AS Expr1 FROM BarDetails WHERE (MenuHeadingId = 2)" & "WHERE " & yYear & " BETWEEN " & "(" &
StartYear & ")" & " AND " & "(" & EndYear & ")"
connection.Open()
Dim dapubcb As New SqlDataAdapterDim sqlcomm
As
New SqlCommand(cmd, connection)
dapubcb.SelectCommand = sqlcomm
Dim dspubcb As New DataSet("BarDetails")
dapubcb.Fill(dspubcb, "BarDetails")

View 4 Replies

DataSource Controls :: Write Select Query To Get Counts In Row Values?

Jun 2, 2010

How to write select query to get counts in row values

View 6 Replies

DataSource Controls :: Repeating A Nested (or Sub) Query For Multiple Categories?

Jul 10, 2010

I'm trying to design a page that displays all suppliers by their location. I'd quite like this to work from a query that will automatically include new locations added in the future.

At the moment my design has a table that holds 'locations' with locationID and locationName fields. In my 'suppliers' table I also have a locationID to join them.

I'm not sure how to query the database to return all the suppliers in location 1, then all in location 2. (Or even sure of the terms I need to Google to get some examples!) For example:

Location 1
Supplier 1
Supplier 2
Location 2
Supplier 3
Supplier 4

View 3 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

DataSource Controls :: Multiple Values Into The Same Table?

Feb 6, 2010

I am creating an online employment application, and instead of creating a table with 20 columns for job duties that may or may not receive values, I simply want to create 3 columns

ApplicantID
EmployerName (Name of Work history Employer)
JobDuty

I want to create a form on a page with 10 textboxes so the applicant can type in some job duties they had at that job.

Is there a way in C# or SQL to then cycle through and insert the textbox values as separate rows?

View 4 Replies

DataSource Controls :: Set Up SQL Table Columns To Have Multiple Values?

Mar 9, 2010

Is it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?

View 6 Replies

DataSource Controls :: Match One Input Parameter With One Of Multiple Values?

Jun 10, 2010

I have 3 tables as follows:

1 - Members containing the following fields:

MemberID int
MemberName

2 - Companies containing the following:

CompanyID int
CompanyName

CompanyType (S=Supplier, R=Retailer, C=Competitor)

3 - Member_Company_Link containing the following:

MemberID int
CompanyID int

The Company table contains any Company with a potential relationship to a "Member". For example:

Companyabc = C (Competitor)
Companyxyz = S (Supplier)

When a new Member record is entered, the user selects from two dropdowns: CompanyType (Supplier, Retailer,Competitor); and CompanyName. The CompanyName dropdown is populated depending on the value selected for CompanyType so if the user selects "Supplier" for CompanyType then only those Companies with a CompanyType of "S" for Supplier will be listed in the CompanyName dropdown.

The use can enter up to 10 CompanyType/CompanyName combinations. When the record is saved, these CompanyType/CompanyName combinations are saved in the Member_Company_Link table. One record for each CompanyType/CompanyName combination is entered in the table.

The problem I'm having is in the retrieval process. I have a "search" screen in which users can select certain criteria to list Members by and one of them is CompanyName. For example they want to see all Member records with "company xyz" as a Supplier and/or "companyabc" as a Competitor. Because each Member can have multiple Supplier and/or Comptitor records I can't figure out how to loop through them to match on the value entered by the user. If Member1 has 5 corresponding records in theMember_Company_Link file and 4 of them contain Companies that are Competitors (Competitor1, Competitor2, Competitor3 and Competitor4) and the search criteria is to find records containing "Competitor3" how can I loop through the values in the Member_Company_Link file for each MemberID to see if there is a match for "Competitor3"?

I know this post is too long and most of you will have ignored it by now but I'm hoping someone will have a clue because I've already spent more than a day trying to figure it out. It seems I have to store multiple values in an array but I have no clue how to do this.

View 5 Replies

DataSource Controls :: Return Multiple Values From Stored Procedure?

Jun 2, 2010

Is it possible to return multiple values from a stored procedure? Basically, if I execute the stored proc on the C# side, then on the SQL side I do multiple calculations. Let's say I have 5 int values I need returned to the C# side.

View 4 Replies

ADO.NET :: Retrieving Multiple Values From A Select Query?

Oct 12, 2010

This code works just fine for me to select * from x,y,z. However what I want to do is retrieve the values return and assign them to variables. How do I go about this?

[Code]....

View 1 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

DataSource Controls :: Writing Multiple Gridview Checkbox Values To Database

Jun 11, 2010

I have a checkbox column in a Gridview that I would like to use to insert the value of one cell in the row into an access database. There will be a maximun of five cells allowed to be selected so there can be one value written to one field in the database up to the maximum of the five fields. The access database has five columns: Selection1 ,Selection2, Selection3 ,Selection4 and Selection5

When the checkbox is checked, the value of one cell (PliD) should be written to each field in the database. Ie: checkbox in row 1 should write PliD value to Selection1, checkbox in row 2 should write PliD value to Selection2, checkbox in row 3 should write PliD value to Selection3 and on depending on which checkbox has been checked. I am not sure how to get the value of the checkbox and write it into the corresponding fields in the database.

[Code]....

View 4 Replies

DataSource Controls :: How To Define Stored Procedure For Values Passed In Using Multiple Controls

Jun 4, 2010

I am using 3 web controls ,two are cascading dropdownlists used to filter gridview control bound to a datasource.

My question is , How to define multiple queries in stored procedure that takes parameter values from the controls declared using sqldatasource.Also, return all data when i set default control value to say 'null'.

NB: one paramaterised query for cascading dropdownlists and another for other control.

View 8 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved