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:

DataSource Controls :: Using A Variable As A Parameter In A SQL Statement

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

DataSource Controls :: Add With Parameter For Like Statement To Fill Gridview?

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

DataSource Controls :: How To Declare A Parameter Value From One Select Statement To Another In Stored Procedure

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

DataSource Controls :: Case Statement Assign Values Based On Condition?

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

MVC :: Dynamically Change The Controller During A Request Based Upon A Parameter?

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

Web Forms :: Dynamically Filter The Parameter's Values On A Popup Window Based On Other Parameters Selection

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

Web Forms :: Dynamically Building Controls?

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

Forms Data Controls :: Building A Treeview Dynamically From SQL?

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

DataSource Controls :: Building A Website By C#?

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

SQL Reporting :: Parameter Enabling Based On Selection In Another Parameter?

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

DataSource Controls :: Building String To Pass Into StoredProcedure From CheckBoxList?

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

Web Forms :: Building Dropdown Listitems Based On Single Value?

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

DataSource Controls :: Building Dropdown Search Box For A Field In A Database Table?

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

ADO.NET :: Dynamically Building A Linq To Sql Where Predicate

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

DataSource Controls :: Variable Connection String Parameter In A DataSource Control

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="<%&#36; ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%&#36; 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

DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value

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

AJAX :: Dynamically Building Linkbuttons To Update A Panel Through PostBackURL's?

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

DataSource Controls :: Passing Parameter To Datasource In Code Behind?

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

DataSource Controls :: Meaning Of N In Statement?

Jan 28, 2010

OBJECT_ID(N'AdventureWorks.Person.Address');

what does the "N" mean or do in this statement?

View 4 Replies

DataSource Controls :: Foreach Like Statement In T-SQL?

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

DataSource Controls :: Select Top Record From Sql Statement

Mar 17, 2010

If I run the following SQL script:

[Code]....

View 3 Replies

DataSource Controls :: SQL UPDATE Statement Not Updating DB?

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

DataSource Controls :: How To Select Statement For Some Scenario

Apr 24, 2010

I want the select statement for the above scenario.

View 2 Replies

DataSource Controls :: How To Declare Variable From SQL Statement

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







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