I have a combobox which contains few objects in Items. When the user selects any item from the combobox the values from the Object member variables are stored in the textboxes on the form.The user will change the values in the textbox and then he will select another item from the combobox.
View 10 Repliesi want to display two values from two columns of same database table..i could get only single value..eg...i want to display emp_name and emp_id in the same combobox...i dun want to use another combobox for emp_name...when displayed it should be like "emp name=XYZ and emp id=E123".
[Code]...
I have a DGV bound to a bindingsource with a column that uses a DataGridViewCombobox, that has a DataTable for it's datasource. This all worked fine at first.But I removed a row from the DataTable that the DGV combobox uses as its datasource. Now when I try to load the form that contain the DGV, I get an error "DataGridViewComboboxCell value is not valid" for each row that contains the value I removed from the DataTable.It seems the value of the column must be a member of the combobox Listitems. Is there a way to allow values not in the combobox ListItems. I don't want the combobox listitems to be locked in for the life of the application.
View 2 RepliesHow do I get the other values of the selected item of the combobox so that I can save it to my table? This in my function
Using cmdTeachers As New SqlCommand("SELECT TeacherID, Teacher, Dept " & _
"FROM tblTeacherFile " & _
"WHERE Dept = 'HS' ", cnn)
And I have this on formload
Me.TeacherBindingSource.DataSource = Me.GetTeachers()
Me.TeachCombo.DisplayMember = "Teacher"
Me.TeachCombo.ValueMember = "Teacher"
Me.TeachCombo.DataSource = Me.TeacherBindingSource
I would like the user to enter positive numbers (decimal or whole numbers but no fraction) using combobox. However the user can only enter the numbers using a number key pad built in the combobox. The number key pad will appear once the user click the down arrow of the combobox (I am not sure if there any predefined feature built into vb.net 2005 that has this property). The number key pad should contain the numbers 0-9 and decimal(.).
View 2 RepliesI have a combox and a datagridview on a form, the combox filters the datagridview but doesnt have Distinct values. I found this on one of your post. I have a Products DB Table with ProductID, Series, Description and UnitPrice, I am trying to filter the the datagrid using the column Series with the combobox but i get multiple values of the same thing in the combobox, where i would like to make it Distinct.[code]
View 6 RepliesI have a program that reads a database file(.csv or.Txt) then allows user to select data from 6 different comboxes and taext boxes are then populated based on the selection made from combobox
I would like to be able to give the user the option to save their settings so next time the program is open it will connect to the same database as the last connection and also have comboboxes go to the last selection Do I have to create a save setting value for each combobox? and the connection string?
is there a simple way to just save everything? so when the program is open it goes back to the last time it was open.
My code below will save records to my database as long as all the parameter have values. One of the parameter is @MI (middle initial), however, there are times that student have no middle initial so when I click my button I get error. I want to still save the record even if one of the parameter value is missing.
[code]...
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
lets say I have a form (form1) with lables a-z which are all designed with default text "0". So they all show 0 on program startup. which is fine. I also have a dialog with 2 TextBoxes; I want my program to update the default text/value on (only)form1 labels x, y and z to whatever was put into the textboxes when i press the OK button on the Dialog, so these specified labels show the 'new' value on next startup. Is it even possible or should I save the values to a file which loads the values in the specified labels on startup?
View 5 RepliesI have filled a DVG with information and added another column to index(8) pragmatically Now i want to create a combobox with values depending on values in other cells on the same row so each row will have a combo box with different selections. below i have placed the code and hoped someone would have some input on how to approach this. i have tried datagridviewcolumn but that fills every row with the same information regaurdless of a if statement
[Code]...
I have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
I was useing VB a lot for some years ago and now I have started again..then, think I was useing VB3 or VB4 there was a property on ComboBox and listboxes that allows only to select the values in the Combox.. Not able to write own values..
View 1 RepliesThis is so confusing, i've been trying all day but it doesn't seem to work.
IN my database i have Vendor tables, i have 2 records
VendorName
a
b
I'm trying to get the comboxbox to get "a" and "b"
[Code]...
I have an XML file, and a ListView control shows the data through aDataGridView control as shown below.Now,This Japanese web site helps me understand how to get cell values.And I'm trying to populate ListBox and ComboBox with the values from ListView's
Column 2.
For j As Integer = 0 To ListView1.Items.Count - 1
ComboBox1.Items.Add(ListView1.Items(j).SubItems(1).Text)
Next j
[code].....
i am developing vb.net windows application. i have a combobox. In that i added items in its properties as follows
<- - - select- - - >
school
hospital
office
others
when i run my application i need to display the selected item as "<- - - select- - - >" but it display empty.....
Im trying to set values for every combox item for example if I have an item name of "currentyear" it should return the year.
View 4 RepliesI want to setup values for a combobox in vb.net through code. But I don't know what's the code for setting it up. I want to do something like this:
if combobox1.selecteditem="1" then
combobox2.values=("x", "y", "z")
end if
I display some values in a combobox that come from an array.By default the selected index of the combobox should be the first item.
If cboAtt.Items.Count = 0 Then
For i = 0 To nums(att)
cboAtt.Items.Add(cat(att)(i))
Next
[code]....
This works perfectly, but now I want the combobox to display the new (initial) value that is swapped, except than when I do that the cboAtt_SelectedIndexChanged event is triggered which results to an infinite loop --> crash.
Is there any way to type a value to comobox which is not on the list of item in the combobox I have tried but it always throws an exception
View 10 RepliesHere is my code.
for example TextBox1.Text= 12,34,45,67,67
Dim process_string As String() = TextBox1.Text.Split(New Char() {","})
Dim process As Integer
[Code]....
i want to add values in reversed order in combobox2 that are available in combobox1
but when i run the application the second combobox remains empty and not showing any value.
When I update but do not really made any changes to the value and press the update button, the data becomes null. And it will seem that I deleted the value.I've taught of a solution, that is to add both combobox1.selectedtext and combobox1.selecteditem to the function. But it doesn't work.
combobox1.selecteditem is working when you try to alter the values when you update. But will save a null value when you don't alter the values using the combobox combobox1.selectedtext will save the data into the database even without altering.But will not save the data if you try to alter it.-And I incorporated both of them, but still only one is performing, and I think it is the one that I added first:
Dim shikai As New Updater
Try
shikai.id = TextBox1.Text
shikai.fname = TextBox2.Text
shikai.mi = TextBox3.Text
[code]....
Iam making a web browser which consist a combobox as the address barso how to save any address will be written in it even after closing my app?
View 3 RepliesI am adding items to a combobox through user entry and need to save them, so when I close the application down, they will reappear when again opened.
View 7 RepliesI need people to be able to Add items to the ComboBox and then it will save it after adding so when it is reloaded it is still there! I just want it to save to the settings or something. No db or anything.
View 14 RepliesI'm using ms access 03 to fill a datagridview no problem. I have 4 fields(id, first, last, points), but I just want to fill one in a combobox I have. Here is what I'm using to fill the datagridview:
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsPC #6My Documentsstudent.mdb")
Dim sql As String = "Select first,last,points from student"
Dim oledbAdapter As OleDbDataAdapter
Dim ds As New DataSet
[Code] .....
How could I get a combobox to just display just one field, like idk if I'm explaining myself correctly, like a SQL statement look like this:
Dim sql As String = "Select first from student" but just for my combobox.
Is it possible to have a different selection of values in the 2nd combobox depending what was picked on the first combobox? For example an American state is picked in the first combo box and the second combo box loads the cities in that state? I'm just using a basic form in Visual basic 2010 there is no database behind it.
View 6 RepliesMy code is:
sqlsub = "SELECT distinct field1, field2"
sqlsub += " FROM tbl I
Dim da As OleDbDataAdapter
Dim lsdataset As New DataSet
[code].....
My prob is how should I bind the combo with field1+"("+ thpr+ ")" thpr is the string i get from function by passing field value 2 from query my combobox should be displayed as field1 + (thpr).
I want to check if two combobox values are equal. The comboboxes are in a datagridview.I found you need to use datagridview_EditingControlShowing to add a handler to the comobo boxes for selectedindexchanged. I can do this with this code.
Code:
Private Sub dgridRegisters_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles dgridRegisters.EditingControlShowing
Dim combo As ComboBox = CType(e.Control, ComboBox)
[code]....
However, the message box comes up for every combobox in my datagrid when I change the index, not just the cmbPort2. I would like to have something like this...
If cmbPort1.selectedindex == cmbport2.selectedindex then
'do something
endif
..but it doesn't seem possible.
How I could go about checking a typed value in a combo to the values in the combo box. I am making a system to select lockerID and Supplier ID I want the user to be able to enter the value in the combo box as well as select the value form the list in the combo box. Here is the code I have been trying.
If cboStockID.Text = "" And cboStockID.Text <> cboStockID.Items.ToString Then
MsgBox("Please enter Stock ID")
Exit Sub
ElseIf cboSupplierID.Text = "" Then
MsgBox("Please Enter Supplier ID")
Exit Sub
End If