DataSource Controls :: Building Where Statement Dynamically Based On Parameter Value?
Aug 9, 2010
How can i check a parameter value and add onto or remove conditions from my where statement.Here is what i mean.. i have a stored procedure that is being used for returning small set of fields based on a parameter that it is expecting. Since the only difference between the select statements are the last AND condition, i was wondering if i can check that parameter as im doing now but change that AND condition so that i have only 1 select statement instead of 3 within my procedure.Current Example:
if @rptNum = 1
begin
Select * FROM tblName
[code]...
View 2 Replies
Similar Messages:
Mar 25, 2010
I've done some SSIS package work in the past, but am by no means an expert.
I want to use an SSIS package to do the following:
1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.
2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.
and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.
View 6 Replies
Feb 4, 2011
how to add " Addwith parameter" for this Statment. I have this query for search, Whn the user type in " Ac's" with apostrope, i get an error. So i have to use Add with parametr.I fill the gridview with the result.
[Code]....
View 2 Replies
Mar 23, 2010
I have an sp that I would like to us the data from one column to use as a parameter for the following Select Statement
[Code]....
need to set the @customerID parameter = customer_data.CustomerID from the first Select Statement
View 5 Replies
Feb 2, 2010
I need to modify the results (NULL) to reflect '0.00'.
My query statement is giving me an error at the CASE level.
[code]...
View 3 Replies
Aug 11, 2010
I have a requirement whereby I need to be able to change the controller being used based upon a parameter. I am creating an application that needs to be dynamic enough to be able to change controllers on the fly. Let me explain further;
When the application starts a dictionary of custom controller names is loaded with a controller name as the key and a custom controller name as the value. This will be help in the application scope.
When a request is made I need to access the requested controller name, use that name and check to see if it matches a key in my controller dictionary and if so, replace the requested controller name with the custom controller name from the dictionary.
example;
My dictionary will contain data as follows
Key: 'Home', Value: 'Home_IN'
Key: 'Customer', Value: 'Customer_BE'
Now, the following request is made 'User/Edit/1'. Does the controller name exist in the dictionary? No, continue with original request.
Now, the following request is made 'Home/Details/2'. Does the controller name exist in the dictionary? Yes, replace the original controller name 'Home' withe custom controller name 'Home_IN' so changing the requested URL to be 'Home_IN/Details/2'.
Does this make sense?
My problem here is knowing exactly where in the request cycle I need to do this?
I am assuming I need to create my own custom controller factory?
View 7 Replies
Apr 30, 2010
I have a pop up window which contains a listbox. The items on the listbox should be filtered when it is opened based on the other parameters on the parent page. I am using session to pass the values from a page to another.
View 4 Replies
Apr 23, 2010
I need to dynamically creates form with textboxes, dropdown list, required validators from database.Anyone has any idea on the best approach to do this? Can you please show me link to example, tutorial?
View 3 Replies
Jan 25, 2011
Need to build a treeview dynamically from SQL data. I have 2 tables Project and SubProject.
A project can have many sub projects...
I need a display like this....
Project 1
subproject a
subproject b
Project 2
subproject c
subproject d
View 6 Replies
Feb 2, 2010
I want to building a website. I don't know step build a new website. I don't know use DataSet or create new class store connection string connection to DB ?
View 3 Replies
Nov 12, 2010
I have a parameter Owner with 1,2,3 options in dropdown.
On selection of option 1 , a country parameter should be enabled with all countries' values defaulted.
Option 2 should enable Region parameter with all the Regions values selected and country parameter should be displayed.
Option 3 should disable both Region & Country Parameter.
I am using SSRS 2005 with Enesys tool as add on.
View 2 Replies
Jul 1, 2010
I have a CheckBoxList that I need to get the values from, concatenate, and pass into a stored procedure in SQL Server 2005 utilizing Visual Basic. Due to the way our data layer is I cannot use a SqlCommand object at this level.
I have no problem getting to the selected values in the CheckBoxList:
Dim selectedValue As New StringBuilder
For i = 0 To cblMethods.Items.Count -1
If cblMethods.Items(i).Selected Then
selectedValue.Append(cblMethods.Items(i).Text)
End If
Next
The problem is that I do not know how to list the values in such a way that my stored procedure will pull data:
SET @MethodNames ='GetWords','GetLetters'
SELECT * FROM TABLE WHERE method IN ( @MethodNames )
I've tried experimenting with apostraphes but cannot make it work:
selectedValue.Append("'''" + cblMethods.Items(i).Text + "''', "
View 2 Replies
Jan 5, 2010
i have a procedure on my page that returns a number, i need to use that number to build a drop down with that many items.Example:Returned Value: 5
DropDown Values:
1
2
3
4
5
View 5 Replies
Dec 20, 2010
I'm building dropdown search box for a field in a database table. How can I code search all in web form and Stored procedure?
View 4 Replies
Sep 13, 2010
I just read this:
http://www.albahari.com/nutshell/predicatebuilder.aspx
I have a couple questions,
1. is that predicateBuilder the only way to do this?
2. will the following code produce 'AND' or 'OR' connecting these?
foreach (string sParam in sParams)
{
query = query.where(item => item.Whatever == sParam);
}
assume query is an IQueryable<t>. This stucture also dynamically builds the where predicate right?
View 8 Replies
May 20, 2010
I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
View 1 Replies
Oct 27, 2010
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
View 2 Replies
Oct 4, 2010
I have a pretty simple C # page that when the page first loads, a bio is diplayed in that center section based upon sql executed from my code behind. I have 4 link buttons on the page that when clicked, fill that center section with other content based upon which link button they clicked (News, Publications, Contact Info, and Presentations). I was all done, then I thought about using an UpdatePanel to get rid of the annoying "flicker" when the page posts back on the click of the link button.
View 3 Replies
Mar 25, 2010
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
View 3 Replies
Jan 28, 2010
OBJECT_ID(N'AdventureWorks.Person.Address');
what does the "N" mean or do in this statement?
View 4 Replies
Mar 10, 2010
how to do do some action recurting each row? My data looks like
[Column1] [Column2]
item 1 10
item 2 5
I would like to do something like..
foreach row in Column1 <-- how would I do this part??
While (row.Column2 > 0)
BEGIN
.. do something
row.Column2 = row.Column2-1
END
View 3 Replies
Mar 17, 2010
If I run the following SQL script:
[Code]....
View 3 Replies
Feb 24, 2010
I am writing a simple form that will take in data and insert it into a db if it's a new record and update the existing record if it already exists. The insert works fine, but the update isn't working at all, yet the code looks solid to me and everything I've compared it to in my google searches.
[Code]....
View 7 Replies
Apr 24, 2010
I want the select statement for the above scenario.
View 2 Replies
Oct 21, 2010
I am rather confused as how or where to declare this variable in asp.net.
[Code]....
Whenever i put this in my sqldatasource for it is asking me to Define Parameters:
The wizard has detected one or more parameters in your SELECT statement. For each parameter in the Select Statement, choose a source for the parameter's value.
View 4 Replies
