I want a to create a combo box that gets the selectable items from a table and when I save the form I want the selected item saved to a different table. I'm sure this is simple I'm not a database wiz and still very much a newbie.
View 4 RepliesI have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
How to use a databound combo box to display one field in the drop down, and another as the combo box text on roll up? Using VS 2005... For example, I have a datatable that has 2 fields. One called "ShortDesc" and one called "LongDesc". I want to be able to see the "LongDesc" column values in the drop down on the combo box. When I make a selection, I want the text in the combo box to read the corresponding "ShortDesc" value.
[Code]...
I programmed in VB6 but with VB2008 I have trouble with this:I have a table called Clientes (Clients). One of the fields is called Provincia (State), but this is a numeric field wich references to a Provincias table.So, when I show the Clientes from, the Provincias field must use a combobox with the province name instead of a textbox with a number.
View 9 Repliesi created 20 tables in ms access.. and only one table is connected to vb 2008 using the DataGridView?.. how can put the remaining tables in ms access to the vb 2008?
View 1 RepliesI have a 4 table database and need to query at least 2 tables (the single table query works fine). The output goes in textboxes / labels on an existing form.
I'm trying something like this:
Private
Sub AddCustomer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I've got this problem. I have no clue how to prevent a duplicate from being entered in a combo box in VB2008. The information that is to be compared to is in a text file. What I have now works, but I have left out the prevent duplicate part.
[Code]...
I am trying to delete particular tables routinely from the sys.tables in vb.net. here is code, but it does not work.
[Code]...
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
i have a login form that contains a combo box and a text box and a button. the items of the como box are from the databse while the person selected can only log into the system if the password he enters on the textbox matches the password details in the database.(of the name selected)
my problem is, the second tab contains a couple of textboxes and combo boxes that need to be filled in. but i want the first combo box in the second tab to have drop down value of the name of the person that has logged in to fill in the form.
the person login in the first tab, his name should appera on the combo box in the second tab
I have a problem with Combo Boxes. When one uses the mouse to open the drop down menu, the text appears to be missing, but when you click on a entry, the text appears in the box at the top of the combo box (the thumb?). Likewise, when the cursor keys are used to scroll through the options, the text appears in the thumb.
View 4 RepliesRecently started working with VB.NET, and I'm just playing around with the controls and everything. What I want to do, is populate a drop-down list or a combobox (on program load) with data from a dictionary. I'm used to php, so I tried a for each dictionary.items as newitem combobox.items.add(newitem) but I can't get it working. Can someone give me an example of this? And what if i wanted only the key to show in the drop-down, and the corresponding value shown on a label besides it when I make a selection?
[Code]...
How to turn the combo box/drop down box uneditable.
View 3 RepliesI have in my code the CBN_DROPDOWN command that is sent using a Windows Message, but I want to be able to make the Combo Box List Drop Up as well. Does anyone know if this is possible or how I can do it?
View 2 RepliesI have a modal form with a single instance of the built-in .NET 2.0 tab control. The tab control has several pages, and on one of them is a combo box that isn't populated until the user activates it for the first time. When that happens, I handle the DropDown event and run a process that takes several seconds, then I add the items returned by that process to the combo box.It works fine, except right after the list portion of the combo box is dropped down, it immediately closes as if some other control took the focus. I've narrowed it down to the fact that there is a tab control on the form, and the process that retrieves items for the combo box takes more than 4 seconds. If I create a completely blank form with just the combo box, I don't see this behavior.
Needless to say, this is strange beyond belief. Any idea why the tab control would interfere with the control that currently has focus?
[Code]...
I've created a form to handle "frequently asked questions". In the form I have five Drop-Down Combo Boxes and I want the user to be able to select one of the questions listed in the drop down boxes and have it return a "message box" with the answer to the question. Naturally I'll have different "answers" for each question, but my initial efforts have me getting my message box as soon as I click on the drop-down arrow itself, and I don't want that triggered until I click on the specific question.
View 5 RepliesThis code doesnt work it gives an error saying invalid column OrderNumber..
Dim cmd As New SqlCommand
Dim s1 As New SqlDataAdapter
Dim s2 As New DataSet
[Code]......
i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
View 3 RepliesI have read through some of the other posts and I think what I want to do is slightly different. I have a combo box in VB ExpEd2010 that I want to allow the user to only select from the drop down list. However, I want to be able to set the value in the combo box to something that is not in the list. So the drop down list will have values 1, 2, 3 but I want to be able to write to the same combo box a value of 2.4, 1.2, etc.
View 13 RepliesI've found some unexpected behaviour in my ComboBox, which I'm hoping someone can help me with. If focus is lost by pressing the Return key on a form which has AcceptButton set, then after handling the Validating event and cancelling the validation,the ComboBox will not drop down any more. When you click on the drop-down arrow, the list drops down momentarilly then goes away again To reproduce this, create a new VB.NET Windows Forms application. Drop a Combo Box and a Button onto the default form, then add the following code:[code]....
Run this application, click on the Combo Box, enter some random text (e.g. "asdf"), then press Return. After this, click on the drop-down arrow on the Combo Box.I'm using Visual Basic 2010 Express on Windows 7 Home Premium.
See the below
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
[Code]....
the last value inserted into the access database will be add to the drop down list of their corressponding combo box.
Please anybody help about how to create two dynamic combo box. Like Country and province.. when I select country conutry Combo box then Province Combo box automatically show same country province.[code]
View 5 Repliesthe combo box style 1 has both the drop down option but also a manual entry option. I need to know how to code it so that when you manually enter data, it takes that data and places it in a text message "The shipping charges for "data" is $15" displaying in a text box. Shouldn't be hard but have developed a mind block.
View 4 RepliesIm trying to switch from VB6 to VB2008/VB2010 and i have managed to convert all my old code to the new. The only thing i cant figure out is how to use the new database system. How can i convert this code to be used in VB2008 ?
Dim vntTemp As Variant
Dim vnDummy As Variant
On Error GoTo Form_LoadError
[Code].....
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesPublic Class Form1
Dim con As New OleDb.OleDbConnection
Dim dprovider, dsource As String
Dim ds As New DataSet
[code]....
The code above can access the database but it refuses to add,update,or delete any records..
A while back I have created an application with ms access 2003. But ms access is limited to what it can do. So I have started to redesign the application in vb2008. The application is a registration/reminder/payment system for martial arts school students. I got stuck with 2 questions.
1) I have added mdb file into vb project, but I don't seem to be able to assign mdb fields with form fields. The only way it lest me do it if I go though a wizard, and then my vbform looks like msaccess form, which I don't want it to look like that. I just want it to look like any other normal application, without the db navigation button at the bottom of the form. If someone has a tutorial that I can look/read to find how I would assign db field to form field.
2) My other concern is that I need the vbprogram to be separated from database with having to create odbc connection. The main reason, is that I always need to add/change/fix features. And that is the main issue I am having with my msaccess app, that is while I am working on it, no one can add/look at the student records. What I would like to do, is that I have a vb app, that will look for .mdb file at the certain location, if it is not there, the use would have an option to either browse for it or create a new one.Then I can do all of the modification and send the updated vb app to the person that works with it, without hindering his/her work.
I'm still passed from VB6 to VB2008 and...I found it very changed!I've learned in few days how to use the most used commands, but I've got a big problem in connecting to an Access Database.I saw that we can connect to a database using:
- wizard connection
- manual connection
I think that using the Wizard everything is more cleaned and I can reuse the code in a simple way.So I tried the Wizard Connection, but all the guide and tutorial explain the connections using DataGrid. I don't want to show DataGrid. I've learned how to import data in listboxes (also in auto-complete mode) but I cannot understand how to work on data in the way I prefer.
- I've got a combobox with a list of data
- When I "change" the selection (combobox_SelectedIndexChanged) you have to load related data (from another table) in a ListBox (in which I can add other items without inserting them in the DB)
- Send all the data loaded in this fields (there are also other data) to create a record in the DB (like "Order of Product")
i'm developing a linq to sql database application that i created with visual basic 2008. I intend to install the application on another computer system. The problem i'm having now is that, after i've developed,deployed it and installed it on another computer, i can't find the linq to sql database i created with the projectkelvin rolex on the installed application on the other computer,
View 3 RepliesI need to know who to write data from several text boxes on a form to a sql database.I have created the sql database on a localhost using myphp admin, i have created the connection in a module named as dbconnect()i can try the connection and this connects fine, but unsure how to write the data from the texboxes to the database.
View 3 Replies