Can someone tell me what's wrong here: Dim sql As String = "SELECT * FROM courses" Dim con As New MySqlConnection Dim dt As New DataTable(sql) Dim cmd As New MySqlCommand(sql, con)
con.Open() ComboBox1.Items.Add(dt)It doesn't show the courses.
I am creating a form for entering technical data about a part into an Access database. In the same form I have several ComboBoxs that need to have their lists filled from the same reference table in my database. I have a number and unit field for the twist and bending radius properties. I made the unit fields ComboBoxes and I am trying to bind them to referance table in my database called UnitsLength. The relevant structure is as follows....
Form: NewPartForm
Database: CableDataSet
Main Table: PartMechanical - with fields: TwistNom, TwistUnits, BendingRadiusNom, BendingRadiusUnits
Reference Table: UnitsLength - with fields: Unit, Shorthand, Conversion Factor
First tired the following settings....
Data Source: Other Data Sources > NewPartForm List Instances > CableDatase
Display Member: UnitsLength.Shorthand
Value Member: UnitsLength.Unit
SelectedValue: PartMechanicalBindingSource > [The associated unit field]
But the lists didn't populate.... Then I tried these settings
Data Source: UnitsLengthBindingSource
Display Member: Shorthand
Value Member: Unit
SelectedValue: PartMechanicalBindingSource > [The associated unit field]
But now every ComboBox displays the same value but still stores the data in the proper field... it just sets them all the same.
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
I have a simple app where I am trying to fill in a bunch of fields (Client Info). The controls are bound to a DataSet (ClientDS and the table I need is Clients). I have a data navigator which should allow me to scroll through the selected info for each client. I have the following code
[code]...
The problem is ... it won't accept the Clients in (ClientDS.Clients). ClientsDS is the existing dataset I've created and to which the controls are bound..
I have two comboBoxes, one is CountryCombo and second is StateCombo.What I want is the that when i the clicks country combo and select a one country then the States of that the country should get populated in the State Combo.I have tried things many many many but nothing working. Below is my code of how my CountryCombo is getting filled.
query="select CountryName from CountryMaster"
if dr.hasRows()
{[code]......
How to fill another combobox depending on the value selected from first combobox?
View 2 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
Example table:client_id <= auto incremented valuefirst_nameIf you have a combolist that is generated with a list of data that includes client_id and first_name, but if the combolist is displaying the first_name. How can I pass the client_id of the selected item to a function or something?
View 1 Repliesim having problems with the project i was assign, so im supposed to make like a retail store POS, where i look for the articule and add how much did they take and the price.
So this is the main window is attached to this post [TEX]MAIN.JPG[/TEX], so my main problem is that im supposed to copy all the info from the top combobox and textboxes to the datagrid and so the first item it does enter it ok(well thats what i think) and when i try to enter the second item it just refresh the first item So what im expecting is that the datagrid makes several entries so that after that i can transfer all of that to a database registering the sale.
So this is the code of the button that inserts the article to the datagrid
Private Sub ACEPTAR_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ACEPTAR.Click
TEST1.Text = "Aceptada"
[Code].....
I finally got my last project done and Im updating it and making it more efficient. So instead of DGV to list users what Ive done is using a combobox to list the agents names in the database. I got that part done and I have that table as the datasource for the combox and that part works fine. However Im wanting when they select the Name from the combox it gets the values from the columns and displays them in the appropiate area. Ive tried like SELECT PhoneID FROM agents WHERE Agentname =" & comboname.text, but I cant get it to work that way.
View 4 RepliesI want to fill the both combobox in this website [URL]
I can fill the main category but I cannot fill the subcategory, I already tried but I cannot.
I would like to fill a textbox with my selected text in combobox. Could you tel me which code I have to add to following code? [Code]
View 3 RepliesI am working on a desktop application, and in my application i am using combobox in 2 ways:
1. directly on the form, and
2. as a column in the grid.
This is how i have to used it in my application: whenever i am writing anything or selecting anything in my combobox it should display a floating panal containing a grid having some extra columns which help me in selcting any value in combobox.
[Code]...
Okay so i have set up a database connection and got my combo box to fill from my table but it only fills with the first 4 records even though there are 5. There will be even more records depending on how many bookings are made so i need it to fill with all the records [code]...
View 3 RepliesI am trying to fill a combobox with data from an xml file. I have it setup on form load to call a loadXMLdata function. In the loadXMLdata function it reads the xml file. I would like to know how I would return each of the elements to populate the combobox. I have mostly done php work and in php i could do an array like this: array[book] = "VB.Net Programming". Is there a way to do something like this with an array such as xmlData("Server 1") = "255.255.255.255"
HTML
<config>
<connection>
<servers>
[Code]...
I know there are some things missing in my code like setting the counter integer.
I want to fill a combobox with the values that I have in a datatable. How can I do that? Below is the code for the population of the datatable:
[Code]...
I have 2 comboboxes. When I choose a country in cboLand I want only the states to show in cboStaat that are associated with the country from cboLand. I tried the code below but I get all different error messages. Perhaps you can see something in my code that I missed.
[Code]...
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 RepliesDo any of you know how i can filled the font color in a comobox and then change the color of the text in the textbox?
View 1 RepliesI have a form that has three comboboxes in it, cbxStudy, cbxMethod, & cbxAnalyte. When I call the form I load a data table and use that table to fill the comboboxes. I want to assign a value to cbxStudy, then fill cbxMethod by filtering the data table using the value in cbxStudy, then fill cbxAnalyte by filtering the data table using the values in cbxStudy and cbxMethod.
This code keeps failing when the forms New constructor is called, but once the form is loaded the code works great. I indicated below where the code is failing. It's failing because Me.cbxStudy.SelectedValue is = {System.Data.DataRowView} when the constructor is called even though I set the SelectedValue myself.
Public Class frmSelectMethod
Private cv_dt As New DataTable
Private cv_strPrevValue As String
[Code]....
I want to fill up a combo box with all the keys from System.Windows.Forms.Keys. My question is how can I do this?
View 6 RepliesMy DataGridView contains three columns, column types are checkbox, textbox and combobox.How can I load a row's combobox when the checkbox in the same row is checked?
View 1 Repliesi have the following code to fill two comboboxes using one dataset:
Private Sub sub_cbo_type_load()
Dim ds As New DataSet
ds = cls.cbo_type()
[Code].....
the problems is: whenever the index is changed in one combobox, it's automatically changed in the other one too.
I need my application to open an excel document and fill in the combo boxes, with whats in Column A, and then fill in text boxes with whats in Column b etc, but I also neeed to edit those textboxes incase I need to do any edits to the excel document, then click a button, and save those edits to the excel document.
View 3 RepliesI am using MS Access and i want to fill a combobox cmbFamily with data from a column called family in a dataset called availability and also a combobox called cmbModel with a column called model.
i have this:
cmbFamily.Items.Add(Availability.Columns.Contains("Family"))
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
'and
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
If you're not living on the edge, you're taking up too much room
White this code, my ComboBox while by fill, white data frome the database. Now i want to fill the TextBox, on basic frome the selection off the ComboBox
example,.. The ComboBox is filled white meat, in the database is there a price attached
Whene i make a selection in the ComboBox, thane must the attached price show up in the TextBox. My code works for de ComboBox, but not for the TextBox.
[Code]....
The code works fine, but I don't know if is necessary while sentence, maybe there is another option..
Dim CMD As New OleDb.OleDbCommand
CMD.Connection = otraConexion
CMD.CommandText = "SELECT * from procedencias"
[Code]....
this is the code in the webpage:
<select id="topic_id1" class="createSelect" tabindex="3" title="Choose a topic (the best that fits)" name="topics[]">
<option value="">Choose a topic (the best that fits)</option>
<option selected="selected" value="5887581">Arts & Design</option>
<option value="5887601">Books, Poetry & Writing</option>
<option value="5887571">Business & Work</option>
[Code]...
[Code]...
I'm making a combobox on a form. I want the combobox to have a list of choices from a table in a db. The two columns are a String and a Date. I want the date column to only show the year. I'm hoping I have the code right as it is above, but I'm not positive I've done the whole date thing right.