I am trying to delete multiple selected entries from a listbox. When I run the code I have now, instead of deleting all of the items that are highlighted, it deleted all the items in the listbox.[code]
View 1 RepliesI have 7 textbox entries and I would like to add them to a listbox and when I close my application it would save them, I have the code for the 7 texboxes and everything like that has been done, but I just dont know how to add multiple textboxs to a listbox then save the list box so when I close the application and reopen it, itll still be there. I know I need a button to add the list to the listbox, but how do I save them, so theyll still be there?
View 6 RepliesI have a program where you have three entries, CD name, artist, price and it goes into a listbox and .txt file when closing. I have to have a message box if you enter the same CD name. I have a code to open the .txt file and compare strings but I need to change it to compare only the CD name and not all three entries. Is there a way to do my string compare against my listbox without opening the .txt file?? The program loads the listbox from the .txt file when opening. Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click' adds CD information to the list box
' declare variables
Dim strName As String
Dim strArtist As String
Dim strPrice As String
[code].....
I'm using the MS example script [URL] to install a COM+ application. For uninstall I have a script that shuts down the app, calls Remove from the Catelog App Collection, and then I call regsvr32 /u. This cleans up the COM entries and removes my app from the catelog but leaves behind the CoClass and Interfaces in HKEY_LOCALSoftwareMicrosoftCom3Selfreg. How should the script remove the SelfReg values?
objCatalog.ShutdownApplication(myAppName)
objApplicationsColl.Remove(iCounter)
objApplicationsColl.SaveChanges()
[code]....
I have a dictionary collection as bleow:
mydic.addvalue(key1, val1)
mydic.addvalue(key2, val1)
mydic.addvalue(key3, val1)
mydic.addvalue(key4, val2)
mydic.addvalue(key5, val2)
From the above dictionary I want to delete all the entries where value == "val1", so that the result would have only following entry:
mydic.addvalue(key4, val2)
mydic.addvalue(key5, val2)
My VB source code is on VS2008 and targeted for 3.5
I've read through all the search results for this and haven't quite got it yet. I often get given Excel spreadsheets of file names and have to check through them for duplicate names.I am making an app to do this for me. I've extracted the data from Excel I'm just having issues with checking for the duplicate. I've tried 2 different ways I found online and neither are working for me,
[Code]...
I've imported data from a text file using Streamreader and populated a listbox with this in 3 columns. I now need to
a) get a total value from the 'Hours Worked' column (sum) and
b) put in a calculation to populate an extra column for each entry (Gross Pay) where values are not imported but entered as a result of a calculation.
My current code is as follows:
Private Sub btnRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRefresh.Click
'Program Objective: Display payroll report for National Success Coaches which could be updated unknowingly at any time.
Dim name As String
[Code] .....
I just starting coding in VB.net about two weeks ago so I'm still a begging and I learn best by seeing working code and then adapting it to my situation. That being said, I need help displaying table entries in a listbox. I've successfully created a database in my test application, added it to my Data Sources and used a drag / drop method to add Datagrid View & Details (labels & textboxes) to my application for testing purposes. Now I want to try and display table entries in a listbox.
Example Database:Table: Contact
- ContactID (autonumber) [primary key]
- FirstName (text 50 limit[code]....
Also is there any benefit or down side to creating a database in MS Access, create the relationships & tables, then attaching that database to my application or is it better to create the database in the application like I did in the example above by using the Add New - Service-Based Database option?
My program is half a formulator, and half ordering system. Where I get stuck is the ordering system part. In one screen I have 5 check boxes that you can check for which products you want to order. The products you checked then get sent to another screen and put into a list box with a quantity variable that starts at 1 attached to it. Now, if you check the same product again, another time through the program, as of now, quantity accumulates to 2, which is good, that's what I want. My problem is I want quantity to keep accumulating, right now it accumulates to 2, then on a third pass through the program,it duplicates the entry, so now in the list box has the original product and quantity of 2, and another entry that has the product with quantity of 2. 't quite understand how they work. Here's the code:
Option Explicit On
Option Strict On
Public Class OrderRequest
[code]....
I have a program with two forms, one that handles the applications controls, and the other with the functions that open a file (csv), open a database, and query the database. The controls on the first form are a list box, three labels (to display parsed csv information), and three buttons (clear database, load database from csv, and load listbox).
The clear database and load database buttons (events) seem to function correctly.On the other hand, the load list box event doesn't function 100% the way I'd want. [And, I can't test the selected index event yet]
The code for the load list box event is:
Code:
Dim db As New DBUpdt 'second form
b.openConnection("weather.mdb") 'open database connection
db.query("SELECT * FROM stations") 'query database
Do While db.moreRecords
[Code]...
You see, in my new VB application, I have a form with a TextBox and a ListBox, and I need to make it so that, whenever some text is written in the TextBox, a SELECT operation must be performed in a table belonging to an SQL database, in order to return the elements of a particular column that are LIKE the text I just wrote in my TextBox. The results of this SELECT operation must then be written inside the ListBox.In other words, whenever I have some text inside my TextBox1, I have to do:
SELECT Description FROM Elements WHERE Description LIKE TextBox1.Text (this must be done whenever the text changes)And the results of this operation must be displayed in the ListBox on the side.
I have a problem, again. I don't know how to store multiple entries from one listbox into one cell from the database.
View 10 RepliesJust what the title says. I have a listbox with varied entries, all in one format:name, email, phone, age
When an entry is selected, and when a certain button is clicked, I require the entry to be removed from the listbox and the four categories from the entry must each go into their assigned textboxes.
i have an access 2007 database in wich i have a table named abc_PersonalLog, wich also has three columns: Id (auto number), StarDate (text) and LogEntry (Memo). It is a Diary application. So, when the user makes a log entry, the StarDate column receives a string formed of concatenated year, month and day, i.e. if date is 20th march 2012, the string will be 120320, and the Log entry column, the text entered by user in a textbox.My problem is that, somehow, i have to retrieve that data, when the user will want to read log entries he made. I managed to assign the text property of a label to the LogEntry text for a given date.But, if the user makes multiple entries in a single day, the table will have several rows containing the same string in the StarDate field, but different text in the LogEntry fields. How can i display ALL the LogEntry texts for all the rows containing the same StarDate value? Here is my code so far:
[Code]...
I am trying to take a database with multiple entries of 11 digit numbers and run a check sum algorithm that adds the 12th digit to the 11 digits as an output.The algorithm is as follows:
Add sum of odd digits starting with first digit, then multiply by 3.
Add sum of even digits, then add to result of odd digits multiplied by 3.
Take result and divide by 10. The remainder is the check sum which needs to be added to the end of the original 11 digits.
I am working on getting a multiple values from a single column displayed in a single textbox or label. I know I should be able to find the information I need online, but I am coming up empty. I am using Visual Studio 2010 with SQL Server 2005. For example, I want to pull all the email addresses, that have a value, from a table and display them together. The output I am looking for is like this:
[Code]....
I have data entries in my database that have a common field. For example:
account_id type user_id
1 new 1
2 old 3
3 new 1
4 old 1
I am using a query like this(mysql): SELECT account_id, type, user_id FROM table WHERE user_id = 1
This is just all theoretical. The problem that I am having with this is it is only returning the first result in this case account_id 1. How can I get it to find all the results with the user_id 1 because in the way I am thinking that it is failing is that it is finding only the first result and then ending?
I'm trying to create an invoice program in VS2005. I can make the database and insert and save all data regardingthe customer and the vehicle,but cant figure out how to create an input control where random items"car parts" could be inserted and saved. It would
View 4 RepliesI want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this working by myself using the 'SQL Pane' in VB and testing it by using execute sql but I don't know what to do now. I assumed that I could just save it and it would work from there but that's not the case, it dissapears from the SQL Pane if I close the project (even though it worked fine when I ran the project the first time), so where do I put it/what do I do with it in order to get this to work?
View 1 Repliesi successfully load data from database to listbox, what i want to do is to add a record and then directly the listbox will update as well as in the delete.
[Code]...
I have a question here.. pls kindly advise.I need to design a simple form that allow user to choose the value from Listbox A to Listbox B. For example, in Listbox A, have value A, value B and value C, then user can choose (or highlight value B and value C) and copy into the listbox B.
May i know how can i do this in vb.net? Any reference link?
On my application I'm trying to make it available for users to Add and Delete Locations (which come with number of miles).Basically I have a Form, with a listbox and a tool which will allow the user to add a location along with it's distance.I have a button called "Add a destination" and under this button, I have this
filename = "destinations.dat"
FileOpen(1, filename, OpenMode.Random, , , Len(Onedestination))
numberofRecords = LOF(1) / Len(Onedestination)
[code].....
How to delete a selected Item from ListBox?
View 17 Replieshow can i delete line 1 from listbox?
View 13 RepliesI have to create a SQL server DB that has a table named people with, people_id int PK IDENTITY, firstName varChar(30), lastName varChar(40 (completed) create a windows program that lists the firstName and lastName combined with a space detween them in a listBox (completed)provide functionality in code using command objects/parameters (no wizards) to add and delete from database and reflect the changes in the listBox..I am having trouble with the delete. [code]
View 5 RepliesHow can I delete all the selected items in a multi-select listbox in VB.NET?
View 4 RepliesHow is it possible to delete all the items from a ListBox that have the same extension? This is in particular to video files that have have extensions of .mpg, .modd and .moff. I can populate the ListBox with just the .mpg files but I would like to know how I can remove the other file types should I put the whole lot in.Also, presumably using similar coding, it it posssible to highlight all lines with a particular extension?
View 4 RepliesI have the below code that works great, until you have multiples of the same thing.example of data
burger
-tomato
+tomato[code].....
if i select the +tomato in wrap it remmoves the +tomato in burger (deleting the 1st oocurance of it) how can i fix that. i have played alot and can not figure it out.(ps the other list boxes are other data but it needs to remove the same "line" as each other. they are all changed to the same selected index when 1 is changed)
Dim value As String
Dim value1 As String
Dim value2 As object[code].....
basically, i have one delete form, where i will load the firstname from a table in access(hardcode) to listbox.then when a user choose the first name, from list box and click delete.the entire row related to the first name should be delete.
The code, i wrote so far..
Imports System.Data
Imports System.Data.OleDb
Public Class Delete
Dim inc, MaxRows As Integer
[code]....
I am coding a simple database that uses a .txt file as a way to store infomation (It is required to use an external file and .txt was the first one that comes to mind), my question was. Is there a way to click on data in a list box and then delete it from both the listbox and the .txt file?
View 4 Replies