The instr function compares two strings and returns an integer specifying the place of the string found.
if I want to search "Quick brown fox" for any of the letters "A B C D", is there a function that can do this?
I want to display all the items existing in database for ex:
If i enter just book. All the items with book work should get displayed
Example in google search as soon as we enter one word related all things get displayed. I am not talking about auto completion
I use some code to encrypt & decrypt string in C# but i want a good one that can generate encrypted string that contain only letters or numbers not any other ( + , / , ...)
View 1 RepliesI'm trying to write a validator for an ASP.NET txtbox.
How can I validate so the regular expression will only match if the 6th character is a "C" or a "P"?
In my website, where majority of the users are from Norway,I access some values via querystring(eg: email address).Since the members' email ID may contain Latin letters,I am confused and blocked at this level.
My requirements are,
1, I need to access the Latin letters from query string. Is there any thing different from normal query string operations?
2, I need to store these latin Email IDs to my DB ,which is mysql.Any precaution to be taken while storing latin letters to mysql?
3, I need to show these stored email IDs in my web page.Should I use localization(which I have not used yet) for correctly displaying latin letters in webpage?
I am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
[code]....
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesThe 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.
[code]....
I created 3 product table . A,B and c.
I show product of table in different gridview.
Now I am using one search box. but how to search product name with image in one query all of three table....
Simple how to search product from multiple table and show result...
I want to search data from three text boxes how can i write code in one button click ??? This if else is not gud formed
protected void Button2_Click(object sender, EventArgs e) {
if (TextBox2.Text == "" || TextBox3.Text =="") {
DateTime dt = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type and dateadd(dd, datediff(dd,0, [R_date]), 0) = @R_date ");
[Code]...
i have the following controls:
[Code]....
And the onclick method:
[Code]....
The Search.aspx has a SqlDataSource that get that querystring and search on 3 DBs for just 1 word. I was wondering how i could implement if i want to search for multiple words on that Textbox txtSearch. Could i use the SqlDataSource for that or should i use LINQ or another component ?
I've build a random string generator but I'm having a problem whereby if I call the function multiple times say in a Page_Load method, the function returns the same string twice.here's the code
Public Class CustomStrings
''' <summary>'
''' Generates a Random String'
''' </summary>'
''' <param name="n">number of characters the method should generate</param>'
''' <param name="UseSpecial">should the method include special characters? IE: # ,$, !, etc.</param>'
''' <param name="SpecialOnly">should the method include only the special characters and excludes alpha numeric</param>'
''' <returns>a random string n characters long</returns>'
Public Function GenerateRandom(ByVal n As Integer, Optional ByVal UseSpecial As Boolean = True, Optional ByVal SpecialOnly As Boolean = False) As String.............
I have a string variable contain text that I would like to search for "Keyword" and replace it with new value.
For example:
Dim strValue = " col1 = "John" and col4 = "smith" or col7 <> "closed" or col9 > 1 and col5 = "passed" "
After the replace the strValue should be :
strValue = " col1 = "John" and ( col4 = "smith" or col7 <> "closed" or col9 > 1 ) and col5 = "passed" "
Site.Master contiains search form using code below. After pressing submit button entered search string is reset since whole page is re-loaded. How to persist search string so that search field contains enterread value after page is re-loaded ?
[Code]....
Using MVC2 and C#:
I have textbox that is going to be used for searching. I would like to access the data entered in this textbox in the Controller, so I can filter results in my list. I've found a couple ways to accomplich this, but haven't been successful with any. The way that I like the most is using action method parameters. Here's what I have setup; can someone tell me where I am going wrong or supply a simple example:
I have a SearchDetails view that is basically a textbox:
[Code]....
Here's the search details method from the controller:
[Code]....
Here's the search results method from the controller (where I'm trying to access the data from the textbox):
[Code]....
I added a break on the line with 'test' string and 'txtInvestigator' is null. I've also tried to make these methods GET requests and try to access the textbox value directly with Request.QueryString. It seems like I'm close, but must be missing something fairly obvious. As an aside, I already have a List() method in the controller that lists all the items from a table in my DB so I am making a little progress!
i am using the below code for extracting paragraph for matching string.
[code]...
i am getting correct result,but i am getting breakable words in starting and ending paragraphs like "...ing regions uses the and Boolean connector to specify the region so narr..."
I have 6 text boxes on an asp page and one search button. Users can search by entering text in any of the search boxes. I am using Linq to query to my sql server database and I can write the queries. but the problem is since there are so many text boxes I will have to write lot of queries. for ex: user can search by entering data in all 6 text boxes or 5 text boxes or 4 or 3 or 2 or 1. You can see how many queries I have to write. Is there any way to code this kind of problem or should I just code all possible combinations.
View 1 RepliesI ve a list of string List<string> that have more than 100000 records. Now i want to search a particular string and their occurence it list. Is there is any buit in method that can perform dis job???
List has BinarySearch method but it retrun the index...
can anyone writing efficient algo of searching n counting no Occurrence in List of string
the method should b like
[code]....
I want to create an Select SQL string by some search fields. Since I can't check the blank ones, otherwize it would look for blank, I have to do this on steps, adding them if they where not in blank, so, for that I am using something like this:
String SearchString = "SELECT * FROM Sala ";
String SelectWhere = "WHERE "; //This where is because I may receive all empty, so, the WHERE would make problems in the string.
If (TextClassroom.Text != "") {
SelectWhere += "(Classroom = " + Classroom.Text + ")";
}
But here is the issue. I may search for more than one at once, and that, would make me have to put an "AND" clause between them. How do I check that in the less number of lines as possible? I made a count variable, so I can count when it has been entered. But, getting to the third time it gets in, I have to check if the number is 1, or the number is 2, to see if I need to put an AND, right? And that would start making hard when we have, like, 10 fields. Is there an easier way to check when to put the AND without that many checks inside checks of empty texts?
I'm trying to implement a search function on an incident logging page that is working fine. Currently I am only able to search against one criteria at a time, using the following route:
View 2 RepliesI have created a search page which outputs results in a repeater. It uses a stored procedure to search a table %like a textbox value, what's the best way to make it search multiple tables and output the results on one button click?
As i could just use seperate stored procedures and repeaters for each table i want to search, which is only 2, but this seems inefficient.
im trying to write a query. for my ui ,i have 3 text boxes for firstname,flightno,sequencenumber.
i input search value on particular textbox it has to be searched on particular column of my db in a single stored procedure.
im using this procedure but it retrives only one column at atime. so like this i need to write three procedures.
but i have only one GO button.
ALTER PROCEDURE [dbo].[spp_searchUsers3]
@lastname nvarchar(50),
@Value varchar(50)
AS
DECLARE @SQL nvarchar(500)
SET @SQL = 'SELECT firstname,flightnumber,lastname,status FROM tbl_pregister WHERE '
+ @lastname + ' LIKE ''%' + @Value + '%'''
I'm searching folders using the following code. Is it possible to use this code to search for *.mp4, *.mp3, and *.m4v files instead of just *.mp4 files?
[Code]....
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.
We have 2 tables that i need to search thru..we are trying to be as flexible as possible with this search page.. a very stripped down version of how search engines are setup..
You have 1 textbox and are free to enter what ever you want..
Well in our case.. we want to setup a textbox on the page.. and pass that into our procedure and have it look thru 5 differnet columns ( id, date, name, time, number )
So if i enter say 1974 into the field, i want to go find any record that contains that in any of the 5 columns..
Is this possible without using SQL Full text indexing??