VS 2010 2 Databases From 1 Listbox?
Mar 22, 2011
I have 2 Access databases;
Db 1 & Db 2, On the form is a list box which is data bound to DB1 'MainName', and a bunch of textboxs which populate from the record selected from db1 in the listbox.
In DB1 the 1st column is called 'MainName' and in DB2 the 1st column is also called 'MainName'
Now what im looking at is when the item in the listbox is changed, the record in the second database which has the same String in the 'MainName' column is also selected.
The route to take that i can see is having both databases added to the project , and have the listbox apply a filter on database 2 based on the selected item.
(im using 2 separate databases as when my project updates the DB1 also updates, but DB2 contains the users own strings so i don't want that to update as it would lose all there saved strings.I dont know much about lookup tables etc but they must all be in the same database right? so that rules them out, due to the update issue.)
View 2 Replies
ADVERTISEMENT
Jun 7, 2009
How do I display may sql databases in listbox without connection? Is it possible? Right now I have this:
Dim connString As String = "Data Source=.sqlExpress; Integrated Security=True;"
Using sqlConn As New SqlConnection(connString)
sqlConn.Open()
Dim tblDatabases As DataTable = sqlConn.GetSchema("Databases")
sqlConn.Close()
For Each row As DataRow In tblDatabases.Rows
ListBox1.Items.Add(row("database_name"))
Next
End Using
I am doing this because I wanted the user to create the connection for the main application to use. Right now, i have a combobox with items, MyServ/SQLexpress and ./SQLExpress. I have a textbox and a listbox where the user will choose from the items from the listbox which will then display in the textbox.... I dont like to explicitly put in my code this
=.sqlExpress
In one of my button I have this code
builder("Data Source") = Me.cboDataSource.Text.Trim
builder("Integrated Security") = True
builder("Initial Catalog") = Me.txtDBName.Text.Trim
builder.ConnectTimeout = 30
View 6 Replies
Mar 12, 2011
Several times av been come across of the need of how to create new variables on my application while is running and the next time i will run again the application to be existed in my source code and still be inside.
what excatly i mean is for example i have a listbox with out assigne it in any databound ,or retreive any items from any textbox i just want to insert some items inside
if i go from the designer then i can succesfully add any item i want and they will be there as i declare them.but if i want to to that programmatically i will be able to add them in the listbox but the next time i will run it again it will be lost.until i will select the command again to fill my listbox which is not what i want
in my case i have a datagridview which is running SQL querys and i want if the user selects to save this query i want from some way to save this query string in my listbox . and i want to be there the next time i will run my application with out using any text file or database,
is there any way to that ? i have search before i ask but obviusly my keywords dosen't much with what i was looking for
View 4 Replies
Jul 8, 2009
I need to know of is a good tutorial or site of using databases...Mostly the basic functions like...
*importing it into visual basic
*reading
*writing
*updating
I have a good knowledge of visual basic and want to learn how to use the databases.
View 1 Replies
Apr 23, 2010
i want to create a windows form where i can add names, Employee ids and the projekt they are working on. Clicking a button should add the data to a database. Later id need to retrieve this data.First i was thinking that setting up a sql database and finding functions to access it would be fairly easy however.. Theres obviously more than one way of doing this and im having trouble finding the right angle...
View 13 Replies
Dec 8, 2010
connect to 2 separate databases that control a system of logging in/out and the other a database of items. Think of it like logging in to ebay and searching for items. The only problem is that the x64 computers that will be used to run the final solution dont allow for MS Access databases or SQL databases to work for whatever reason.What other options do we have in order to have an effective system? A series of generated text files with the input registration details is so far the
View 3 Replies
Sep 15, 2011
I'm writing a desktop application that uses the main access database that will be hosted on a central server, but there will be a laptop with the app on that has an offline mode so records can be created offsite. When the laptop returns I want it needs to be synced back to the main database.
Has anybody got any pointers on a way to do this, I've briefly read about JRO but is there an alternative / better method?
Originally, I was just going to write some custom code to do this, but thought I'd check to make sure there wasn't something already out there.
View 4 Replies
Apr 27, 2012
I want to design a application which can support two different types of databases same time e.g; when we install, it will ask which db it has to support and based on initial selection it should work with any db without changing anything in the application.In short it has to be developed keeping in mind that user may have either MS SQL or MySQL. It should support both.
View 4 Replies
Feb 27, 2012
I have two MS Access database; Mydb1 and Mydb2. I would like to do the following:
1. Copy all records in table (MyTable1) from Mydb1 to Mydb2. MyTable1 also exists in Mydb2
2. Move all records in table (MyTable2) from Mydb1 to Mydb2. MyTable2 also exists in Mydb2 which needs to be flushed.
View 5 Replies
Dec 14, 2011
how would you clear a listbox, like with a button.
View 3 Replies
Mar 15, 2012
I have this code which lets you choose a class, then enter 3 names into the roster listbox...the problem im having is with the btn grades...im using a nested loop but cant figure out how to get all 3 names into 3 seperate inputbox prompts to input the grades...right now its only showing the first name entered...how do you get the code to loop and go through whatever amount of students entered in the roster listbox into the grade listbox.
[code...]
View 5 Replies
Nov 19, 2009
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
View 4 Replies
Feb 17, 2011
This code bellow to compile a single listBox on form1 to listBox on form2 then listBox on form3.
I want to modified this code to compile 169 of ListBoxs on form1 to 169 listboxs on form2
and 169 listBoxs on form3.Try this code,not need the new coding.
Original code from JoOl and modified by John Anthony oliver
[Code]...
View 1 Replies
Feb 13, 2010
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
View 8 Replies
Jul 5, 2011
I'm trying to implement a way for users to specify which files they want to backup by typing in file extension into a listbox.But I'm a but iffy on how exactly to do this.
This is what I have so far:
Dim n as integer Dim extensions(n) as string for each fe as string in listbox1.items
Here I want to add *.txt or *.docx from the listbox as a string in the array above whilst incrementing n by 1 for each new string next How exactly do I do this?
View 6 Replies
Apr 2, 2012
i've been doing ADO.NET for a while but I would like to know if its posssible to use dao recordsets in VB.Net 2010 and where I can get tutorials and code samples to do database stuff like insert etc. I've tried to google but most of the code available is for vb6 I was going through some stuff on this link [URL]../bb243801%28v=office.12%29.aspx and i'd like to know if it works for vb.net 2010 or maybe theres something i'm missing. because the moment I put "Dim dbmyDB As dao.database" its been giving me the wavy blue line and i am now doubting if it works or maybe i'm missing some other code
View 1 Replies
Sep 9, 2009
If you are using an sql database with a vb.net application, does the user need to have anything extra other than the .net framework installed for the program to run? Meaning, if I simply compile the application, are there any extra steps I need to take to make this work?
View 1 Replies
Mar 16, 2012
I have the code which gets HTML code and puts it in a richtextbox with seperate lines.I would like the richtextbox to delete each line which doesnt contain a url in it.
View 3 Replies
Apr 21, 2011
I have this form and I want when any of the RadioButtons is checked, then some items appear in the list.
in the group box1 : I used this code Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged, RadioButton2.CheckedChanged
[Code]...
View 4 Replies
May 2, 2012
Each time when a user clicks on an item in the listbox (items are integers only), this item should be added in an array . Array should be sorted at each click from smallest to largest values and must be shown somehow .
[Code]....
View 2 Replies
Oct 27, 2011
How to compare two listbox? I have two listbox one has a list of names and the other has a list of names too but I need compare the listbox1 with the listbox2 for delete from listbox2 all items existing in the listbox1 for example:
HTML
listbox1 Listbox2 Listbox2 after press a button
joel joel John
[code].....
View 5 Replies
Apr 6, 2012
I have a custom control type that inherits from ListBox. It is a list box where you can assign a ContextMenuStrip to each individual item, stored in a Dictionary object. To do this I also had to create a helper class that inherits from ObjectCollection to make sure the owning ListBox gets notified whenever an item is added or removed from the collection, so the corresponding entry in the dictionary can be removed.Now I have a problem that baffles me: Whenever I right click an entry in my EnhancedListBox, I get the following error on the line that has been marked red in the "InvalidArgument=Value of '1' is not valid for 'SelectedIndex'."(Of course, the value can be 0 or 2 as well, depending on which item in the list I click.)
I have checked, and there are 3 objects in the collection, in fact the current value of SelectedIndex was 1. The quotes are also misleading, the value I am trying to assign if of type integer, as is the current value of SelectedIndex.
[Code]...
View 4 Replies
Jul 10, 2010
Ok i am on my webbrowsers favourites, and im looking to use a listbox so the user can have as many as they want. Also i want the listbox to show the Site Title, like so it just shows the title of that website. But then i wouldn't know how to navigate to that website if just the title is in the listbox How would i do this?
View 6 Replies
Feb 10, 2012
I've being trying to work out a problem i've being having for a while now and i'm not sure if i'm over complicating it.When a form loads, it uses a for next loop to load an array of peoples names into a list box. However i want to extract the persons ID once their name has being clicked. I can make this work by using another for next loop until the selected name matches the an array number. However it fails if there are two people of the same name.Is there a command or piece of code that can extract the row number of the item selected?
View 3 Replies
Dec 22, 2011
I am the kind of person who learns as they need it and this time I cannot figure this one out :SI have a listbox with n amount of items.I am trying to add n amount of items to an array and then save the entire array to a textfile.How should I go about this? I have Google'd around and code I have adapted or straight out copy-pasted (sad I know) is throwing all kinds of errors :S
View 5 Replies
Aug 23, 2010
Dim mess As New MessengerAPI.Messenger
Dim msncontact As imessengercontact
Dim msncontacts As imessengercontacts
[code].....
View 4 Replies
Jun 12, 2011
I have two listboxes and one text box. lbxData is already populated with strings (ex; car, boat, motorcycle) I have a text box (tbxRandom) for user input to choose the number of random strings they want generated and placed in the other listbox (lbxRandom) when clicking btnRandom. Here is what I have but keep getting an error. mylist.addrange(str) "value cannot be null. parameter name: collection
Dim Str As String
'Declare a List
Dim myList As New List(Of String)
[Code].....
View 14 Replies
Mar 7, 2011
The app I'm creating is about ordering pizza, this is a screen shot of the form.At the moment, I have only set up customer 1, when i enter in all the information and click total at the bottom it is supposed to then display all of this information in the listbox at the bottom. But when I click total nothing happens I have looked at this over and over and can not understand why. Here is the code that I am using.
[Code]...
View 7 Replies
Jun 25, 2011
im trying to save a listbox with a few lines in it. Im using this:
save.InitialDirectory = "C:"
save.FileName = "List of needs"
save.Filter = "Text Files ONLY (*.txt) | *.txt"
[code]....
Im not sure what to put in W.Wrte() and i guess thats why i get a text file with this:
System.Windows.Forms.ListBox, Items.Count: 4, Items[0]:
View 5 Replies
Dec 11, 2011
I use this code to search items, using a textbox, in a listbox:
ListBox2.SelectedItems.Clear()
Dim count As Integer = (ListBox2.Items.Count - 1)
Dim words As String
[code].....
View 7 Replies
