I'm having difficulty in getting data into an array. The following returns a column of data which needs to be placed into an array.
<code>
select * from [schema].[table]
where [number] = ######;
</code>
I attempted binding, and created a query in the dataset but failed to get any further...
I'm trying to sort an array based on a structure but whenever I do this, it basically erases all the data in the entire array.I have verified that the array is populated correctly, it is when using array.sort that everything returns blank.
View 6 RepliesI 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 Repliesi have an array contains a-z.Then i have a textbox and when click on the button, it will replace the text inside the textbox to the index number of the array.Example, from "abc" will become "0 1 2" The code below do the job.how to do so that i can replace the text inside the textbox from "0 1 2" back to "abc" based on the array?
Dim txtKey As String = readKeyTxt.Text
readKeyTxt.Text = ""
For Each b As String In txtKey[code].....
Here's the data I'm trying to work with
Spark Plugs
column 1: PR214,PR223,PR224,PR246,PR247,PR248,PR324,PR326,PR444
Brands:
column 2: MR43T,R43,R43N,R46N,R46TS,R46TX,S46,SR46E,47L
column 3: RBL8,RJ6,RN4,RN8,RBL17Y,RBL12-6,J11,XEJ8,H12
column 4L 14K22,14K24,14K30,14K32,14K33,14K35,14K38,14K40,14K44
Here is what i came up with for my code so far
Public Class frmMain
Private strSpark() As String = {"PR214","PR223","PR224","PR246","PR247","PR248","PR324", "PR326","PR444"}
Private strBrands As String(,) = { { } }
End Class
how to parse SQL Text with VB.NET?
Ex: I got a sql file "CREATE TABLE..." i want to get an array of columns and an array of data types.
Ypos = TopMargin + Count * PrintFont.GetHeight(ev.Graphics)
ev.Graphics.DrawString(ROData(x, 3), PrintFont, Brushes.Black, LeftMargin, Ypos, New StringFormat())
Count = Count + CInt(ROData(x, 4))
The above line prints the data contents of the ROData array in position three. I would like to be able to assign a specific position accross the line to have the printer print the data at without left padding the array data.
I am trying to write a thread safe application that contains 3 threads : -
1 - Data acquisition and decoding
2- Data graphing
3 - FFT and filtering
Thread 1 is collecting bytes from the serial port and converting them int integers (so taking two bytes) after is has captured 64 Bytes and converted into 32 integers, it then needs to pass the array to the graphing thread.
The graphing thread then plots the data and waits for more data.
Thread 3 also waits until thread one has collected 2023 integers and takes these and performs some FFT calculations (which take time).
My question is how do i share the arrays between the three threads without deadlocking the program? as the serial thread will be flying around reasonable fast (1000 bytes per second) so it will synclock onto the shared buffers for most of the time.
Originally i was going to use two synchronised queues, so when thread 1 has collected 32 bytes it queues the data into the graph queue, and once it has collected 2023 it queues the data into the FFT queue.
Then thread 2 and 3 can simple dequeue the data.
However using queues has the overhead of casting the data in and out, and as i know the data type i was planning on using two arrays :-
Dim GraphArray() as ushort
Dim FFTArray() as ushort
Then Thread 1 adds data to each thread, and thread 2 and 3 simple wait until the correct amount of data is available before removing the data. my question is there an array type that allows me to remove x amount of data from an array?
Because i cannot do this easily with the ararys defined as above (GraphArray, FFTArray), as i was planning on making them 1mByte and allowing thread 1 to fill them Knowing they should never overflow and then let thread 2 and 3 remove x amout of bytes at a time unless there is a better way of doing it
Data binding should be an extremely simple thing to manage but I can't find a SIMPLE solution to the following problem.
I have two forms
Form1 contains a 4x4 MSFlexGrid (unfortunately an unmanaged COM object but I can merge cells, which I can't do with a managed Datagrid)
Form2 contains other controls which change the data in the Flexgrid.
I connect the two with a Public 4x4 array. Form2 changes the data in this array. I can update the grid data by reading the array. But how do I bind the Grid to the array so that it auto-updates - which is the whole point of binding isn't it?
In order to re-sort the data received in USB easier, I send the data array received in USB (declared as Byte) to a temporary array (declared as SByte) to re-sort. I declared the temporary array as SByte just for easy sorting. After I compiled, an error message came up "make sure not divided by zero". I tried to use convert.SByte but still didn't help. Is it not allowed to send data to an array with different data type declaration?
View 1 RepliesI have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 RepliesI have an array DetailsArray in VB.NET which contains the result of a LINQ query. I have shown below the values of the array. i need to get the "ProjectID" from the array and assign it to 'ProjID' variable
DetailsArray (0){Name =
"TestProject1", ProjectID = 10}
Dim ProjID as Integer = DetailsArray(??)
How would I do that?
I need to construct a data array and I am not sure if I can do what I need to do given the data. I probably should opt to store in a new class but that's too advanced for now
the data describes a series of points. each point has its index in a list a boolean, binary value and a list of integers of its neighbour points. so i thought it would be three columns and the third column would store a list. can you do this?
I presume i could get rid of the column dedicated to storing the integers..
i have an array of double. May i know how to get all the data to be display into MsgBox? The code below has problem saying "1 dimensional array of Double cannot be converted to 1 dimensional array of string". I tried using CStr also cannot.
Dim numbersAsString() As Double = Array.ConvertAll(res.ToArray, New Converter(Of Double, Double)(Function(i) CDbl(i.ToString)))
MsgBox(String.Join(" ", numbersAsString))
I have a ListView control on my form set up like this in details mode:What I would like to do, is get all the values of the data cells when the user presses the Delete booking button.So using the above example, my array would be filled with this data:
values(0) = "asd"
values(1) = "BS1"
values(2) = "asd"
[code].....
I have for ex. 5 names i table A in table B i have several rows with 50 names.. But i only want to pull out the records that matches the 5 names in table A! I never know the amount of names in table A so i need to pull out every record in that table..I guess i have to get the names from table A and put them into an array and then in the query get the records from table B that contains the data in the array.. I have tried, but no luck..
View 2 RepliesI need to retrieve data in array. We are asked to get id number, name and section and put it in a array and then if we clicked retrieve button it will prompt an inputbox requesting for the id number of students and after we input the id number of the student the name and section will be in the msgbox.
View 1 RepliesHere is my objective. I have a text file, delimited. Data sample below
1140001074,03/06/12,0001000016,03/07/12,0412652694,1150000309
1140001074,03/06/12,0001000016,03/07/12,0412652695,1150000369
I need to import this data into a table, that is already created in sql. I'm not updating, just a simple insert.I thought the way I would do this is read the file, put that into an array, then from the array import into the table.My code below for reading the text file, and placing it into an array
Private Sub ReadtxtFile()
Dim lista As New Collections.ArrayList
Dim input As String
If File.Exists("C:filetestBol Test.txt") Then
[code]....
I am reading two lines of data into an array, the data being split by commas (,).[code]...
View 2 RepliesThis is getting on my nerves. All the examples I keep finding deal with Consoles, all I'm trying to do is put data into an array of objects and output them into a Text box, but I don't know the syntax to do that.Here's my class
Public Class Student
Private SID As Integer
Private firstName As String
[code]......
im having trouble reading in lines of data using arrays and a structure. I believe my main problem is figuring out how to keep track of the lines read in, even if the whole array size isnt used up. Also, To break up each line I am trying to use the split function to seperate spaces, but dont know if im doing so correctly.[code]
View 3 Repliesi have data (CSV) that goes into an array. I then update the data but when it updates, it keeps blank elements of the array. Each time i update, the array doesnt replace my old data with the new data, it just seems to create a new element of the array. Then i get the incorrect count of entries.
Reads XML
For Each node As XmlNode In xnames
nvalues = node.InnerXml.Trim
Next
[code].....
Private Sub XMLReader()' Wir benötigen einen XmlReader für das Auslesen der XML-Datei Dim XMLReader As Xml.XmlReader _= New Xml.XmlTextReader("Properties.xml")
[Code]...
i'm trying to save data from an xml in an array depending on which record is read. But everything is saved into one array, i think the valuecount +1 doesn't work but i can't get it
I'm having trouble trying to put together some code for an array. What I'm trying to do is get data entered from a text box and store it in an array.What I then need to do is take the entered data and make it appear in reverse order to what it's been entered and show this.
View 6 RepliesI'm still learning visual basic and I'm kind of stuck. I'm getting the wrong output when I test my data. I'm trying to sum array data and get an average from it. When I print out the average it's way above what it should be. When I enter these numbers 32500, 23000, 38210 I should get an average of 31236.67 but the number I get as the average is 46855.
[Code]...
I am trying to work out what exactly I am doing wrong. My code looks right but I cant seem to find why I cannot access my arrays from my structure in another procedure. I think perhaps my temp array is not declared correctly to my structure. why I cannot use it from another sub and explain if I an using the structure correctly. In my click_button, I am getting the error:'SuburbString' is not a member of 'System.Array'.
[Code]...
if you could possibly point me to the right direction, that would be great. i have tried researching about this but found no solution.i have a 2d array which holds student name and 3 grades (eng, maths, science.)student array (24,3)Now, i would like to use the data which is held within the array to create averages.I need a total class average for: maths column, eng column, and science. I also need an overall average for all subjects.the code i have used, so far, brings some odd results.
studentarray(i,1) / count
studentarray(i,2) / count
studentarray(i,3) / count
[code].....
I have a ListView in which i have a function that creates images for users.I pass userGender,userImage1name,userIsImage1Aprooved values to the function in which i generate image.ie. if user has approved image i return it back, otherwise i return default image based on gender.
My question is, is there any way to avoid passing 3 parameters to that function and to pass whole DataRow so i can get values of columns i need?In reality i pass about 12 parameters just made it easy for you.ie. i want to achieve something like that <%# GetImage(Container.Item) %> while in GetImage() i would be able to access Item("some_column_name") or C# version Item["some_column_name"].
I'm using vb.net 2008 edition and i was wondering if there a way to convert an array type to another array type. For instance say i dim an array as string and then want to convert the array to the integer data type for sorting, how would i go about this?
View 1 RepliesI want to store the contents of an XMl file into an array but struggling to work this out. I have managed to read the data in and store in labels as a test. I then created an array list and used a message box to display the data to see that it has been stored. It does but I am not sure how to group this data. There are 3 records in the file. the idea is to end up with the following:
[Code]...
