I am using a combobox which is connected by data source with a table. On this table I do a Select distinct with some filters. Everything is fine except the fact that when I click on the combobox and dont select a value the app hangs until I select one value.Sometimes I have this error, sometimes no.I call the value by the sub load:
[code]...
Let me try to describe my problems in the simplest way: I have combobox1 and combobox2. I hope to achieve two things: Combox1 is bound to list1 (a list of string). When a user selects an item in list1, list2 (a list of string) will be obtained from database and combobox is bound to list2.If user specifies text1 in combobox1 and text2 in combobox2, then these two values will be shown in the comboboxes regardless of the bound lists.
[Code]...
So the results of above code is that goal 1 is achieved, but goal 2 is never achieved. combobox1.selected index is always 0 and combobox2.selected index is always 0 too.
I got a DATASource connected, changed the table to details and draged it on to my form, but then it shows me the bindingnavigator at to of my form.
q1. how do i make it so every time this form opens it is like add new?
q2. how do make my own save button (don't want the binding navigator at top)
q3. in my form all my collums aper as textboxes how can i change it so there is a drop down menue that has forexaple 3 pre defined items that the user has to select on of.
I'm selecting a ListItem as I add it to a ListItemCollection. Then I use that ListItemCollection as a datasource for a DropDownlist but the Selected List Item is not being selected after databind.[code]...
View 3 RepliesI'm selecting a ListItem as I add it to a ListItemCollection. Then I use that ListItemCollection as a datasource for a DropDownlist but the Selected List Item is not being selected after databind. Here is an example of the code:
[code]...
I'm trying to get this to work so I can return only a list of items, instead of a list of items and the selected value. Is there a way to make the DropDownList select the selected ListItem from the ListItemCollection (or any other type of collection)?
Populating the combo box with the list of items from the one of the column in table from database.Based on the selection of item in the combo box, the another combobox should be populated with value corresponding to the selected item in the first combo box.[code]The problem with this code only the first row that is populate in the 2nd combo box.
View 6 Replieshow do i delete selected row from a datagrid connected to sql server database...?? Delete selected row and update database.
View 2 RepliesOk so i'm particularly new to this, just wondering. I have a combobox on a form, I have an array set up so the items in the combobox have values. The problem is I need to send the values from the combobox to a textbox from a different form. So basically how can I connect a combobox to multiple forms.
View 6 RepliesI have a combobox that is connected to a datatable with 3 columns. When i click a button i want 3 values from the selected item to be transferred to another datatable.The easiest way without any hassle to do this is via the Combobox.Text, Combobox.SelectedValue and....eyy nowhat?
View 8 RepliesI know this is a very basic question but it has been awhile since I created a project with a database( been using a lot of XML). I created a database then selected it as a data source added some controls to some forms. Then I realized I needed to adjust some tables and I needed to add a whole new table. I deleted the controls and updated the tables that needed some adjustment. Now I would like another table. Can I disassociate the data source and do my adjustment to the database?
Have I created a problem with the binding object since I just deleted the controls on the form. I have written classes and some logic or else I might just start over. I guess I could copy those files but I am wondering if there is an easy way to fix what I have started. I realize that there are alot of questions here so any resource on how to modify a database that is attached to a VB.Net project.
i have a remove button like i would like to delete just sigle selected row from both datagridview and the acutual database.the problem I am having is in deleting selected row.if i dont use the parameter the contents of the table gets deleted ,i dont have any primery key just an ID field (AutoNumber).
[code]...
How do i delete a row from datagridview and datasource that is populated by a class file?dding of item goes like this, but not not sure how to delete the item.
Dim dt As DvdEzyDataSet.DVDCopyDataTable = DvdCopyDB.getDvdCopyByID(CInt(txtCopyID.Text))
Dim dr As DvdEzyDataSet.DVDCopyRow = dt.Rows(0)
Dim dt1 As DvdEzyDataSet.DVDDataTable = DvdDB.getDvdByID(CInt(dr.FK_dvdID))
[code].....
I list folders in my combobox but I'm trying to sort the folders alphabetically and then numerically or vice versa.
My coding to populate my combobox is
With Combobox1.DataSource =
(From folder In New IO.DirectoryInfo("Path").GetDirectories
Select (folder.Name)
).ToArray
End With
Is it possible to sort the combobox?
I have folders that are numbered like 1, 50, 115, 189 etc.
These should display as
1
50
115
189
however they display as
1
115
189
50
I have defined a datagrid which has combobox in one of the columns, is there anyway to modify the datasource of the combobox (the source of the list) at run time?
View 2 RepliesI am trying to get the valuemember of my combobox but it just won't work. I have tried a lot of things (won't post them all here) can somebody just show me how to do this?
Private Sub cmbGroup_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbGroup.SelectedIndexChanged ' Get valuemember here End Sub
I have a ComboBox that is bound to a List(of T).Now I type-cast the ComboBox.DataSource into List(of T)and add some more elements in the List.The items collection of the ComboBox doesnt get reflected and the new element does not show up in the ComboBox. Am I missing something ?
View 3 RepliesPrivate Sub UsernameEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqlconn As New SqlConnection
sqlconn.ConnectionString = "stuff"
[code]....
The combobox just populates with "System.Data.DataRowView" I know it is some command to read the correct data out of the table, is it setting up something like:
dim i as integer
for i = 0 to CompanyNames.length-1
companyadapter.fill(companynames.rows(i)]
next
just curious what happens when i set the datasource of a combobox or datagrid or what-not to a dt then when i want to change what's in the combobox etc., i just set the datasource to a new one. i am cleaning as i go but just want to know what happens to the old datasource:
[Code]...
I have a combobox which i am binding to a sortedDictionary list, so it displays in ascending order. My question is, I need to display "--Select--" as the first option. Is there any way to either:
1) add another item besides for the datasource
or
2) add an unsorted item to the top of the sortedDictionary
I'm trying to use reflection with LINQ on a sub that set datasource of all my ComboBox:
Usual Method:
' ACAmp Panel
cboACPanelAmp.ValueMember = "IDACAmp"
cboACPanelAmp.DisplayMember = "Description"
cboACPanelAmp.DataSource = m_Entities.ACAmps.OrderBy(Function(c As ACAmp) c.SortOrder).ToList
Want to use that sub
FillCbo(cboACPanelAmp, "ACAmp")
Private Sub FillCbo(ByVal cbo As Infragistics.Win.UltraWinEditors.UltraComboEditor, ByVal entityName As String)
cbo.ValueMember = "ID" & entityName
[code]....
I can't figure out the last part of the last line, the LINQ
I have to add item "Final Grade" to my cboQuarter. The thing is, my cboQuarter already has a datasource and I can't add the item "Final Grade" during drop-down. The error says, "cannot modify or insert (can't remember word by word) when it already has a datasource."
View 4 RepliesI have a 2 classes, one is Employee, the other is Employees. Basically Employees is a collection of Employee, I have a combo box where the Datasource is Employees.
When the user selects a value from the combo box, How do I get an Employee object from whatever is selected?[code...]
It is an Infragistics combo box by the way.
Appropriate Title would be: Bind comboBox Tag to database.I have a comboBox on form which is bounded but and I need to populate it manually. With some reading on net i have found a way but it is not working
I can populate my combo, select item in combo, update database but the problem is when I load my form it displays empty combo (combo is fulled with my custom data but nothing is selected it must select correct ItemText) and after selecting a value in combo, the value disappears as soon as combo losses focus .
[Code]...
Is it possible to BOTH set a comboboxes datasource AND databind the selected value?Ihave 2 comboboxes on a form that I want to populate with data from 1 table,ut I want the actual selected values on each of the comboboxes to come from separate columns n another datasource Right now if one combobox changes, so does the other if that makes sense.
Here's a sample of code:
'Bind DataSource
With cboYields
[code].....
public Enum ClaimStatus
Ongoing = 0
Completed = 1
[Code]....
With code above, how do I assign the value to the combobox while retrieving data from the table so that it point to the corresponding combobox item. For example, if the value of status_ID is 1 then the combobox should show "completed" in the datagridview.
I am using code similar to this to populate a combobox with items from a database. The display works fine, but when I try to get the combobox.SelectedValue it is returning a DataRowView, where I need an integer. Obviously this is becuase I haven't casted the value to an integer, but the function, CInt(cboPosition.SelectedValue) is throwing an InvalidCastException. Is there any way that I can get the ValueMember's type to be an Integer?
Dim cn As New SqlConnection(CreditDisputesLogConn)
Dim cmd As New SqlCommand("CustomersLookup", cn)
Dim da As New SqlDataAdapter(cmd)
[Code]....
How can I get an item value from a Combobox using a datatable as it's datasource? Here's my code for constructing the combobox. This code works, that's why I'm not showing it all, but I want you to know how I'm creating the combobox.
Try
query = "SELECT category_id, name FROM categories ORDER BY name ASC;"
dbCommand = New MySqlCommand(query, dbConnection)
[Code]....
I want to display what is the item you physically see in the combobox that you select.
I have this controls
ComboBox: list of myobject
TextBox: view a description
DataSource: list(of MyObject)
MyObject:
property id as int
property combodesctription as string
property description as string
What I want: I set the datasource of combobox with list of MyObject when I select a value on combobox, I would like see description in TextBox is it possible bound text property of TextBox to same datasource of combobox or it is possible change description of TextBox only with changedEvent of ComboBox?
I have a ComboBox which is bound with a DataSource from (obviously) a Database. However, there are 659 different entries inside this Database and I was hoping to tack on AutoComplete.
I tried setting the Source to the ListItems since, after initialization and the data is bound, all the items necessary are in fact inside the ComboBox so I had assumed that it would pick that up. I was wrong. I tried using a Custom source but VS errored out saying that I couldn't do that since the ComboBox was bound.
My question is, how can I utilize AutoComplete's "Suggest" mode with a bound ComboBox?
I have a DataSet with a DataTable that has several numeric columns of Data. The numeric data is composed of distances given in U.S. Standard units. I currently have my ComboBoxes set up and working, but I need to expand on what I currently have in two ways.I need to be able to convert the Decimal numbers in my data column being displayed to Fractions, is there a way to do this and maintain databinding? In this case its the Display Member of the data source...I need to be able to display my drop down options in different sets of units... I've written Unit Conversion classes to help take care of this, but I don't know if I can somehow do this as well and maintain databinding? I'd like to convert the units on the display members as well...
Private Sub ComboBox1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox1.SelectionChangeCommitted
Select Case ComboBox1.SelectedItem
[code]....
What is the best approach for using ComboBoxes when dealing with issues such as displaying fractions and units...