This 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].....
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)
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]...
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 RepliesI have a datagridview and i want it to display the results from a query. How would i go about doing this. Here is my code so far:
Dim searchStr As String = S_date_menuItem.Text.Remove(0, S_date_menuItem.Text.IndexOf("'") + 1)
searchStr = searchStr.TrimEnd("'")
adapter = New OleDb.OleDbDataAdapter("select * from account where Date= @Date", acctconstr)
adapter.SelectCommand.Parameters.AddWithValue("@Date", searchStr)
that is my query but i don't know how to get my datagrid to display the results.
I want to create a LINQ to entities query getting data(join) out of two tables and bind the result as datasource to a datagridview.
Unfortunately I seem to stumble upon a syntax issue.
Table 1 : dcpricing.tblpricing
Table 2 : dcpropertydetail.tblpropertydetail
Grid: grdpricing
[Code].....
What 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".
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")
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 Repliessearching 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.
New 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 RepliesHow to search DataGridView like on this video, see time (12.00). [URL]. I do all that but it seems that the codes are not the same for "Add Query" in vb 2010 as in vb 2008.
View 2 RepliesIs it possible to query a DGV? ie. search for a value in a certain column or columns.
View 7 RepliesI 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]...
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 Replieson form's load I am filling the DatagridView with an a Sql query. I also use some buttons to highlight every row(record) of the DataGridView. I have a button where when I click on it I want to display in a msgbox the value of the first column(field) of the highlighted row (i.e. the name of the first filed-column is Code).
View 5 RepliesI'm planning to create a program that would bind the search results into the datagridview in vb.net. For example, listing of students that has the same course in the datagridview.
View 1 Repliesi am trying to read a csv file and then query it using linq and thereafter bind the query result to a datagridview. similiar code works fine when querying a database but not when using the csv file. the file import works fine but the result on the datagridview is the lenght of the strings of each year, nav and return. how do i get the real values and not the information of the lenght of the values.
[Code]...
