DataSource Controls :: Searching Table With Multiple Criteria?
Apr 15, 2010
I want to select data from a table where the user can search by 3 options; date, keyword, and type. The date will always be either today or a user chosen date. The keyword can be null or something the user inputs. The type will be chosen from a drop down and can be all or a specific category. I know how to search the date, but the other two create complications. I have created a stored procedure trying to figure this out:
[Code]....
Is there a way to say if the keyword is null then don't use it as a search criteria. If that is possible then type can use that same logic I suppose.
I have an application that populates a gridview based on criteria in a table. I have another table that holds data to be omitted. I will post the current LINQ code and also the end result SQL code that I need to figure out in LINQ. Below is my code:
Current LINQ Code: Dim TestType = (From test In db.Table _ Where test.TypeId = TypeID _ Select test.Id, test.Title)
First off I'm a week into asp so apologies in advance for silly questions! I am looking to connect to a SQL database table and allow the user to filter the table based on a search box on the asp page. I have written a sql query with a parameter in the where clause, a bit like this:
select col1, col2 from table where col1 like @my_parameter
Then I pointed the parameter to a textbox on my asp page, and this seems to work quite well. However, I would now like to add an additional search facility which would be a dropdown list. This would be sourcing all the unique values from the col2 in my table abve (there are only about 10 possible values here). But I don't want users to be able to use both of these searches at the same time.
So the bottom line is I would like to offer two methods of filtering the same data table, which search on different columns of the data table. Then the results should populate the same results table, but the user must only be able to use one search method or the other.
I have done a bit of research but couldn't find anything along these lines (I think it is becuase I don't know the words of the things I should be searching for!). I did find information on a standard postback event or cross page posting - not sure which of these (if any) is the best to use for a beginner?
I want to query an SQL table using some Web controls to provide the parameters for filtering the records in the table. Results are displayed in a GridView.
I have a TextBox with an ID of "keyword" where the user may enter one or more keywords. I'd like to search 2 columns for instances of these keywords.
I also have a DropDownList named "category" that lists categories contained in a "category" column of the table.
I have a dataset with a TableAdapter for the table I want to search. Got it working fine with the DropDown List but not sure how to proceed with the TextBox and keywords.
What SQL query should I use? The user may not enter anything into the textbox, they may enter one word, or multiple words.
This is where I am now:
SELECT * FROM tablename WHERE category = @category AND ??
I'll try to specify my problem as simple as possible! I have a problem comunicating between 2 pages; Products.aspx and ProductDetail.aspx. On Products.aspx i have about 15 DDL's on the left side (all set to autopostback), and 1 ListView ond the right side. Results in my ListView control are based on selcted items from DLL's on the left. Every single result in Products.aspx has a dynamical hyperlink to the ProductDetail.aspx. Now when I click on specific product in ListView I'm redirected to ProductDetail.aspx page, and everything works fine! If I click on the Back button in IE or FF it works also fine because it returns me to the previous Products.aspx page and all my results based on selected items in DDL's are still there!
The problem comes when causing some more autopostback's in ProductDetail.aspx page, because every autopostback is counted as a new page request and therefore i have to click Back button in IE or FF for more then 1 time to come back to the previous Products.aspx page.
I tried to implement code BELOW in ProductDetail.aspx.vb but it does not completly fulfill my expectations, becase all my searching criteria are lost when returned to the previous page (Products.aspx)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then ViewState("ReferrerUrl") = Request.UrlReferrer.ToString End If End Sub Protected Sub BACK_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BACK.Click Response.Redirect(ViewState("ReferrerUrl").ToString) End Sub
Does anybody knows any other solution how to come Back to previous page with only ONE CLICK without loosing searching criteria?
search form!Have no idea how to do it.Hope the example says much about how it should operate!Profile search where the result will come out in a list view.theusers should be able to filter between firstname, lastname, age, gender.right now I have this!Search page
The gist of the problem is that we have an alumni table (one record per person) and also a couple of other tables (one to many) that have degree info and interest info. In a search screen in our app you can search for criteria that spans all three tables (there are actually more fields and tables than shown in the example below but I am trying to keep it simple).
The code below works (properly returns people without degrees for example) but still feels a little clunky or over-engineered to me. Are there easier ways to do this? NOTE: I have been through quite a few iterations/approaches to making the correct data be returned.
I have a form that searches for images in a database. I have several DropDownLists with various search criteria e.g. Genus, Photographer, State, Project.I'd like the user to be able to filter using any combination of these. For example they might pick a specific photographer and a specific genus but choose not filter by project or state.I'd like to find a good, clean, elegent way to do this.Here is an example of the code I have now, it has only two possible criteria. It works but I have a feeling there are better ways to do this....
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?
I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.
I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.
[code]...
How can I get results from searching only one textbox?
An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.
Here I am using ASP.NET using C# and my backend in active directory.
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?
I know I'm missing something here but I can't figure out what it is. I've got a query joining three tables....accounts, payments, and a table linking the two (there is a M:M relationship).I'm trying to pull a list of all accounts in the account table that have a payment that needs to be resequenced, and also the maximum payment priority if there are any payments that haven't been fully paid. If all payments HAVE been fully paid, I want to return a 0.
It's that last bit of logic that I can't get right. If I include that in the where clause, I get only the accounts that have a payment that hasn't been fully paid. If I take it out, I get all the accounts I get, but I get the highest payment priority whether or not the payment has been fully met.
Here is the query....how do I include the where clause criteria but still include all accounts?
In general, If multiple users thru an application try to update the same tables in database simultaneously, then by default on what basis the priority will be given.Like if we don't have any extra logic for the locking implemented.
I'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:
I have read up on uploading multiple images and storing them to a file but so far i am only able to store one image into both file and into database. The problem i have is that i don't know how to create the table to store more than one image?
I've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
I have Tables customer (Customerid),Product(Productid),Order(orderid). i have created view Customerid,Productid,orderid . is it posssible that if i insert value in view it will get inserted in table itself. can i do it in MS SQL SERVER
I have two pages, the first is datepicker.aspx and it contains a textbox where I enter in a date in YYYY-MM-DD format and a button that performs a postback to results.aspx. Results.aspx has a gridview where I'd like to see records from the journal table in my SQL database that have the date I entered back in datepicker.aspx only the gridview never produces results.I'm using the following query in the datasource, if I test it in the datasource wizard it works and it also works when I run it directly against the database.
SELECT * FROM QM.Journal WHERE ([DateEntered] = @SelectedDate)
The @SelectedDate is setup as a FORM parameter in my datasource. Is there anything in particular that I need to do to the results.aspx page so that it grabs the date I put into my datepicker.aspx textbox?
I have a table that contain special characters and when the user search for nguyen I want to return string that contain Nguyá»…n or nguyen or any other nguyen variations.
I have absolutely no idea where to start and will be greateful if someone know any article that explain how I can do this.
I have been google some but I can´t find any solution that have been worked for me. I do use System.Net.mail on my site to send emails to individual employes. Now I would like to be able to email all emplyees. The emplyees email address is stored in a MS SQL table. Is it possible to make a BCC email to all employees in that table?
I want to make data-driven page and ability to filter data on some parameters, for example 3 text boxes and 2 dropdown lists and then show the results by the grid view control.
Actually I like input data in the text boxes and select item from dropdown list and then press "OK" Button and result (filtered data) show in the new page by the grid view.
What I have seen in the quick start tutorial is filtering by one parameter.
I've requirement where user can enter multiple columns like first name, lastname, email, age, sex fields and insert them into database.on my frontend aspx page, i'll be showing a single row initially with 5 text boxes(first name, lastname, email, age, sex) and a button to add more columns. when user clicks on add more, another 5 textboxes will be shown and then i'll be taking 5 + 5 (textbox values) and comma seperate them and need to insert into a table with primary auto increment key ID and the remaining 5 columns(firstname, lastname, email, age, sex). I previously worked on the same requirmeent but with only single column. Now i need to insert for 5 columns, How can i do this? Below is my stored proc which i used for single column insertion.