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 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 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]...
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'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 RepliesI m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
I'm trying to filter my access database and when I "search" by name, it works, but when I search by policy number it doesn't seem to work.
Here's my code:
If RadioButton3.Checked = True Then
Form3.Show()
Me.Close()
[CODE]...
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
View 5 RepliesI 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 want to filter row and put it in a textbox and filter another row in another text box vb.
ex.
ID--------- Date -------- msg_num ------------ Message <<
10001 -- 01/01/2012 ------ msg1 ------------- Blah! Blah![code].....
i wanted to link options selected from Comb box A (general) to specific options in combo box B (specific). I want to pick a word in Combo box A that has specific words/phrases in Combo Box B show. But not all the words to show in the combo box B if they aren't associated with the Word picked in Combo Box A. Ex.When "Soda" is picked in A, only "Coke, Sprite, Fanta" should be visible in combo box b, not everything else.This is the code i used to make the boxes, but i don't know how to link them.
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' fills the combo boxes with values
Me.xGeneralComboBox.Items.Add("Soda")
Me.xGeneralComboBox.Items.Add("Juice")
[code]....
How to use a databound combo box to display one field in the drop down, and another as the combo box text on roll up? Using VS 2005... For example, I have a datatable that has 2 fields. One called "ShortDesc" and one called "LongDesc". I want to be able to see the "LongDesc" column values in the drop down on the combo box. When I make a selection, I want the text in the combo box to read the corresponding "ShortDesc" value.
[Code]...
I am getting an error when i try to populate some combo boxes with a value, the combo box has values in and the right amount the code is getting the right number.
the error msg is "Object reference not set to an instance of an object."
Combo box 2 is filled based on a selection made in combo box 1 and a listview is populated based on the selection made in combo box 2.When the LostFocus event completes in combo box 1, it hits the LostFocus event in Combo Box 2 but it shouldn't. How do I prevent this from happening or if I can't prevent it, how do I work around it? The following is the code used.
Private Sub cboCategory_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboCategory.LostFocus
[code].....
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].....
is 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 Replieshow do i program by saying if a certain item is selected in a combo box then that item will not appear in a second combo box. i have this code for now but it does not work
[Code]...
I know how to add the items during design time but how do you add the items through code. I want to fill the combo box in the datagrid with the results of an SQL query?
View 3 RepliesI have a form with 8 combo boxes and would like to disble certain combo boxes, depending on what was selected in another combo box. The reason is so the user will not have a blank return on a query. The first form I created like this worked great, no issues. This form only allows one combo box (Number_of_Lightheads) to disable any others. Below is the code I have for this Form. why the other combo boxes will not disable the ones that are called out in the code?
Option Compare Database
Private Sub High_Def_AfterUpdate()
If Me.High_Def = Yes Then
[Code]....
how do i program by saying if a certain item is selected in a combo box then that item will not appear in a second combo box i have this code for now but it does not work
j = 0
Do While j < cmbSession.Items.Count
If (j <> lesson) Then
[code].....
I have two combo boxes and I am currently using MicroSoft SQL Server to get the instance name into one combo and the databases on that instance into the other combo. I am wanting to switch to System.Data to get these values and I am able to get the instance through enumeration but am having trouble finding where to get the database name values assigned to that instance.Does anyone know the equivalent of SMO Server.databasename is in System.Data?
View 5 RepliesI want to add a row to that will contain dropdowns,search textboxes, and maybe other controls to allow filtering to the gridview. I've looked at This Question but it did not help me. How can I add a row so i can add these controls to my gridview?
[code]...
Following Karl Ericksons DataGridViewAutoFilter/library/aa480727.aspx I have added bits of that to suit my requirements. But not modifying his original work only adding ComboBox
View 1 RepliesI'm having some trouble extracting a distinct value out of a dataset.. I have a database table with 5 fields,
ProjectName, VendorName, ExpenseType; TxnDate; Amount
In VB6 I would have several different recordsets opened one after another to
A. Find all the unique project names within the table (and put them into a For/Next loop)
B. For each unique project name open a recordset to look up unique vendor names applicable to it (add For/Next)
C. For each unique projname, unique vend combination find unique exptype....for next loop....
D. For each unique projname, vendor name, exptype, date combination, sum up the dollar amounts...
The end effect is that you have a net dollar amount for each unique combination of project/vendor/expensetype/date.I dont like doing it like this because I have to keep hitting the database, I wanted to know if there was something I could do within the actual dataset which will be filled when I open the application with the values of the entire table..I got to ds.tables("Text").select.distinct( ....not sure how to proceed and everthing I've read online leads me into a complicated direction of creating new datatables...
I have a simple application, a form with two datepicker( Datepicker1 is for startsearchdate, while datepicker2 is endsearchdate) to filter out any record that not in the range. The source of the record is readed from a rtf file.The record is in format as showm below.[code]...
View 9 RepliesI want to filter a collectionviewsource using a filter I've written, but I'm not sure how I can apply the filter to it?
Here is my collection view source:
<Grid.Resources>
<CollectionViewSource x:Key="myCollectionView"
Source="{Binding Path=Query4, Source={x:Static Application.Current}}">
[code]....
gives me the error: Failed object initialization (ISupportInitialize.EndInit).'System.Windows.Data.BindingListCollectionView'view does not support filtering. Error at object 'myCollectionView'
i have two DatePickers on form and I want filter between two dates. So when i click search in lsitview display the dates between can anyone tell me how to deal with?
View 2 RepliesI am using Spreadsheet and I am saving the Data in Excel File. and I am opening Excel File like the below code xlApp.Workbooks.Open(path) // Path means where I am saving the Excel file But the issue is I need to Turn off the filters before Opening the Excel File?
View 2 Replies