I'm having an issue wherein my combobox is populated from a datasource (access database >> [URL] and unwanted duplicates are shown.
-Example- [URL]
How can I make it so no duplicates arise?
Also on another note...I'm having difficulties linking the 2nd combo (model) to the first (make).
I would like the program to function in such a manner that
>makeCombo is populated from the database
>the user selects the Make of the vehicle from makeCombo
>modelCombo is populated from the database according to the make selected
>the user selects the Model of the vehicle from modelCombo
>user hits search
>datagrid is populated with appropriate vehicles
The above code displays drop list of employees first names in a combo box. I want first name and last name to be displayed. How can i do it?I tried to include two columns FirstName and LastName as below but didn't work.
I was wondering how i can loop through a combo boxes items display item field - and return the value for each - i want this to be generic regardless of the combo boxes data source - or if the combo box has been populated with a string list / class etc
In a windows forms project, I have several combo boxes. The first combo box contains a list of objects. Those objects then have several lists which are used as the datasource's for the successive combo boxes, depending on which item is chosen in the first.
I have the following coding in place which basically edits my text file, however with the information that is shown in the text file I want to remove all duplicates, is this possible?
Dim path As String = "c: est1.txt" Dim sb As New StringBuilder Dim sr As New StreamReader(path)
Ok, I found some code online on how to do this, but they only compare the Listview.item.text, and they don't care what is in the entire ListViewItem. Is there any code to remove duplicates in a ListView that checks to see if all the subitems are the same as well and THEN removes the entry? [Code]
I started programming Visual Basic .NET a few weeks ago. I wanted to make a tool to remove duplicate lines from a listbox. I have the following
Dim strItems As New List(Of String) 'Make a list with originals Dim strDup As New List(Of String) 'This list contains the duplicated lines
For i As Integer = 0 To ListBox1.Items.Count - 1
LabelChecking.Text = "Checking for duplicates: " & i & "/" & ListBox1.Items.Count - 1 Application.DoEvents() If strItems.Contains(ListBox1.Items(i).ToString) Then
I'm new to the forums and VB programming in general, so I only have a very basic understanding of VB commands, but I still have a good grasp on logic and the like. I'm doing this for a school assignment, and I am in a bit of a pickle.I am trying to generate an array of 6 random numbers from 1 to 30, making sure there are no duplicates.I think I'm pretty close to cracking it, but it still doesn't work.Here's what I have at the moment:[code]......
Option Strict On Option Explicit On Imports System.Data.OleDb
[Code]....
And the registration part works fine, but my only problem is that if someone registers twice with the same email, it will create another cell in Access, causing me to have duplicates.
I'm trying to make a snippet that will remove duplicate lines from text files. However, I seem to be mixing my for loops up.. does anyone know a simple way that I could do this?
Is there an easy way to search through a List(Of Integer) and find duplicates? Or do I need to do loops to search through it with each number, comparing it to each one?
In my project,, I have three forms. In my main form, I have a DataTable filled with some data from a MySQL-server.In the two other forms, I have a DataGridView which is bound to a BindingSource, which again is bound to the same DataTable in the main form. So It looks something like this:
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 am customizing a DataGridView control. The DataGridView is supposed to be bound to a collection of some type (be it a List(Of T) or ArrayList or whatever), and the idea is that one can easily determine (at design-time in this case) which properties of the type have to be shown in the grid and which column header name they should get. One can do this using an attribute. For example, if I have a class Person with Name, Age and HairColor and I don't want to show the HairColor property, and want to show the Name property as 'Person', I would use:
vb.net Public Class Person <Grid.GridOptions(displayName:="Person", visible:=True)> _ Public Property Name As String
[code]....
I do this during run-time by simply looping through the properties of the bound type (in this case Person), retrieving the GridOptions attribute (if any) and checking the values provided. This works just fine except for one thing: I'm not really sure how to determine the type in the databound collection...
At the moment, I cast the DataSource property to an IList and retrieve the type of the first instance in that list (if any). If there isn't a first instance (the list is empty) then I don't know how to get the type... Often I know that it will be impossible to know the type. If someone is binding an ArrayList for example, then it's impossible to know what kind of items he's going to put in that ArrayList. Even the normal DataGridView cannot show any columns when databound to an empty ArrayList. However, the framework's DataGridView does show the columns when bound to, for example, an empty List(Of Person), or a Person array.
I'm pretty sure that casting the DataSource to an IList is not the correct way as all information about the type of items in that list is then lost. But I'm not sure what else to cast it to... ITypedList? IBindingList? I even considered List(Of T) because that's all I am going to be using, but besides the fact that the grid would then obviously only work for a List(Of T) I still don't know how to do this... I don't know 'T' so I can't cast it to a List(Of T)...
I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the data entry form, the report does not reflect those changes. I have to close the entire program and reopen it before the changes take effect on my report. This piece is used to bound the report to the dataset
I am converting a VB 6 app to VB.Net. In the vb 6 version I have a table that contains roughly 80 fields. Over that table the users currently have a single form which gives 12 diferent views. Each view is placed on a different tab, which, although giving a distinct set of fields per tab, also leads to a ton of duplicated code. Changing the underlying table is not an option.
What I would like to do is to use a single datasource (containing all 80 fields), a single datagridview on the form, and have a combobox act as the filter choice for the differing views. Does my solution seem like the right way to handle this? If so, I'm not sure I know which controls would best be used.
Like i want it to read the lines i have in the text file but i get an error Each time i press the button Why?
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Dim objreader As New System.IO.StreamReader("C:UsersJamesDesktopMusicas.txt") Do Until objreader.EndOfStream
[code]....
Error:
Quote:
Items collection cannot be modified when the DataSource property is set.
I want to know how to perform row delete to datatable which is a datasource to the grid.
In details: I have a datagridview (dg) and its datasource is set to dtItem. User will select some rows in dg and press 'delete' button.
dg.DataSource = dtItem;
I will perform a loop and delete the records. Here is the code eg:
foreach (DataGridViewRow drw in dg.Rows) { if (drw.Selected)
[Code]....
The problem is it didn't delete correctly. If user selects row index 0 and 1 in dg and delete it, it will delete the first one correctly and then finished cuz no more row is selected in next gridviewrow.
I tried google and didn't find what I want. may be because i don't know the correct keywords I should use to search.
I have a loaded combo box and was wondering if there was a way i could get the place value from it when it is selected. An example would be i have a combo box full of foods:
Apple Bannana Peach Pear
if the user selects apple then i want to be able to get 1 from the combo box since that is the spot it is in. if peach was selected then i want to get the place value of 3.
In my Visual Basic application I have added a Access 2003 Database to the Data Sources. When I drag and drop the table I want onto the form in Details view, it all appears very nicely with the added bonus of a Calendar selector thing for the field with a Data Type of Date. However I have used some Lookup Wizards while setting up the database in Access and they appear as Text Box, how can I make it so they appear as combo boxes with the selection from the lookup wizard?
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
End Sub End Class
How can I have a box of text and each text word is linked to a website? Public Class Form1 Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
1a. Website Name 1b. Website Link 2a. Website Name 2b. Website Link End Sub End Class
Is there a way of doing this? I can do it in vb6, but after moving to 2010 everything is different and I am having to learn all over again,
I've read many posts about disabling Alt+Ctrl+Del and Ctrl+Tab, etc. I'm not looking to do that. What I'm trying to do is create an app which will be hidden, and then need to be unhidden from "anywhere." For example, if I have an Excel spreadsheet open, I want to be able to use a combo like Ctrl+U to Unhide my program, but I do NOT want it to underline the text in the cell I'm currently in (which Excel will normally do). I don't want to worry about disabling or changing shortcut combinations for Excel, Word, etc.
I have a combo box on a form that is set to certain width. The data the combo varies and can be quite large. Is there a way that the combo box could be expanded to fit the widest data/text when the Combo is selected?It would be quite neat if it pop out of the form when selected! I guess I could create this effect by creating another form that opens when when that object is selected.
I have a Form with a Tab control on it, one of the fields is the Apartment number which is a Combobox. It is displaying properly, however since it sits on one of the tabs when you scroll through the records its hard to remember what tenant you are dealing with.
I have a label on the top of the screen that shows the Tenant First/Last Name. I also want to at what Apartment Number they are looking at.
I currently am trying this: I have also tried:
SelectedItem SelectedText SelectedValue
Column 0 of my combobox is the ID and Column 1 is the Text description.
I'm using windows form (vb2010) for data entry.. so now I want to add a combo box into my windows form using sql code because all my connection & Inserting records in SQL command. And other important matter is the combo box should connect to my SQL Server database Table.
Combo table Name : TblPosition Data entry Table : EmployeeList (with EmpId, EmpName, Position, BasicSalary) fields.