I'm trying to concatenate nonnull multiple columns from a database into the text property of a combobox. Right now, I'm receiving an "IndexOutOfRangeException was unhandled name, address1, address2". The line in red is where the error is occurring. Here is my code for this section:[code].....
View 1 RepliesI'm trying to concatenate nonnull multiple columns from a database into the text property of a combobox. Right now, I'm receiving an "IndexOutOfRangeException was unhandled name, address1, address2". The line, "cboFreight.Text = drFreight("name" & ", " & "address1" & ", " & "address2")" is where the error is occurring. Here is my code for this section:
Dim drFreight As SqlDataReader = cmdCorrespFreight.ExecuteReader
While drFreight.Read()
'If "address3" <> "" Then
If IsDBNull(drFreight("address3")) Then
[code]....
I have been searching for an easier way to validate the text property of my combobox.
Below is a background of what I am try to accomplish:
I have a from that contains many controls, mainly comboboxes that are bound to datatables. I have these set up in such a fashion as to when the user begins to type, the values begin to show and auto populate the combobox. This makes the selection process easier to select an actual value in the list. But, as we all know, you can lead a horse to water but you can't make him drink. Users still have the ability to type something that is not in the list. I do not want to allow them to leave the combobox until the have selected or typed a valid value from the list because I am building a SQL query to retrieve data for a later form. I don't want to lose the above mentioned functionality of being able to type it in. I currently have it working as follows, but there must be a more elegant way to do this.
I first populate my combo box like so:
CODE:
The part I don't like the most is that I feel like I should be able to use the list already loaded in the combobox data, but I can't figure out how to do it. So I end up having to reload it, this seem like a waste of time.
I'm filling a combobox from a dataset that has three columns, DealerID, DealerName, DealerState. I can only get one column to display. show two or more columns in a combobox? My code follows:
adapter.Fill(datList, "tblDealerID"))
Dim drDealer as DataRow
For Each drDealer in datList.Tables("tblDealerID").Rows
cboDealer.Items.Add(drDealer("DealerID"))
Next
Does anyone know how I can go about concatenating multiple columns from a table to populate into a combobox? I have 4 columns from which I need the data to show up in 1 line when clicking on the dropdown/combobox list. I'm not sure if I have to deal with the display member or the value member.
View 2 Repliesi just finally got my code, with the help of you guys, working to fetch column values from my database and display it in a ComboBox.
Now i am thinking to myself that simply displaying a customer's surname just is not enough due to repetitive issues etc. What i propose that i should do is have multiple column values in a the combo box. For example
CustomerID, Surname, Firstname
My current code is:
con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:My DropboxDocumentsTaxi Service ProjectDatabaseTaxiProjectDatabase.accdb;")
con.Open()
[code]....
I have seen something like the following in many software. Combo box populated and displayed with multiple columns (for example stock code, stock description). But now I am only able to populate with stock code. May I know how to achieve this? I know it can be done by calling a form (And I can do whatever coding in this form) out when clicking on the combo box. But I am looking for better solution, or is it possible to populate the whole datagrid into the combo box as source instead of only the data.
View 3 RepliesI am working on a project that uses lots of custom class objects.Before starting work on real project, I tested the object behaviour on a temporary project. And find that if i add the object to a list and combobox and then make any change to the object property then it reflects in list and combobox.But after using the same process in real project the change does not reflect. Why?Also, how can i update object property placed in the combobox.
for eg.
Class X has property id and name
created objX of type Class X and set id=1 and name='All'
[code].....
I have a form created in VB.net. It is used to get some information form a user. The form is not bound to any data source.
A combobox on this form is used to enter a cost. I want the value entered by the user to be displayed using currency format. I have used the Format String Dialog that opens from the ellipses button on the FormatString property of the combobox and selected Currency. This put C2 into the FormatString property.
When I run my application, this format is not applied to the value entered into the combobox at the time the number is entered or when I leave the combobox.
In a combobox populated by a DataTable I am having two issues!The SelectedIndex property will not set 1. Either by integer 2. Or by FindString
[code]...
While modifying my form, I was suddenly unable to place any of the controls onto the page - i kept getting an error:
"Components cannot be added in localization mode. Select Default in the Language property."
So I set my language to Default...thinking that perhaps it had somehow gotten set to another setting. That seemed to fix it...I could now add controls to the form. Suddenly however, when I run the form, I notice that my new changes aren't there. If I re-set the language property to what it was before setting it to default, I see the form I see when i run it...it's like there's 2 forms.
Is it possible to use 'Tab Stops' when you're concatenating (say) a Label text? I know it can be done for a PrintLine statement but I'm, trying without success, to put tabs after the colons in this code. ( "...... :" & vbTab ...)
Label1.Text = "Width margins:" & a.ToString & " Pixels." & vbCrLf
Label1.Text += "Height margins:" & b.ToString & " Pixels" & vbCrLf
Label1.Text += "Top margin:" & c.ToString & " Pixels" & vbCrLf
Label1.Text += "Bottom margin:" & d.ToString & " Pixels" & vbCrLf
Poppa.
I have a textbox "myTextbox" and a listbox "myList" which shows a list of strings e.g "AAA", "BBB", "CCCC".When the user clicks on an item from the listbox the text must be appended to the end of whatever is in myTextbox with a space preceeding it. e.g " AAA".The user must never be allowed to delete the added text.The user must be allowed to manually enter text in the textbox but it must always be in front of the added text. They must never be allowed to type over the added text or after the added text.I have been trying to get my head around this for a day now and cannot figure it out.
View 7 Repliesaligning text into columns in a textbox.
I need it to look like the following:
XXXXX XXXXX XXXXX XXXXX
XXXXX XXXXX XXXXX XXXXX
I've seen several representations of how to do this in VB6, but I would prefer managed code (VB.net). Also, I want to make sure that what appears in the textbox will translate to the printed page the same way.
I have this application which has one class. I need to return a recordset of data to the calling form. If i use Properties to return, it can only return only a single value at a time. Right now i'm returning a datareader object with one of the properties.Can anyone suggest a better way to return multiple rows of data to the calling method via Class Property?
View 1 Replies I'm rewriting a VB6 application in VB.Net. So far I have 2 forms, frmLocations (frm1) and frmLocationInfo (frm2). frmLocations has a combobox, cboLocations, from which a selection is made and an "Ok" button is clicked, which then loads frmLocationInfo. frmLocationInfo has a series of textboxes to display info corresponding to the location that was selected - Location, Location Number, Phone, Fax, Email. There are also 3 comboboxes on frmLocationInfo - cboDepot, cboFreight, and cboDispatcher. I need their text property along with items to be populated, also with data corresponding to the initial selection made on frmLocations. I'll spare you all the difficulties I'm having w/the other comboboxes, and instead focus on cboDepot. I have gotten it to populate its text property to display the corresponding Depot, however, the items are not populating and all you see now when you click on the dropdown arrow is only the depot that shows up in the text property.
Here is the code for this portion.
frmLocationInfo
Private Sub FillDepotCombo()
Dim sql As String = "Select distinct depot.depot_name, depot.depot_refnbr, locations.site from depot inner join locations on depot.depot_refnbr =
[Code]....
So I'm trying to make a combobox use a string that has other strings and has text too. [code]...
I'm trying to use numbers more than once so I want everything to be in there. I tried using:
Dim numbers As String = (one or two or three or "four" or "five")
but that didn't work either. Is there any way to make this possible
creating a function that reads in data from multiple textfiles into a combobox. The function just needs to read line 1 into from every text file into the combobox.
View 3 RepliesI'd Like to know how to make a free text search function, If you don't Know what i mean by "Free Text Search" then here is an example:
Lets say i want to search for the string "ong" in a Combobox(In the list ofc)
And we have the following Listitems:
Tim Carlson
Bob Hanks
Julie Wong
Jennifer Sanfre
Jimmy Wong
<<
Then Both Julie and Jimmy Should apper in the combobox list.
How do I read 4 textfiles and then put he names of the files in to a combobox so when one of them is chosen it write the text into a listbox.
View 4 Repliesfollowing issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
I have 7 textbox's.
Names are
textbox1
textbox2
[code]....
I need to do
For i = 1 to MyVar
textbox(i).enabled
next
Am currently piecing my programm together and working on structure. My plans will have me running multiple forms,and my question is this. When I have ,say ,on form1, a "TextBox1" and on another form a TextBox with the same name,will I have conflicts when I access data across forms. Should I be taking care to make sure textboxes and buttons names aren't being repeated,or will VB know what I want?
View 11 RepliesI have a small project i am doing for work to compare our website catalogue to our actual inventory in our financial software. To do this, i have exported the online catalogue as a delimited text file using "^" as the delimiter. I then want to go into our Accpac data a find out if all the items are still active, the current price and the stock on hand.
[Code]...
I wanted to have multiple color for text in single label controller
e.g.
label1.Text = " $ 480.00 "
What I want is character $ in Red color and other digits or character after $ in color blue. $ 480.00 I cannot use separate labels for digits and $ due to limitation
I am trying to find a way to show a large amount of data that spans across multiple forms and text boxes. I am making a somewhat summery of the input strings.
View 3 Repliesi wan to display the text from combobox into the textbox and clear the combobox text when click on the button.But when i select another text from the combobox and click the button, the textbox display and overwrite the previous text.How can i do so that when click, textbox display text from combobox and clear combobox text. Then click again, display the new text at 2nd line of the textbox without deleting the previous text?
View 5 RepliesI'm trying to create a datagrid with auto generating columns. Let's say my Collection is a property named Articles of my viewmodel of type ObservableCollection<ArticleWrapper>.
I bind now the ItemsSource to this collection:
<wpf:DataGrid ItemsSource={Binding Articles} />
The class ArticleWrapper is like this:
[c#]
public class ArticleWrapper
{
public ArticleConfigurationSet ArticleConfigurationSet { get; set; }
public string Description { get; set; }
[Code]....
But now my problem: I want to bind the displayed data to my ArticleConfigurationSet property. But I cannot change my ItemsSource Binding, because the SelectedItem property of the datagrid must be of ArticleWrapper (for command handling).
The datagrid should also look like this:
I have this code here:
[Code]...
I know there is MyDataTable.columns How can I get it to put the columns into a ComboBox so i can select them?
So i have a datagridview with two combos, when the form it's created i fill the first one with all the MainValues, and the second one with all possible values for the MainValues (called SecondValues) (1..N).Now my issue, when the user selects one value from the first combo i want to fill the second combo with all values related to the selected MainValue, i can do this for example by filling the datatable again with a parameter that filters the data, but if the previous rows have different main values, the dgv throws errors because it doesn't find the binded ones in the new filtered datatable.
How can i handle this? One datatable for each line?! Other thing, i'm using the SelectionChangeCommited event for handling the values change (in theEditingControlShowing), but if the user uses the keyboard to select the values the event doesn't behave in the same way or the way that i need. The values in the combo are numeric values (1001,1020,2010,3010), when the user select one of the values, i need to fill another cell in the same row with the number selected plus some string, example combo:1001 cell:1001XPTO. So if the user presses 1 in the keyboard the combobox selects the 1001 and fills the cell with 1001XPTO, but if i keep pressing the keyboard to select the 1020, by pressing 0 and 2, i get the 1020 selected in the combo, but the cell remains with the 1001XPTO.