I have a combobox where I use datasource to populate it with data, in the key press event I have the following coding which i use to filter the data.
With Me.Combobox1
Dim ToFind As String = .Text.Substring(0, .SelectionStart) & e.KeyChar
Dim Index As Integer = .FindStringExact(ToFind)
[Code]....
I know this would be possible by me changing the style to dropdownlist but its not exactly what I was after.
I am using vb2005, and I am using MS Access 2003 as my database.
This is what I am doing and this is what I would like to happend
I have two combo boxes, combobox1 and combobox2
I have two tables, Application table and Group table
Here is how the data is going to be display:
Combobox1 = Application Table
Combobox2 = Group Table
In the Application Table I have 3 columns ID, Code, Description
The same information applies for the Group table
THis is an example of the Application table
CODE DESCRIPTION
1 Purchasing
2 Stores
3 Assets
[Code]....
How to filter data from the database to combobox? For example, the database have the data, and i have a combobox, then i want to type the first letter, and the dropdown list comes down that the data have the first letter that i type in the combobox.
View 6 RepliesOn the form, I have combobox1, combobox2, datagridview, and a listbox. Basically, combobox2 displays a list of street names. My problem is that once the user selects a street name from combobox2, the listbox should be populated with only the customers' names who lives on that street. How can I go about populating a listbox with just the customer names? Originally, the street names include the house numbers as well. For example, "5100 E Dublin Granville Rd". Fortunately, I figured out how to display ONLY the street names ('E Dublin Granville Rd') and not the full street address to the combobox by adding the following public property below. However, I am still encountering a problem because now the combobox has duplicates of the same street name![code]
View 3 RepliesI have a child form which contains a list of names and information, like age, sex, etc, in a multicolumn listview that gets populated from an xml file on the form load.There is also a combobox on this form that contains different Ages and when the user selects an age in the combobox I have it so the listview clears and the data reloads then removes all the rows that don't contain the matching "age" value in the age column.This works but it's really slow since each time a user makes another choice from the Combobox the whole listview is repopulated from the xml file.[code]I was thinking about doing the Name filter about the same way except on the textbox keyup event, but I fiqured I'd work at getting this working better first since this is way too slow.I don't really know any way of filtering the listview other than deleting the entries that don't match what's in the combobox.But then I end up reloading the whole thing when another selection is made from the combobox.
View 4 RepliesVS 2010 ComboBox filtering of db table names
View 4 RepliesI am trying to write a thread safe application that contains 3 threads : -
1 - Data acquisition and decoding
2- Data graphing
3 - FFT and filtering
Thread 1 is collecting bytes from the serial port and converting them int integers (so taking two bytes) after is has captured 64 Bytes and converted into 32 integers, it then needs to pass the array to the graphing thread.
The graphing thread then plots the data and waits for more data.
Thread 3 also waits until thread one has collected 2023 integers and takes these and performs some FFT calculations (which take time).
My question is how do i share the arrays between the three threads without deadlocking the program? as the serial thread will be flying around reasonable fast (1000 bytes per second) so it will synclock onto the shared buffers for most of the time.
Originally i was going to use two synchronised queues, so when thread 1 has collected 32 bytes it queues the data into the graph queue, and once it has collected 2023 it queues the data into the FFT queue.
Then thread 2 and 3 can simple dequeue the data.
However using queues has the overhead of casting the data in and out, and as i know the data type i was planning on using two arrays :-
Dim GraphArray() as ushort
Dim FFTArray() as ushort
Then Thread 1 adds data to each thread, and thread 2 and 3 simple wait until the correct amount of data is available before removing the data. my question is there an array type that allows me to remove x amount of data from an array?
Because i cannot do this easily with the ararys defined as above (GraphArray, FFTArray), as i was planning on making them 1mByte and allowing thread 1 to fill them Knowing they should never overflow and then let thread 2 and 3 remove x amout of bytes at a time unless there is a better way of doing it
I created a query on a Access database, which I would like to show with the datagridview. So, I created a new table adapter with my query, which creates as well the datatable tbl1. Then, the wizard created the datagridview for me, showing the correct data. Now, I would like to filter these rows: I already read it is possible to do it by simply clicking "Add query...", but I would like to do it in a different way. I have some comboboxes, and I would like to use the strings inside them to filter my table tbl1. Is it possible to apply those queries one after the other on my datatable tbl1? I am able to filter only once with:
Me.tbl1TableAdapter.FillBySomething(Me.DataSet.tbl1, params...)
But, if I wanted to filter the result again?
I am using a datagrid to display a dataset. I would like to filter rows on certain fields (ex: ____ (Male/Female). I would want to it post-data retrieval on the client side.
View 3 RepliesI have a database with a Student table and a Class table. There are many students and many classes and each student is a member of a class.I then have a windows form that needs to display a list of student names in a listbox. However, I have a different form for each class. So for example in this form I have coded below, I need to display all students that are members of class51. The code I have so far is reading in all students from tblStudent and this is not what I want. I know that if I was doing SQL or something I'd simply write SELECT * FROM TBLSTUDENT WHERE CLASSID =his?
Private Sub frmAttendace51_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'clear data set of any existing data
[code].....
Private
Sub
ComboBox1_SelectedIndexChanged(ByVal
sender As
[code]....
DataGridView filtering. I have this data bound to a combobox:
Product Index
Prod1 1,2
Prod2 7,8,9
Prod3 10,11
Actual Table structure is:
Index Product
1 prod1
2 prod1
7 prod2
8 prod2
9 prod2
10 prod2
11 prod3
(Product is the Display Member, Index is the ValueMember)
On the combobox's SelectedIndexChanged event, I'm filtering the DataGridView:
DGVCustomers.DataSource.DefaultView.RowFilter = "indexes like '%" + MyDropDown.SelectedValue + "%'"
If MyDropDown.SelectedValue is "1,2" then any record without either number will not be shown , in addition "7,8,9" will only show customers with that string... etc etc. How can I filter the DGV correctly with the CSV style data? (It's not my data unfortunately!)
I am trying to make a small application and I have a problem in binding data after filtering them.I use VB 2005 and SQL 2005. The data are shown in datagridview and I bind the selected row to the text boxes of the form. eg.[code]Later on I search the data for some records and at the same time I remove the databinding. When I try to bind them again it does not work because the index is from the whole data and not the filter data.I have fixed the problem in another situation where I had autonumberin as a primary key and I used this as an index. In this case I use platesno as an index and it's not working.
View 3 RepliesAm back from burial with a simple nut scratch....(hope its simple)I've queried my database from about seven comboboxes, textboxes and datetimepickersbut now before the data is put to the list view i want to sort it further more intogroups. Crop is the main group followed by variety.this is the code under the search button
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sqlCrop, sqlVariety, sqlEnteredBy, sqlFromTo, sqlSDN, sqlWHERE, sqlAND1, sqlAND2,
[code]......
This is the code string I use in my app. to bind a label to the relivant data field.
[Code]...
I am pulling different information from the same file at two different times: 1) The first time, I pull information that is inserted into a combobox. I need to use the combobox as a filter for when I pull the information a second time. 2) I pull different information from the same file, and it is outputted into a datagridview table. I already have a filter in place when the information is pulled the second time, and I was wondering if I could add to that filter or if I have to make another filter? The filter (or filters) will be used to filter the information in the datagridview before it is outputted in a chart.
This is the code for binding the combobox to the information
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
[code].....
I am looking for a Visual Basic control for my windows application. It's a either a datagridview or listview in VB 2010. The list actually come with the filtering function on the top row. The user is allowed to key in the search key in the respective column and the list will filter at run time. Please refer to the picture below for your reference, the function is in the red box. I found this control in one of the software. Is there any similiar control in the VB 2010 or 3rd party control?
View 3 RepliesI have some code which displays data in a hexadecimal format, so each line of the display looks like this ...
000000 xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx cccccccccccccccc
... where the left six characters are an offset and each xx represents one character and the string of cs on the right are the actual characters.
I've learned that I have to keep control characters out of that string of cs or the display gets messed up. I've been using this code and it works fine (when it's not commented out). (binbuf is a Byte array)
'Select Case Convert.ToInt32(binbuf(i)) < 128
' Case True 'traditional ASCII character
' If Convert.ToChar(binbuf(i)) <> " "c Then
[code]....
I've got grid data and I want to allow the user to filter it.I'm curious what controls or methods you all have used successfully to ask the user for this type of information.I see EXCEL allows you to click a header - ask for a filter - and get arrows in the heading to allow you to see a DISTINCT list with CHECK BOXES.Google Docs spreadsheet does almost the exact same thing.
View 3 RepliesI have a question about binding the datasource (MS Access database) to a listbox in a VB form. I have created a listbox and in the datasources explorer I have my datasource say SampleDS. I have several columns inside my datasource, say name, age, address in it. If I select name and drag to the listobx in the form, only the entries in the name column will be displayed in the listbox.
I want to know how to filter the name based on criteria. For example, how do I display names whose age >25?
my table is:
CREATE TABLE [dbo].[VarianceReport](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FN] [nvarchar](50) NOT NULL,
[Fdate] [nvarchar](50) NOT NULL,
[code]....
But inserted null value when all textbox is temp!?!How to resolve this problem and best way for this action?
My program so far reads a certain webpage's source code and places it in a textbox. This much has already been accomplished.
Now I need to pick certain strings out of the rather large amount of text data and have the lines stored in variables, but the trick of it is, the exact string is unknown. The exact function should be, that the code finds certain tags from the source code, say <td> and </td> and takes the string data in between those tags, what ever it may be.
Well I have a list of things I want to search based on multiple points of data...for example Resolution, 3D capable, touchscreen capable....etc....What is the best way for display someone can think of & filtering results by capability, I have none of it typed out, etc...like list of objects & capabilities, etc... alreat...so it can be made any way that is thought to be good(with speed as well) for many different listings...say 1,000 of them & it filters pretty much instantly....reading capabilities & such & the list itself is easy but how can I make a filter(unchecking something brings back things, checking something takes away only since well your adding capabilities to filter selection....I have pictures that can go with items too as well as a name & more information could be given directly with the method or clicking on the picture/item.
View 13 RepliesPrivate Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me:
objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
[code].....
I got the System.Data.DataRowView when I tried to select the data from sql database. These are my code:
......
myCommand = New SqlCommand("SELECT FirstName +' '+ LastName FROM tblVisitor", myConnection)
myAdapter = New SqlDataAdapter(myCommand)
[Code].....
i hve create combobox & text box and add database source to my project...i know how to binding data or load data to combobox using SELECT query..but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...second..can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
View 7 RepliesI have a dataset (WW1Dataset) with one data table(WW1).(database used in an access database) I'm trying to filter the dataset e.g a user wants to filter by a chosen surname (SurnameTextBox.text) so the datset is filtered to display only those records wherethe surname column in the dataset matches SurnameTextBox.text.
View 1 RepliesI have data in my combobox1 and was wondering if it would be possible to sort the data in the combobox alphabetically? I have spent ages trying to find the answer by searching the forum but couldnt find anything,
[Code]...
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 Replies