I want to load all of the LOCATIONS in the Location table to a Combobox and then for any found locations (in another table) to be deleted from that combobox. Im using a Array list, but can't get the Data reader to write to the Array list.
Dim SQL As String = ""
Dim Reader As OleDbDataReader
Dim i As Integer = 0
Dim LocationArray As ArrayList = Nothing
[Code]...
I have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
How do I load data from a datatable into an array.
Dim
dtDataTable As New System.Data.DataTable
dtDataTable = dsStaffHoursWorked.vwGroupProjHoursDate
Dim DRs = dtDataTable.Select("enddate = '05/14/05'")
Got an array, why cant I save dataread info to array pos?
While myDataReader.Read()
' txtPhone.Text =
Tempstr(i) = myDataReader.Item("Phone").ToString + vbCrLf[code].....
apparently Object reference not set to an instance of an object.
How can I fill this Percentage array with Sql data reader..
Dim StudentID As Integer = Me.ComboBox1.SelectedValue
Dim Percentage() As Integer
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[code].....
I would like to retrieve a single column of about 800 rows in a table and save these values in an array so as to reference them later on. How can I do it? I tried:
[code]...
And it didn't work. The col1 is of type Int64 and so is the array prev_ob(). Please let me know how I can save it to an array.
I have a program that will compare an array of grocery list items glist and an array of coupon item clist.When I compare the two and if there is a match somewhere in the array I want to have a picturebox visible.When there is no match, I want the picture box not to be visible. [code] The code seems to work great until I come to the else statement.When the code finds a match it displays the picture box and the msgbox without error, but as soon as the message box is cleared, even though i've input it as an ELSE statement, the picturebox goes false again.Does anyone have any idea of how I can "hold" the picturebox to stay visible while the match between the arrays exists?
View 18 RepliesI am not sure how to phrase my question properly but I want to achieve something like this.
I have a class named Products public class Products
private ID as Integer
private Name as String
Public Property ProductID()
Get
Return ID
[Code]...
When I do the same, I am getting an error "Object Reference Not Set to an Instance of an Object.
I am using a datareader to pull data from my database. I store the data in a multidimensional array in a seperate class file. I access the values in the array from a form through properties.The problem I am having is when I run the project as I step through the code I can see the values being added to the array but when access it from a string property it shows up as string System.String[,]. I would like to have my array transposed accross the listview under the corresponding column. below is the code I am using.
[Code]...
I have a problem with my project. here is the problem:
My code for login is as follows:
dim conn as SqlConnection = New SqlConnection("Data Source.................)
dim cmd as SqlCommand = New SqlCommand("Loguser",conn)
cmd.CammandType = CommandType.StoredProcedure
[CODE]...
Now the error i get is that "there is a datareader associate with this connection that need to be closed"
i have issue returning a list in a web method. here is the code
<WebMethod()> _
Public Function getTags(para_parents As String) As List(Of getTypeDetailsByParentName_Result)()
Dim context As New PPEntities
[code]....
the error is
Value of type 'System.Collections.Generic.List(Of SaftyonRoad.getTypeDetailsByParentName_Result)' cannot be converted to '1-dimensional array of System.Collections.Generic.List(Of SaftyonRoad.getTypeDetailsByParentName_Result)'
I am trying to get a count of all the times a byte sequences occurs in another byte sequences. It cannot however re-use a bytes if it already counted them. For example given the string let's assume the byte sequence was k.k it would then find only 3 occurrences rather than 5 because they would be broke down like: [k.k].[k.k].[k.k]. and not like [k.[k].[k].[k].[k].k] where they over lap and essentially just shift 2 to the right.
Ideally the idea is to get an idea how a compression dictionary or run time encoding might look. so the goal would be to get down to just 2 parts, as (k.k.k.) is the biggest and best symbol you can have.
Here is source so far:
[Code]...
I have a class called Car. Car has a bunch of properties i.e. Car.Color. CarService has a method called GetCars(). Within GetCar, I have a loop that appends a List of, you guessed it.. Cars.[code].....
I get: Value of type '1-dimensional array of Namespace.Car' cannot be converted to 'System.Collections.Generic.List(Of Namespace.Car)'. What would be the best way to convert this 1-dimensional array' back into a List of Cars?
I have a variable declared as...
Dim MyList as List(Of String)
I would like to create an array of these lists of string.
Something like....
[code].....
I'm trying to create a Combobox List and I created the following my first try:
Private Sub ComboBox1_DropButtonClick()
ComboBox1.List = Array("LI-3:comparing and contrasting two or more print sources based on
[code].....
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
was just looking for info on why I can't seem to get the last value from an arraylist of integers, my code looks like this:
'sort items in array
arrayListInfo.Sort()
Dim i, num As Integer
[Code]....
and give i a number like 5 then this works but it just appears to have a problem the last number for me.
I am trying to make a MVP kinda system and I am trying to define and load an array, through the system. Then read it out and it should populate a ListView1 object.I know they are set correct, because the console tells me it's set ok.I know the sample would fill with the same item (a week to be exact) every time i add an item, but that's not the point.Also, is it possible to define the array without the index, i mean now i set it with (6) so it sets 6 blocks for strings, but I would like to be more flexible. Is there a way like in php for example
$item["firstname"]
$item["lastname"]
...
ClientlistItem.vb (definition of the actual item)
Public Class ClientlistItem
Private entry(6) As String[code].......
I have this piece of code
For a As Single = 1 To Picture1.Height - 1
If a < TempArray.Length Then
' Some Stuff here that i really would love not to share
Else
[code]....
I get an error when i try to add the Array TempArray to the List of Boolean TruthBool... The Error Says QuoteObject reference not set to an instance of an object.The Variables are declared like this
Dim TruthBool As List(Of Boolean)
Dim TempArray(10000) As Boolean
I know there are a couple of other problems with this code.. and i have solved most of them in my actual program.. I just cant get this error to go away...
I have two arraylists. The JobArraylist gets adresses from a database table and JobIDArray Gets the ID for those addresses.I'm populating a Combobox with the JobArrayList which is working ok.When I select a an address in the combobox I use the sectectindex to get the AdressID from JobIDArray.My Issue is when I have duplicate addresses the JobIDArray always returns the the ID for the last Address. not the select one.[code]...
View 2 RepliesI have a few running totals and a name associated with these totals and was wondering if an array would be quicker to use instead of storing it in a database.Basically what happens is I need to search a name and if it exists I add the necessary amounts to the totals and if it doesn't exists I add a new record.
View 4 RepliesI'm writing a program and currently have 4 lists called Palette1, Palette2, Palette3, Palette4.Each contain 15 list items of Color type.I was hoping to create an array of lists but have been unsuccessfull in doing so.[code]
View 6 RepliesI am successfully building an array list as shown below:
Dim obj1 As paperCutObj = New paperCutObj
obj1.Model = readLine(0)
obj1.IPaddress = readLine(1)
[code]....
Is there a clear command that I can use on an array list, I try to use clear but something is wrong here[code]...
View 5 RepliesI'm trying to create a small program where someone would select one of five items from a list box (Hot, Medium, Mild, Sweet, Zesty). When they select this, they then enter in a qtyTextBox the quantity they want, ie.e, 1, 2, 3, 5,... Then they the Calculate Button, which then the total would go into the preDiscountLabel box, where it would calculate the amount they want * the sale price. Here is the Price Listing:
Hot - 3.19
Medium - 3.09
Mild - 2.98
[Code].....
I cannot figure out how to set an array to one of two sets of numbers (there will be more later), every way that I have tried throws some kind of error. I have tried to Dim the array inside the case statements, but then I cannot use the array in the For Each, which makes this worthless. [Code]
View 3 RepliesHere is what I am trying to do:
TemporaryControlsPart.ChannelList = Split(MainControllerModuleChannelList,
";")
Here is the error I receive:
Error 1 Value of type '1-dimensional array of String' cannot be converted to 'System.Collections.Generic.List(Of String)'.
To me, this seems like a reasonable line of code.
im creating a simple program where the user inputs there own numbers in a textbox and the program works out the total and average and produces a bar chart.I have done the hard part of creating the bar chart, but i am stuck on using the numbers in the text box from the array.This is the code for my array lists:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles graph_btn.Click Dim aMonths As ArrayList = New ArrayList(), aAmounts As ArrayList = New ArrayList()
aMonths.Add("1")
aMonths.Add("2")
aMonths.Add("3")
aMonths.Add("4")
[Code]...
I'm making a card game and I want to try and design my own card deck.
Dim X As Integer
Dim currentCard As Integer, currentCard2 As Integer
Dim RandomNumbers As New Random()
Dim NumberofCards As Integer
[code]....
I started a basic vb.net class for my fall semester of high school, and although I've learned a lot, my goal since the start of the semester has been to do this. I realize there are simpler way of assigning card values than writing 52 if then statements, but I'm planning on doing other things with the statements. As you can see, my main plan of action is to generate a random number for each card, loop through the array list to make sure the random number representing that card hasn't been assigned before, use the value to select the card, and then add the randomly selected number to the array list so it won't be used again (non-repeating random numbers).
1) I'm trying to represent all the numbers with Numberlist.Item(X) and that doesn't work because either a) x represents any one number or b) x always represents only 0, which means it only checks the first number.
2) I think I've read something about using this method for generating random numbers in a loop, that it doesn't work for some reason.