Searching To Use A Textbox Or Dropbox To Specified Column?
Jul 13, 2010
I am having a little trouble in working out the best way in which to query my database. What i am looking to do is to search a using a textbox, the problem is that there is not only one field or one table I want to search for. For instance I have a table of parts that contains the part number, part name, the associated project number, searching for these would be relatively straight forward, I also want to be able to search based on the project name (this is stored in a seperate table) I have thought about using a drop box to allow the user to specify which column they want to search in however this didnt work very well. Ideally i will be able to add more search functions onto this after.
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 few textboxes and I want to search the text (partial search is also required) in the database and then show the result in a telerik grid. The grid has to be hidden initially and when I click the search button it should show up and display the results.
I have to create user control which will have list of languages and contry flag to implement this i have used DropBox control but i could not able to add flag in dropbox control along with langauge name.
I want to make a filtering table. It will be a table where below each column it will have a textbox. I want to, while the person type a word in the filter textbox, the table refresh, displaying only the items (rows) with that word. I think AJAX is a good idea. Just put the table and the textbox in a UpdatePanel, and then write a code to refresh the table on textbox_changetext event. The problem is that you have to take the cursor out of textbox to have the event fired, and I want the table update while text typing.
I made a thread about getting all values of checkbox in my database, fortunately it was an easy task. I have 12 list items and the last item is "Others, specify:", wherein there would be a textbox near it for input. Obviously, it will be use to make additional data that is not included in the list.
Here's it is:
[Code]....
I made my server side code to concatenate multiples values that will be sent into my database from the user's checked items. Here it is:
[Code]....
My question is, how could I concatenate the inputted values that would be made by user on the textbox to the checkbox column on my database. I'm thinking like this:
[Code]....
Now if this is a decent method, then I would like to ask how could I set a parameter on otherattainment.Text without making a new column for it in my database. Obviously to avoid SQL Injection.
EDIT:
I just put cmd.Parameters.Add("@Others", SqlDbType.NVarChar).Value = otherattainment.Text; above, I believe this setting of parameters is only applicable if only the element will be included in the SQLCommand query and or in the database. Do you think that it has been set to parameters by adding this?
I have a TextBox bound to a decimal column and want to drop any zeros to right of decimal point. So 8.0000 shows as 8 and 7.6000 shows as 7.6.Currently the Text property is #Bind("Units", "{0:n2}")
I have created a form that populates a Gridview with 7 coloumns via 3 DDL's. This is working as intended. I however need to implement Writeback to two coloums on the table while keeping 5 of them read only.
Below is the codebehind
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data;
I need a textbox for each column of the header row of my Gridview. Then whatever I type in, say the first column is a Surname, the Gridview needs to be filtered by records with only that Surname.
I'm trying to populate a date from a bound text field in a DetailsView. I keep getting a error when a DBNull is in the column. How do I avoid the DBNull when populating the text field.My code is as follows:
Means if i have two columns in database namely name & email
i wanna search the users or email by entering either name or email on textbox then after clicking the search button record will be displayed in gridview ?
I have the following gridView and I would like to add a 'free format textBox' to 3 of the column headers, to allow filtering. Much like here If I could/somehow achieve this that would be amazing. I can't use dropDown lists like many of the examples I have found as these lists would be too populated and proving too unfriendly to use.
If i have two textboxes textbox1 & textbox2 and button1 in my ASP.NET and SQL Server database
Database records are:
ID Date Seats 1 15-Dec-2010 1,2 2 15-Dec-2010 3,4 3 17-Dec-2010 1,2,3,4
I want when i type 15-Dec-2010 in TextBox1 and Click on Button1 then in textbox2 The Output would be retrieve from Database using SELECT query then in TextBox2 the output would be displayed as 1,2,3,4
That the exact i want using SELECT query and VB.NET.
How should i insert null values into a database. I have textbox1 and the textbox2 will convert the value out of textbox1, when i the time i click save and the textbox1 is empty i got an error, "Conversion from string "" to type 'Date' is not valid." i just want to insert null value if the textbox is empty.
I wrote a console app that displays information from a local file on my desktop and displays the content within the file. I was wondering how can I create a function that can search for keywords and only display the words, I want it to search for?I'm trying to display this content in a database and search for the content I want it to display.
* ZIP Codes * Area Codes * City Name * State Name * Two digit State Code * City Type * City Alias Abbrev. * County Name * State FIPS * County FIPS * Time Zone * Daylight Savings Indicator * Number of Businesses * Q1 Payroll * Annual Payroll * Number of Employees * Employment Flag * County Growth Rate
I tried something like this - And it didn't work.
Csharp Code: var keywords = new string[] {"some", "keywords"}; var foundKeywords = File.ReadAllLines("filename"). SelectMany(line => keywords.Where(keyword => line.Contains(keyword))). Distinct();
I have a web application running on ASP.NET 3.5 which basically stores, retrieves, and allows users to manipulate data from a SQL Server 2005 database. One of the features allows users to search through the records in the database. When the system was first launched last year, there were no records, so searches were lightning fast. However, over the past year, about 100,000 records have been entered, so most searches now take over 15 seconds to perform. I'd like to speed up searches, but there are problems with both of the conventional approaches I can think of:
Caching - The database does all the heavy lifting in this application - the ASP.NET web application is little more than a UI that passes user input to the correct stored procedure, and displays the returned output. The stored procedures are responsible for interpreting user input, applying the business rules, and transforming the underlying tables and views into a context-sensitive result set which the application just displays as is. Unless if there's a way to apply a stored procedure to a C# object/collection (the cached records), and get another C# object/collection back, effectively bypassing the database, I don't think this will work.Stored procedure optimization - There's some optimization potential here, but even a simple SELECT * FROM TheView statement on the underlying view currently takes 11 seconds according to SSMS, and I expect that the amount of time taken will continue to increase as more records are entered.Are there are techniques out there that I'm not aware of, which could be used to bring searching down to a reasonable amount of time (5 seconds or less per search)?
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?
