i got a function that search for database data, is it possible that i make it search the nearest words or keywords? which mean if d name is TEST, n i key in TE then it will show those name wit TEST TESS TSST? [Code]
View 2 Replies
We have users to type in Business Requirement in a text box.For instance : DOB Field is mandatory in Service Request Screen.
I am planning to define all the keywords in my code and once search button is clicked it should look for the keywords and throw a msgbox with number of keywords found.
Any code snippet vb for searching key words like name or id no. On my database connected with my vb form application?
View 2 RepliesI am in charge of developing a searchable database which should allow users to search for any key term in every fils content in a folder. Note that I need to search for filescontent, not file name. Right now, users usually have to searchfor every file to look for particular filecontents with any key terms.
View 2 RepliesI have a requirement to search large piles of text for keywords
The "keywords" are known in advance - but the number is variable.
The text is large - I've had 50000 byte strings in tests already...
I have a application that uses data from a database to create a email signature for a user.When you create a template you can insert optional fields. Like this
View 5 RepliesHow can I exclude a common keyword like "a,the,is,or.. etc.." from my search query ? If you do a search in Google or other search engine it says "the" is a very common word, and was not included in your search.Is there a list somewhere that I can get all the common keywords that need to be excluded from the search query?
View 3 RepliesI am working in excel trying to setup a function involving multiplying a cell by a set number and then having the result round to the nearest 10. Here's the beginning of my function statement fx=e3*1.026. say the result is 8654, I need it to round to 8650. Also if it comes back 8655, I need it to round to 8660. I have about 2,000 records I need to do this to so I was hoping that one formula or statement could be used for all my data.
View 2 RepliesI am creating a search function which searches a database for keywords in a selected field in FilmTable (name of table to be searched)
This is the SQL I am using:
CODE:
It is saying there is an error in the FROM syntax
I wanna invoke a function when user presses ctrl+F .The function works same like searching a string in word or notepad but in my project i m searching whether entered string exist in datagridview. How to get the key code in vb.net
View 4 RepliesSo I have a function that looks up values in a jagged array, and it goes like this:
Private Function Lookup(ByVal Search_path As String) As Integer
Dim i As Integer = 0
Do Until MasterIndex(i) Is Nothing 'throws an exception here
[Code]....
Problem is, when I test this with an empty array, it gives me the error of Index was outside the bounds of the array at line 3. How do I fix this?
I have been trying to write code that asks the user for the size of an array , and then takes inputs from the array. They are characters A-E... Then I am to call a function that will count the frequency of A,B,C,D,E . Then it is supposed to send the information to a listbox. Eg. There are 2 A's,There are 0 B's, There are 5 C's..
I have the code for populating the array, but when it comes to searching it for the frequencies..This is what i have so far..
[code...]
If so, what is it? I am using VB 2010, and am relatively new to VB.
View 2 RepliesI need code for the function filesystemobject which gets the text files from a folder when searched for.
View 1 RepliesI previously posted a Question about code that uses a function to return the frequency of characters in an array. I have now got this code.
View 5 RepliesI need code that would take the input from textbox "Txtkbb" and divide it in half then round to the nearest 25 and store it in value "KbbValue"
View 4 RepliesI have written a program to return the colour of a pixel from an image. The problem I have is I need to return the colour name. Of course not all colours returned will be one of the pre-defined colours (knowncolours), so my question is, is there a way to find the nearest knowncolour which matches the colour of the pixel?
I have looked at GetNearestColour but am confused by its function. It just seems to return the same colour as the parameter passed into it.
For example, how would I get the # "220" from the number "229". Or the number "300" from "309"? The only way I've found to do this is using string stuff, but I'm afraid of the overhead for strings?
View 15 Repliesgetting a formula round off to the next highest .25.example:
2.35->2.50
2.26->2.50
2.24->2.25
2.51->2.75
I can't use the Round function because if I have 2.26 then it will round off to 2.25 which is unacceptable.I have been using the Ceiling function but it rounds it off to the nearest highest integer. Which can add an almost extra kg,lb to my formulas.
how can i always round a double up?
2.3 = 3
2.5 = 3
2.8 = 3
i always want to round up to the nearest whole number
How do I go about rounding up to the nearest (Unit 10) ie Codes Below
IfVal(TimeHalfFareTextBox.Text = $/£ 0.05)
Then roundup
to $/£ 0.10. Or it might be .....
[Code]....
I use Mschart to produce charts. What I am trying to get is the nearest data point by where I click on the chart. The problem is that I can't find any connection between the HitTest values and the data point x/y values.Say, I clicked on the following point:
Dim result As HitTestResult = Chart.HitTest(e.X, e.Y)I have now values of X and Y where I clicked. How to associate it with the data point values?
What I want to achieve is to double-click on the chart which would find the nearest data point (x,y as integer) and knowing these values I would be able to recalculate other values based upon where the user needs it and double-clicks.
[Code]...
[code]How can I validate that if 387 mod 2 <> 0 then it should display the nearest double. In this example, it should display 386 which is nearest to 387 and can be fully divide by 2.
View 3 Repliesi'm building an image library and one of the things i want to do is compare the most common color in a given image to a set of established colors in rgb format the way i'll probably do this is create 3 arrays for the average r,g and b of each given image, and then compare them to my established values for r,g and b that i want to match to so if my first image has the average values of 255, 125 and 5 for r,g and b..what would be the best way to do a nearest match against my pre-established colors? (about 32 in total)
View 1 RepliesI'm trying to round a double to the nearest 5th or 10th number. So far my code looks like this basically:
'Mathamatical equation For Cost to Mow
dbCost = (txtArea.Text / dubMetres) + intExclusions * 3 + (intIrregular / 2)
Dim dbRounded As Double
'Trying to round to nearest 5 or 10
[code]....
I have read about Round() and MidpointRounding.ToEven but I still could not figure how to use it to achieve what I want. I have numbers (usually from 5 digit decimal) such 125.36 , 125.10, 125.99. I want to make the 2 decimal point rounded to the nearest 20. Means, the 2 decimal point should be either .00 or .20 or 0.40 or .60 or 0.80 only.
125.36 should be 125.40 : 125.10 should be 125.00, 125.99 should be 126.00
125.54 should be 125.60 and so on
Is there math function to make or I should parse the number as text and test the last 2 digit?
Is there any prebuilt items to roundup a number to set fraction size or do I need to build a routine to do this? If I have to build this any thoughts on the way to go about it? I was thinking I need to strip the decimal places and then compare them to a dataset of numbers a make a choice?
View 3 RepliesDecimal number in my textbox I need to round to the nearest even number. Is there any idea how to do it?
View 21 RepliesI'm doing an assignment for class which is basically a simple program that takes 12 monthly temperatures and averages them. But I also need to round the average to the nearest tenth. I am not particularly good at programming or math and don't know how I would fit this into my code. I am Including My program thus far. I put in bold and italic where the calculation takes place.
Private Sub btnEmterTemperature_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEmterTemperature.Click
'FOR BUTTON CLICK EVENT "ENTER TEMPERATURE"
[Code].....
How can I make it so that decimal numbers round up or down to the nearest integer?
View 3 Replies
