I have a combo box and onload I want the combobox to be populated with data in a field from the database. However, when I execute I receive an empty combo box please could someone look what am doing wrong..
Private Sub populatecmbprojtype()
Dim cmd As New SqlCommand
Dim conn As SqlConnection = GetDbConnection()
I have a project that currently uses an XML config file to create some groups. Based on these groups, you can search a database for information. What I want to do is create a form for editing that file. I can get to the information via messagebox, but when putting it into a ComboBox, I can't get the list updated. I have tried the text property which only populates the initial selection, and the Items is a read-only property. Nothing else looks close to what I want to do.
My other thought is to populate a datatable with the information and then populate the combo box from the database. It seems like an extra step that I shouldn't need, but it may be the only option right now.
The reason it can't be hardcoded is that the XML config file is already being used by a program, and the file may be updated from two or three computers, meaning I need a central location for the file.
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")
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.
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
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>
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
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?
I am having a strang problem with button event handlers that I am creating at runtime.Actually if I set the form as startup form everything is working fine but when I set the main apllication form as startup form the events for buttons created at runtime are not firing.I am posting the code so that you can have a better look and see whts wrong?I have two classes under spotlight here "Class1" and "Grid"I am creating an instance of grid in class 1 and in a sub in grid I am creating buttons dynamically as follows and adding event handlers
For i As Integer = lIndex To uIndex Dim btn As New Button btn.Name = ds.Tables(tblName).Rows(i)(btnName).ToString
In the code below in the btnAmountEarnedClick event, the lblResults is not being populated.
Private Sub cboRecycleSelection_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboRecycleSelection.SelectedIndexChanged
I have several combo controls that need to be populated with a specific ID and name. I want the user to choose the name and have the ID in the background. Later when the data is exported from the database the specific ID's are exported and not the names.
I see that I can create the items in the combobox rather easily using their names. However, how can I associate the ID number for each of the items. Private Sub frmReceipts_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Add receipt types to combo box cboReceipt.Items.Add("Monetary") cboReceipt.Items.Add("Inkind") cboReceipt.Items.Add("NSF") End Sub
I thought it would be better to have a seperate table with the different receipt types and then somehow connect/link the contents of this new table to the combo box on this form. However, I am at a loss on how to do this.
I tried binding a DataGridView to a DataSet using the DataSource property but no data appeared in the DataGridView. I placed a DataGridView in an empty form, making no property changes except for the name. I did not create columns in the DataGridView. In the form's load event I placed the following code for loading a dataset named ds Executing in debug mode, I confirmed that there was data in that dataset. No column headings or data appeared in the DataGridView. What am I doing wrongly? There are 34 fields (columns) in the DataSet - maybe it exceeds the capacity of a DataGridView.
I have set up a search form so that when the user enters a character, a search occurs. I have some code behind to do the search. The code I am using is as follows:
Javascript:
<script type="text/javascript"> function TextBox_OnKeypress() { document.getElementById("ctl00_MainForm_ibtnSearch").click();
How do I add rows that have already been populated. I saw a param that took an array. I have 8 columns, so would I need 8 elements in my array when I add them I have the code: me.datagridview1.rows.add() But I want to modify the data in the row using code, how would I go about doing this?
I'm using this line to populate my combobox with all files in my application path:
ComboBox1.Items.AddRange(IO.Directory.GetFiles(Application.StartupPath))This works fine, however it displays the path as well, and I only want to display the files with extension .txt
I am fairly inexperienced with using datatables in VB. My question is this: Can I access a particular column of a table by name if it is not defined elsewhere like when I populate a datatable using sqldataadapter.
[Code]...
Is this the way it can be done? I believe this is the case, but can't find any definitive examples online (probably not searching properly)
I'm having trouble using an arraylist with an object. [code] The arraylist Phrase gets populated with 4 objects (WordObject) filled with the word "Fox".The arraylist AnotherPhrase gets populated with strings "The", "Quick", "Brown", "Fox".Why does the Phrase Arraylist do that? Shouldn't there be 4 objects each with different words?
withautopostback=true? i am using vb.net and have 50 checkboxes that shall show up from the database data depending on the selected value of the previous dropdownlist. also can i change the label of the checkbox
I have a test Listview with four rows. In the code below when I start at the top and check each row the textbox is populated with the selected value. When I randomly check a row the correct value (checked row) does not consistently populate.
Private Sub lvwInjuredWorker_ItemCheck(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles lvwInjuredWorker.ItemCheck If lvwInjuredWorker.Items.Count > 0 Then For Each lvitem As ListViewItem In Me.lvwInjuredWorker.Items [Code] .....
I have a checklistbox and I'm running the following
Public Sub ProcessCompanyAssociations() Dim clientID As Integer Dim fullname As String Dim CheckedItems() As String = frmMain.clbCompanies.CheckedItems.Cast(Of String).ToArray Dim UnCheckedItems() As String = frmMain.clbCompanies.Items.Cast(Of String).Except(CheckedItems).ToArray
I'm trying to get a combobox to be automatically filled from a text file and have it editable by the user.
So far, when the program is running I can add new items and they appear in the text file and combobox but when I restart the program the combobox list is empty even though the text file has stuff in it.
Dim w As New IO.StreamWriter("z:url.list.txt") Dim linecounter As Integer For linecounter = 0 To ComboBox1.Items.Count - 1
I'm using visual basic 2008 express I have 1 combobox which is populated from a coloum from my database, when I select a value from the combobox I wish to populate several textboxes with data from the row selected. I have created a dataset. How can I do this? Is there a tutorial I can read anywhere
I hav a program that has an icon in the system tray using Notifyicon, i have linked this with my Context menu so when right clicking the tray icon, you get the Context menu pop up.I have a list of URL's that i have read into a string from an SQL database, i want to show these url's on the Contextmenu. and then when the user clicks on the url, for it to open the url in iexplorer. I have read through stuff online but i'm very lost!
I am adding a DataGridViewComboBox Column to a DataGridView. The column is added But when I click onto the dropdown arrow, nothing show up in the cell.
Dim lstCol As New DataGridViewComboBoxColumn lstCol.HeaderText = "Type" lstCol.DisplayIndex = 0
this shall populate the dropdownlist data, but in the value i need it to pick up the "ID" field from the stored proc. the stored proc sends two parameters, ID and Name. so i populate name, but how do i populate the id in value like this -
I'm trying to create a form application in which the user is prompted to enter a date in a textbox by clicking on a button next to it that would popup a calendar. Then the user would select a date from the calendar and the textbox would be automatically populated with the date selection. The user could also just type it in, but I would like to have some kind of validation before accepting the date. I will be converting the date to an integer in this format YYYYMMDD to pass it to a query on a SQL Server 2005 database. Don't ask me why they're storing dates as integers I have no idea I'm just working with what I have hehehee. I've been looking online and trying different things but haven't been able to figure this thing out.