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.
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
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].......
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.
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.
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
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.
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")
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?
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.
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?
I am looking to after the user selects from a drop down to give read only access to the form( textboxes, buttons, etc).Upon the second selection the user would have read-write access and upon the third selection full access.Does anyoen have an example of how this might go ? I have the code in place which places the information in the drop down from the configuration table itself.
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?
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.
How do I make the default modelbinding handle Lists?
Let's say I have a ShoppingCart class, which has a ShoppingCartItem List:
Public Class ShoppingCart Public Property CouponCode As String Public Property Items As New List(Of ShoppingCartItem) End Class
[Code]....
However, when I submit the page, no values are picked up, not even the CouponCode field. The model object is empty. What gives?
Ultimately, my goal is to add/remove items clientside via javascript and then have the modelbinder pick up the changes automatically when the page is submitted.
Update: I was just missing the Property keyword from my model properties declarations. It's too late, and I got to get some sleep. :)
I need to create an unordered list of dates for a news items archive... It should look like this
2011 Dec Nov
[Code].....
I can carry on with this adding in the for loops for months nested under each year however it doesn't seem very practical and will generate links for months even if there are no news item entries...
Is there a way I can build this tree automatically and only include the years/months that have news entries. I can pull a list of SQL Server timestamps from the DB for all the news items and then would like to populate the list based on that...
Not Sure if this is the right forum to ask this question, but could not find any specific forum for CAS.
I am using CAS in one my VB.Net based application. I am using Imperative Security. I need to use the SecurityPermission class and need to allow access to Execution and Unmanaged Code Security Flags.
I am not able to find a way to add multiple flags in the constructor of the SecurityPermission Class. how to set up multiple SecurityFlags for the SecurityPermission Class in VB.net? C# will be fine.
Private Sub CheckSearchState(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkVarible.CheckedChanged, chkMessage.CheckedChanged, chkOrgin.CheckedChanged, chkAdditionalInfo.CheckedChanged ' If TypeOf sender Is CheckBox Then
[Code]...
how to extract the control clicked on using this method?
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
ListView Drag&Drop allow to Drag&Drop between form??
Public Class frmModule Private Sub ListView1_ItemDrag(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ItemDragEventArgs) Handles ListView1.ItemDrag[code]....
Can it be drap and drop item to other form control??How to write the event when mouse up at the other form control?
I'm creating a simulation programe. In one sheet I have a group of cells (AngleConf) that have a drop down list. I would like to make some operations when I change the value of one of these cells. It always works when I insert the new value manually. But it doesn't always works when I change it by selecting the value from the list. I supose that that happens because of some option that I change while I'm working but I can't find out witch one exactly.The code that I think that its implicated:
Sub Worksheet_Change(ByVal Target As Range) If InRange(Target, Range("AngleConf")) Then Call resistance 'Actualiser le r�sultat mecanique
You will have to excuse me but I am a little bit new to vb. Anyways I was wondering if anyone knew a way to have a vb app accept dropped files on the main form. Basically what I have is a program that needs to accept dropped files (outlook attachments to be specific) and copy that file to a specific location on the C: drive. Then I need it to store the file name and path to a variable and set a text box on the main form equal to that variable