Finaly I get to ask a simple question.
I have some ComboBoxes and I want to do two things with them:
1) Make there be a value in it rather than blank then the form loads (it is populated by the properties tab rather than in the code)
2)Not allow anything other than the values in the list to...
I am try to create a data grid that will select all users with a surname that is stored in a variable that has been entered earlier.
The code below is there to quickly check the database to see if there are any records of that surname, the next section which will compile a DataGrid is going to...
All I want to do is get the first column from the grid created below to be in the format of last booking ref first. Can I find the resource on the web? No i can't!
SELECTS ALL BOOKINGS THAT RELATE TO THE CUSTOMER NUMBER
Dim da3 As OleDb.OleDbDataAdapter = New...
I have a try catch set, and if the error message box is displayed the user clicks OK and the finally statement is executed.
What I'm after is to stop the application so that amendments can be made,
What I am trying to deicide is whether I should use multiple datareaders to store the the individual values or if I should query the data an stash it in a dataset then bind the result in set to the labels.
Which one should I use and is it doable?
I think that I am in the correct place for this one.
I have two questions about the display off data grids,
1) Is there any way of changing the titles of the fields displayed. For example it presently displays the field name from the DB (custID) rather than the nice Customer ID that I want it...
I have a variable the stores a total cost the is received from a database (Access). What I am getting is an error saying that the value type Integer can not be displayed in a label, nor a text box, in fact any method of displaying it yields no result.
The code I am using is...
I think that I get what you are saying, however I think that we would need to see an example of the code that you are using.
I believe that pulling sql code directly out of access and place it in vb.net will not work as you need to use the formal sql in the application.
Post the code and we...
I am trying to get this to run an insert into the database. I keep getting an error saying that it is missing a ;. I don't really get where that would go.
The actual method works in other places of the application so it must be a syntax problem.
' Creates the OleDb connection...
I am trying to get some values that have been stored in variables to add togeather.
I have a form that calculates a total for the person before adding their personal details to a access DB.
The total for the person is added to the grand total and the form is reset (not reloaded), then the...
I am having a problem with an sql statements in my VB.net form.
The DB is access and the sql is as follows:
SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = bookingBooking is a integer variable, I am not to sure if I have entered the variable correctly into the...
I have managed to get to the point in a project where I must display a summery of a booking.
The details that I have stored in an access database are as follows:
First Name, Surname age and activity
I need to get these to display in a data grid so that the user can confirm the booking.
Problem is resolved.
Thanks for the help that everyone gave me on this, the main problem was in the sql statement. I was trying to do a query that would return the value 0 every time that it ran hence the problem.
Also I had the sql in the catch statement and as a result this wouldn’t run...