On my form I have two radio buttons. One for CDs and one for books. If I select CDs I have a group box that changes visible = true and I have txt boxes there I want to input. If I select books I want the groupbox to remain visible = false and in its place a text box to appear. How would I do this? I know I can just overlap the controls but that looks hideous in designer.
View 3 RepliesI have a listbox with two values, Current account and Deposit account.The current account has an interest rate of 7% and the deposit account 3%.I have 4 other textboxes. The boxes on the right is where the user inputs and the left side holds the value.
Account Type [ ] Listbox >>[Current account]
Deposit account
Investment Amount [ ] [ ]
Interest over a year [ ]
What I want for the Investment Amount is that if the user selects Current account, the amount invested will be automatically calculated with the 7% interest and the same for the deposit, calculation with 3% interest.And the Interest over a year textbox to show how much the interest will be over that year at the rate (whether its 7 or 3%)
I 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 am creating a programme for my institute which helps in their administrative process. i am using visual studio(basic) 2010. which is connected with ms access database (abcdata.accdb) the database is having table called session with columns sessionID,sessioncode,sessionname.
* sessionID data = 1,2,3,4
* sessioncode data = 13,14,15,16
* sessionname data = 2013,2014,2015,2016
[Code].....
other then this u can see i want this because i am trying to create a database which must save the students data year wise, so that whenever we need to know a detail any students then we can find with query.
Here the code to load the records in data grid when form loads
01
Private Sub BindData()
Just wondering if someone can at least point out where I'm going wrong here. I've already got the code to populate the listbox by a button click from the user and am just trying to figure out how exactly to alter the text of a label based on what the user selects in the listbox. From what I have the Label will display the case else selection but nothing else despite my best efforts to get it to change. Here is what I've tried. I realize it is very trivial, but I am only a beginner to programming.
[Code]...
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?
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 RepliesGiven the following XML, I would like to return all eventtitles where the eventtype id = 23. My current query only looks at the first eventtype, so returns the wrong result.
<event>
<eventtitle>Garrison Keillor</eventtitle>
<eventtypes>[code].....
I'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'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...
NB: I'm using Visual Basic.NET?My form has 2 DataGridView controls. One of these is bound to a DataSet, the other isn't visible - at least not until the user selects a uniqueidentifier cell in the 1st grid.When the user makes this selection, the 2nd grid will become visible and display the row from another with the same id as the one selected in the 1st grid.So, basically, I want to dynamically display data in one grid based on user selection in another grid.My code looks like this so far...
Private Sub RulesGrid_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles RulesGrid.CellClick
Try
FlagsGrid.Visible = True
[code]....
We have a GUI that displays a radio selection box (3 options) that are the three sites where our hospitals are. We need to dropdown located on the form to fill with only the locations based on the selected radio option.
Here is the code behind we have so far (sorry, VB)
[Code]....
For the record the Location dropdown is currently databound but its a static SELECT statement which brings us all the locations but we'd prefer it to be cleaner if it only returned the locations based on Site. We are using Visual Basic 2008 Express Edition for development.
In 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 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.
I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
Private Sub frmLocation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
[Code] .....
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
I have a database with table "Customer" that will be the datasource for my form controls. My form has a combobox and various textboxes that need to change based on the selectedvalue in the combobox, cboCustNo. Firstly, I'm try to get the combobox to populate with the customer names on the table but have the value member of the combobox set to their customer numbers (just for ease of indexing). Based on the user's selection I'm trying to have various textboxes show the corresponding data (Address, City, Balance, etc.). The code I have so far is below:
Dim cnnDB As New Data.OleDb.OleDbConnection
Dim cmdSelect As New OleDb.OleDbCommand
Dim rdCustomer As OleDb.OleDbDataReader
Dim CustTable As New DataTable
[Code]....
I'm running into a little problem making one combo box dependent on the selection of another combo box. I'm using a access back-end to this project. I have two tables: MajorCategoryTbl and MinorCategoryTbl , MajorCategoryTbl has PK and description field, MinorCategoryTbl has a PK, MajorID (foreign key), and description field. I have two combo boxes on my form, one that displays the Major description, and one that displays the MinorCategoryTbl description, but the stored value is the PK for both. I want the selection of the minor category combobox to depend on what was selected in the major category combobox.
View 2 Replieshow to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
I want to be able to change an image depending on what is selected in the drop down box. I have this JS code to change the image. Simplified of course.
<script type="text/javascript">
function changeImage() {
var oDDL = document.all("ddlNAME");
var NAME= oDDL.options[oDDL.selectedIndex].text;
switch(NAME) {
[Code] .....
When I call this function I do it in my DDL implementation.
<asp:DropDownList ID="ddlNAME" runat="server" OnTextChanged="changeImage()" >
But for some reason the changeImage() is not firing. It is giving me an error saying
'changeImage' is not a member of 'ASP.default_aspx'
How do I set my horizontal scroll bar to have the values increment between 1 and 100 and then have a label (lblFuelChosen) updated according to the value chosen on the scrollbar?
I have a label that is named lblFuelChosen and I have a horizontal scrollbar underneath it. I need to set the scrollbar to increment in values between 1 and 100, and the value to be placed in the lblFuelChosen label. How do I set the scroll bar values and how do I set the value to the label?
I'm writing a standalone application in VB.NET using Visual Studio 2005. I want to display/hide a bunch of Buttons based on the selected value of a ComboBox. Each selection would have a different set of Buttons to display, and I'd like to have them arranged in a nice grid.
Driving a TabControl with the ComboBox value would be the kind of behavior I want, but I don't want it to look like a TabControl to the user because it might be confusing.Is there a way to do this?
Basically, I'd like Selection1 of the ComboBox to show Buttons 1-4, Selection2 to show Buttons 5-11, Selection3 to show (maybe) Buttons 1, 3, 5, 6, and 8, etc., have them arranged nicely, and have the GUI show only the ComboBox and the buttons.
I have a product table with ProductId,ProductName,ProductCode as fields. I've populated a combobox with productnames. Next I have two other tables called Result_Header and Result_Detail. The Result_Header table has ProductId as a foreign key and BatchNo,TestDate etc. The Result_Detail table has ResultId as a foreign key which is the ResultHeaders Primary Key and other fields such as Result,SpecHi etc. What I need is when I select a Product from my combobox my two datagridviews must be populated via the Result_header and Result_detail tables respectively.
View 20 RepliesVisual Basic 2010 Express: I have a form with a combobox that is populated with the names of locations from a datagrid which in turn was imported at run-time (Form_Load) from an Excel database. The Excel database (and the datagrid) also stores the information for addresses and phone numbers for their respective locations.
What I would like to do is have the phone number and address text boxes automatically be updated with the proper corresponding data when the user selects a location from the combobox. Whether the text boxes are updated from the datagrid or Excel database is not a concern; I'm mainly looking for whichever way is simpler.
How Do I show the values from the dataset to the text box based on the selection from the combobox list i already populated the combobox my code is. [code]
View 3 RepliesI've been working on this RegEx for the past day or so and I think I have it worked out so that it returns the data I want. First a little background.I have a content editor that users will be able to edit web pages. They can format text, add links, etc.. standard content editor stuff. When they click save, the editor provides the ability to get the content (editor.Content) and put it into a string. What I want to do is get any links (<a> tags) and find out if they are internal or external links and if they are PDF files.
Here is the Expression I've come up with:
<a[^<>]*hrefs*=s*[""'](?<domain>https?://[^/s'""]*)*/?(?<path>/?[^s""]+?)?[[>""']
With this, I am able to separate the domain (if it has one) and the path out. Then, I loop through the matches...
dim matchColl as MatchCollection = Regex.Matches(editorContent, regExString)
For Each m as Match in matchColl
If m.Groups("domain").value <> myInternalDomain and m.Groups("domain").value <> "" then
'this is an external domain... do some stuff
[code]....
My question is this... the parts where I 'do some stuff' to the values, what would be the best way to get that back into my 'editorContent' string? I could probably put the editorContent into a StringBuilder and do a whole bunch of replaces on it, but is that very efficient?So, for example, with the PDF, I want to specify that it open in a new window (target="_blank") and for the external URL, add some javascript code into the onclick attribute.
In a vb 2010 project, I have 2 win forms: Form1 and Form2.
In the Form1 class there is a server-based timer: when the "elapsed event" fires, then I update the text of a Label1 on the Form2. A very simple code:
i have a DGV and 2 TextBox (the first one is for user input and the second is for displaying "Contact Person") in my Form. DGV DataSource is from database, i bind it programmatic with DataTable, the data is binding well, perfect, but when i use event Selectionchanged for DGV to display "Contact Person" in TextBox2 BASED USER SELECTION in DGV, it become error : "The Connection is already open" here is my code to bind data to DGV :
[Code]....
I want to do the following
1) Copy a picture in paint (done Manually)
2) Select and copy a portion of it (Done manually)
3) Paste the selection to my image control via clipboard
in other words if in paint I copy a selected portion of an image how Can I get the selection in my vb application via the clipboard?