DataSource Controls :: Search Various Database Columns Based On User's Input?
Nov 18, 2010
I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.
I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.
What's the best way to do a search?
I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches
[Code]....
for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches
[Code]....
for three textboxes, there are 8 combinations,
Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?
View 1 Replies
Similar Messages:
Jan 24, 2011
What i am trying to achieve is that there are 7 columns in my db table. one is primary key and rest 6 are integer columns. Now my application will allow user to input 6 values. I want to compare 6 values entered by user to those 6 integer columns and if in any row 3 or more columns match user's input Primary key of that table is returned..
I have tried using queries, cursor, nested loops and i am still unable to achieve my results..
DB Table Structure.. I am inputting 2,3,7,11,45,65. Number of returned rows should be 5. eg..
UID A1 A2 A3 A4 A5 A6
-----------------------
1 2 3 4 5 6 7
2 2 3 4 55 56 57
3 65 11 45 66 67 68
4 45 7 11 99 98 97
5 7 7 7 7 7 7
6 7 7 7 7 7 7
7 8 8 8 8 8 8
8 8 8 8 8 8 8
9 45 45 0 3 1 2
10 65 7 4 0 0 0
IDs returned should be 1,3,4,9,10
View 6 Replies
Jan 12, 2011
I have two text boxes for the user to enter UserName & First Name, both these fields are optional and not mandatory to fill.
once the user presses the Search button, i execute the following query to fetch matching records.
[Code]....
The problem is, in cases where User leaves both the textbox or one of the textbox empty/blank, in that case that particular field should be removed from where clause.
More like if something is entered then search for that particular record otherwise search for all the records.
View 2 Replies
Jan 25, 2010
I have successfully created a strongly typed dataset. And trying to assign my user input values to the columns of my StronglyTypedDataset but having no luck with it
[Code]....
In the above code 'PlantInventoryAccuracy' is the name of the Strongly Typed Dataset and 'PlantInventoryAccuracyDataTable' is the dataTable. when I try o debug this to see if my user input values are being assigned to te currentRow I see blue squuiggly line under the 'new' key word when I mouse hover it says
'The type PlantInventoryAccuracy.PlantInventoryAccuracyRow has no constructors defined.'
This is the first time I am trying to use Storngly typed datasets. I am not sure if I am trying to use it right. The above code is in my code behind page and my idea is to fill this row with the user input values then pass this to my data layer where I need to assign these values as the parameters to the stored procedure I have created and then store them to the database.
View 3 Replies
Jun 9, 2010
I need to have search form in my web app . I want visitor input text in textbox control and when he click on Search button it check DB table for his input text.
I dould like if user input "Windows 7" and I have the sentence in DB Records as "My be Some Windows Generation .." it list this record.
in other word I want to search for any word that users entered in DB.
Could any one tell me efficient way instead of split input text to words and then execute search query per word?
View 3 Replies
May 27, 2010
how can i generate rtf file based on input field(textbox input by user) c#
View 3 Replies
Jan 25, 2010
i have 3 columns in database table. like below
StreetCode Address State
my Input is = 221 Hyd tg GA
StreetCode = 221
Address = Hyd tg or Hyd --> like that
State = GA
i need to search my database table with 3 columns matched records above string.
the input is not coming separately it is mixed of one string with space of string.
but see Address is = Hyd tg is one string how to seach 3 column values in one string input.
View 4 Replies
Jan 16, 2010
I Have a table containing columns Address1,Address2,Address3,State,City and Area.Now i want to apply search Location where there will be a single textbox where the user can enter multiple strings seperated by spaces and then those rows should be fetched which contains all these strings entered by the user (implementing AND Case). For which the search on rows should be applied by merging the data of all the above mentioned columns and then searched.How to implement the above case?
View 12 Replies
Apr 21, 2010
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 Replies
Apr 20, 2010
could u tell me add controls to a page base on user inputs,
i know the basic of creating a button dynamically but here I have to to add few controls based on user input and how to identify event for each dynamically create control.
View 2 Replies
Dec 8, 2012
I want to search record based on  Name, ID, Date, Report Type. from same table with one textbox. I can do search with one column how can do it with multiple column ...
protected void Button2_Click(object sender, EventArgs e)
{
DateTime dt = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type ");
cmd.Connection = con;
[Code] .....
View 1 Replies
Jan 24, 2016
I want to know that how to render partial view based on where the user navigates. I mean to say if user navigates to Home/index it will load different partial view and if user navigates to Home/contact it will load different partial view on the _layout page.Â
View 1 Replies
Jan 12, 2011
I am having with the a full text index I am developing for a product catalog. It does all work to a degree I am just seeing some strange things happening.
From the database side I have a Products table that is being indexed on both the PartNumber and Description columns because I would like the users to be able to search either or using the search function.
Problem 1:
whenever I use multiple words in the search I don't always get the results I am looking for, this happens most notably when I am attempting to say put in a full part number (which for in this case would look like "I 10-9.2")
Problem 2:
I am not 100% sure that this is the most efficient way of completing what I am attempting to accomplish here since I have 2 columns that I need to perform the search on
Here is an excerpt from the click even when the user clicks the search button on the page:
[Code]....
And here is the search functions called from the click event to firstly check if there are any results and the second to display the results in a custom gridview:
[Code]....
View 1 Replies
Oct 13, 2010
I am familiar with creating and persisting dynamic controls on the first load of a page and on subsequent postbacks but I am having trouble with the following user initiated scenario...
In my demo I have a placeholder, two buttons and a literal
[code]....
View 1 Replies
Dec 27, 2012
I have one table in sql server called student_info
In this table keys kills column contain value like below
'c,c++c#'
'c++,c,c#'
'c,c++,c#,asp.net'
etc...
I want to search the student information based on keyskills like naukri
1.Any keyskills from textbox1
2.All keyskills from textbox2
3.Except keyskills from textbox3
When I enter c,c++ or c++,c in textbox1 then it will dispaly all the student whose have c,c++ keyskill
How to achieve this.
View 1 Replies
Nov 8, 2010
I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.
View 4 Replies
Jan 22, 2010
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
View 4 Replies
Jan 18, 2010
now have tried to locate and find anything about how to make a
TEXTBOX and A Button "Search"
Problem is that I have made this "bellow" and when I then enter a "value" into texbox2 and hit enter on the button it wont show me the "emnenummer" that I have requested.
im not even sure this is the correct way to do a "search"
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><asp:Button ID="Button1"
runat="server" Text="Button" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"[code]....
View 3 Replies
Sep 8, 2010
i have a textbox with button search.
i would like to search database of input text from textbox and give result out in one view.
View 2 Replies
Sep 15, 2010
I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.
View 2 Replies
Jan 19, 2010
I have a TextBox entry field where the user will enter a integer value. And then there is a "Create" button, which when clicked upon must generate a Table with 2 columns :
"Name" and "Email" being the column headers.
I want each row to have a textbox in each of these columns.
All of this has to happen after the button is clicked. I have discovered that if you dynamically add a control in ASP.NET(I am using C#) then the controls are lost during postback. And I don't know how to prevent that from happening.
Can somebody give me some ideas regarding how to go about adding rows dynamically to a table (I tried using the asp.net Server side table control but ran into the "lost-during-postback" problem - can I try with something else like a gridview ? but afaik a GV will not work without data bound to it )
Point to note is that my table has textboxes for user entry and it is not for showing data ..rather it is for accepting data from the user which will be later used to persist details to the database.
View 1 Replies
May 11, 2010
How to search through a Database column C# and display only what you want like a number 2 in a Gridview ..
View 12 Replies
Jun 15, 2010
I want to know that how many tables we can have in database and what is the maximum no. of columns.I also want to know the maximum size for each datatype.
View 3 Replies
Sep 2, 2010
I have to get input from user in flat file format.then convert it to xml. Then, i have to store the entries into a datatable in the database. say 1,2,3 a,b,c be the user entries. it shall be stored into a table with 2 columns.how to do this?
View 1 Replies
Jun 19, 2010
I have a table 'articles' where all the articles are stored and I want to create a search engine for my website.
user types the keywords in the search engine and what code i should use to search the records in my database?
View 2 Replies
