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.)
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
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
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...
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
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.
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.
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.
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
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?
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
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?
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.
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
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 .
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
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.
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?
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?
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
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)
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.
