set the selection criteria using combobox, but there is a possibility to select "All Items" option. There are more than 2 combobox selection.
Code:
strSQL = "SELECT nama from GridView"
Dim da As New SqlDataAdapter(strSQL, oconnection)
Dim ds As New DataSet
[code].....
My project consists of a user interface designed in Visual Studio 2010 Express. I have it linked to an Access database. At this time, I have two text boxes that the user will enter a number. I want to be able to write a query that will take the first and second number and pull the information from the database that is equal to or greater than the user entered number
View 6 RepliesUpon entry into my database, frmLot opens. The form opens in datasheet view. It displays several fields to include one named WorkOrder. The user clicks in the cell named WorkOrder. In the On Click property, I store that variable and name it stWorkOrder. What I need to happen then is to pass this variable to the criteria field of a query named qryWorkOrder and have it run and display results.
View 1 RepliesI have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
I have database with table called "Konzultacije" with field "Vrijeme" (Date/Time). I have datagridview (DGKonzultacije) with columns. Column (1) data format is set to date/time. I want to delete record from "Konzultacije" table depending on selected cell in datagridview but only I can get is error.
This is my code:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = " & DGKonzultacije.CurrentRow.Cells(1).Value
conn.Open()
[CODE]...
If i add apostrophe like this:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = '" & DGKonzultacije.CurrentRow.Cells(1).Value & "'"
error is raised: Data type mismatch in criteria expression.
I want to retrieve query from MS.Access database criteria is between some date range,but I get the following error when execute my reader:Syntax error in date in query expression 'D_ate BETWEEN # @DateFrom # AND # @DateTo #'.
Dim StrSQL As String
StrSQL = "Select * from Pla_Comp Where D_ate BETWEEN # @DateFrom # AND # @DateTo #"
myCommand = New OleDbCommand(strSQL, conn)
[code]....
This is the code
Imports System.Data, System.Data.OleDb
Public Class Form1
Public CON As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" & Application.StartupPath & "\bible.mdb")
[Code] .....
I got that Error for
data2.Fill(ds1, "Bible")
Data type mismatch in criteria expression
the combobox1 value is numbers
I tried this code
Dim sql1 As String = "select distinct ChapterNum from Bible where BookNum ='" & Trim(ComboBox1.Text) & "'"
And this code
Dim sql1 As String = "select distinct ChapterNum from Bible where BookNum ='" & Val(ComboBox1.Text) & "'"
And it still got the same error.
I am trying to find a way to use a month calendar control as an object data source, such that when end user selects a given date, or a date range (1 week max), it will supply the date range criteria for an access query, and the results will wind up displaying in a data grid view below the month calendar. I am having a really hard time..
how to write the date criteria into the access query for something like this
I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I have three controls on my form; Textbox1, cboCity, lstCity When something (lets say "a") is entered in the TextBox1; I want to get each and every item in combobox cboCity that starts with "a" and add them to listbox lstCity.
View 5 RepliesI have a combobox on a form. It works but I want to filter it with a constant value. I don't want to change the query in the dataset because that would affect other programs. So I click on the little arrow on the combobox in the form design view and then click on Add Query and make my new query which I preview and it's okay. The problem is I can't find any way to make the combobox reference the new query. In the properties for the combobox the Data Source is just the binding source. How do I specify a specific query?
View 3 RepliesIn 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.
I am having a problem with filling a combobox with unique values.Im not very good at vb either so I will explain what I have done so far.
1. I added a combobox to my form called Combobox1
2. I clicked the little triangle widget thing on the ComboBox1 set the dataset to MyDATASETDataSet1
3. Display Member: CurrencyCountry, Value Member: FCode, Selected Value = None
4. I fill MyDATASETDataSet1 when the form loads using:
PricesTableAdapter.ComboBoxQuery(CurrencY_DATABASEDataSet1.Prices)
ComboBoxQuery =
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]
The form does not load, i get the error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.If I replace ComboQuery with Fill Query (which is the default fill command) it displays results....but not unique results, i see the same items being repeated throughout the list in the combobox.I guess my questions are:
1. when you fill a dataset do you need to select all the fields when you are creating your query?
2. if i simply wanted to perform the following lookup:
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]and set the combobox Display Member: CurrencyCountry, Value Member: FCode how would I do this in the code?
3. how can i change my query to display only unique values, distinct doesnt seem to be working?
I'm trying to fill combobox with my SQL query result.[code]...
View 2 RepliesI am trying to fill a combobox using the results form a query to combine two fields (first and Last name). I cannot seam to get to the query through the table adapter. I can set the binding source and select one of the fields to fill the control but I cannot get to the query's.
View 2 RepliesI have added a query to my form using the sqlDataAdapter object and the wizard.Now I want to show the result of the query in a combox on my form.The combobox is not binded to a data source, but is going to be used for searching a record (but this is for later)
View 10 RepliesI am new in vb.net 2008.I want to populate items of a combobox with a result of a query that may include join or not.
View 3 RepliesI have a problem with search query im using combobox for searching in my code there's is no error.but nothings happen when i search this is my code:
Public Sub searchdata()
Try
SQLCONNECTIONS.connect()
[code]....
I'm designing a login screen which MUST allow the user to ONLY select a login via a combobox. A user has THREE login attempts only, the problem Im experiencing is resetting the count if they hilight the combobox, move the selection around but ultimately click on the original name.I can use either SelectedIndexChanged or SelectionChangeCommitted but they are both activated even if the same login is selected.So you can select a login enter the password twice and then click on the combobox move the selection around before finally clicking the original name and the login count is reset to 0.Is their a way to do this without using variables to store the previous value (perhaps using validating/validation methods)?
View 4 Repliespopulate a simple combobox with a query to a MySql database. I Just want the combobox to show the results of the query:
SELET DISTINCT models from Cars
I am using VB 2008 with Datasets, how can I achieve this?
There is a connection in my program to SQL Server and there is a query which is bound to a combo box, to pull out values from the database. For some reason, I get an error message during run-time, saying that the syntax is incorrect.
Here's the query:
'The SQL Command to be executed:
projs = New SqlCommand("use " & Me.ComboBox1.Text & "''" & _
"go" & _
"select name from projects where condition = 'Y'", cnn1)
cnn1 is the name of my SQL Client connection.
How to Find data using a combobox? I make a code to search or find it's work but cannot find the data..this is my code:
[code]...
but when i try using a textbox it's works.
I have 2 tables: locations and depot:[code]I have 2 forms, frm1 and frm2. Frm1 has a combobox, cboLocations which pulls from the Locations table. Frm2 has textboxes which populate based upon the location selected from cboLocations on frm1. Frm2 also has a combobox, cboDepot, which pulls from the Depot table.So far, I've been able to get cboDepot to populate with the first depot_refnbr. This is not the corresponding depot_refnbr that matches with the selected Location; it is just the first depot_refnbr in the Depot table.I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
View 11 RepliesIs it possible to use LINQ to query the items collection of a ComboBox & get the index of the item that matches what I'm looking for?
View 4 RepliesI would like to combine the two things in the title to use as a query for an access database. I think i kind of know what to do, but then it doesn't work so i actually dont, the error i am getting in runtime is that the query is incomplete. The line of code in question is this:
Query = New OleDb.OleDbCommand("Select key From '" & frmFrontEnd.cmbModel.SelectedIndex.ToString & "'_Assistant", AccessConn)
I am tring to bind a data to listbox with where combobox.selectedvalue. My code is below; I am using data entity in wpf project;
Class Window1
Dim db As New AdvanceEntities
Private Sub Window1_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded[code].....
Also I need to create a query with Join In statement. I need to get two table in one query, they have same values in USERID collumn.
I have set the combo box dropdown style to dropdown, the auto complete mode to suggest append and the auto complete source to list items. This works fine IF I choose the required item using the mouse. If I type the full item name into the combo box, it is displayed but not selected for use. Is it possible to use a key such as TAB or Return to select the item in the combo box's display area after the drop down window has closed?
View 11 Repliesfollowing issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
i'm trying to populate a simple combobox with a query to a MySql database. I Just want the combobox to show the results of the query:
SELET DISTINCT models from Cars
I am using VB 2008 with Datasets, how can I achieve this?
I'm trying to populate a combobox from another combobox
There are two comboboxes involve:
1. comboSupplierID
2. comboSProducts
[code].....