I have bound data from Excel to my project, but now I am trying to pull a specific column from the table and put the information in a combobox. I am trying to pull dates from column O of my excel file, and I want the dates to go into the combobox with no repeats.[code]...
View 2 RepliesPlease forgive, I'm new to Silverlight and am still trying to wrap my head around data binding...
I have a generic list obtained from a class using LINQ. The list has 4 objects, each object consisting of a Letter property (string - A, B, C and D) and a corresponding Number property (integer - 1, 2, 3, and 4).
In Silverlight, I have a combobox control and a text block. I'm trying to figure out how to:
Bind the combobox to the generic list so that the letters populate the combobox.When the user selects a letter in the combobox (say C), the corresponding integer value (3 for this example) is displayed in the text block.
I have a context menu strip (named cmnuRtxtIT) that pops up by right clicking on top of a rich text box in a VB 2008 WinForms application. Context menu strip cmnuRtxtIT has one item named ToolStripMenuInsertFld. This last one has one dropdown item named oolStripComboBoxFlds which is a ToolStripComboBox type. I do the following in the form's Load event to bind ToolStripComboBoxFldsto an Sql database:
Dim dt As New DataTable
Dim dta As New SqlDataAdapter("SELECT pkID, txtFlds FROM ApplicationFields", goConn)
dta.Fill(dt)
[code].....
I have a table in my database with 5 columns (ID1 to ID5) and just one row. I'm trying to bind a comboBox, to show ID1 through ID5 in the combobox when my form loads. I have a dataset and tableAdapter's made for this already. I just want to know how to bind a combobox to those ID values.
View 4 RepliesThe code below produced the error:
vb.net
Dim i As Integer
Dim strText As String
Dim oExcel As Application = CreateObject("Excel.Application")
[Code]....
error: value can not be Null at Me.ComboBox1.Items.Add(strText) line.
I have a form with a button and combobox. I want to make a program that when I click the button, I get a OpenDialogBox so I can chose an Excel file.
Then when I chose the file and click OK, the first column of the excel file shows in the combobox. I have coded the button that opens the file, but I have no idea how to get the data from excel into combobox.
p.s. is there a way to keep the excel file from actualy showing(i've figured out that I should do something with VISIBILITY=FALSE but I keep getting errors at that point)
Visual Basic 2010 Express: I have a form with a combobox that is populated with the names of locations from a datagrid which in turn was imported at run-time (Form_Load) from an Excel database. The Excel database (and the datagrid) also stores the information for addresses and phone numbers for their respective locations.
What I would like to do is have the phone number and address text boxes automatically be updated with the proper corresponding data when the user selects a location from the combobox. Whether the text boxes are updated from the datagrid or Excel database is not a concern; I'm mainly looking for whichever way is simpler.
I 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 RepliesI 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 Replieshow do i change the display member of a ComboBox after i have entered a code in a textbox that it represent the combobox value?example
Code: 02-001 Combobox: Provider X
if i change the code the provider combobox must change and if i change the provider combobox the code should change!..
if e.keychar = chr(13) Then
combobox.valuemember = textbox.text
combobox.displaymember = me.stockdataset.selectprovider(@textbox.text)
end if
this code change the combo box display member but if I change the comobox by clicking it the code on the textbox doesnt change, to its corresponding code...the combo box is bound to the provider tables....
I have a listbox that is bound to an observable collection of Audio (custom class).The Audio class has two properties, DisplayText (string) and a property called TarpIds (Observable Collection of Integer).I need to allow the user to change the TarpID in the combo box for each list item displayed and catch the selection change.I created a DataTemplate that styles the DisplayText property from the Audio object and adds a ComboBox to display the available TarpIDs for this audio (These are dynamic and unique to each Audio).The DisplayText works great, but I can not get the TarpIDs to display in the ComboBox.FYI I set the ItemSource at run time that binds the ListUploadAudio to the Observable Collection of Audio.[code]
View 1 RepliesI have cascading data-bound combo boxes, however, if the second of the two boxes does not have the value, I am trying to change the data source of the original process to the default selection.
However I am getting errors no matter what I try to do to get the combo box to clear.
cboSubSystem.SelectedIndex = -1
cboSubSystem.DataSource = Nothing
Call cboSubSystem.Items.Clear()
[Code]....
Currently: "Items collection cannot be modified when the DataSource property is set." at the Items.Clear If I try to remove the clear, I get "Cannot bind to the new value member. Parameter name: value" at the valuemember set
I hae a program that opens and reads a textfile database and have several comboboxes with a string of items and the selectedindex is returedn from database
Me.subj_pool_txt.DataBindings.Add("SelectedIndex", Me.BindingSource7, Form10.pool_txt.Text)
Upon opening a new file I run this code to clear exisitng databindings and reset text
For Each ctrl As Control In Me.GroupBox1.Controls
If TypeOf ctrl Is TextBox Then
CType(ctrl, TextBox).DataBindings.Clear()[code]....
My problem is my combobox do not re-bind to new file.They bind fine upon initial instance however
How do I get even basic binding to work between a ComboBox and an ObservableCollection? I can't get anything but error messages.
VB:
Class MainWindow
Dim Units As New ObservableCollection(Of String)
Private Sub Window_Loaded(sender As System.Object, e As
[Code]....
I have binded the accdb to combobox but it can not bind the data currently, it can only bind the first character of first record of the table for example, if the records are:
abcd
xyz
ijkl
the combobox will display
a
[Code]...
I am using a dataset on the server, in this dataset I have a datatable that calls a stored procedure and returns column names from three tables. I call this stored procedure using a web service.i manage to show all the column names in my combobox but when I want to click a button and insert selected column name into a richtextbox I get System.Data.DataRowView in the textbox instead.
My code:
'the combobox
'if I don't have this textblock all the values are shown vertical instead of the normal horizontal lines
'the stored procedure
SELECT COLUMN_NAME
[code]....
how to get the selected text in the combobox to the richtextbox?
I have combobox in a form. The combobox is bound to a table and displays the list of values as expected. What I want to do is also bind the combox to another field in a different table similar to the way the datagridview with combobox works. That is the dgv is bound to the combobox column but the dgv's bound value sets/reflects the value selected by the combobox. I can't figure out if this is possible with a standalone combobox.
View 3 RepliesI have a DataSet with many tables and a single DataGridView. I need to select a value from a combobox and then pressing aButton to show the selected table to the DataGridView. For example if I select from combobox "Selection1" I would like to show to the Datagridview the contents of the table called Selection1. I paste the event that I thought might work but doesnt show a think: Private Sub aButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles aButton.Click
[Code]...
I'm hung up on the syntax to bind a value to a combobox control. I store the ID of the value in a database. I want the value to show in the combobox control. How do I do this? [Code]
View 2 RepliesI am working on a new winforms application that is receiving data from a WCF service. The programmer has implemented the services like this:Note that this sample is C# but I will be working in VB.NET
[OperationContract]
[FaultContract(typeof(ServiceFault))]
[FaultContract(typeof(ValidationFault))]
[WsdlDoc("Search all cars")]
[return: MessageParameter(Name = "Cars")]
List<Car> FindCars(List<SearchCriteriaItem> criterias);
[Code]...
I've got a ComboBox with an ItemsSource which I've bound to a List(Of String).What I'd like to do is have the XAML update a String property when the SelectedValue of the ComboBox changes. I've seen a whole bunch of examples for TextBoxes which use
Text="{Binding Path=MyString}"sort of stuff, but I don't really think that'll be the way to go if, in future, I need to change the ItemsSource to a List(Of ObscureObject)...
I've got a combobox - style DropDownList.
Three options - blank, EMAIL or PHONE - these three are set at design time.
Do I just bind the TEXT property of the COMBOBOX to the field in the DATATABLE?
This appears to be working fine - but I'm a bit confused about the purpose of SELECTEDVALUE in all this. I'm not binding to that.
it's possibly to bind the values in a combobox to a column in a dataset? If so, how would I go about doing it? For example, If I have a column named 'Names' in a DataSet, each comboBox item would be a name from that column.(There will only me at maximum, 10 entries)
View 6 RepliesI actually have three combobox bind to diffrent table. and I got such the error in my title. Bellow are my codes:
myCommand = New SqlCommand("SELECT (FirstName +' '+ LastName) AS FullName FROM tblVisitor", myConnection)
myAdapter = New SqlDataAdapter(myCommand)
[Code].....
Through this code, i got only the first comboboxthat display the query result, but the other two do not, and display the message 'Cannot bind to the new value member. Parameter name: value'.
I am developing a Windows Form Application against a SQL Server relational database. An example of the database schema is:
TableA
------------------
PK A_ID uniqueidentifier
A_NAME varchar(254)
[code]....
In the form I have a ComboBox (cboA_ID) to select the TableA record (DataSource = TableA, DisplayMember = A_NAME, ValueMember = A_ID) and a TabControl where controls on each tab are bound to fields in either TableB or TableC.My question is, is it possible to bind cboA_ID to TableB.A_ID and TableC.A_ID?This is my first database application so if there is a better way to do this I'm all ears. I have set everything up using the wizards in Visual Studio 2010, so I'm still not 100% familiar with what all the various TableAdapters and DataSets do.
this code
Me.vendorLookup.DataSource = vendorBAL_C.vendorTable
Me.vendorLookup.DisplayMember = "SimpleId"
Me.vendorLookup.ValueMember = "VendorId"
Makes the combobox have a list of Names (simpleid) and PK (vendorid)
How do you make the combobox also be bound to a specific row of a record in an "case management" table? I've already used the datasource for a table of vendors - right?Or is this where I put two tables into a DATASET and make that be the DATASOURCE?
My problem is that i have two frequently updating DataTables and both of them must be showed in two DataGridView and in .XLS file.
As i understand i cannot make .XLS file without calling New Excel.Application
So i open New Excel.Application, create two datasheets - for each datatable and close application..
For DatagridView i use [code]...
Simple code :
Private Sub ExportGridToExcel()
Dim Excel As Object = CreateObject("Excel.Application")
If Excel Is Nothing Then
[code]....
How to bind entire grid in to excel without looping..
I'm trying to populate the list of a combobox by binding it to a datatable. Also, I want the selected value of the combobox to be bound to an object property so that when the selected value changes, it's automatically updating the object. However it's causing an error at runtime: "This causes two bindings in the collection to bind to the same property.
Parameter name: binding" I thought binding the dropdown list to a datatable and the selected value to an object were different properties but obviously I'm not getting it right.
Code:
Private Sub PopulateSiteSelect()
With Me.PlanSiteSelect
If _Plan.PlanID <> Nothing And _User.UserID <> Nothing And _Plan.Category <> Nothing Then
[Code]....
I have the following:
a table of addresses and a bindingsource for the table
a enum list of address type: 0 = "Mailing", 1 = "Physical", 2 = "Shipping" etc...
I would like to bind the datasource of the combobox to the enum so it displays "Mailing", "Physical" etc. Then I would like to change the bindingsource position of the address table based on the user selection of the combobox.
Here is what I have so far:
cbxAddressName.DataSource = New BindingSource(ApplicationEnums.GetEnumList(GetType(ApplicationEnums.CompanyAddressType)), Nothing)
[Code].....