I have a database in my app which loads and displays some information on a form by binding the Comboboxes and Textboxes. However, I need to get some of the other values from the database for calculations before they are displayed on the form and I can't seem to find out how to do this.I could bind a couple of Textboxes to the database and then use those values to calculate, but it doesn't seem like a very efficient way of doing things.The dataset is created using the wizard and the controls are linked in the UI.
is that instead of receiving data from one row and assigning it to the same array Im receiving data from multiple rows, but the information is the same because its from the same one column from the database. The error I keep getting is 'index out of bounds of array'
here is the code
What it does is it loops through once and retrieves the first value from the db then it throw the exception when it goes to retrieve the second value.
Dim qBkNum As String = "SELECT BookingNum FROM Bookings WHERE BookingID = '1'" Dim bkNum(5) As String Try
I'm creating a calculator in visual basic 2008, and with this calculator I want to implement a feature that can store numerical values in a variable for instance x. Similar to the feature used in most graphing calculator that have the button showing: "STO->". I was thinking on using the My.Settings. But I'm having trouble on it.
I would like to read values set in a string that's retrieved from the Web, I've already got the string in a string called Webdata.The string is like so...
"Info" { "Name" { "Name1""Value1"
[code]....
I need to set Value1, Value2, Value3 as strings that I can use.
Ok so here's the story. I have an array of Assemblies which are initiated by [Assembly].LoadFrom() that load a number of DLL's. Upon initialising, a method called InitMain (from the DLL!) is called, which sets a number of variables outside of this method, like here:
Public Class Example Dim C As Integer = 0 Public Sub InitMain() C = 50 End Sub
[Code]...
If I call the method Test using that same array of Assemblies somewhere later in the main application (like pressing a button or something to trigger it), it will pop up a messagebox with that says: "C = 0"Why is this? Is it fixable without any odd workarounds?
1. Is it possible to store images in the variables or something like that, then store the images of things that are not buttons, picture boxes or panels?
2. What is the fastest way to store images in Visual Basic?
3. Is it possible to create a list of the class Bitmap and post a picture in each bitmap in a forloop? If it works I would like to see some examplecode.
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] .....
I have several threads all relating to this same subject but I have yet got a answer which I could work with. I think most of that is because of my explaining..So..[code]...
Which is the best way to store global variables, in My.Settings or My.Namespace. The reason I ask is because I need to know certain boolean values if certain forms are open from other forms. At present I am defining Global Boolean variables in My.Application, which give the result I require.
My text file is a settings file and I know I will be adding more to it in the future, right now it reads "autoplay=false;mintray=false;"I am currently using probably the most inefficient way to check both of those settings:
if contents = "autoplay=false;mintray=false;" then elseif contents = "autoplay=false;mintray=true;" then elseif contents = "autoplay=true;mintray=false;" true elseif contents = "autoplay=true;mintray=true;" endif
How can I read the file, find each word from the equals sign to the semicolon, and store each of them in a variable identified by the text before the equals sign? Something like this:
Also, how can I edit the settings in the text file without having to overwrite everything every time I save to it? For instance; finding mintray in the text file, and changing mintray to true instead of overwriting the file with "autoplay=false;mintray=true;".
This is my current
Reading Dim fs As New FileStream("C:myfile.txt", FileMode.Open, FileAccess.Read) Dim d As New StreamReader(fs)
I am trying to store 5 values and an associated unique key. I need to search for this key and update the 5 associated values. I'm guessing I would use an object as the value but how do I get the values out from the object?
I am trying to create a "Generate Number" application. It needs to generate numbers ( 1 - 100 ) and add them to the array. I have the numbers generated already and outputed into a list box. but I am not sure on how to add them to the array.
I have generated the numbers using for...next and do while loops. But I haven't been able to get the right syntax to be able to add the numbers into the array. [code]/...
I would I have a program that I use in the computer in my network, but for every user I need to edit the source to this user, thus the user cannot edit his information, just use the program how it was ... So, looking over the internet I found a "program" that may contains my solution... Its a Keylloger, I'm not meaning use this keylogger, no, but it has a a very interest feature: I use the main form to edit the information then after all it create a new program with the new information inside... I use my main program to create every userprofile then my program create a new program with the profile inside...
I don't know if I can have several same forms to do the manager jobs, ACTUALLY THE STORE VALUES ARE DIFFERENT(those forms can have the independant data values to store into the forms), like if I can have the datagridviews to store the different values? SO,MY QUESTION IS if I can have several same forms(FROM ONE SAME FORM), and can store different data values into the forms with vb.net & access, OR I HAVE TO CREATE SEVERAL SAME FORMS.
I have the following code which obtains the compass direction from a degree value. I'm new to VB.Net and was wondering what is the best way to store the values, in an Enum or an Array?
I'm trying to convert old code to VB in VS2005. The code I'm working on is used to store values in a string, which will then be handed to a proprietary scramble function. This function is a given in this case. I've already switched from a string to an array of bytes in my .NET code.
The old code (VBA) was using a string value to store the data, example function for Double value: Private Function DoubleToStr(ByVal value As Double) As String Dim Bytes(7) As Byte ' 0-7 Double is 8 bytes Dim n As Long CopyMemory(Bytes(0), value, 8) DoubleToStr = "" For n = 0 To UBound(Bytes) DoubleToStr = DoubleToStr & Chr(Bytes(n)) Next n End Function
The code basically copies the memory contents (using API call CopyMemory) of the memory (held by the double variable) to the memory held by a byte array. It then reads the byte array and converts it into a string. Workarounds could be to convert a bool or long to a string, though that would be expensive in terms of memory/storage eg. 1234564787 would be 10 bytes in a string where as a long is only 4 bytes (factor 2.5 increase).
How to retain the original precision? Converting it to a string would result in endless numbers. Another problem (at least I think it could be) is that in VBA the variables are rather simple, but in .NET they are all objects, so how to retrieve the actual memory location of the value? let alone garbage collection moving stuff around. How to get those variables stored in my byte array?
Here is my select stament to store values when username and password and check boxes are check
com = New OleDbCommand("INSERT INTO Users (UserName,Password,IsAdmin,Read,Write,Change,REMOVE,User_st) VALUES ('" & txtusername.Text & "','" & txtpassword.Text & "'," & CInt(chkIsadmin.Checked) &
[Code]...
My problem is this wehen i add new record to my db it saves values like this the value of read column is as follows read = 1 when check box is checked and read = 0 when check box is checked but i want to save true or false instead 1 and 0 how to achieve this using vb.net and my db is Oracle.
I built a small website and there will be only one admin, so in the admin panel I am asking for a password with a value that I do not retrieve from a database, I just hard coded it in the function in code behind, I know this is wrong though I don't know why.
So is hard coding it in web.config the right thing to do? and how?
I am attempting to teach myself visual basic and I cannot figure out how to send a calculated value (on a button click) into a one-dimension array and then recall the last five values in a message box when the user exits.
Here's what I have:
Public Class frmInvoiceTotal Dim totals(4) As Decimal Private Sub btnCalculate_Click(ByVal sender As System.Object,
My application sends information from Form1 to Form2 by means of a global variable on Form1 whose value is read by Form2.
This variable is basically used to tell Form2 what it has to do because it's value will change depending on different conditions.
All form2 is meant to do is load data from a database into DataSets which will "ported" to Form1 (the main form) for consumption. I use a Form for this rather than a class because there's a lot of data that will be loaded each time it's visible and I wanted[code]...
I have a rich text box and i want to enter 10 values and I want to use this button I have to store it. How can I do this? Or can anyone link me to the Microsoft site with information about this? (this is visual basic in Visual studio 2008)
I am a beginner at VB.net programming. this score calculator. The application is suppose to total up a sum of numbers added, show the count, and an average of the numbers inputted. I try using an array to store the inputted values. Now I'm have issues with my loop keeping track of the total. Also, how do I clear out the array to start over?
Using VB express 2008 here. I am just wondering about the best way to store certain values like the last browsed folder even if a user closes the app and starts it again. I dont want to go the route of making a text file in the installation directory and storing the values there. Seems clunky.
I want to store say like 8 values, that in the end will be combined into one string. What's the best way to store them? They should be reached in a own namespace I did. In a separate .vb file. I want to able to edit them. The values are both text and numbers. So whats the best way according to you?
i think its hard to explain, but here we go.I have a combobox, where you should be able to add item (in this case colors/Hexcode selected from colordialog).So lets say we have 3 items in that combobox:and if you pick blue, the color blue should apper in a background color.I can only get names to work, but i cant find out how to store the hex value data.
what if you created a pool of numbers: 1 - 21 and then chose a random selection from the pool? Something like the following:[code]This gets rid of those messy if statements and all of those loops.
i had a look at how to set values of variables from nummbers stored in external txt files the variables then needed to be added up so i used trial and error first
((XVAL) + (NEWVAL))
assuming that XVAL was set to 10 and NEWVAL was set to 20 i expected to get the answer of thirty but waqs presented with the new value of 10 20 VB.net pysicaly added the two values together but i wanted the mathematical product of the two which is ((10) + (20)) = 30
