VS 2008 : Having The Values For Each City Selected Via Two Drop Down Lists?
Apr 15, 2009
I've written a program to work out the flight distance between a set of seven cities around the world using a 2D array but was wondering how I would if possible go about having the values for each city selected via two drop down lists (say start city and destination city).
Public Class frmDistance
Private Sub Flightdist_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim rowcolumn(7, 7) As Integer
Dim sr As IO.StreamReader = IO.File.OpenText("Distance1.Txt")
[code]....
View 1 Replies
ADVERTISEMENT
Oct 5, 2011
I have two list boxes. A users selects a value from each, clicks a button and the application creates a relationship between the two selected items by saving them in an array and displaying the relationship in a third list box.
What I want to allow is for users to be able to drag a value from one list box and drop it on top of another value. I have the code to capture the value of the item dragged but I don't see how to capture the item that the data is dropped onto.
Is there a way to capture the targeted selected item?
View 2 Replies
Jun 2, 2009
I've got a couple of drop down lists for languages. I bind them to a language list that comes from a query. Then the fields are also bound to the row in the DB they relate to. I have several panels with the language drop down - each "tied" to a different table in my DB. When I call up different records on the same panel the drop downs immediately "set to the position" of that rows language in the list. But when I call up another panel - tied to another database table - I see that language in the drop down.
[Code]...
View 9 Replies
Mar 12, 2010
I have four drop down lists here and I've assigned the datasource and displaymemberproperties so they are populated by a table. When I run the program and select a choice, all four of them get updated with the new choice.
View 3 Replies
Apr 5, 2011
I am fairly new to VB (have done some VB in excell, but its a bit different)
I have a couple of questions:
1) How do I populate a dropdown list from a Database Row 2?
2) When I create a Database from Acess, where do I save the database? and If I build the exe program later on, will it include the database, or how does it work? I feel completely stupid, but one of the best ways to learn is to try over and over again
View 2 Replies
Oct 31, 2011
I'll try to clarify by using the following example. In here I have two Drop down lists (ddlInsertEmployee + ddlInsertCustomer) which should both be bound to fetch data from tables [Employee.EmployeeID] and [Customer.CustomerID] and insert it into table [Task].
The problem is that it inserts data from Employee.Fullname and Customer.Fullname into resp.Employee.EmployeeID and Customer. CustomerID.If I would change the Drop down lists to textboxes, and manually insert the IDs, it works like a charm, but this is not very efficient, I want to be able to see the entire Fullname.how to change my Sqlstring in order to make this work correctly.
Imports System
Imports System.Collections.Generic
Imports System.Data[code].......
View 1 Replies
Nov 20, 2010
I'm using Visual Studio for the first time and VB. I have programed for awhile, but mostly new to windows related softwares. I have an access database connected to my test application and I am trying to display a drop down box with a listing of the item names in my table and the value that is sent off to my database is the actual item id. I can figure out the database part in terms of adding and editing, but I haven't been able to figure out how to display the full list. If I click the next button the list that is generated it displays the next item, but I would rather just list all items in the drop down box and remove that toolbar all together.
View 1 Replies
Jun 12, 2012
Here is my drop down list and data source. My question is.. when is it possible to set a defaulted selected option for the drop down list, aka when have all the dropdownlists been databound and their ListItems populated? I have tried Page_PreRender, age_PreRenderComplete, Page_Load.I have read over MSDN's Page Life cycle event which suggest Page_PreRender.
<asp:DropDownList ID="ddlRampStandard" runat="server"
DataSourceID="RampStandardDataSource" DataTextField="StandardName"
DataValueField="StandardName" RepeatDirection="Horizontal"
[code].....
View 1 Replies
Jan 16, 2010
I need to strip out part of a datafield namely Column name "City" the data provider adds an abbreviation to the end of the City name Example: Houston[HST] I need /want to strip out the [HST]been trying to modify my statement with no luckI am using Jet 4.o and database is a .txt or .csv file
OleDb.OleDbCommand("Select *, (([AddressDisplay])&',' &([City])&',' &([State])&',' &([ZipCode])) AS Address, IIf(IsNull([BathsQuarter]),0,[BathsQuarter]*.25)+ IIF(IsNull([Bathshalf]),0,[Bathshalf]*.5)+ IIf(IsNull([Bathsthreequarter]),0,[Bathsthreequarter]*.75)+ IIf(IsNull([BathsFull]),[BathsTotal],[BathsFull]) AS BATH From " & Me.OpenFileDialog1.SafeFileName & " Where ListStatus <> 'Closed Sale'", con)
View 13 Replies
Aug 10, 2009
I need to show a drop down list when the page loads, the default selected value is nothing, or an empty element (such as "-"). When the user selects one value from the list, another drop down list is added below the first one, and so on.My problem with this is how you make the page to remember the drop down lists created through postbacks and the values they have selected?
EDIT: I did this example for dynamically add drop down lists and suscribe them to an event handler but the event won't fire.
EDIT 2: Changed the code because I labelled for VB.Net and posted something in C#. I update the code with some trivial improvements, but still won't fire the event :(
Private myDdlArray As New List(Of DropDownList)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Session("ddl") Is Nothing) Then
[code]....
View 4 Replies
Apr 16, 2010
I have a series of GridViews in a Tab Panel - databound to a generic List of Business Objects.
The columns in the Gridview are all similar to the following:
<asp:TemplateField HeaderText="Company" SortExpression="Company.ShortName">
<ItemTemplate>
<asp:Label ID="lblCompany" runat="server" Text='<%# Bind("Company.ShortName")
[Code].....
View 1 Replies
Dec 1, 2010
I have a couple drop down lists connecting to an Access database. I can get the first drop down list to populate with the departments I have listed under "dept" in my access file. After someone selected a "dept" i want the second drop down list to populate with the names ("name"). Right now the second dropdown list is showing up but isn't poplulating. What am I doing wrong?!? I would like to include a third dropdown list for another selection with a button to then show things from the specific selections. Right now, I just need to figure out how to populate a list upon another lists' selections.
View 1 Replies
Oct 20, 2010
ok, I'm basically trying to make mulitple drop down lists on my form. When the page loads, I can get my main dropdown list, called makelist, to fill in with the items that I want from a txt file.
What I'm trying to do is whenever the selectedindex is changed in makelist, it has to load a different dropdown list, called modellist with items from a different txt file.
[Code]...
View 13 Replies
Jun 17, 2012
I'm using vb.net. Basically, I have a drop down list, text box and a submit button. You choose a movie director from a drop down list, then type in a movie, click button and it adds the data to my database.There's another button which hides/shows drop down list, text box and submit button using Visible = True and Visible = False, but what I don't like about it is when it hides the things I said before, it leaves some white/empty space like if they are still there, but not visible.Is there anyway to put some kind of holder/container and place a button which when clicked could add my drop down list, text box and submit buttons to that place?
View 1 Replies
May 18, 2011
tbFrom = "one" and tbTo= "two" use drag and drop to swap the values so that tbFrom.text = "two" and tbTo.text = "one" with tbNope.text = "three" but you aren't allowed to drop in tbNope. Show the appropriate symbols for allow drop and don't allow drop. set allowdrop to true for tbFrom and tbTo. So far i have one way working.
Public class Form1
Private sub tbMouseDown(ByVal sender As Object, ByVal e As System.Windows.Form.MouseEventArgs) Handles tbFrom.MouseDown
TbFrom.DoDragDrop(TbFrom.Text, DragDropEffects.move)
[Code]....
View 5 Replies
Dec 23, 2011
Find common values in multiple arrays with PHP Pretty much does what I need, but in PHP, I need VB. My situation is I am trying to create an intelligent stock pick system based on multiple stock locations. At the point of invoicing, we loop through the items invoiced and check the stock database for available stock.
If all items on the invoice are available to pick from stock location 1, then all should be picked from stock location 1... etc. If all most items are available from stock location 1 except one or two, then pick all stock from stock location 1 except for the exceptions which should be picked from the location with the highest available stock. Finding highest available stock is simple, but I can't work out how to analyse the stock availability from multiple locations and finding the common stock locations.
[Code]...
View 2 Replies
Feb 19, 2011
I have a gridview which can be filtered from one or more values in a querystring. That all works great: e.g. "?subject=Maths&authorName=Bond_James&type=Magazine" The values passed to the query string come from 3 drop down lists: Subject, Author, Type.What I'd like is when the user presses "Filter" it will take the selected values from the drop down lists and pass them to the querystring - it could be 1 value, 2, or all 3 (like above).
The drop down lists have an item called "All Subjects" / "All Author" / "All Type" each with a value of -1. The idea being that if the user leaves these items selected then the Filter button just ignores them.
Here is my code so far:
Protected Sub buttonFilterGo_Click(ByVal sender As Object, ByVal e As EventArgs) Handles buttonFilterGo.Click
Dim queryString As String
Dim selectedAuthorString As String = "author=" & dropAuthorList.SelectedItem.Value
[code]....
Also, one more thing. How do I get the drop down lists to have the filters selected when the page re loads?
EDIT: I changed the default values of the drop down lists to "" - this leaves the URL looking messy though ?author=&subject=&type= This works, is it the best way?
View 2 Replies
Sep 19, 2010
I accept both C# and VB.NET suggestion, even though I'm writing an app in VB.NET I have two lists of intergers
List1 {1,2,3,5}
List2 {2,4,6,7}
I want to have new List3 {4,6,7} which is composed of elements of List2 that are not in List1. I know I can write a nice For Each loop for this but I want it done in LINQ I've been looking for such methods at Enumerable Methods, but I can't find it.
View 2 Replies
Sep 25, 2009
Im having a problem getting the selected values of a listbox that is data-bound..
vb.net
Do Until CType(Ctrl, ListBox).SelectedIndices.Count = 0
For Each Index In CType(Ctrl, ListBox).SelectedIndices
[code]....
The error message says... "Operator '&' is not defined for type 'DataRowView' and string " "." And the only way I can get it to work is to pull out the & operator and change that line of code to this.
vb.net
'FROM THIS:
TableData.Miscellaneous += CType(Ctrl, ListBox).SelectedValue & " " 'Errors HERE
[code]....
The SelectedItem text shows up in the controls current state while debugging, correctly.. but after I finish the execution it shows up as "System.Data.DataRowView"?
View 2 Replies
Dec 29, 2011
When .Clear() is invoked, is the memory freed up that was allocated when all of the items were added? I need to load several lists of codes from a database depending on the import selected by the user. Each list of codes will be a List(Of String). My idea is that I will load only small strings into a List(Of String) along with a List(Of <class>) for the data I will be validating and manipulating. When I am done, I want all of the data from the Lists to be purged from memory. Will .Clear() take care of that or does the memory still remain allocated and have to be dumped by the OS once memory gets full? (And, incidentally, what causes the OS to decide which memory blocks to dump? FIFO concept?)
There are so many lists, I'm not sure if I just want them sitting in memory or not. Granted, the lists will just consist of a single string value for each code pulled from the database. So there won't be a ton of data, so maybe I could just load all the validation lists at the beginning of runtime and only worry about purging the data List since it will contain between 35-50 "fields" per record and there will be a couple thousand records each import that is run. I don't want my program to actually cause a hit in performance in the long run. I ultimately don't see a problem because I won't be running millions or even hundreds of thousands of records at once, but I just want to be sure.
View 10 Replies
Dec 27, 2009
I wish to read a web page that had various frames and div elements.To start with I would like to create a routine that justs lists all of those elements values and then display each element name and its value so I know what I have and how to reference it later on.I have been using the WebBrowser control and have managed to do a few basic things so far like go to a website and auto login.
View 2 Replies
Nov 30, 2011
I've worked out how to create a DropDownList using the following code: <select id="salesPersonDropList" runat="server"></select> In my .aspx page, then my code behind loops through database output running:
Dim newListItem As ListItem
newListItem = New ListItem("Title", "Value")
salesPersonDropList.Items.Add(newListItem )
What I can't figure out is how to programatically set which of the List Items created is the one to be pre-selected in the rendered DropDownList, ie, how to create what I'd write in HTML as:
[Code]...
View 3 Replies
May 17, 2007
I have 2 drop down lists and 1 submit button. It works such that after the user has selected values from BOTH the drop down lists, then the user will click a "Search" button. My problem is, after the user click the "Search" button, the second drop down list is no longer displayed with the selected value, instead it displayed a default value. May I know how can I make sure the selected value remain selected even after the user clicks the "Search" button on the page?
For your info, my coding goes as
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strSelectedUsername As String
[Code]....
View 7 Replies
Aug 10, 2011
We have to get the data from a Ship to a Data centre which is located in a city. And the Ship has broad band connection via Satellite . So for capturing data from the ship we suggested to create a WCF services which will be deployed in Ship. And the Application Running on the Data center will call the service and get the data and upload it to the data centre . The same type of Application will be deployed in the data center to upload the data to the ship.
View 3 Replies
May 15, 2012
My dropdownlist is set to databine like this...
dt = dal.FillDataTable(SqlConnectionString, "SELECT SQL Query Statement")
dropdownlist1.datasource = dt
dropdownlist1.datatextfield = dt.columns.item(0).tostring
dropdownlist1.databind()
This is turn populates my dropdownlist, when a user selects a value, it is then populated to the remaining textboxes on the remaining forms with a session call...
dropdownlist2.add(ctype(session.item("valOne"), String))
Through this session it populates the one value, is it possible to display the selected value but also include all other dropdownlist items in case they want to change thier selection?
View 1 Replies
Jan 20, 2009
I have a fairly large Drop down menu:
<asp:DropDownList ID="DropDownList8" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList8_SelectedIndexChanged">
<asp:ListItem Value="" Selected="True"></asp:ListItem>
[code]......
View 8 Replies
Apr 1, 2011
I have two lists. One list is a list of names, the other list is a list of how many times each name is found in the first list noted in the database
so...
Nick
John
Jim
Jack
is the firs tlist
10
13
13
2
is the second list. Nick had 10, john 13 and so on.I want to sort the second list from large to small, but have the index for the first list still linked to the correct amount of calls.i do it this way so I can
for x = 0 to num_of_names
string = lst_name(x) & "-" & lst_count(x)
next x
View 3 Replies
Jul 7, 2011
I have a couple of dropdown lists like this
<asp:DropDownList runat="server" OnSelectedIndexChanged="Update_ddls" AutoPostBack="true" ID="ddl1" />
<asp:DropDownList runat="server" ID="ddl2" />
[Code]...
I also have a function called Update_ddls which runs OnSelectedIndexChanged that looks like this
ddl2.Items.Remove(ddl2.Items.FindByValue(ddl1.SelectedValue.ToString()))
Which removes the selected item in ddl1 from the second dropdown but if I keep changing the ddl1 item then ddl2 won't have any items left in it.
Is there a way to re-add the previously deleted items in the Update_dlls function without re-databinding because if I re-databind I lose the selected item in the ddl?
View 2 Replies
Apr 28, 2011
Im doing the same thing as him but in vb express 2008 what i have is a checklist box of 10 toppings, all of which can be selected, (no max or min) to put on a pizza, and i have 3 radio buttons grouped together for pizza size (S, M, L) i cant figure out how to give them vaules in which(for sake of demonstration) s=$5 m=$7 l=$9 and each topping is $0.25 then make them add up to an order total in a msg box or something like that
View 2 Replies
Jun 5, 2009
I created a vb program so anyone in my company can open it and see who is using what phone number offsite, and since different people go to different places each day, i linked the name and place fields to their respective database.
View 3 Replies
