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 a beginner when it comes to VB express. I went to the FAQ and found what looked like the answer to my question in "Database - How can I put the value of a variable/control into my SQL statement?" which said I should use thecode ...... where Field = ' " & variablename & " ' at the end of the SQL statement
I am using a field defined as a nchar with 10 charecters and my variable is defined as a string. my field has been given the value "abcdefghij" so it is full to avoid confusion with spaces and even though the variable is identical and I have used the len command to check there are no hidden spaces etc. When I run the query I get no records selected. What am I doing wrong?. If I use Where Field = 'abcdefghij', ie specify the value in the SQL I get the correct records selected but this does not give me the flexibility I need
I'm in the middle of a project, I've got the bulk of it working but I cannot work out how to get my variables to modify the SQL query properly, I'll try and explain. GUI has 5 search fields Q1, Q2, Q3, Q4 & Q5 with 4 checkboxes that denote AND / OR operators that need to be inserted into the query correctly. If they are all set to 'AND' it works fine. However if the user wants 'Q1 AND Q2 OR Q3' then it fails. If I hard code then I just user brackets ie '(Q1 AND Q2) Or Q3'. For some reason I seam incapable of working out the code to achieve this...
Code snippet: 'Check AND OR Checkbox and assign Operator If Q1AND.Checked = True Then Q1Op = "AND" Else : Q1Op = "OR" [Code] .....
I made a UpdateCommand for my dataadapter in my MySQL connection. [code]Is there a way to link these up parameters to variables or textfields? Cause I want the value from a textbox to be the value of tabText.
Well I am a new to VB.NET, converting a legacy system to .NET world. Recently I have been reviewing the already existing code since I joined the project quite late in the team. I find that there are many shared functions (not shared class) inside many classes. I doubt this may create some problem if two requests ( i.e two different HTTP request to the same method as it's a WCF application, of course exposed methods are not shared but internally called methods are shared) comes to the same shared method and both the calls to the method may have different method parameters/arguments, overwriting each other's arguments. In short, if shared method has a list of arguments which is going to be processed, is there any chance of inconsistencies in the light of multiple access to the shared method via two http requests.
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?
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
We have recently updated our SQL Server to 2008 (from 2000). I moved all the data over to the SQL 2008 server by exporting from the 2000 server. All the tables open just fine, and all the data appears to be present. Within the VB.NET app, however, any table reference that uses a parameter generates an error: The data types text and text are incompatible in the equal to operators. The table adapter works just fine with full table previews, but not with either parameters or filter values (i.e., Field1 <> '0'). I should confess that I am new to SQL 2008. What do I need to do to get these parameter queries operational?BTW, I have downloaded and installed the VB2005 plugin that enables working with SQL 2008 (VS80sp1-KB954961-X86-INTL.exe).LDC
There is not a VB.net database forum, and there is a HUGE difference (unfortunately) between ADO and ADO.net. I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie
Using cmdExe As New System.Data.SqlClient.SqlCommand sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')" .CommandText = strSingleSQLLine
[Code]....
There are two questions here actually...can I add the parameters before setting the command text, and do I have to add the same parameter over and over again?
I need to be able to start with Form1, move to LoginForm, then back to Form1 taking 2 variables and the "values" they have in the LoginForm back to Form1 and using the variables. I start with the main form (Form1) and have the user enter some information. Once they click OK I have the LoginForm open. After they enter their credentials I will check to make sure they are legal users, then go back to Form1 (here is where I need to take the Username and Password with me) to log onto a server using the same credentails from the login form.
I've recently ported my website from 2005 to 2008, and I'm using LINQ Queries to implement a search. The issue is that none of the fields are mandatory, so I've had to implement a dynamic LINQ Query (sic?). Here's the relevant code -
Public Function searchQuery(ByVal titleType As String, ByVal titleName As String, _ ByVal configMgr As String, ByVal lifecycle As String, _ ByVal CIType As String, ByVal recordsPerPage As String) As IEnumerable(Of
I've got a couple of drop down lists for languages. I bind them to a language list that comes from a query. Then the fields are also bound to the row in the DB they relate to. I have several panels with the language drop down - each "tied" to a different table in my DB. When I call up different records on the same panel the drop downs immediately "set to the position" of that rows language in the list. But when I call up another panel - tied to another database table - I see that language in the drop down.
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
I am new to working with SQL databases (and databases in general) so I do not have a lot of experience with how queries work and how I can practice them. When I was first learning xml and XPath, I found XPath Visualizer incredibly helpful after someone on stack overflow mentioned it to me.Due to this, I am wondering if a similar tool exists for SQL databases?Basically a tool that will allow me to connect to a database,enter queries and see somehow what the results would be like.
I have looked online a bit, however I have found relatively few options in terms of any utility that would do what I want, and that looks reliable.I will ultimately be writing an application to interact with an SQL 2008 server in vb.net, however for now I am just experimenting so I will know what I am doing when I actually want to create my application.So far I have managed to connect to the database using an OLE DB connection, but I am now looking for a way to experiement with queries without just querying and figuring out a way to interpret the results in my program. Basically I want to be able to remove the programming aspect of things so I can experiment with queries without needing to question anything in my code that is unrelated to the specific query.
I've been trying to pass two parameters to my report using code the two parameters are DateTime type, my problem is crystal report viewer is still asking for the first parameter only and it accepts the second one?! in my report i've used two parameters ?firstDate and ?secondDate as dateTime parameters and used them in selctionformula where the date is between the two paramters.[code]...
I need to call a function that expects a DataType as a paremeter. I fail to get the right syntax to specify a datatype (integer, string, single, boolean, etc):
Public Sub AddSetting(ByVal PropertyName As String, ByVal PropertyType As Type, ByVal DefaultValue As String) Dim p As New SettingsProperty(PropertyName) p.PropertyType = PropertyType p.DefaultValue = DefaultValue [Code] .....
I am working vb.net08. Access Db. I am sending my below code for refference. Actually i am getting error when i am sending values from datatable to Temp Table in the Access Db. Error is : "No value given from one or more requaired parameters". In my datatable name called 'Crosstab1' few columns having text type and few columns having Value type. So i am getting error while i am Inserting values into Temp Table Called 'Official'. My Code is:
Dim connStr As String = "connection string goes here" Dim conn As New Odbc.OdbcConnection(connStr) Dim comm As New Odbc.OdbcCommand("insert into mytable values (0, @P1, @P2, null, @P3, 'n')", conn)
[Code]....
I get "A syntax error has occured." It appears as though my parameters aren't getting replaced with the values I'm telling it to use.
we are suposed to create a program that we like with certain peramiters, I have done as much however I have an error and I can not find a solution anywhere. We are, before you ask, able to seek help on this matter. Here is what I have:
I cant seem to find a solution on how to pass parameters to another exe like adding some parameters after path in shortcut, and then launching that shortcut, only I want to do it directly without making shortcuts. So ,how would I pass parameters needed to start another exe (console in my case)?
[code]That code will add a new DropDownItem everytime I click on it, then everytime I click on those new created items it calls my "aa" function. How to I set this up so I can send a parameter? It just needs to be a single int parameter.
i've got a database with a table called Customers, and i've created a form so that i can edit the customer details and update the database. However when i click the update button, it doesn't work and keeps coming up with the error which i've put in the title.
Private Sub btnupdatecustomer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdatecustomer.Click If MessageBox.Show("Are you sure you want to update your details?", "Save", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then Dim intPosition As Integer
[code]....
The bold/underlined text is where the error is coming up.What am i doing wrong? I've got a feeling it is something really stupid as i modelled the code on an example project that a teacher gave me, so it's practically the same code except for the field names etc.
