Array Of Variables - Put Together A Quick Program For Database
Nov 17, 2009
I'm trying to put together a quick program for our database, I haven't touched VB since vb6, and we have 2008 .NET now. my question.
Ideally I'd like to make an array which can hold multiple values...such as
Job[job#].joblocation
Job[job#].jobsupervisor
So there would be a Job array, and then different values contained within that. I can't seem to make an object or whatever which allows me to hold different variables inside it.
View 7 Replies
ADVERTISEMENT
Dec 26, 2011
I know this is a VB.Net messageboard, but it can work with in all languages. Is there a quick way to complete a line (sample code):
//Setting variables set 1
a = e;
b = f;
c = g;
d = h;
.....
//Saving changes set 2
e = a;
f = b;
g = c;
h = d;
without having to type everything out...A technique using EXCEL or Notepad....Find and Replace. This would save a lot of time coding and becomes pain in the butt when you working with many variables.
View 4 Replies
May 5, 2011
I get what I'm supposed to do, and this is my 9th project in this class so I'm not new to the coding and how it works, but for some reason I'm having a hard time wrapping my mind around the multidimensional array and the variables to get the program to work. Here is the first part of the instructions I was given for the project:
Write a program that will determine the cost of a Yacht rental based upon yacht type, the size of the yacht and the number of hours the yacht is rented. There are three categories of yachts: Ranger, Catalina, and Excalibur; and three yachts sizes: 20 feet, 30 feet, and 40 feet. The rental cost is the yacht price multiplied by the number of hours rented. Create an array to hold the rental prices.
RangerCatalinaExcalibur
20 feet 95.00105.00125.00
30 feet110.00130.00150.00(prices per hour,
40 feet120.00145.00180.00 multi-dimensional array)
Use a data structure that contains the following fields: yacht type, yacht size, price per hour and cost of the rental. Limit the number of transactions to 20. Each time the Calculate Price button is pressed, look up the rental price from the price array and display it on the form along with the rental cost. Add the appropriate information to the data structure to create a transaction history.
Here's my code, the top with the variables:
vb.net
Public Class YachtRentalMainForm
'Variables
[CODE]...................
And here's my calculate button code where I'm having the most trouble:
vb.net
Private Sub CalculateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalculateButton.Click
[CODE]......................
I'm not getting errors anymore thankfully, but when I run the program... I choose my yacht type and size and input hours, it doesn't matter how many hours I put in - the price doesn't change. I know I'm missing something, maybe I've just been staring at it too long and need a fresh set of eyes to give it a look over and tell me what I'm missing? It also isn't calculating properly. 40 foot excalibur is supposed to charge $180 per hour and instead it's charging $125 flat rate.
View 6 Replies
Jul 29, 2011
I'm currently designing a mock-up of a customer booking system for a cinema using Framework 4.0. All data at present will be stored in an array and as it's a mock-up, it will remain their (customer name, ticket price etc...) as no requirement to permanently store the data at this time.[code]...
View 1 Replies
Nov 5, 2009
I want to create an array of constant variables for my program. But from everything I read about arrays they are handled by a number. I want to be able to pass back a variable that will hold the name of the constant as well as the value. How would you go about do that.I want to when I type the variable to have the constant name show up as I am typing.
View 4 Replies
Dec 7, 2010
I am developing a VB application using the Visual Studio 2008 IDE. I was making changes to my code using the Quick Replace function when the dialog window stopped displaying. Selection of Quick Find or Quick Replace from the Edit menu, as well as use of shortcut keys (CTL+F and CTL+H) all have the same affect: the IDE loses focus but no dialog windows display. Is this a known issue with an available fix?
View 1 Replies
Aug 2, 2010
Could anybody guide me how to perform a quick serch in vb.net database?I used to do it in vb6, using FindFirst method.Is anything else like that in vb.net?Do i always have to use SQL to check if record under current data exists in the database or not?
View 3 Replies
May 16, 2011
[code] Runs fine for 4 seconds. as you can see tried thread.sleep but did not help.just crashes itself then crashes my entire programs
View 5 Replies
Jan 5, 2012
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
View 1 Replies
Mar 13, 2010
I am using a Webbrowser in my program.
In the page source of a certain URL is the following: <input type="text" name="email" maxlength="50" value="email@email.com">
I'm trying to get the value part from the source and have it printed out to a TextBox on my program. I'm not sure how to do this but I tried. I made a new HtmlElement called email. Then I did email = WebBrowser1.Document.All.Item("email") However, when I try to add it to my textbox it doesn't work.
View 9 Replies
Dec 3, 2009
I have a program that creates an array of part numbers. I also have a database that holds part numbers and all associated information I need for other calculations. How can I search an MSAccess database table against all of the part numbers in the array? The Array will never have more than 100 items in it, the table has over 7000 records to search from. I've posted my nonworking code hoping someone can point me in the tight direction.
Dim rs2 As New ADODB.Recordset
Dim Test1(7000) As String
Dim Test2(7000) As String
[code].....
View 29 Replies
Jun 20, 2012
I am trying to make a simple program to put data from a database into a javascript array and then display one result in a textbox.[code]...
View 1 Replies
Aug 28, 2009
I have a byte array of a file and I need to save it into my database in a field that has been set aside of type image.
However I have a problem my data access class takes a sql string and commits it to the database for example.
"EXECUTE stored proc @parm1, @parm2, @parm3"
However the problem is I cannot figure out how to transfer the byte array to string so that I can add it as an argument.
I hope this make sense.
I also understand that I can build parameters in com objects but I do not want to do this as it will disrupt my whole data access class and I am not prepared to do this at the moment.
View 2 Replies
Feb 9, 2010
I'm trying to write a program to call Quickbase and retrieve a database and put it into an array. It's a contacts table that I need to be able to query and select different fields according to letterheads, memos, etc. I've tried to do this three different ways.
1.) Find a direct port or some way of accessing Quickbase directly, similar to connecting to an oracle database or MS Access.
2.) Export the table to MS Excel and read the data from a spreadsheet.
3.) Opening a web browser in a background processes and login to the Quickbase account, then navigate using the little XML knowledge that I have.
I just can't find a good way to do this. Any ideas or can give some help on the code to do any of the ideas?
View 1 Replies
Mar 11, 2010
I need to manipulate data for 1000 boxes, each one of these boxes has 8 variables.How to declare an appropriate array? and how to load the array with the 8 variables for each box?
View 1 Replies
Jan 9, 2011
im already familiar with splitting variables into an array using a certain character e.g.
strtextfield = name,surname,dob
strpersonarray = strtextfield.split(",")
strpersonarray = (0)name
(1)surname
(2)dob
im wondering whether you can split one variable according to its characters e.g.
strtextfield = name
strpersonarray = strtextfield.split(unsure as to what char)
strpersonarray = (0)n
[code]....
View 4 Replies
Sep 2, 2010
Ok so I have an array and wish to add the variables of the array to separate lines of the list box. I came across this which in some ways worked but also didn't. The second thing mentioned on the page was to us:
ListBox1.DataSource = Form2.Title This works the first time you run it but if you try to run it again nothing happens. So using the above or something else how can I get it to update the list box? Another thing I tried was to use the DataSource method but instead to clear the list box first, but that turned up an error
View 14 Replies
Jul 26, 2011
I have a set of nine double variables declared earlier in a program (i.e., phq91 through phq99) that I have placed within an array. The variables need to hold numeric data that correspond to item responses within combo boxes.
View 6 Replies
May 12, 2010
My problem is, in VB 2008 I need to convert this[code]...
View 8 Replies
Dec 21, 2011
I have a small class of Object CellValue
Friend Class CellValue
Public CellColor As Color = Color.White
Public CellShape As Shape = Shape.Blank
Public CellName As String = ""
End Class
Then in my main I make an array of CellValue but I want to know if the values are also being passed down with the array.
Dim Plan(SizeW - 1, SizeH - 1) As CellValue
Dim CellW As Integer = PictureBox1.Width \ SizeW
Dim CellH As Integer = PictureBox1.Height \ SizeH
[Code].....
Are CellName, CellShape and CellColor being tied to each element in the array?. The reason is because I need to use these properties to tie certain functions to them. The CellName should have a MachineID which I would have to use to pull some info from a Database.
The Array should also be serialized and deserialized to XML as customer needs to create/edit and delete certain values in the array. And in order to save the array has to be in XML
So the Questions are does it save the CellName, CellShape and CellColor for each element, will it be affected if I serialize and deserialize using XML. If possible, how can I call up the Cellname p.e for a specific array element.
View 5 Replies
Feb 21, 2012
I have a form that asks for a name, and a phone number, it has 3 buttons, a add customer button, show list button and an exit button. When the add customer button is clicked, it increments intCustomer variable, formats the phone number, makes sure only the first letters of the name are capitalized and creates an ID that is the first 4 letters of the name plus the customer number, the show list button takes ALL customers added to the array and displays them into a multi-line text box, like so:
ID Num Customer Name Phone Number
JOHN-1 John Harry Peters (111) 111-1111
Paul-2 Paul J Rodgers (111) 111-1111
Etc...
The area where I am completely lost in, is how to add the consecutive customers to the array, in the correct way. here is my code in its entirety
Public Class frmCustomerName
Dim intCustomer As Integer = 1
Dim names(9, 2) As String
[code]....
View 1 Replies
Jun 10, 2011
This may sound quite basic, but i was wondering how to change the value of a variable in an array, not knowing the index value but knowing what the variable is.
For example, I have an array and I want all strings within it that haven't got a value to say "Stretched". here is what i have tried:
For Each stl As String In Me.stl
If stl = "" Then
stl = "Centered"
End If
Next
My array is called stl(), and the size of it is always changing, so i can't just change the specific variables within the array
Also, is there some way to show/change etc all variables in an array? e.g. msgbox(stl(all))
I know this won't work, but what will?
View 4 Replies
Jul 19, 2011
I have text file that is saved as comma delimited. There are 3 columns with x number of rows. I cannot seem to figure out how to create an array that will store all three columns with the variable intProductArray as the length of the array. I have been opening the file with only one column and putting it into a textbox and using the lines of the textbox as the variable for length. I cannot figure out the array for all 3 columns.
Private Sub btnChoose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnChoose.Click
Dim myFileDlog As New OpenFileDialog()
myFileDlog.InitialDirectory = "c:"
myFileDlog.Filter = "All Files (*.*)|*.*" & _
[Code] .....
View 12 Replies
Jun 12, 2009
I'm having difficulty passing a variables in a an array list. [Code] I have to pass the paramvals array to the function. The paramvals array contains the string but not the value of variable of that name. For example, parmaval(0) should contain the value of vSequence but it showing me that it contains string "vsequence".
View 3 Replies
Oct 30, 2010
I found out that you cannot set the array size for a structure when you are making it, i.e
[Code]...
I have to fix this by making a variable with type made by Structure bullet and then redimming it, i.e
[Code]...
This means for every variable with the bullet type i create i have to redim. Is there a way i can set the size of .mesh with .capacity for every single variable created with the bullet type automatically?
View 2 Replies
Mar 19, 2011
My basic set up is Visual Basic 2010 Express on Windows 7 64 bit What I'm trying to do is to have VB 2010 get the data from a Open Office spreadsheet. I have looked around on the general interenet and have found quite a few references to MS Excel, but none dealling with Open Office. The code samples I have tried to use seem to rely on MS Excel being installed (Which I dont have). The 'Automate excel' page (Here: http://support.microsoft.com/kb/302094) naturally seems to rely on a Microsoft Excel Object Library reference that, not surprisingly, isnt there because I dont have MS Excel. Keep in mind I havent mucked around with a programming code for decades!
What I do have is Open Office 3.2, which CAN save spreadsheets in a excel format (.xls), and a few others such as .ods, .dbf and .xml (Excel 2003?).
[Code]...
View 1 Replies
Nov 16, 2009
I have a delimited text file, let's call it models.txt and it's delimited by a comma with carriage returns.
example:
21,Z920081
22,Z920082
59,Z930023
120,Z930027
I'm trying to input this into an array and then a combo box using:
dim item as integer
dim array() as string
dim ifile as integer
[CODE]............
What I want to do is to display the right part of the delimited text (Z920081, Z920082, etc) in the combo box. But when you select the item in the combo box, I want it to use the left part of the delimited text (21, 22, 59, 120, etc) as a variable for other use.
View 6 Replies
Apr 14, 2011
I am working with binary files that have 500 rows and 500 columns (width x height). When I load these files into array I set width and height variables to 500 and I was wondering instead of hard-coding like that how I can code in a way that the program should find the # of rows and # of columns of the file before loading the file into array...
View 15 Replies
Dec 5, 2011
I had to write a program for my class today(I don't like VB.NET, I like Java though) that created an Exception. Is it good practice to set variables to Nothing at the end of the program? In Java, there is the garbage collector so it will automatically delete variables if they are not used again. I don't know if VB.NET has this so should I keep what I have at the end of my code? [code]
View 10 Replies
Mar 29, 2011
I would like to loop over two string arrays but does not work.[code]...
View 4 Replies
