Use SQL Queries With LIKE, @parameters, And % Wildcards?
Feb 22, 2012
I am using a database in Visual Basic 2010 displayed through a DataGridView. Through the DataGridView's "add query" option, I am writing these queries. My goal is to have partial search entries show up (ie if the entry is "Lewis" then it should be among the entries returned if "Le" is in the textbox.)
SELECT * FROM Table WHERE Surname LIKE '%' + @Surname + '%'
I am using the above query and it only returns exact matches despite the LIKE operator. Partial entries never show up despite the presence of the wildcard % symbol. It's as if the whole thing is being treated as an equal sign.What should I do? Is it a problem with the SQL itself or does VB's "add query" maker simply have such limited capabilities?
I am writing a message system on my server, the xml is something like this
<xml> <entry> <sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
i want to copy all the files in a directory with an extension e.g .exe or maybe all them files *.*I searched on google and found this on MSDN But it doesn't work when i type *. or *.* or *.exe into the textbox and there is files in that folder.[code]
i am pulling data line by line from a PPML what i need to do is: If "current line" matches my string then write that line to a new file
that part I have down my only issue is, is that the "current line" has filenames with in it that change constently i would like to be able to do something like a string with wildcards in it : "<currentline>src=""*""/>" but this does not seem to work Do i need to do an index with conditions or is there a different way if i do need to do an index how would i go about doing that in vb .net for studio 2008
i have a bunch of radio buttons which can have different text displayed depending on whats retrieved from the database.however i want to add code that hides any radio button that would have a 'zero' retrieved from the database.so far this is the code i was coming up with, without getting into the nitty gritty of the actual database queries
If RadioButton1.Text = Me.HWExamsDataSet.DSExamTextA.Rows.Item.tostring = 0 Then RadioButton1.Visible = False End Ifabase entries or queries.
it looks like it may work...but is there a way to automate it so that i can put in a reference to ANY radiobutton like radiobutton(*).text? or a bunch of buttons if need be.i know theres a way to specify additional items to a given command...just can't remember if its curly brakets etc.
I have to provide the app users, a way to search by both regex and wildcards.I've already implemented the regex option, but how to provide a search by wildcards?
I am trying to return a filename without the extention, to keep things simple, lets just say I want it to go to a MsgBox.[code]The only thing I am getting is a * in the msgbox. I though that strings supported wildcards?
i created a DatagridViewNumericUpDownColumn but i got error message Cannot access a disposed object. Object name: 'NumericUpDown'when i closed and reopen the form. It shown You are not authorized to perform this action.how can i get access to view this thread?
I'm using Visual Basic Professional 2010, I have two directories of XML files. The naming convention in directory one is a user's name, a six digit date and ending in ".xml_CREATE.xml". So, I perform some work on a file in directory two. During the course of that processing I discover that a file exists in directory one called "Mike" an unknown six digit date and ending with ".xml_CREATE.xml", so while I have no way to know the date, I know it exists and would look something like Mike030312.xml_CREATE.xml. So, now I want to load that file as an XElement that I will eventually incorporate into an XDocument, so I need to perform a Load similar to: myXMLFile = XElement.Load(My.Settings.XMLDir & "" & Mike030312.xml_CREATE.xml), However, since I don't know the date, I need to insert wildcards at that spot. How do I make that happen?
how to even start a code project of this sort but here it goes... I have an external Hard Drive with some music. My itunes makes duplicates of all my songs so this is what i have.
What I want to do is have the program search the files and delete all files that have a duplicate with a number behind it... Now I would use windows search but some of the songs are like 1001.mp3 or 1001 1.mp3... I want it to look like this when i get done (from the above):
Ok i want to copy all the files in a directory with an extension e.g .exe or maybe all them files *.* how do i do this?I searched on google and found this on MSDN But it doesn't work when i type *. or *.* or *.exe into the textbox and there is files in that folder
VB.NET For Each foundFile As String In My.Computer.FileSystem.GetFiles(Application.StartupPath,Microsoft.VisualBasic.FileIO.SearchOption.SearchTopLevelOnly, TextBox8.Text)My.Computer.FileSystem.CopyFile(foundFile, IO.Path.Combine(FullPath, foundFile))Next
I find and replace text in a .doc file using MS Access visual basic. Here is my Sub:***************************************************************Public Sub
If CompLang.Text = "ru***" Then CompLang2.Text = "working" End If
This is just a simple example. I'm trying to make it so that if one x.text = ru*** (for instance, ru---, or ruuuu, or rux2x, etc.) to have x.text change to a predetermined value (hardcoded).
I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
Basically Commands has Parameters and parameters has functions like Add, AddWithValue, and etc. In all tutorials i've seen, i usually noticed that they are using Add instead of AddWithValue.
[Code]...
since it saves my coding time. So which is better to use? Which is safe to use? Does it improves performance?
is there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
I have a Access 2003 backend db and I'm using vb 2005 to connect to the db via conntection string. It works ok! I can see all the tables but only some of the queries. Why should some queries be absent? In 1 query I have a user define function which cuts up a string. I've created a new VB project with a new connection but the same result. I've compacted the database with not change.
I am trying to UNION the two queries below without success. Dim ds1 As New DataSet Dim MyConnection1 As New OleDb.OleDbConnection(GetPOWERConnectionString()) [Code] .....
I am trying to perform a search query using drop down boxes with a button named search. I want it to bring up the data that is searched for. I dont know where to start from, i have looked around for some coding and different ways to do it but they seem complicated, this is the bit of ASP that is my weakness, need some assistance and guidance. below is the code for the page;
I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Web.UI
Where can I find informations on which WMI queries are in fact available for .NET interface through ManagementObjectSearcher. The command below returns exception for "Win32_LogicalDisk", but works for "Win32_Environment". Every reference in msdn directs to msdn library, which contains all Win32 and COM development classes (that seems not to be available from vb .net code):
I've been going through a lot of forums and see a lot of mention of ADO.NET and how it's better to use. I guess because it's newer and being maintained with current times?I've done google searches for this, but every time I see different programming languages other than VB.NET implementing param queries with ADO.net, or it brings me to results that have oledb commands again.Is there a good ADO.NET for VB.NET tutorial with parametrized queries?
I want to send the a vb.net application which will run some updates on the database. I have built the sql script files which i would normally run thru query analyser but that is not available thru MSDE.I know i can use OSQL or ISQL to run these scripts but i really want to run them thru a VB.Net application.here is the code i'm using which is generating an error beacuse i'm trying to execute more than one statement?
Dim connectionString As String = ' CONNECTION STRING IS HERE Dim conn As New SqlClient.SqlConnection(connectionString) Dim cmd As New SqlClient.SqlCommand
i have a form which once the user has entered their correct Account No they will access the jobs relating to their number. I now need to use and update query so that once I select yes in the Query handled box, after clicking the update button, this row will then be deleted from the table. Here is the code that I have so far:
Public Class Form1 Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click End Sub