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:
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.
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.
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?
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.
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?
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 ?
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 + "''', "
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?
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.
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" />
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.
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.
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.
