I have a combobox that displays saved names from the fullname column of my database. This works fine, all the items under the fullname column are added to the combobox. However, I also have several textboxes on the same form that also need to display data from the database, from the same record. So I was wondering if this was possible:
[Code]...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I have a query in Access 07 that identifies the following fields: ContractID, status, start date and end date. For each contract, I've been able to search a network share and upload its corresponding file; however I need to skip the import and write a record to a table for contracts with the same start and end date. I've included a placeholder (in bold below), but how do I make the date comparison work? Do I need to create a multi-dimensional array for that or can it be done with the code I have?
Private Sub cmdRefreshList_Click()
DoCmd.SetWarnings False
'Create an array based on the true-up contract IDs.
[code]....
How to add values from field ( Access 2007 ) to a combobox in visual basic 2008?
View 3 RepliesI'm trying to compare a item i have to enter in a combo box with an item already in the box (duplicating items). I've use the contains function but i need something that is case sensitive. Here is what i have so far
[Code]...
The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it does save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program.[code]I'm only trying to get the ID column populated, the rest should be fine as they're all from textboxes.
View 8 RepliesHow can I display column contents of a MS SQL Database on Text Box using VB 2008
View 2 RepliesThere are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I want to add a blank value to a field in access database with vb 2008 command.
Problem 1: Here is my code, it shows conversion to string not possible errors
Private Sub btnRedThrow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRedThrow.Click
Dim dbCnct As New DBUtills
[Code]....
notice the fifth and last value is empty. But it is not being added into the database, how do I do that?
Problem 2: Why does an additional field from my access database disappear even after I manually created the field?? (access database 2003 version, extension is .mdb) I'm using visual studio 2008
how to get this login to work if i add a field in to my database called UserTypes "Admin" "Normal" if they are admin if will display cmdAdmin and if they are Normal if will hide cmdAdmin this is the code i have currently?.[code]
View 12 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 Repliesi am developing a vb.net 2008 application. I use oledb to connect to oracle is there any way to insert a clob field in oracle from vb.net 2008 ?
View 1 RepliesHow can i declare a simple variable in a form that is the count of the amount of times a field appears in a database.Basically i want to count the amount of times the word "Saloon" appears in a column in my database (access 2007) and then assign that value to a variable.
View 22 RepliesI am trying to update a SQL Server database Date field.When the user enters the date they enter 02 Oct 2010.When I pick up the DateTimePicker.Value it is 10/02/2010 00:00:00. I need to get the value to read 02/10/2010 00:00:00 How do I get the value to be in this format?
View 7 RepliesI am trying to write a routine to bind a combobox to a datasource (coming from a LINQ query)and at the same time populate the "autocomplete" collection of the combo box:
[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?
How to compare data from two database... The fields of the database are very much the same.
Example location of the database..
Database1
C:Program FilesMySystemDatabase.mdb
TableName: Person1
Database2
C:MysystemDatabase.mdb
Tablename: Person2
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
I have this code here:
[Code]...
I know there is MyDataTable.columns How can I get it to put the columns into a ComboBox so i can select them?
Actually I have datetime value stored in the database. What I am taking from the textbox is a time value. I want to extract those results from the database which are between the given time value....To be more concise, my application is a booking system for a sports club and provides an option to view alreaady made bookings.. Here i offer two options either to view all bookings for a specific game or to filter bookings. In filter bookings one option is to filter through date and time...Date option is running okay but problem lies in time part...I provide two times but unable to view bookings between them...
My code is:
Dim prmtimefrom As New SqlParameter("@booking_time", SqlDbType.DateTime)
prmtimefrom.Value = TextBox3.Text
Dim prmtimeto As New SqlParameter("@booking_tim", SqlDbType.DateTime)
[code]....
I know how to pull data from an access database and place it into a combobox, but I am trying to make certain that I dont have multiples of the same information.
Like one column is for countries of origin.
United States
Canada
Mexico
In the combo box, it should only list the United States only once, not multiple times.
How to filter data from the database to combobox? For example, the database have the data, and i have a combobox, then i want to type the first letter, and the dropdown list comes down that the data have the first letter that i type in the combobox.
View 6 RepliesI would like to load a combobox with some values from an access database. On form load I load my information into a data grid view but if the user wants to add more information or edit what is selected in the DGV I will enable some text boxes and a combobox to show the selected data. I have not issue loading from the DB into the text boxes but the combo box has me a bit stumped. I have 3 columns in the database, periodno, start date and end date. I want to display the start and end date concatenated together. When the user selects a period and hits the button I want the dates to set a variable with the periodno that matches those dates.
View 1 Repliessample code for show id from database ke combo box. i use sql database.
View 1 RepliesI have a combobox which reads a directory and displays the file names in the combobox. What I'm trying to do is when a value is selected in the combobox I wish to display this in a label.
I have tried the following
Label1.Text = Combobox1.SelectedValue
But it doesn't seem to work.
My coding to display value in the combobox
With Combobox1
.DisplayMember = "Name"
.ValueMember = "FullName"
[Code]....
I have the first snippet of coding in the Combobox1_SelectedIndexChanged event.
The "FullName" works with textbox1 when i select a value in the combobox but I want to display the "Name" in label1.text
I am creating an application install program, but one of the main things i cannot get working is the combobox, this is a drop down list of all my applications that i have put in there. I was wondering if there was a way you could tell the combobox to look at a directory or share and list the names of files within it? So, for example i could place 5 programs inside a share or directory then when i run the program and the click the drop down combo the 5 programs are listed and then i can click and install this program. Also then if i add/remove any programs it also removes it from the combo list.
View 10 RepliesWhy won't this build and populate my datagridviewcombobox?
Me.POLLINGV2_SCHEDULEDataGridView.DataSource = Me.DataSet1
With POLLINGV2_SCHEDULEDataGridView
Dim dgvc As New DataGridViewComboBoxColumn
[code]....
I'm using ms access 03 to fill a datagridview no problem. I have 4 fields(id, first, last, points), but I just want to fill one in a combobox I have. Here is what I'm using to fill the datagridview:
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsPC #6My Documentsstudent.mdb")
Dim sql As String = "Select first,last,points from student"
Dim oledbAdapter As OleDbDataAdapter
Dim ds As New DataSet
[Code] .....
How could I get a combobox to just display just one field, like idk if I'm explaining myself correctly, like a SQL statement look like this:
Dim sql As String = "Select first from student" but just for my combobox.
I am developing a new project for my daily office use using access database with vb 2005.
In this project I have one bounded datagridview and it is ready to use.
I want to alter a particular field value in the datagridview regularly. so whenever I click the rowheader that particular field should be editable with a combobox with some value, after selection of the value and leaving that particular cell it should be updated with the appropriate record in the database.
I can use this code to set the DisplayMember, but the ValueMemeber is always the name of the field and not the field values. I can even reverse and put the ID in the DisplayMember and it works. Not sure what I'm missing here.
strSQL =
"SELECT LGGrpMainID, LGGrpMainName FROM LGGroupMain "
Public
[Code].....