I'm trying to select a company name from a data bound combo box, then display the relevant record in a data bound datagridview.
I've currently used the Data Sources wizard to set the connection string, create the dataset and dragged the combo box and datagridview onto my form.[code]...
I have a ticketing system that reads a MS 2003 MDB. I can easily fill the DataGrid view with all of the items on the data set How ever I need to be able to have agents filter the rows by login(key)
I have a large list
made this way
csrLogin.Add("james", "TomJim")
I select agents on the menu strip and the combo box populates all the names in that collection (combo box displays TomJim in this instance
I have an SQL query made (I think it is correct)
[Code].....
I have a datagridview (datagridview1) on my form which onload displays all the records from the bindingsource (bindingsource1) via an sql connection to a table in sql server called "article".
I also have a combobox on the same form which displays the name column from the same "customer" table -
Me.ComboBox1.DataSource = customerTable
Me.ComboBox1.DisplayMember = "custname"
Me.ComboBox1.ValueMember = "custid"
I would like to enable my combobox to filter the datagridview via itsSelectedIndexChanged event . So if custname "xxxone" is selected in the combobox then the datagrid shows only the results for custname "xxxone".
So far I have worked out how to enable the combobox to move to the position in the datagridview depending on which custnameis selected-
Me.myBindingSource.Position = Me.ComboBox1.SelectedIndex
But this method still shows the other titles,it doesnt filter them out, it just points to the selected custname. I cannot find how to filter the datagridview so ONLY the selected custname is shown.
I will be changing the field names, I have used custname and custid just to describe what I am trying to do.
I've got some code like the following. I want it so that when I chose an item in 'select 1' it changes the in the second combo box but I'm not sure of the best way to go about it. Does it have to be AJax or can it be done with just Javascript?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
[code].....
I have a datatable loaded from a database. I bind the datatable to a gridview on page_load. Now I want to filter the gridview by a user selection so I made a checkboxlist and wrote some code as follow at CheckBoxList1_SelectedIndexChanged
[Code]...
With this code above, it can filter if there is only one selection on the checkboxlist. I try to loop the checkboxlist myself but always ended up in errors. Hope someone can help me out to make this work.
I want to filter a text in all columns in a datagridview. So I use Like % in the filter text. However, I found that the text(strFilter in my code) may contain % sometimes. So it have a syntax error. How can I use filter with like clause when the filter text contains %?
Private Sub PassFilter(ByRef dataTable As DataTable, ByVal strFilter As String)
Try
Dim dataview As DataView = dataTable.DefaultView
[Code].....
I have two combo box in my program
one has the subteam for example if you click the 1st combo box, the items would be[code]...
i have two combo box in my program one has the subteam for example if you click the 1st combo box, the items would be
[Code]...
what i want to happen is that if i chose A1 only the members of team A1 would appear in my combo box2. and by that, you need an sql statement. but how do i code that?
I have a problem to make a selection by using combo box(cbChoice). if I have 2 item [name], [age], [id_number]. After click SEARCH button, the data from database will display to textbox. this my code but its not work
myCommand = New MySqlCommand("SELECT * FROM daftarpelajar WHERE " & cbChoice.Text & " Like '%" & txtSearch.Text & "%' ORDER by id_pelajar ", conn)
[code].....
I'm new to VB.NET and looking for some help with combo boxes. I was wondering if it is possible to link 2 combo boxes to each other based on user selection? [code]If the user selects Dept Name "Bakery" from the first combo box the second combo box should fill with the appropriate Section Name i.e. "Bread", "Cakes" etc.I am using VS2008 and the DB is SQL Server 2008. Both combo boxes are currently bound to the above Tables and displaying all Dept and Section Names.
View 2 RepliesThe combobox is bound via binding source to a table. How can I display the list of look up options while having the first option say [None} and if selected, clears the value from the list.
View 2 Repliesok, got a question here, two really. first i'll ask the hard one, as i think i have my other one out of the way so i'll save it for later but i made a program where a user enters in dimensions in several text boxes in inches. there are radio boxes that the user decides what thickness of wood they would like to use. what i'd like to do is add metric into the program and use two combo boxes. one combo box drops down and you can select inches, centimeters, or millimeters. the other one drops down to choose the thickness of the wood.ok now here's my question. say i pick inches in the first combo box, i'd like the second one to display only the thickness of the wood in inches, no metric. if i pick centimeters, i'd like the second combo box to display the thickness of the wood in only centimeters, no millimeters or inches. and the same goes for millimeters.i also have the program on a timer that runs at 100 milliseconds so the user can quickly see the differences in dimensions they put in instead of having to hit the calculate button over and over and over (not sure if that really matters or not, had a couple issues with the boxes earlier but don't think it was timer related now)but is this possible? basically just looking for the kinds of drop boxes that you see on a page like autotrader.com where you select dodge, and then only the dodge cars are listed, select chevy and the chevy cars are listed, etc.
View 7 RepliesI am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out what the first one is requesting. Basically it's choosing a line number on the first box and then selecting the machine associated with that line number.[code]...
View 4 RepliesI created a filter for a datagrid using a combo box, but every time I select an item from the combo box and there is no data for that filter I get the following pop-up error during debugging:Index -1 does not have a value.Here is the code that I am using:
1 Private Sub RYAN3estimatesBindingSource_CurrentChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RYAN3estimatesBindingSource.CurrentChanged
[Code]...
lets see if I can explain my self. I have 2 fields in the country the country table "CountryName & Countrycoed" . My question is how to display the Contrycoed in a textbox after selecting the country in a combobox. For example if I select Canada in the combo I would like CND to be displayed in the textbox. This is the SQL I have to load the combobox
comType.CommandText = String.Format("select CountryName,Countrycoed from Country ")
As the title suggests I have a ComboBox and 2 listBoxes on a form. I need to fill the left ListBox with items not now asssociated with the ComboBox selection and the ListBox on the right with items already associated with the ComboBox selection. Is it possible to populate the ComboBox and each ListBox using only one query and returning a dataset of ALL the data to do so, or do I need to Populate the ComboBox, then use 2 queries, one for each ListBox?
View 6 RepliesIn my below forms, the user select a name from the combo box list and enters an amount for the name selected. The user can enter as many entries. Every time the total button is clicked, I would like the total for each person to be display on the labels.
View 1 RepliesI am still having issues with the combo box. I have the correct query. I have four tables in MS Access. I need to create a form in Visual Basic that has a combo box and a datagrid. The selection from the combo box will display all relevant information about that person on the datagrid. For example, if I select John Doe (from the combo box) the datagrid should display: [Code] How do I add John Doe to the combo box and link this query to it, when upon being selected, it displays the result in the datagrid?
View 1 RepliesI have a combo box on few of my vb.net 2010 programs. The end users that use my program have touch screens and they have a hard time making selections on the combo box. I have an Android cell phone and when ever there is a combo box it will open another screen and making the selection is a breeze.
View 1 Repliesis there a way to set a single cell as a combo box? it looks to me that you can only set the whole column.
View 5 RepliesI'm working on a mobile project, and I have this:
search textbox (fillby method)
combobox (bound to the data)
datagrid
[code].....
I have a form that has a combo box and a sub form which displays as a datasheet or aka. datagrid. I would like as i type text into the combo box that the datagrid scroll to the matching record.
View 9 RepliesIn VB.NET 2008 I've two forms 1 & 2 containing two datagridviews connected to two data source 'ACCESS 2007 tables' Now I want to select multiple rows from one datagridview (form1) & transferring these to another empty datagridview (form2) with a button_click.
View 3 Repliesbased on a selection of name and time i want to add a value or text in datagridview,but it doesn't return a value... this my code
Public
Sub Btnplanner_Click(ByVal
sender As System.Object,[code]......
Is it possible to multi select cells in a DataGridView over several rows?
Example:10 columns, 2 rows
Say I click and hold in row 1, column 5. If I then go down to row 2 column 5. I want column 5 to 10 in row 1 and 1 to 5 in row 2 to be highlight.
Am using vb.net 08 and i have a datagridview with 3 columns. The first column has a button as the columntype with the name "UserName". Now, i want if the user clicks only on the UserName which is the first column, but not the entire row, it should display the value of the UserName column only. If other columns are clicked are apart from the UserName, nothing should display. So there will be a for loop that will itera te through all the rows of the datagridview.
So i have something like this:
CODE:
I have been looking all over the place trying to figure out how I can programally select a certain Cell in a row. What I am attempting to do is when doing Rowvalidating, and I find that the user has not filled out a column, I do a msgbox, then want to have the cell have the focus, so user can enter in the data. IE, like the way you can cause a text box to have the focus.
View 4 RepliesI want to know if it is possible to click in one cell, and the entire row be selected.
View 6 RepliesI am using VB 2008. My DataGridView could contain a thousand rows in alphabetic order and I want my users to be able to find a row quickly without them having to scan through many rows. I could provide a row of buttons captioned A to Z or I could provide a search field in a textBox but in either case my program would have to find a particular row and focus on that row. Question one: Does DataGridView have a function that searches for a a particular value in a specified column? I have found no alternative to sequentially searching through the list. Question two: Once I have identified the index to a particular row, how can I make that row become the selected row?
There is so much to DataGridView that somebody should write a book specially about DataGridView. I would buy it.
I have a vb net program that shows a datagridview which pulls data from a mySQL database. When the user clicks on a row (I am checking for a 'cellclick' event), a text box is filled with data from a hidden column in the datagridview. This works fine and runs without error, BUT...When I use the cursor keys to move the selection up or down, the row highlight changes, but doesn't update the text box. I realise that this is because I am looking for a 'cellclick' event, but I don't know how to look for cursor keys as well.
Please could someone tell me what event I should be looking for to capture input via both mouse click and cursor. I have changed the program so it updates the second dgv on 'selectionchanged' but this crashes at run time with an InvalidCastException.Alternatively, is it possible to stop the user using the cursor keys?