I'd like to display the same data in 6 different listboxes but with different queries.The data is formatted as so:
ExptStage
expt1Expt List
expt2Ready to Print
[code].....
I am adding data to two listboxes: listbox1 and listbox2. Now i want so sort Listbox 1, witch i can do with listbox1.sorted = true. But then listbox 2 has to be sorted the same way. (The data has to be matched) How can i do this?
View 1 RepliesI am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
im trying to replace data from listbox1.selecteditem to listbox2.selecteditem i have a temp.txt text file that loads in to listbox1 (rlines) this is the methord i use to load each file in to a list box...
Try
Dim file_name As String = tempdata()
Dim stream_reader As New IO.StreamReader(file_name)
Dim line As String
[code]....
it dose what it says and replaces that line of text from the data loading in to listbox2 with the data i selected in listboz1(rlines) but what im looking for is to have the data load in to listbox2 and then have a button so i can select a line in listbox1 and in listbox 2 and it will replace the line from listbox1 in to listbox2 now i can add a line in to listbox2 from listbox1 with
listbox2.iteams.add(listbox1.selecteditem)
but cant find a replace for it
i have a form with two list boxes and two buttons to transfer data between the list boxes.one button is the add and the other the remove. some code for these two buttons?
View 18 RepliesTwo listboxes data to correspond to each other
View 1 RepliesAm just goin on 3 weeks of teaching myself vb2010 and have found a long way to do a simple task. Well it seems it should be a simple task. I have about 12 different listboxes spread over 3 different tabcontrols. There are 3 buttons that load all the listboxes according to which tabcontrol they are in. I found that when populating the listboxes it would not clear before loading the information so it would basically double post, triple post etc. I've figured out one way to do it that I've put in a sub and call the line before the tabcontrols are populated with their listboxes. Here is the sub:
[Code]...
It seems like a longwinded way to do this is their an easier way to have one command clear all listboxes within all tabpages within all tabcontrols on the form??
I have a program that has to store a pre-made array that contains strings (moviename, moviegenre).
I setup all the items in the array already, example:
moviearray(0,0) = "Green Lantern"
moviearray(0,1) = "Action"
For this example, if the user selected "Green Lantern" from my listbox, then the label needs to display "Action". So yeah, it's a 2-column array: first column = movie name, 2nd column = movie genre. Now, I have a listbox containing all of the movie names (not entered by the array, but entered through the Item property of the listbox). When a selection is made in the listbox and a button is clicked, I need to have the genre of the movie output to a label. That is where I am stuck, I just can't figure out to compare what's in the list box with the first column of the array to output the 2nd column to the label.
I have a listbox with multi-select turned on. I want to transfer items from listbox 1 to listbox 2. The following code supporting the "Add" button works for an example where you are not using multi-select. How do I modify it to accomodate multi-select?
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
If Me.ListBox1.SelectedItem IsNot Nothing Then
Me.ListBox2.Items.Add(Me.ListBox1.SelectedItems())
[code]....
how to compare two list boxes and remove identical values or add them to a 3rd list box, but for some reason it's not working when I retrieve the data from a mySQL database using ADODB, here's my work cut down by a fair bit for it to be easy to understand.
For k As Integer = lstFriends.Items.Count - 1 To 0 Step -1
If lstDBFriends.Items.Contains(lstFriends.Items(k)) Then
lstFriends.Items.RemoveAt(k)
End If
Next
I've tried everything from changing the data type on the mySQL database to storing the retrieved data from the database to String declaration and it simply wont compare the two listboxes
I have this XML file from which I'm grabbing all the data:
<?xml version="1.0" encoding="utf-8"?>
<Tabel>
<Member>
[code].....
I have 2 tables that are related. Each app can relate to many apps. ie, office can be related to word, excel.[code]I would like to do the following query. I use vb.net but c# is ok.Query is to return all the apps that are not related to (1), so the result should be (4, quake) .
View 3 RepliesI've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
My project contains a DataGridView with a SQL Database Table called Shows. This is a list of TV Shows and I want to apply several filters to it. So I have several different columns to apply the filter to.
1. Completed (bit)
2. Hide (bit)
3. Seen (bit)
4. Genre (nvarchar)
Currently I am using RadioButtons to switch between the queries, but I want to be able to have several filters applied at the same time with CheckBoxes.
[Code]...
I've got everything working except this one problem which I can't seem to get my head around.I've made a function that returns a random number between 1 and 11 (how many invaders there are on a row).I've managed to get this to work, however the invaders will keep firing even if they are visible, so I made a do until loop which says to keep running the random number until it finds an invader which is visible... The problem is that if the whole row of invaders aren't visible, it will get stuck in the loop.
View 13 RepliesI'm a PHP coder normally, but I've been asked to make a small vb app. I've created my sql db (MSSQL) and have got all the data in it. However, I have no idea about how to connect or perform queries.
Here's my
Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]..........
1) Am I connecting properly? I created a new database using the dataset option and it has no username or password.
2) I'm trying to list the results, which will be clickable to open a new form with the full details. How would I do that?
Eg: In PHP, I'd loop through the resources using fetch_assoc, and create a link with the id and it's name as the firstname and surname.
I am trying to fill a temporary table with one column( a code) with the unique results of three queries of their respective table adapters.I can't figure out how to do it from here.The database is Access 2007 and I have activated the appropriate dataset on the form from which this code executes. The table adapters are part of that dataset.I could try to use the recordset approach, but that means making another connection to the same database.Is that a preferable approach?My purpose in doing this is to build a VB process like the one that works in a VBA Module of this Accessdatabase, partly to help me learn VB2008 and partly to overcome the necessity to keep updating queries used by the module.Code below
[Code].....
I have a Datagridview, It will have pairs of lines:
first line: requested customer
second line: assigned quantity for that item for that customer
Something like:
CUSTOMER-ITEM-VARIATION1-VARIATION2-VARIATION3-VARIATION4
Cust001....-120.-......10........-.........0.......-........8........-.........1
Cust001....-120.-........0........-.........0.......-........0........-.........0
Cust002....-120.-......15........-.........7.......-........2........-.........0
Cust002....-120.-........6........-.........0.......-........1........-.........0
The second line will have numbers if other table has information about that customer reservations, or will be in 0 if not.I can load the first line of each pair, with the data of the "requested" items loading a datagrid with a datatable.
I have a problem with sorting this thing. I want to sort a column without changing the data in the other column. i have an attached document. A picture of my query and database..
View 3 Repliesthe application I'm building is ALMOST done. The ONLY final feature I NEED to add is the ability to receive email. Now I'm using VB 2010. How would I go about doing this? Would I use 2 listboxes and a form with labels on it to display the message. I haven't any code yet. How in the world do I do this??
View 2 RepliesI use an access database and some queries return calculated fields resulting from
functions in the code module of the database These queries are not listed in the "Views" tab of the query designer when adding a tableadapter in the data source designer
This is what i have for my set of columns:
[Code]...
2nd question. How can i bind other queries from different table to these columns. like Column[2]and Column[3] should come from a different query.
I am working on a Data Survey Project and first I have a few questions about the different types of databases, and second, I need help querying my tables that have relationships.
1. I need a database that is stand alone. It is just the back end for the program. Simply to hold all the data an employee gets while out on a job. So would I be better using access, or SQL Express? I have played with both, but I do not want a large redistribution to my user machines. When I compile and produce this app does the SQL Database still work without installing any SQL Technology? Or do they have to go in after they install my app, and install Express?
2.Overview: I suppose depending on the first question regarding the database, it might change this question a bit, but none the less...I have 4 tables( using Access at the moment) I will be generating Reports based on data in the database. I haven't gotten that far yet. *Project* is the table that holds all the details that pertain to the job and client. It has a "one-to-many" relationship to *Survey*. So for one customer there are going to be many Survey Records. *Project Type* also has a 1-to-many back to *Projects*. Parts is kind of an orphan, but is linked to the *Survey* table with a one to many. So there can be many parts for one survey. I wanted this table for a drop down box, so the user could just simply select what hardware he was using instead of typing all the names and parts.
So in VS 2008 using the Designers and related Query tools, how do I constrain the Survey Data to one Customer? I have one form that opens from a button that is "New Project" and then there are all the *project* fields listed, so the user fills out the info and hits accept and that opens a new form called "frmSurvey" I need to add some code to the accept button to check what type of project is selected from the frmNewProject and then run a select query based on that. How do I write query statements in the code section of the form, without using the Visual Database tools?
Ill stop here, and get these questions out of the way first. If I could just get a handle on how to use the data properly with different forms and different controls with my queries, that would be great.
DATABASE
CODE:
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]...
I am creating a programme in which the user searches a file by typing into a textbox. if the search terms match anything in the file, it will be displayed in the list box. I understand this may be unclear so i will include an example:If the user enters "Oliver" into the textbox, the programme will search the file for any records that include "Oliver".The records are stored in structures:[code]The user will then click the desired record (several may appear)how would i get the integer and perform simple addition and subtractions on it?
View 10 Repliesi keep getting this very wierd problem were i put in audio into my forms and (Design) but when i put in a 4'th song, it stops working and comes up with a error. I havn't limited my audio to how much songs i can play but for some reason it just stops playing them. This code below is the code i use for this form
Public Class Form1
[Code]...
First my prog scan a specific path "C:music" which contain Mp3. Then it takes the MD5# of all mp3 and put it in a listbox1. Also on the formload it does open a ".txt" which also contain MD5# that goes into listbox2.Now this is what i am looking to have :When i click my button it compare each line of my listbox1 to listbox2. If , for exemple , the first line of listbox1 is already in the listbox2 then it delete the first line of listbox1 (listbox1.items.removeat(0)). And Do until listbox1.items.count = "0".
View 2 Repliesi am generating a listbox from a txt file this list box has ip's in and what im trying to do is run a for each statement
for each item in listbox.items
me.query()
next
this is what the query() is
Try
Dim UdpClient As New UdpClient()
UdpClient.Connect("my ip in here", 2005)
[code]....
this is the same code i used for my last app to populate a list box?
I have a program I'm trying to put together to allow my employees to submit shift reports. I'm doing this simply to make my life a little easier as this way, they will all be formatted the same. Instead of spending a large chunk of my afternoon thumbing through a bunch of differently formatted reports.
One feature that I need to figure out requires that one listbox can see what another is doing. Here, let me try to explain..
I have one list box that keeps track of EVERY action the employee does on a customers account. (cancel, upgrade, downgrade) and then a hidden listbox that JUST tracks "cancel" actions..one for "upgrade" actions and one for "downgrade" actions.
The reason behind that is that in the shift report, the all need to be listed separately. This way, I can just add each list to it's own array and list them where I need to.
The problem I've run into... If an employee handles an "upgrade" action at the beginning of the day..and then later on the upgrade is canceled, I can easily remove it from the main listbox that shows everything, however, I can't figure out how to find it in it's own listbox. The "Upgrade" box.
I have a program I'm trying to put together to allow my employees to submit shift reports. I'm doing this simply to make my life a little easier as this way, they will all be formatted the same. Instead of spending a large chunk of my afternoon thumbing through a bunch of differently formatted reports.
One feature that I need to figure out requires that one listbox can see what another is doing. Here, let me try to explain.I have one list box that keeps track of EVERY action the employee does on a customers account. (cancel, upgrade, downgrade) and then a hidden listbox that JUST tracks "cancel" actions..one for "upgrade" actions and one for "downgrade" actions.
The reason behind that is that in the shift report, the all need to be listed separately. This way, I can just add each list to it's own array and list them where I need to.The problem I've run into... If an employee handles an "upgrade" action at the beginning of the day..and then later on the upgrade is canceled, I can easily remove it from the main listbox that shows everything, however, I can't figure out how to find it in it's own listbox. The "Upgrade" box.
So unfortunately, on the shift report, it's still there even though it's gone in the program as far as the employee can see.The item in the main listbox doesn't have the same index as the item in each individual list boxes so I can't just tell it to remove the item at the same index..