I have a table in an access database than manages user subscriptions. A user can have many subscriptions which is where im having trouble in terms of code.What i aim to do is store all the courses in an array of strings but i don't know how to do it.[code]The above code would be the command that i'd use to select the courses that the user has but i need to know how i would store the results in a array.
View 2 RepliesI am trying to create the following program Store in a 1d array a set of 5 place names and in a 2d array the distances between the places. Ensure that the order of the places is the same in both arrays. When the names are places are input the distance between them is displayed. If they are not both in the table a suitable message is displayed
Dim town(1 To 5) As String
Dim Dist(1 To 5, 1 To 5) As Integer
Dim First As Integer
[CODE]......................
I think the best way forward is pass a parameter to the function findnumber.
I have a little problem with interacting with sql server from vb.net. I look here [URL]. I made an sql server table called Per: Until here all it's ok. What I want to do is to insert in the two textboxes the user types Mike (in textbox1) and Bottomley (in textbox2) ,press the button search and stored the results in listview if he finds the row (and in this case it finds).
Here is the printscreen of my windows forms application vb.net (I am using visual studio 2008. So I type in the two textboxes Mike(textbox1), Bottomley(textbox2) press the button and it searches in my sql server table (if it finds -in this case I have this rows it's row1) it displays me the result in the Listview.
I performed a search by completing this information in my form:
TextBox1: the user types DB-20-RTS
DateTimePicker1: selects 7 april 2004
DateTimePicker2: selects 7 april 2004
[Code]....
I don't have errors of syntax in my code the only problem is when I press the search button (it doesn't store me in the columns of datagridview the 5 things I want).
I want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 RepliesSo hopefully this is a quick fix but for the life of me I can't figure out how to get my results from a OracleDataReader record set.Just trying to get all the users for a specific TNS into an array. I was able to do this easily before with ADODB, but thought I would try using ODP.net.Here is what I have so far and it definitely gets all the USERs for a given TNS. its when I get to the READ() part where the syntax is ??
View 1 Replieswhich is the way to create all "matches" to array without this style:
ListBox1.Items.Add(Regex.Match(GetWebData).Value)
ListBox1.Items.Add(Regex.Match(GetWebData).NextMatch)
ListBox1.Items.Add(Regex.Match(GetWebData).NextMatch.NextMatch)
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
How could I add array values and populate the results in a specified text box?Then repeat for each line after. Then get a final total.
For example:
1 2 3 4 5 (15)-text box
1 2 3 4 5 (15)-text box
2 4 4 3 5 (18)-text box
-----------------------
(48)-text box
The assignment called for a VB.Net (not web based) program that would accept user input for the loan amount, interest rate, and term of loan, and display the monthly payment of the loan then list the loan balance and interest paid over the term of the loan. the list will be longer than the screen so use loops to display a partial list, hesitate, and then display more of the list. So, I did exactly that and the program works fine. However, after submitting this program for grading, The instructor for the class tells me, "One thing you should work on is not using a timer to pause.
You should not use a scroll bar either." He says I should work on loading the results into an array or use a loop with a counter that can be used to display a given number of results with a more results button for displaying more (but without a scroll bar?). Like I said, this program works fine and I am not asking anyone for any specific code (some sort of example would be great but not necessary) What I am asking for is an explanation of how I would go about loading results into an array to be used for displaying just partial results at a time in some way other than I used here: [Code]
So basically, I am running through my selected path recursively and returning the results to an array.. I think.
vb.net
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim path As New FolderBrowserDialog
If path.ShowDialog = Windows.Forms.DialogResult.OK Then
Me.TextBox1.Text = path.SelectedPath
[Code] .....
I was told that to return the search to an array, I add the return toarray() at the end.
Now obviously Im not getting errors, but I am also not polling the results that are in fileslist.toarray(). I've looked at arrays quite a bit, I see their functionality if they are defined like myarray(4) with 5 declared array values... its an array with 5 value places. And to read from any one of the 5, you'd say something like msgbox(myarray(3)) to call the 3rd place in the array.
Well, as you can tell from the code, I am putting a variable amount of information into the array, How can I call that information? If I scanned a folder with 300 files, how can I call the results of that array and put them in a text file, or console, or messagebox through them? And assume I am doing it through a button click event. So, button click to read all input in the array to console or something like that.
I want to store value in array, from my database. I am using following code but it return error: "Object reference not set to an instance of an object."[code...]
View 2 RepliesThe following code works just fine:
Dim wksSheetNames(0 To xlsWB.Worksheets.Count - 1, 0 To 1) As String
Dim i As Integer = 0
For Each Wks In xlsWB.Worksheets
Wks.Activate()
wksSheetNames(i, 0) = xlsApp.ActiveSheet.codename
[Code] .....
What is the best vb.net based search method that would permit me to search for i.e. "Sheet2" and be able to obtain "Cats"? I attempted to ascertain the index number of "Sheet1" with:
Dim SheetArrIndex As Integer = Array.IndexOf(wksSheetNames, "Sheet1")
Then obtain the value "Cats"
wksSheetNames(SheetArrIndex, 1)
But I received an error message:
Code Line ->>>> "Dim SheetArrIndex As Integer = Array.IndexOf(wksSheetNames, "Sheet1")"
Error msg ->>>> "Only single dimension arrays are supported here.:
Obviously I do not know how to Search and Return the results of a 2D array.
I seem to be having a heck of a time trying to figure out how to add the results from a mySQL query to an array in vb.net. Right now, I only understand that you have to define the dimension of the array, however this is shy of impossible since the dimension of the array will change due to different results from the query. What is the proper way to take my results and put them in an array?
View 12 RepliesI'm having a hard time learning picture box.I can't figure out how to store a picture in an array.when i press the button the Picture Box1 generates 1 picture out of 5 pictures.[code]
View 8 RepliesI want to store a regular array in My.Settings. Not an ArrayList, not a StringCollection, just a string Array. Can this be done? If so, how is it done? I can't seem to find the string array datatype in the settings designer in Visual Studio.
View 3 RepliesI would want to store a datagrid row in a array.Every column value in a diffrent "part of the array".Like
Array(0) = column index 0
Array(1) = column index 1
But just from one row and the same row!
first i need to input the expression in textbox that will be store to CharArray and then substitute the variables to integer by using input boxes.. my problem is how can store the integer to an array and also store the operation..
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim arr() As Char = TextBox1.Text.ToCharArray
[Code]....
Problem storing value in array from database
View 3 RepliesI 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've created a program that requires students to answer addition questions.I have the code so that it calculates if the answer is correct, along with outputing the correct answer into a textbox.If the answer is correct the textbox background colour changes to green.If the answer is inocrrect the textbox background colour changes to red.I've done this using an array, and I want to use this array to calculate how many questions the students have answered correctly, and output them onto another page.I'm not sure is something like this would work:I was thinking about giving the textbox that outputs the grade score a value of 10. For every red box that is highlighted, 1 is taken away from the texbox value, outputting the amount of questions the user has answered correctly.Here is my array so far, not including the ability to output how many answers the student has answered correctly.
Public Num1(10), Num2(10) As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
i've a treeview in my project form which look like this.[code]The user will be able to upload their pages to the respective pages nodes and I am suppose to make it in such a way that after the user uploaded the cover page which is showing at the PictureBox1 which I've use to display the image, and when he uploads the second page image at the PictureBox1, the Cover page image that he uploaded earlier on will not be overwrite.I was told to create class and use array to store the contain in the respective nodes but I do not have any idea how to do it.Is there any other ways about solving this problem? I'm using Visual Studio 2008 vb.net.
View 2 RepliesI have a text file called COUNTERS_SETTINGS.DAT having the following contents:
[USERID]<=>COUNTER_1
[PASSWORD]<=>ADMIN1
[CONNECT_STRING]<=>DATA SOURCE=RECAT;USER ID=PAYOPER;PASSWORD=PAYOPER
I'm Trying to have that entries in a Jagged array of Strings like this
Array Name is : Core (2,1)
Core
(0) (1)
(0) USERID | COUNTER_1
(1) PASSWORD | ADMIN1[code]........
I am building a small office application that requires users to log in dont need encryption or other sophisticated aproaches. all i need is an array of passwords that users can log in.
So If passtext.text= "test" or "test1" or test2" then
else
msgbox("Fix password")
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?
[Code]...
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?
I'm writing a program that reads randomized test questions from a text file. The text file includes information about how to set up the screen including which pictures, videos or buttons etc. to show for each question. The user responds to the questions and another text file is created logging the results. would it be better to read in all the data from the text file into an array to work with during the test, or should I just read the questions one at a time keeping the text file open while the user responds. The amount of data that would be read into an array for an average test would be about 200 lines which range from a single character to 20 sentences (whose length would of course vary).
View 5 RepliesI'm retrieving data from Active Directory(name,department,title,company,mail) into a string seperated by commas and I want to split the string and store them to array where i can export it in excel before updating it to my database. but i how do i store them to an array?
here's the code: I'm getting data from AD and storing it in list:
Dim formattedName As String = String.Format("{0},{1},{2},{3},{4},{5}", _
resEnt.Properties("name")(0).ToString(), _
resEnt.Properties("company")(0).ToString(), _
resEnt.Properties("department")(0).ToString(),
[Code]...
In the following code (Class & Form1), I'm trying to figure out the following:
- Create an array that stores the 'Clients' (first name, last name, account number)
- 'Button List' the array with the (First Name , Last Name , Array Value , Account Balance) [code]
I want to store a 2-dimensional array with 5 columns and indefinite rows in My.MySettings. I've tried to use a Class with an item list (list(of T)) but also a StringCollection.
View 15 Replies