In a manufacturing environment I'm using an Access database to store properties of manufactured parts. I've queried a table to fill a datatable, which then populates the attached form.
[Code]...
I can loop through comboboxes likes:
for i=0 to 5
directcast(me.controls ("combobox" & i.tostring), combobox).items.add ("Hello")
next
However, if I do the same thing with binding sources:
for i=0 to 5
directcast(me.controls ("bindingsource" & i.tostring), bindingsource).movenext()
next
It errors me saying that you can't cast binding source as a control or something (they aren't of the same type). How do I loop through binding sources?
How can I sync 2 binding sources, both binding sources contain the same data(contactsbindingsource)I have 2 forms:1 form is a list of contact information the other is a search form.I have a linq querie in the search form that returns contact names to a datagridview, but I want to be able to double click on selected cell and have the relevant data appear on my first form.Also my first form has FK relationship to another form that contains company information, could this have something to do with it?
View 6 RepliesI have 2 BindingSources that interact with controls on my application. Is there anyway to save them to a file and also load them?
View 2 RepliesI have a winforms app access a database with 6 tables. Out of 6, I am showing 3 tables on three different tabs on my Form. However, I want to do it using a single binding navigator that will use / change the respective binding source dynamically, depending on the tab that is activated by the user. I have separate binding source for each of the three tables.
View 3 RepliesI need to do in other platforms but seem to be having some issues with VB .net 2008.I have a datagridview bound to an SQL table that has several comboboxes.the rowSource (is it called that still?) for each of the comboBoxes are SQL lookup tables that I've created and based on the the users selection in ComboBox1, comboBox2's datasource may change.What I want is, if the user picks "Dental" from ComboBox1, I want comboBox2 to load Dental plans (Which I have working, no problem here I think).And if they pick "medical" in ComboBox1, comboBox2 loads medical plans in comboBox2 dropDown list, which, again that part seems to be working.If in the first row in the DGV,the user selects "Dental" for comboBox1 and then a Dental plan in ComboBox2,on the next row, if the user inputs "Medical" in ComboBox1, the first rows ComboBox2's "Dental plan" info disappears.
The medical plan can still be selected and displayed in row 2's comboBox2 (so the changing of the datasource is working)If you then click anywhere in the first row, ComboBox2's dental plan appears again but Row2's combobox2 now no longer displays the medical plan.Becuase whatever value you choose, no matter if it's a medical or dental plan, the info gets saved in the DGV bound table, shouldn't it display the saved information from the DGV's source and not the shifting comboBoxes datasources?
I have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1
[code].....
Is it possible to bind a button to an object? I have a situation where I create lots of buttons dynamically and add them to a form, each button corresponds to a record in a database table, I want the button to hold all the info in the record without the need to search for the data each time I press it. I've already have the info in the tag property as a delimited string, but the process of extracting the info from the string is not efficient. if I add one new value I have to add the code to extract that info using string manipulation. I would rather have an object that represents the record so I can access each value directly.
View 1 RepliesI'm trying to bind data to a combo box but it does not appear to be working. I've setup the DataSet and the DataSetBindingSource and all this appears to be working, within the form design I can expand the little arrow in the ComboBox control and preview the data. This appears to be working but when the application is run, nothing appears in the drop down box.
I have the following code in place:
Code:
cmbSelectCompany.DataSource = ContactsDBDataSet.Company()
cmbSelectCompany.DisplayMember = "CompanyName"
cmbSelectCompany.ValueMember = "CompanyName"
[Code]....
At work we have this really old excel spreadsheet with movable points in it.This feature no longer works in '07 so I have decided to try and make a VB form to replicate it's functionality.I have the concept down of what I'm gonna do, I'm using sliders for the movable points and I'm using a data grid view for all of the numbers they are just going to type in, and then I have a button that saves all of the data to the database that it links with.I've figured out how to get everything working except the button that saves the data. So there are 4 separate databases attached to sliders and another one that is part of the data grid view. What am I going to have to put into that button under the click event in order to make it save the values in all of these databases?
View 2 RepliesI am trying to add 2 databindings to a combobox. 1 will bind to the text, andthe other one will bind to the selectedvalue. However, I am only able to add one databinding to the combobox.
cmdCustomerID.DataBindings.Add(
"Text", TblCustomerBindingSource, "strCustomerID", True)
cmbCustomerID.DataBindings.Add(
"SelectedValue", TblCustomerBindingSource, "idxCustomer", True)
This is what I have done. Only the selectedValue DataBindings.Add is being captured.
I'm trying to bind data to a combo box but it does not appear to be working. I've setup the DataSet and the DataSetBindingSource and all this appears to be working, within the form design I can expand the little arrow in the ComboBox control and preview the data. This appears to be working but when the application is run, nothing appears in the drop down box.
View 5 RepliesI have 2 tables:
Locations
location_refnbr (pk)
location_name
office_refnbr (fk)
[code]....
I have combox1 and i want to dispaly Foure Columns in combox1 and I make this
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.Text, "select FirstName,FatherName,GrandFatherName,FamilyName from dbo.PersonalData")
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "GetSpecialFieldOFPersonalData")
Do While dr.Read
Me.ComboBox1.Items.Add(dr(0) & " - " & dr(1) & " - " & dr(2) & " - " & dr(3))
Loop
how one might go about binding to a gridview in ASP.Net 4 in a scenario where the first row of my gridview should be the headers, the second should be a combobox for each column and the third is the beginning of my actual datasource.
If you can imagine what I am trying to achieve is an ability to create a binding between each column in the datagrid and another datasource. This binding is created by the user selecting a value in the comboboxes. However no matter what I try I cant seem to achieve this.
HeaderText1 | HeaderText2 | HeaderText3
ComboBox1 | ComboBox2 | ComboBox3
DataRow1 | DataRow1 | DataRow1
DataRow2 | DataRow2 | DataRow2
DataRow3 | DataRow3 | DataRow3
I have set up at DataGridView "cdgvExp" for data entry. cdgvExp.Datasource = ExpTab. The datagridview can accept new rows according to how many entries there are. I will then use the data in ExpTab. The Fourth colum is called "Lot" and is a combobox in the datagridview. The goal is to have the Combobox in the fourth column have the datasource be LotTab which is populated according to other choices in the form. I am hunting for something that would work like an independant combobox like cbLots.datasource = LotsTab
How do I dynamically set the Datasource and Datamember of a combobox that is already set up in a datagridview?
My 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 have this code
Public Sub FillCategoryCombobox(ByVal categoryList As List(Of tblCategory), ByVal LvName As ComboBox)
LvName.Items.Clear()
Dim itemValue = New Dictionary(Of Integer, String)()
For Each category As tblCategory In categoryList
itemValue.Add(category.CategoryID, category.CategoryName)
Next category
LvName.DataSource = New BindingSource(itemValue, Nothing)
LvName.DisplayMember = "Value"
LvName.ValueMember = "Key"
End Sub
I receive an error on
LvName.DataSource = New BindingSource(itemValue, Nothing)
Value cannot be null
I want to retrive data from table into combobox ..when the user click combobox items it's corresponding data will be show.In details :I have PERSON table , my program allow to the user search by : Person Name When the user enters the name into TextBox the combobox items will be all names existed in database same which user entered. when the user selects item from combobox a new form will show all person' data
[Code]...
VS2008 targeting .Net 3.5x. I have a combobox with a datasource and display member set, and when I run the project, I see the items. I am also binding the selected item to another object which contains the item upon which I want to select. I have verified that both the bound object and its underlying data contain the value I expect. The problem is that I cannot get it to select the correct item - it only ever selects the first item in the list.
View 8 RepliesI've got a bound Combobox in a database for a lookup but when i set it up and change the data in the combo the program won't let me go and further. There is a data conflict but i don't know where. The problem is here in the combo setup:
Display member : ProductName (nvarChr(20)
Value Member : ProductID (int)
Selected Member: SelectedLookup (int)
This doesn't work. Everything is displayed in the dropdown by name but when i select a item. I can't go any further. If i change the Display member: to 'ProductID' the program works fine. but displays the ProductID where users won't understand. It's like it is trying to store the 'displayed member' Product Name instead in the Value Member 'ProductID'. if i use a list box instead the program works correctly.
[code...]
On my first form, I have a combobox that is bound to the Locations table and displays all the different locations. Once a location is selected, a 2nd form is loaded which has textboxes which are also bound to the Locations table and are populated with the corresponding data.
Here's my issue: on the 2nd form, I have combobox that is bound to the Offices table. Currently, when this form loads all the available offices, displaying with the first office in the list. I need it to populate with the correct office based on the selection made on the combobox on the first form. I guess what I'm asking is, how does one bind a combobox to a foreign key b/c it is the foreign key, office_refnbr, from the Locations table that needs to display in the Office combobox.
I've tried a variety of bindings, including:[code...]
enlighten me about how one might go about binding to a gridview in ASP.Net 4 in a scenario where the first row of my gridview should be the headers, the second should be a combobox for each column and the third is the beginning of my actual datasource.If you can imagine what I am trying to achieve is an ability to create a binding between each column in the datagrid and another datasource. This binding is created by the user selecting a value in the comboboxes. However no matter what I try I cant seem to achieve this.
HeaderText1 | HeaderText2 | HeaderText3
ComboBox1 | ComboBox2 | ComboBox3
DataRow1 | DataRow1 | DataRow1
[code].....
I have in my database a smallint field with 2 values 0/1,is it possible to bind that field to a combobox with 2 values "Yes" "No" without creating another datatable for Yes/No values or to modify sql query to bring Yes/No instead 0/1 something like binding to SelectedIndex ?
View 9 RepliesI tried to bind the following Enum to a ComboBox
Public Enum PossibleActions
ActionRead
ActionWrite
ActionVerify
End Enum
I can't change the Enum itself, but I do not want to display these strings. My intention is just to cut the prefix 'Action' and display 'Read', 'Write' and 'Verify' in the ComboBox.
Therefore I wrote a ValueConverter
Public Class PossibleActionsConverter
Implements IValueConverter
Public Function Convert(ByVal value As Object, ByVal targetType As System.Type, ByVal parameter As Object, ByVal culture As System.Globalization.CultureInfo) As Object Implements System.Windows.Data.IValueConverter.Convert
[Code] .....
I have a datagridview bound to a datatable. I want replace one of the cells with a combo box and bind that combobox to one of the columns in the datatable. I have been able to replace the cell OK but currently have two issues I have not been able to resolve.
1. When I add items to the drop down (items.add ("Yes")...) they don't appear in the drop down box.
2. I can't figure out the syntax to bind a particular column in my datatable to the newColumn(combobox) in the datagridview.
dbConnection = New OleDbConnection
cmdCommand = New OleDbCommand
Try
[Code].....
I want to bind a column of a strongly typed dataset to a combobox. But the problem is i have to get only the distinct values from the column and also when a user inserts a value into that column the new value should be showned in the combobox at the same time.And also i want to make the first row of the combobox to be unselectable..[code]how to make this column distinct values
View 1 RepliesI have a vb.net application. I just want to store a month as number in database. But frontend itself I want to display the month as name jan, feb ........like way in combobox. How to convert database value to month name . I am binding the data from databse to combobox.
View 2 RepliesWhat I would like to do is bind a combobox to my own object which is as follows:
Public Class Categories
Public Sub New(ByVal myConn As SqlConnection)
Dim myConnection As SqlConnection = myConn
myConnection.Open()
[code]....
(I have put breakpoints and I know this object has data.)So on my form how do I bind my combobox to this object? The code I have is below:
Dim bs As New BindingSource
bs.DataSource = New Inventory.Categories(myconn)
cboCategory.DataSource = bs
cboCategory.DisplayMember = "Description"
cboCategory.ValueMember = "CategoryID"
but it returns the following error: Cannot bind to the new display member. Parameter name: newDisplayMember
I'm wondering what a best practice is for handling this.I've got a standard vendor table - with VendorId (which is PK, numeric) and a field the users call SimpleId (which is usually a name - don't let the column name of SimpleId make you think it's numeric!).I've got one datatable that comes from a data adapter that looks like this. And this already changes the table in the SQL database...SqlDataAdapter("Select VendorId, SimpleId From Vendor_T", _connection)I've got this datatable on one panel of my form with a binding navigator - and you can change the SimpleId for a vendor with this.
View 16 Replies
