I have a specialized string dictionary of (string, string) (_RulesAndTheirDescriptions) that contains the name (key) and description (value) of methods in a given class. I currently do the following query to search for a match on the key or value and then bind that to a grid.
[Code]...
I am getting this error in MySQL on search for keywords. The error: Can't find FULLTEXT index matching the column list. My Database Table is a MyISAM and my dataTypes I am searching are Text. Any Ideas why I would get the above error?
View 6 RepliesI'm having issues with returning a list of strings of the .Value of a Linq query:
Dim details = <Details>
<Vector size="5">
<Item>Syntactic Structures</Item>
<Item>Introduction</Item>
<Item>The Independence of Grammar</Item>
[Code]...
Is correct in that it returns the list of XElements I want (items 1 - 4, base 0), but I really just need a list of strings for the .Value of those XElements. Maybe I'm just dense here, but anything I've tried in the chapterTitles query isn't working (appending with .ToList.ToString, etc.). details.<Vector>.<Item>.Skip(1).Take(4).Value just returns the first XElement's value.
I have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
I have a problem finding strings that do not exist in a column in a database. I am going to use linq but its more the 'way' of doing I am concerned with.
I have strings like;
MEAL
GPST
EXLEG
EXLG ...etc
I need to find records that does not have this list of strings in, so for example DBML BUT sometimes I can have the string MEALDBML, or more concatenated. So this is a known string of MEAL and unknown string of DBML. I would then want to see that record. I do not know the unknown strings up front, so its a case of feeding in the strings I know are ok, and finding one that are outside that list. I was also thinking of regex?
I am learning Linq, so bear with me. I have a class object that holds 4 other class objects with each holding a List(Of T) of the next. Think tiered classes. As these lists as built I need to search all the Group2 for all Group3 to see which Group3.units.count is the largest. "units" being a List(Of T). [code]
View 4 RepliesFor a class project I am supposed to search through the attached file, and write to a new file the years between 1789 and 2009 that are not present in the fifth field. What is my best bet for determining what years are not present?
[Code]...
Should I make an array of integer between 1789 and 2009, then search for every year in the file, then set a flag to false if not found; is there a simpler way to accomplish this using LINQ?
Say I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
View 2 RepliesI am having so trouble with the ToUpper() procedure with strings. I am using LINQ to find unique values in a list of objects. In that whole process I set the values to compare to all lowercase in order to get a proper list. My goal is to populate a dropdown list with the values. I'm attempting to set the first letter of of the string to uppercase and keep the rest lowercase however the toUpper() procedure is not working?
Private Function FixCase(ByVal strIn) As String
Dim strOutput As String
Dim intStringLength As Integer = strIn.Length - 1
strOutput = strIn.Substring(0, 1)
[code].....
This is what I want to do as seen in C#(loop against a list and fill another list from its data using Linq)
[Code]...
I have two array list same size, depending on the information gathered by previous functions. The size of the arrays range from 2 - 45 in length, both arrays always have the same length. I am trying to match one string in one array to another string in the second array. When they match then add Item to List.
Here is my
Do Until i = Arraylenght
info = Replace(myAL(s), " ", "")
SortedArrayList(m) = Replace(SortedArrayList(m), " ", "")
SortedLine = Split(SortedArrayList(m), "Price=")
If myAL(s).Contains(SortedLine(1)) Then
[Code] .....
This code works up to an array of not more then 4 in lenght, when working larger size array then 4, the minute it get to 5 I get this Error:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
In .NET which data type do you use to store list of strings ?Currently I'm using List(Of String) because it's easier than Array to manage and add/remove stuff. I'm trying to understand what are the other options, when they become handy and when I should avoid List(Of String) usage.
View 4 RepliesI am importing data from an Excel spreadsheet into an array. I want to search the array to find the location of each "cell" with text that contains a certain string (e.g. "MyTestString"). So far the best I can do is loop through each element and test it using CStr, but the code takes too long to execute (please assume all variables are properly declared):
[Code]...
(1) Is there a better way than looping through each element, such as a built-in function or a lambda that will return an array containing *the location of* all string matches?
(2) Would it be faster to convert the Object array to a String array rather than using CStr on each element? If so, what is the fastest way to convert a 2-dimensional Object array to a String array?
I've considered using Excel's Find function instead, but would prefer to limit the number of Interop calls to Excel.
Have text file with two parts
[CODE]...
The upper part and the part after the line *+*+* Top *+*+*. What i must do is i must read the value in () at the Top part and compare that value with value in [] from upper part and write it side by side
This is my code so far:
Private Function GetLineMatch(ByRef LineToMatch As String, ByVal LineNumber As Integer, ByVal FileContents() As String) As String
Dim value As String = System.Text.RegularExpressions.Regex.Match(LineToMatch, "([d
[CODE]...
If u see the highlighted value are same. But from top part when it read (2 13.50 26.3)it only matches for one time the value in [2 13.50 26.3] so it take the first line and write and iqnore the second line.
I have text file with two parts
[code]...
If u see the highlighted value are same. But from top part when it read (2 13.50 26.3)it only matches for one time the value in [2 13.50 26.3] so it take the first line and write and iqnore the second line
I have 2 groups of text in my text file[code]...
View 3 RepliesI am trying to make an kinda autoclicker when the desired color is found. I am using a class to make an screenshot of the screen.
VB
Public Class CaptureScreen
Private Declare Function CreateDC Lib "gdi32" Alias "CreateDCA" (ByVal lpDriverName As String, ByVal lpDeviceName As String, ByVal lpOutput As String,
[Code].....
Now I wanna make an functions that find the a pixel with the matching color I put in as RGB in 3 textboxes 1 for R etc.
I need to extract some data from a list with a linq querry like
(from p as MYClass1 In List where P.Datetime> UserDate1 P.Datetime< UserDate2 Select p Skip (StartPoint) Take (Range)
I have a list of data as shown below
Original Data
Genre Name Year
Comedy Shrek Forever After 2010
Drama The Karate Kid 2010
Action Iron Man 2 2010
[Code]...
How to find a matching pair of values in two different arrays? Here's the scenario:
Index Array1 Array2
0 1 3
1 2 5
[code].....
[code]It spews out the directories that contain the .my files [level2a & level2clevel3] and skips level2b which does not.It looks like this code for VB 6 would work:[code]I can get to the level1 directory. I am after an array of paths to subdirectories that contain matching file names.
View 9 RepliesThis is my function:
Public Function GetAllEmployee() As List(Of Employees)
Return DB.Employees.Select(Function(q) New With {q.EmployeeID, q.LastName,q.FirstName}).ToList()
End Function
I'm getting an error:
Value of type System.Collections.Generic.List(Of <anonymous type>) cannot be converted to System.Collections.Generic.List(Of NorthwindModel.Employees).
I have a list of strings. For each string in that list, I want to prepend another string. I wrote a method to do it, but I was wondering if there was something already in .NET I could use to do this. It seems like something that could be built in, but I was not able to find anything.
Here is the method I wrote:
Private Function PrependToAllInList(ByRef inputList As List(Of String), ByRef prependString As String) As List(Of String)
Dim returnList As List(Of String) = New List(Of String)
For Each inputString As String In inputList
returnList.Add(String.Format("{0}{1}", prependString, inputString))
[code].....
It works, but I would rather use built in functions whenever possible.
I'm migrating from VB6 to VB.NET, in hence my questions below:
I have to write a function that returns array of strings.
How can I initiate it to empty array? I need it since I have to check if it's empty array after it returns from this function.
Is list of arrays better for this purpose? If I use a list - Is it empty when it firstly defined? How can I check it it's empty?
I have been looking for examples to find the string between two strings. This top one works fine;
Public Sub ReadData(ByRef keywordStart As String, ByRef keywordEnd As String, ByVal filename As String)
Using reader = New StreamReader(filename)
[Code].....
Now the first one is fine - Ext_Volume is result of the string between the strings <Volume> and </Volume>. <Volume> and </Volume> are unique so this is straight forward.
However the second one - "^FDExp:" is unique, but "^FS" is not unique. There are occurances of "^FS" before and after "^FDExp:".
How do I get the string to search AFTER the occurrence, not before etc?
In vb.net, I am having myList as List(of myClass) and myData as myClass. So how do I find whether if myList contains myData or not? Currently I am doing it like:
dim myList as List(of myClass) = myClasses.GetData()
dim myData as myClass = myClasses.getData(1)
for each Item as myClass in myList
if Item.uin = myData.uin then
msgbox 'yeah'
end if
next
The application must have basic functionality as to: Insert new customers into the database A search function will be needed to find a users criteria entered The more advanced features would include matching certain criteria with another for example if the data in field 1 is the same then it should match this and return the results. so for example if a person has a hobby of 'football' it will return all the people with the same hobby
View 4 RepliesPublic Class Form1
Dim strname As String
Dim intage As Integer
[Code]....
i am trying to make this program that asks for your name, age and a password the user already has and returns a id number that is generated randomly. my question is how would i match a word to a predetermined list of words then it would get deleted off that said list so it could not be reused.
I have these objects:[code]Using LINQ I need to take a List(Of MakeInfo) and a List(Of ModelInfo) and aggregate the StockInfo from ModelInfo into the List(Of MakeInfo).So for each MakeInfo I will have a total count of all stock where MakeInfo.Name = ModelInfo.Make, and also a minimum price.I think it's going to be something like this, but I'm having trouble accessing the nested object and not sure if it's going to be possible with a single query.[code]
View 2 RepliesI was playing with ASP.NET MVC 1.0 a couple of days ago. I started out with a single table DB named 'Contacts', with very simple structure e.g. Title, FullName, SurName, Email, Phone, Address etc.I'm using LINQ as my Model.In my main view I wanted to display a list of alphabets that have matching FullNames starting with that alphabet plus the count of FullNames. Someting similar as shown below:
A - (2)
D - (4)
J - (1)
and so on.One particular thing about the display is that i don't want to display those alphabets that have no names starting with them.I tried a couple of queries but didn't succeed.