I am using vb.net and mysql as the database. I have created a field containing the abbreviations of words. My vb.net form provides a combobox which I want to connect to the field abbreviation. I want to configure the combobox so that when clicked, all the acronyms that exist in the database appear in the combobox.
View 1 RepliesBrand new to VB 2008 Express, but have done some work in VB 6. Not sure what I'm missing, but here goes. I have two comboboxes linked to an Access 2007 database. One box lists the names of the States in the US.
This is what I used for the Table Adapter Configuration Wizard for the combobox "State" SELECT ST_UID, ST_NAME FROM STATE
For the combobox County I used: SELECT ST_UID, CTY_NAME FROM COUNTY ST_UID is an Integer.
I created a label with a bound value to STATE.ST_UID so that when a user selects the name of a state from the State box the appropriate ST_UID populates the label, (i.e, California has an ST_UID = 5).
The problem is when a state is selected, I only want the Counties for that state to appear in the County box, i.e, COUNTY.ST_UID = 5 if California is the selected state.
I then tried to convert the value in the st_uid label to an integer:
CODE:
This is what I last tried when again using the Table Adapter Configuration Wizard for the table that populates the County box: SELECT ST_UID, CNTY_NAME FROM COUNTY Where ST_UID = 'StUID' Order By st_uid, cnty_name
What I'm getting is a "Data type mismatch in criteria expression." I'm sure my error is something so simple.
I created a contact list application that loads a .txt file into a combobox. I need to then sort what's in the combobox, but I can't.
Imports System.ComponentModel
Imports System.IO
Public Class Form1
Private DG_contactsBlist As BindingList(Of String)
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DG_contacts As New List(Of String)
[Code] .....
I have a pretty weird one here, would it be possible to read a column of a text file in to a combobox and to display the directory after the contents of the combobox?[code]...
View 7 Repliesgetting a scrapped list from a website into a listbox. I now need to use the contents of that listbox in a combobox and am going nuts. I have included the code
[Code]...
Can someone tell me why this code works exactley the opposite of the way I thought it should?
[code]...
I have a combobox (cbKeyWords). I want to make sure tbAddEdit.Text does not already exist before I save. To me I should be testing for a False result not True. But the above code, goes to the msgbox if findstringexact=false and saves the data if it's true.
why this code works exactley the opposite of the way I thought it should?
[Code]...
I have a combobox (cbKeyWords). I want to make sure tbAddEdit.Text does not already exist before I save. To me I should be testing for a False result not True. But the above code, goes to the msgbox if findstringexact=false and saves the data if it's true. Am I crazy or am I missing something? Shouldn't FindStringExact return false if it's not found?
I have a form with a combo box and a checked list box. When I select one item in the combo box, I want the list in the checked list box to change to the appropriate choices.
View 19 RepliesA simple form with a combobox called Combo, drawing artifacts when using ComboBox with Custom Draw and the contents of the combobox is scrolled up or down, and with this source code, illustrates the issue:
Public Class Form1
Private Sub Combo_DrawItem(ByVal sender As Object, ByVal e As System.Windows.Forms.DrawItemEventArgs) Handles Combo.DrawItem
Dim Combo As ComboBox = TryCast(sender, ComboBox)
If Combo Is Nothing Then Exit Sub
If e.Index = -1 Or e.Index >= Combo.Items.Count Then
e.DrawBackground()
[Code] .....
I have a combo box that's filled from a query in the database. If I add a field to the database, the new field won't show up in the form until I close it and reopen it.
So, how do I refresh the contents of that combo box?
I bound the data onto the combo box like this:
[Code]...
I am currently pulling data from a database into a comboBox. My intent is to have the description of the selected option in the comboBox displayed in a listbox. How to i get this data to be displayed in a listbox?
Here is the code that I have so far:-
Imports
System.Data.SqlClient
Imports
[code]....
I am new to the forum and to VB, and not great at coding in general.I am learning, and this site as well as others have helped me get farther than I ever imagined. Second, my project is purely for my benefit, so I can learn.There is no corporate or school related goal here, just trying to learn.So the title is a summary of what I want to do. I have a form with a combo box that has five different choices, and below it, a checked list box. What I want is the collection inside the checked list box to change depending on what I select in the combo box above it.For instance, I have room 1 - 5 in the combo box, and the the checked list box below it, I have the furniture associated with that room.The eventual goal is to have this form populate a database, that allows the checked furniture to be recorded in a record.
I assume I need to use a db, such as access, to list the "furniture" in each room, and have a different table for each room, where the combo box selection will populate the checkedlistbox from the appropriate tables contents.I need a step by step on this, because I am a bit of a brick. Most tutorials are also done in VB 6 or VB 2008, and there have been steps missing in association to VB 2010.
I have a database set up with 2 fields, FirstName and LastName, and i want to display both of them in a single combo box. Right now its only displaying the first name:
[
Dim dtFishermen As DataTable = objDS.Tables("fishermen")
Me.cmbFishermen.DataSource = dtFishermen
Me.cmbFishermen.DisplayMember = "FirstName"
Me.cmbFishermen.ValueMember = "id"
Everything works fine, im just looking for it to display "FirstName LastName" instead of just "FirstName"
finding a solution on how to save a four level treeview on each table in the database? each level must be saved in the table w/c includes their parent-child relationship.
[Code]...
how to get my data out of access and to a data grid. What i want to do is, edit this data in the the data grid and save all alterations to the data grid back to access. There must be a command which copies all the contents of the data grid back to the access database??
View 6 RepliesI have been trying for days to work this code. I want to transfer the information from a listbox to a table in an access database. The listbox gets its information from a text file using stream reader. My code so far has produced an error at the NewRow Method. I am using VB.Net 2010
[Code]...
I have a queue and i could copy it to an array. How can i save the contents of the array or even queue to Mysql database
Public waiting As New Queue(Of String)
wait.Enqueue(InputBox("enter patId..."))
dim waitArray(waiting.count-1) As String
waiting.copyTo(waitArray, 0)
I have searched google and youtube for a tut on this but cant seem to find any :/I have a script that adds contents of textbox1 ans textbox2 to a online mysql database like username and and password.All this works perfect What i now need is to display the contents of the given database in a listbox or something.How would i go about this or is there any good tuts on this, all i seem to find is tuts using ms database not mysql
View 6 RepliesI have some code which scans my Database for the table names and displays them in a listbox (ListBox1). Later on when the user selects the desired option(Table) in the listbox the code gets the text which the user has selected at loads that table into a Datatable.
DataDataTableAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM " & ListBox1.Text, DataBaseConnection)
However I recieve "Syntax error in from clause"
I am trying to create an application that adds the contents of a till to a database. (Does this on two forms into two different sets of db columns) and can pull that back up at a later stage. At the moment, I'm stuck at the first section?
BODda.Update(BODds, "Data")
Is where I get an SQL error stating:Syntax error in INSERT INTO statement.I have not been able to find a way to insert via SQL?
I am trying to display the contents of a table from an Access 2007 Database inside a List-view Box.I am using a Combo Box to select the user I wish to see the details about:
Private Sub Admin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ReadUsers()
[code].....
i have sql 2005 and i want to develop a small program that can access the database and amend a few rows of data. in sql database, i have 1 table and it consist of 3 columns = datetime, type & price. below is example:
[Code]....
Any examples of of windows forms that interact with access databases in vb.net. What I creating is a form where you can enter data to a database and delete if need be. But display the contents of a database in a table or tree.
View 2 Repliesi have an array of booleans whose current boolean values I want to preserve but add additional length to the array? How can I achieve that? My code looks like this:
Dim Array() As Boolean
Dim ArrayInterimShort() As Boolean
ReDim Array(119)
[code]....
I am trying to create a code where I placed sets of numbers in an array.I'll use a masktextbox to have the user enter the numbers to match what's in the array. If the user enters the number, ex: social, and the data is correct (matches the numbers in the array), something happens if the number entered in the masktextbox does not match any of the number sets in an array then another thing happens.The masktextbox so far only validates format and gets number only, however, I want the number entered to match whats in the array.
View 1 RepliesI need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI have been staring at a blank screen for over an hour trying to figure out the best way to build this app. We have a warehouse with consumables. These consumables are stored on racks that are three rows high and 15 columns long. I need to display the contents of these racks with the following; Item nameUnit quantityUnit expiration date
Now while this in itself would be a simple thing, I need to . Take a look at this image, the lower portion of the image shows basically what I want to display as far as the form goes. Instead of the "Row 1-1-1" text, I want to show the item, qty and exp. There are multiple rows. It should also be noted that each location may have more than one item stored in it, and there might not be anything stored in it. So I guess my question is, from a design point, is it better to create a small table for each location and then join those tables to a main "Row" table since there will only be a single row displayed on the form at a time? How would it be possible to keep the data properly ordered from a coding perspective? How can I ensure that each storage location remains static unless the item is moved?
How to display contents of ms access database form on a form using vb .net...in visual studio
View 7 Repliesi have some difficulty in displaying records from database to my combobox here is my code in the form_load
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:UserslitoDocumentsQMP_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]....
I have here a combobx1 that has a value of Mr.A and Mr.B. want that if i choose from my combobox1 the selected value will go to my sql database.
View 2 Replies