I want to limit the number of students (60) that will be enrolled in one section and prompt a message that it surpass the limit. I inserted it in my combobox1
Here's my code :
strsql = "select * from Schedulings where Sections = '" & ComboBox1.Text & "'"
Dim acscmd As New OleDb.OleDbCommand
acscmd.CommandText = strsql
acscmd.Connection = asconn
acsdr = acscmd.ExecuteReader()
It doesn't work. How should I do it?
I have a mvc 3 vb.net razor App that I need to redirect the view to a different action if the link is not clicked on between a preset range of Month/Day/Year ranges.This is needed to limit registration for a school semester to only be able to be performed between and Open Registration Date and a End Registration Date.I am thinking I can simply put this in the controller function in the form of either a If Statement or a select case and then use redirect based on the condition of the date..Is there some simple short code to use to perform this test.My variables for the dates are OpenDate and EndDate.[code]
View 2 RepliesMy combobox dropdownlist contains 60 to 65 items. So i want to show 5 items in the dropdownlist of my combobox and add a vertical scroll bar in it so that the user can scroll it and see the items. How to add a vertical scroll bar in the combobox dropdown list? I want to add this vertical scroll bar only when the dropdown list contains more than 5 items.
View 5 Repliesi have a databound combobox using VB2010 and MS access as the DB.. When i click on a button, the selected item in the combobox will be deleted from the database and no longer display in the combobox...
View 1 RepliesI am using VB.NET together with ADO.NET to create a program. I have set my TableAdapters as needed and bound the correct tables-columns to my comboboxes.My problem though is this:My combobox2 item is bound to a datatable. The table adapter's Fill method (the select command basicaly) includes a public variable in the where clause to fetch the correct results. I ll put some code here to clarify it a bit more.Public Class Frm_inv
[Code]...
I am new to vb.net and I am using visual studio 2010. I have two comboboxes on a form, each combobox is set to DropDownList so that a list of items can show in the combobox, but no text is allowed to be entered.
For combobox A, if user chooses item 1, the list of combobox B should be updated accordingly. I think this is quite common on a lot of applications. But I do not know to implement it. I even do not know the keyword to search for the relevant property or event handler.
I think my question is discriptive, or as Microsoft in the Documentation for Data Grid the question is, How do I have a combo box column display a sub set of data based upon the value of a different combo box column?
[Code]...
I have two ComboBoxes
<ComboBox Name="cmbMake" DisplayMemberPath="MakeName" SelectedValuePath="MakeID"/>
<ComboBox Name="cmbModel" DisplayMemberPath="ModelName"/>
I use LINQ-to-Entities to populate the cmbGroup ComboBox
Dim db as myDataEntity
cmbGroup.ItemsSource = db.Makes
How do I populate my second ComboBox (cmbModels) based on the selection of the first ComboBox (cmbMake) using XAML so that whatever I select in the first ComboBox automatically filters the ItemsSource in the second ComboBox?
How do i populate my state combobox,such that when i select the appropriate country my combobox will automatically display the appropriate state?
View 7 RepliesI have a combobox wich I want to populate based on the value of another combobox.[code
View 2 RepliesI am wondering if it is possible to change the text of certain values in a combobox based on if a value is true in the sql datatable.what i have is a Roles Table with 3 columns RoleID, Role and Role not used.if Role Not used i want it to be displayed in bold.
View 8 RepliesI have combobox, listbox and textbox. Combobox has datasource datamember values assigned i would like to select a customer from a combobox and save the datarow based on that selected value to an array it could be a list or whatever created in memory as variable and this will be my listview Datasource. I understand within that current row there is ID value which is interger.[code]...
View 4 RepliesI am using a bound combobox control in a vb.net application. How do I set the combo box to an item if I know the value of the ValueMember, but I don't know the DisplayMember. I can use the FindExactString method if I know the DisplayMember, but not if I only know the ValueMember.In explanation, the value member is an employee Number, the display member is the Name. I get the employee number from a detail item in another table and now I want to set the combobox to display the Name that goes with that detail item.
Can someone post some vb code to show how to do this.
How should i set the combobox selected index based on the "value". The following is the sample code. I am getting an error on the button click event.
[Code]...
I have a combobox (cmbCharge1) that gets populated by a text file. Inside the combobox, the data inside is laid out like this: 41-1A-1303: EXPIRED REGISTRATION Now, autocomplete works fine, if I start typing in the statute (like the 41 part). But what I need is for it to autocomplete based of whats after the: So if I type in EX, then everything starting with EX pops up.
View 5 RepliesI have a combobox which is populated from a dataset (pulling values from the column Actuator_ID). When an item is selected from the combobox, I need to return another value from the dataset (column Gateway_Channel). In the 'selectedindexchanged' sub, I have the following line which should return the value from the second field (gateway_channel) but whatever item is selected in the combobox, only the value from the first row is returned.
errBox.AppendText((ds.Tables("Actuators").Rows("Actuator_ID" = ComboBox3.SelectedItem.substring(0, 2)).Item("Gateway_Channel")).ToString
I have VS2005, Microsoft Access 2003
ComboA is binded to the Customerstbl and displays the CustomerNames. ComboB is Binded to the CustomerContactstbl for the selected customer above and displays all Contacts for that customer is a second cbobox.
I am having a hell of a time with this, When I select a customers name in ComboA, I want ComboB to automattically query the contacts in ComboB based on ComboA's selection. where do I create the query for getting the contacts for that customer?
In the Customer or Contacts tbl?
Is this something that would be better hard coding or is VS2005 that much improved that its ok to use these binding features?
Im trying to format the length of a DataGridViewComboBoxColumn based on the length of the longest string in the comboBox. Here is the code I currently have but it only formats the DataGridViewComboBoxColumn based on the users previous selection in the comboBox.
Is there a way to have the DataGridViewComboBoxColumn at the length of the longest string in the comboBox? Here is my code.
Private Sub comboTest_SelectionChangeCommitted(ByVal sender As Object, ByVal e As EventArgs) Handles comboTest.SelectionChangeCommitted
Dim senderComboBox As ComboBox = CType(sender, ComboBox)
[Code].....
I have a combobox populated from the DB with:
-ID
-State
-Tax
State is the only value that is shown.I'm trying to get the hidden value, Tax, from the combobox based on the selection but can't figure it out.
how to generate unique ID based on combobox selection?
View 5 RepliesI'm new to programming and I'm using vb.net 2010 and I'm stuck with this problem. So here are the details, I have 2 tables in my database, a product table and a category table. In my product table I have product no, product description and category no. In the category table i have category no and category desciption. So this is where Ive been stuck for the entire day, I want my combox(product) to populate based on what is in the combobox(category). For example I have "Chair" in my combobox(category), then what would appear in the combobox(product) would be "sofas", "dining chair" etc.'the part below is where the program will read the category description from my database
Sub fillcomboDesc()
Dim fillcatDesc As MySqlCommand = New MySqlCommand("Select catDesc from category;", connection)
[code]....
I have the following code which add items to a combobox in my form:
Public Class Contas_Bancarias Private Sub Contas_Bancarias_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:BDadosBANKREC.accdb;Persist Security Info = False"
[Code]...
assist in the proper way to populate a value in a txtbox based on a combobox selection? I basically have a table (tblStudent) that has two fields (Range, Amt). The range records are 1-5,6-10,11-20,21-50, >50. Amt are 0 by default.
four more Tables
(tblPA,tblNY,tblNJ,tbMD) with 2 fields (pctgStud,amount) where prctgStud are
ranges (0, 1-10,11-25,26-50,51-100). Amount are 0 by default.
My form has a 5 simple comboBoxes that allows one of the ranges to be selected for each of them. I also have 5 txtBox relating to the corresponding (Amt) fields. How do I populate the textboxes with the related AMT based on the range selected from the comboBox. On a side note, I want to ultimately increment all the textbox values by one in the tables when submit is clicked.
I want to populate the combobox based on the selected item in the first combobox. The following code is written in vb.net 2008
Public Class Form1 Sub fillcombo()
strsql = "select * from device"
Dim cmd As New OleDb.OleDbCommand
cmd.CommandText = strsql
cmd.Connection = con
[Code] .....
For this code I am able to populate the first combobox and when I select the specific item in combobox then the second combobox shows only the first element of that item.
In MS access 2007 I have created 2 tables:
1) Contains the device ex:computer
2) Contains the device and its parts ex: cpu, monitor so here the device has duplicate values
Table names are device and parts.
I'm trying to populate textboxes on one form based on a selection on a combobox on another form. All data will be pulling from the same SQL table. I've got the combox to work fine to show the correct data in one of the textboxes by using the lines:
Dim connectionString As String = "Data Source=F03D3S-DEV01; Initial Catalog=dos_track;" _
& "Integrated Security=True"
[Code].....
,but not sure how to get the other textboxes to fill with the correct data (from the same SQL table row) associated with the combobox selection. I've spent SO MUCH time on this trying to figure it out, but am getting nowhere fast...
The user picks x amount of scenarios from the combobox, and x amount of columns appear in the datagridview. If the user changes the number of columns from x amount to y amount, the columns should be added/removed respectively but currently when y amount is chosen x amount of columns are in the datagridview.
I'm not sure how to do this, I've tried using an IF statement under the .SelectedIndexChanged event but the code adds columns until it reaches as high as it can go, then pulls an error saying too many columns.
Contact Title has a default value which is Sales Person. Anyhow, when a user click Edit on the chosen ListView record, i need Contact Title to have the right value that corresponds to the chosen record. For example, if user clicks edit, the fields on the left side will be filled with values. In this case, i want Contact Title to view the right value.
View 1 RepliesI am writing a program in VB 2008 and i need to be able to select different pages. i have a ComboBox with 15 values in it, and based on what value the user selects, that is the Form i want it to go to. for example, if i run the program and select the Value "electrical", then it will take me to the form that corresponds with that selection. [code]...
View 1 Repliesmy question is how to filter other comboboxes based in first combobox whish is having same data as all.i am using visual basic 2010 and a ms access database which is connected with code.a vb form have five comboboxes and all comboboxes are field with same data with this code:
Private Sub loadsubject()
Dim OleDBC As New OleDbCommand
Dim OleDBDR As OleDbDataReader
[code].....
I am creating a program that will allow me to manage server EXE's for which I have the method to do so already completed. The problem comes when I want my front end to be able to use a database of different server configs stored in a dataset.
My Database has 4 columns (ServerID | ServerName | ServerPath | ServerMod)
I wish to be able to select the ServerName in a combo box (already done via Datasource/DataMember) and then load the ServerPATH and ServerMOD for that row into two variables.