As you can see in the picture I send my wildcard parameters to my query if the "textbox" does'nt have any content. But when the query require INT, and not STRING, I don't really know what to do.Is there another kind of wildcard when it's INT?
View 19 RepliesI am making a small guessing game, and I have a numerical number box in the option forms which sets the max number that can be generated. Because of the way I get the variable it wont update that value correctly. To fix this, I have a label which, upon closing the form, is set to the number of the numerical number box, and the max value is gotten from that label. My question is this: How can I convert a string to an integer? I tried one way, but got (i think, i cant remember exactly) a "First class expectation error" and something to do with "vbexpress.dll" (again, not the exact name) This then caused my Laptop to lag up so much that i couldn't do anything, and had to force crash it. So again, my question is this: How can I convert a string to an integer?
View 3 RepliesIs there a way to check if ther was a change in a interger that i can use in a if statment?
View 5 RepliesWhat I want to do is to replace lets say ##test## with Something(test)..I know that I can find ##test## by: (Though don't know whether there's a smarter way)
System.Text.RegularExpressions.Regex.Replace(str, "##Test.*##", "Output")
So basically the problem is to get what the wildcard (.*) is, since thats really what I need to know..
I have a datagridview on a form.
I have a text box and when the text is changed in the text box, i want it to search the datagridview for any matching values.[code]...
I've been having problems extracting the value of a Regex in a String. I have a string with several regex expressions and I need to get the value of each expression's match. The thing is though, it's not returning the last match correctly. For example:
Regex Pattern: I play (S+.*?) and (S+.*?)
String: I play the guitar and the bass The program is returning the value of the first expression as "the guitar" but it's returning the value of the second expression as "the" instead of "the bass".
How do I add a wildcard parameter to my query. Im using a mysql database. The following doesn't work:
Dim occCmd As New MySqlCommand("SELECT occupationid,descr FROM occupations WHERE lcase(descr) like '?descr%';", con)
occCmd.Parameters.AddWithValue("?descr", prefixText)
I'm trying to use the bindingsource.find method to match a datarow column with a user entered text. I know that using BindingSource1.find("columnName", searchString) will work when the user enters the exact string. What I would like to know is how to find a row that is close to the string using a wildcard search... a good example I guess is:dim searchString as string = textbox1.text 'lets say the user enter "se"dim index as integer = myBindingSource.find("columnName", searchString) 'I would like to find the firs record that starts with "se"I can achieve the idea using the bindingsource.filter method but this will interfere with other parts of my application if the bindingsource is changed.
View 6 RepliesHow can I use wildcard/s for the attachment filename. Part of the filename changes but the characters 8 and 9 (counting from the left to right) always present and always either LK or KL. Currently files are PDF type, thus with extension PDF but might be different in the future (this is not important now).
Here it is: Dim oAttch As Net.Mail.Attachment = New Net.Mail.Attachment("C: est102309LKO.pdf")
searching a directory for a file, and if it doesn't find that file to search again for a similar file and notify the user that a image does exist but for a different revision.
Sub GVC_Photo()
Dim photostr As String = "R:itemphotosp_"
Dim photostr2 As String = "R:itemphotosp_"
Dim photostr3 As String = "R:itemphotosp_"
Dim photostr4 As String = "R:itemphotosp_"
[code]....
This code snippet is used in a program called SyteLine, so some of it may be unfamiliar, but its .net based. The item and revision are fed through from the form, so when the string gets built it might look something like this "R:itemphotosp_22554_B_01.jpg" with "22554" being the item, "B" being the revision, and "01" being the image number. So what I want is if it cannot find a file name with revision B in it, to search for a filename with any revision it it "R:itemphotosp_22554_*_01.jpg", if it finds one to display a message that a non-current photo exists, and if it can't find that, to display a message saying there is no photo.
I'm trying to query a Datable. I can do this just fine: [code] gives me an error: "Error in Like operator: the string pattern 'a*e' is invalid.". Why can't I have the wildcard in the middle? I want to find values that start with something specific & end with something specific & I dont care what's in between.
View 2 RepliesNew user here. I've been searching high and low for what I would think is a relatively simple task. I want to rename a file with a wildcard (i.e. FileNamexxx.xls) within a Visual Basic Script. I'll be running this script within Visual Studio.
I will only have 1 file in this folder, so I do not believe a loop is necessary.
Actual FileName is "CellModelHistory1251234.xls"
Imports System
Imports System.IO
Imports System.Text
Imports System.Windows.Forms
[Code]...
I'm importing a .csv file into my SQL Server (2005) using SSIS on a schedule, after its imported I would like to change the name of the file. The name of the imported file is always different as its coming from an external source.Is there anyway of changing the table name?
I've looked at using the stored procedure sp_rename, i.e.
Code:
USE TESTDATABASE1
GO
EXEC sp_rename 'dbo.SalesTerr5673A1889', 'Values';
GO
What I would like to use is a wildcard?
I am making a project for school with visual basic and its a mcdonalds ordering system.There are 50+ buttons which you can press to remove an item and my code works fine. only problem is it is waaaaayyyy to long and can be shortened with a wildcard. Does anyone know what a good way to put a wildcard in the following code would be:
Private Sub btnsmallfries_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsmallfries.Click
If Label2.Text = "Buy Mode" Then
[code].....
I want a string search/compare with wildcard. I'm trying to create a "crypto crossword" application and got most of the code working but the wildcard thing was harder than I thought.
Basically I want the program to compare if "H**LO" is equal to "HELLO" (true). But "HE*" is NOT equal to "HELLO". I tried with regex but the number of wildcard is different each time and in different places so I never managed to make it work.
I have created a Web Setup project using VS 2008. I have created a custom action to programatically add a wildcard scriptmap for my virtual directory. The app installs fine, but, during custom action, fails to add scriptmap. I've tried this on Win 2003 server with IIS 6.0 and WinXP with IIS 5.1.[code]....
View 1 RepliesI am working on an application in vb.net to move files back and forth between a client and a ftp server. We will be creating, deleting, and renaming temporary files during our update process.I want to check for the existence of a temp file before I begin an upload process to keep different users from trying to update the same file at the same time. I have a method (below) to check if the FTP file exists (using ContentLength), but I want to be able to pass in a string with a wildcard such as:
FileServer.FtpFileExists("MyTestFile.*.txt") Can I use a wild card with a FtpWebRequest object? What about a regular expression? Or should I pull down the directory(between 200-500 files) and iterate through that list on the client side trying to match with a regex/widcard? 'Find if File exists from FTP Server for File specified Private Function FtpFileExists(ByVal RemotePath
[code]....
Is is possible to do something like:TextBox1.Text = Replace(TextBox1.Text, ".*", "", 1, , CompareMethod.Text)
View 9 RepliesThis query fails on a dataset when I add the rating wildcard. The other two are fine but it does not like the %. This works fine if I run the SQL directly on SQL server.
HTML
SELECT Rating, InvDescrption, FullJobNumber, Product
FROM vJobLines
WHERE Product Like ? AND InvDescrption Like ? AND Rating Like The product and InvDescription fields are NvarChar where the Rating is Int32.
I am having difficulty with searching on a Dataridview. I want the user to be able to enter a characters into a textbox and as they enter them the Datagridview will reduce down base on the name that is being typed in.So for example the user types: Smthis will show all the Smith and all the Smarts etc.So to do this user the Textbox change event. This I think works ok. The problem I have is getting it to filter on that data.
I have a dataset:
HTML
SELECT CompanyID, CompanyName, Address1, Address2, Address3, Town, County, Country,
[code].....
I have a method that takes 2 string arguments. One that contains a normal string and one that contains a string with one or more wildcard characters. I've tried the following code:
Private Function DoesMatchWildcardString(ByVal fullString As String, ByVal wildcardString As String) As Boolean
Dim stringParts() As String
Dim matches As Boolean = True
[code]....
The I realized that it won't work properly. If I have ABCD as a normal and A*CD as my wildcard string the match will work even if my normal string was CDAB, which is not what I want.
I have a form which takes input from the user in a TextBox to display ("contains") record/data on a grid. However, I am unable to achieve the input data thing. I have been trying to solve this for a while now. Dtatbase is MS Access.
Here is my code: I don't get any values in the form grid whatsoever for this query.
Imports
System.Data.OleDb
Public
[code]....
I need help extracting the value of a wildcard from a Regular Expressions match. For example:
[Code]...
Im working on a project that includes a TableAdapter for filling data. I usually use parameters for queries I create, but what would be the best way to create a query that may have a wildcard without creating a bunch of queries?
[Code]...
In VB6 I could use an asterisk as a wildcard when searching the object browser. For instance, searching on "c*Report" would find "cFooReport" and "cReport". I can't seem to do the same in VS2008, am I just missing something obvious?
View 1 Replieshave a script which puts multiple files into a folder periodically. I have a code to delete file. this code should run but gives me error that file does not exist.
' for each objFile1 in FSO.GetFolder(strPath2&""&acctdir&""&acctsubdir).Files
' acctno1 = Mid(objFile1.Name,1,11)
' if acctno1 = acctno then
[Code].....
How to download multiple files with a wildcard pattern using webclient DownloadFile? Like project* from [URL]..
View 1 RepliesIn my setup and deployment project, I have made all the directories I needed. The problem I have is: With the registry keys, how do I enter the value field with a wildcard for the location to the new installation. People don't always use the default location, so I need my key to dynamically set the registry to the correct place. So what do I do? [ProgramLocation] or something?
View 3 RepliesI have two tables:
table1
case_no flow result
tc_1 001 pass
tc_1 002 pass
tc_1 003 pass
tc_2 001 pass
tc_2 002 fail
tc_2 003 pass
table2"
case_no result
tc_1 pass
tc_2 fail
Table2 should be updates from table based on the results... If all results is PASS then the table2 should be updated as pass... if any result is FAIL then the entire case_no should be updates a s fail..
This code was working consistently, but now...This code works on the first pass.Then second pass it just hangs on Code:Dim tcpClient As TcpClient = tcpListener.AcceptTcpClient() for about 2 minutesThen the code will fork for another pass, then fail.....
Code:Imports SystemImports System.TextImports System.Collections.GenericImports System.XmlImports System.Xml.LinqImports System.Net.Sockets
[CODE]....