Microsoft Access queries with somecolumnname = [?] do not show up in the list of Views in the New DataSource Wizard in Visual Studio.
The query works perfectly from within Microsoft Access by just prompting for the values of the parameters.
The columns of the query should populate labels on my form based on the values in a couple textboxes.
What is the "best-practices" way to use parameter queries in my .NET application?
In VBE I have a combobox, a button and a listview.
SELECT * FROM table
WHERE description = @cmbDescription.text
My combobox has three items:
1 All
2 Item1
3 Item2
4 Item3
When user will select any Item the query will return the data related to that Item. My question is how to implement if user selects the option ALL in the combobox.
Can anyone see what I'm doing wrong in this
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.
I am currently working on downloading the data automatically on this page[url]...
I would like to somehow be able to control the URL so that, say, when I use the [URL]..
the option selected for Location parameter would be PJM and when I do[code]...
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
When I run this code :
Dim username As String = TextBox1.Text
Dim pass As String = TextBox2.Text
Dim con As New OleDb.OleDbConnection con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=""C:Documents and SettingsSaeedMy DocumentsVisual Studio 2008Projects
[Code] .....
I get these error message:
"No value given for one or more required parameters." at the line:
dr = cmd.ExecuteReader(CommandBehavior.Default)
what is the error.
I want to query items from countries that are selected from a treeview (with checkboxes). However the number of countries that is selected by the user is not known beforehand. So how can I make a proper query when the number of OR operators is unknown? For example: SELECT DISTINCT Item FROM Countries WHERE Country LIKE @c1 OR @c2 OR @c3 etc� and then add the parameter values based on the selected countries in the treeview. I looked into parameter arrays but can�t make sense out of it really
View 13 RepliesHow do I get Linq to ignore any parameters that are empty? So Lastname, Firstname, etc? If I have data in all parameters it works fine...
refinedresult = From x In theresult _
Where x.<thelastname>.Value.TestPhoneElement(LastName) And _
x.<thefirstname>.Value.TestPhoneElement(FirstName) And _
x.<id>.Value.TestPhoneElement(Id) And _
[code]....
I'm trying to bind a datagridview to a tableadapter which contains a query that requires parameters (for the WHERE statement of the query). The datasource is a SQL Server database. When I bind the datagridview in design view, it does not let me choose which tableadapter method I would like to use. The way I've been fixing this is to go into the code behind that form, where Visual Studio puts in some auto-generated code that fills a datatable in the dataset and I change the method that it's using there and put in my parameters. I don't think this is the proper way to do it, however, especially because sometimes that code doesn't even get generated! My other solution is to just programatically bind the datagridview to a datatable which I have filled using the tableadapter. This seems like more work than it should be, though.
View 5 RepliesI'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information.All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and that is the correct data type.But when I run the update query I get an error message saying something like values haven't been entered for some required parameters (my Visual Studio is the Spanish version, so I can't give the exact error message in English).The bit of code where the error occurs is inside the procedure called by my "Ok" button:
Dim campo1, campo2, campo3, campo4, campo5 As String
Dim campo6, campo7, campo8 As Double
Dim campo9, campo10 As Integer
[code]....
(I didn't post the whole code inside the procedure, but of course I'm creating the connection and everything)
The table has 10 fields, and the data is read from the textboxes and stored in variables (campo1, campo2, campo3, etc.), which I'm then using in the "set" query command.
"id" is the first field from the selected row in the datagrid, which I'm sending as a parameter to the procedure called by the "OK" button.The error message shows at runtime, so I'm guessing it's something in the query. Am I writing it correctly?
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have a search function de build.We are using pure ASP.NET w VB.NET We have multiple DropDownLists and we're building a search query with whatever was selected in those DDLs. My question is, how can I handle the blank values (unselected dropdownlist values) with the SQL Query ? I'm using AND operators in the query so if anything is blank it'll fail the search. If the dropdownlist has no selected value, i don't want the value to be part of the search. It would be easy to code with just 2-3 parameters, but we're looking thru at least 10 items and doing a SWITCH CASE or multiple IFs would soon become mayhem.
View 1 RepliesBanging my head against a wall here. I have a query that looks like this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE 'JOE%'
That works absolutely fine in query wizard and the DataTablePreview data window. However, when I do this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE ?
I get nothing when I run the fillby method. If I change the LIKE to =.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName = ?
Everything works great. I need to get LIKE working though so I can wildcard search.
I'm using the SQL server OLE db connections if that means anything.
UPDATE
Using the LIKE operator doesn't work at all. When I just swap out = for LIKE. Nothing is returned.
GOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
I have been posting almost 4 questions now where I have received 2 answers being solved. These are simple questions which any one familar with VB.Net can solve easily. Please understand, I'm a newbie to VB.Net.
Now my next issue is; I have a a form which has text boxes from where the user has to enter the data for the MS Access backend. I am getting the error as INSERT SYNTAX Error when entering the data and clicking the Save button. What is wrong with my insert statemnet below which is at the click even of the Save button?I desperately need to get this application working.
[Code]...
I have getting error while update the data to Access db from VB.NET. Which is shown "No value given for more required parameters". Here i have given the code what i have tried.....
con.open()
dim a
dim cd as new oledb.oledbcommand
a="update inward set Quantity=" & textbox3.text & "Where tool_name=" & listbopx1.selectedItemm & ""
cd=new oledb.oledbcommand(a,con)
cd.ExecuteNonQuery()
con.close
Trying to search a database from vb.net I have the following function
[Code]...
No value given for one or more required parameters. I found the code in a vb.net book someone lent me. It doesnt work at the moment and I wondered if I have everything correct the bit at the top in brackets (Phone LIKE?) is that saying check if there is a row in the 'Phone' column that is the same? Because I am also selecting Phone (the column) in that line? Later I say compare to Form3.Textbox1.Text so I am not sure whether they should both be 'Phone' inthe SQL line? Is it saying that If it finds something display whatever is in the details column to display in the text box?
I've got a program where the insert/update SQL was created with the values coded directly into the SQL string. I've changed this to use the Command's Parameters.AddWithValue method and all worked well. I'm now in the process of separating the data access code out into it's own class. I've got the Select code working using a DataSet in the form that I pass ByRef to my data class so it can populate or refresh it. My sticking point is in how to pass the parameters for the Insert/Update commands to the class since from the form I no longer have access to a Command object. Do I need to make the Command object in the data access class available to the form?
View 6 RepliesHow to pass a object that is initialized from a derived class to a method that has Interface as the parameter?[code]...
View 1 Replieswe 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:
[code]...
I am writing a program where the user has to log in before the program loads. Right now I have all the users and passwords hard coded into the program. Recently I have written a Oracle function that the username and password is sent to the DB and a yes or no is sent back after comparing the passwords. I am getting the correct response back and it will display in a label (I tried it to make sure the response is correct). The problem I am having is that the program after receiving the response doesn't recognize the response so I always get an incorrect password error.
Below is my code:
empName = tbxUser.Text
passWord = tbxPassword.Text
dbConn.ConnectionString =
"Data Source=!!!!; User Id=!!!!; Password=!!!!"
[Code] .....
If at all possible, how can my app detect the number, physical location, and size/resolution of monitors in use so as to define the program's parameters? Secondly, I have created a stopwatch variable ("Count"). I can't seem to get it to function properly unless using full seconds. In the following code, I have tried to use a fraction of a second (like .5) and using "count.elapsed.milliseconds = 500" and the program doesn't act like the code is even there...
Code:
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
If count.Elapsed.Seconds = 1 Then
Run()
End If
End Sub
I would like to create a console program in VB.net that would allow parameters. What i would like to do is in the code below add parameters so the webpart page can be created from the Run menu. e.g. C:.......MyProgram.exe "Design" --This would then create the Design webpart page.
I tried looking at the internet but was not very successfull.
Module Main
Public Sub Main(ByVal args As String())
Dim prj As String
[Code].....
Can I pass parameters back and forth between a Windows Service and .NET program? For ex: I want to pass a compressed/encrypted byte paramater to the Windows Service, who then decompress/decrypt it and return back the decompressed/decrypted bytes.
View 1 RepliesI need to insert a Flash movie in a Visual Basic 2008 express form and send parameters to the movie. The flash movie will plot points sent by VB in a graph.
I tried to insert the Shockwave Flash control in the form but cannot find it anywhere. So I inserted the webbrowser control, which I understand can be used to a similar purpose. But how would I send the values of X and Y (coordinates to plot in Flash) to the flash swf?
I am trying to bind my SQL param's qurey to bind to a table. My problem is i get this error "Fill: SelectCommand.Connection property has not been initialized."
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
If RadioButton3.Checked = True Then
Dim connectionGrid As SqlConnection = New SqlConnection("Data Source=BST;Initial Catalog=dsfs;uid=dfsdf; pwd='dsfsf'")
Dim commandgrid As SqlCommand = New SqlCommand()
[code]....
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:
[Code]....
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
[Code]...
I have a range of serial numbers in groups like below
ID NAME START Range ENDRange
1 eric 12340 12349
2 carl 56780 56788
Can I get VB 2010 sql query for access database that when I enter say 12342 in the textbox , it should return below in my datagridview since it falls in that range
ID NAME STARTRange ENDRange
1 eric 12340 12349