I'm attempting to make a generic query executer function. I want to be able to send it a query string and have it return a two-dimensional array containing the results. Below is my code for how to do it with a (9,x) array. How can I do it with an (y,x) sized array? Also, I feel like there must be a more efficient way to do this..
[Code]...
I'm using VB.Net and have the following LINQ Query...
Dim ACFTTail5 = (From tailcounts In db.TailCounts _
Where tailcounts.Model = "UH-60A" _
Group tailcounts By _
tailcounts.Tail, tailcounts.Model _
[Code].....
But get the following error...
"Unable to cast object of type 'System.Data.Linq.DataQuery1[VB$AnonymousType_42[System.String,System.String]]' to type 'System.String[,]'."
I have a string containing many lines. Each line has many values separated by commas. Basically it's in CSV format. The number of lines is variable but the number of columns is always 7.
I can get each line into a one dimensional array using Split(Var, Chr(10)).
I'd like to make it a two dimensional array where the second dimension contains each comma separated value.
I've got
Dim VarArray1() As String = Split(VarText, Chr(10))
Dim VaryArray2(0 To VarArray1.Length - 1, 0 To 6) As String
Is there a quick way to get the contents of VarArray1 into VarArray2. I know I can do the following.
For Counter = 0 to VarArray1.Length - 1
Dim line as string = VarArray1(Counter)
Dim Values() as string = Split(line, ",")
For Counter2 = 0 to 6
VarArray2(Counter,Counter2) = Values(Counter2)
Next Counter2
Next Counter
But is there a quicker way to do it that doesn't require passing through each element of VarArray1 and then passing through each element of Values.
The eventual goal in all of this will be to find the highest value in the 3rd column (the arrays are strings at this point because not all columns are numeric). To do that once I get the values into VarArray2 I suspect I have to pass through each element VarArray2, i.e. VarArray2(Counter,2). Unless I can copy the whole third column into a SortedList?
I need to hash a number (about 22 digits) and the result length must be less than 12 characters. It can be a number or a mix of characters, and must be unique. (The number entered will be unique too). For example, if the number entered is 000000000000000000001, the result should be something like 2s5As5A62s. I looked at the typical, like MD5, SHA-1, etc., but they give high length results.
View 5 RepliesI'm creating a small program to read from an SQL server, loading result into an array, pivoting the array to my liking and mailing it out to selected members of a group. It's going to be run once a day with Windows schedule. I have the connection, query and mail sorted, but not the datareader to array bit.
(line 26)?
Imports System.Data
Imports System.Data.SqlClient
Imports System.Net.Mail
[CODE]...
I have 9 1-dimensional arrays of bytes and 1 of them is empty, I want to make the empty one equal to the others put together like you would a string:
Dim bla As String = "bla" & "bla" & "bla"
'now bla = "blablabla"
but instead:
[Code]......
In VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top..The code is part of a routine to programmatically check whether an image overlaps cells that are used in a workbook. My current method of iterating over the cells in the UsedRange is slow since it requires repeatedly polling for the top / left / width / height of the cells.I'm going to go ahead an accept Doug's answer as it does indeed work faster than naive iteration. In the end, I found that a non-naive iteration works faster for my purposes of detecting controls that overlap content-filled cells. The steps are basically:
(1) Find the interesting set of rows in the used range by looking at the tops and heights of the first cell in each row (my understanding is that all the cells in the row must have the same top and height, but not left and width)
(2) Iterate over the cells in the interesting rows and perform overlap detection using only the left and right positions of the cells.[code]
Per this UserControl that can be added to a blank form, I would like to use the HorizUnits array below to map custom grid x coordinate from a mouse x position.For a given input value 13, what syntax would I use to obtain a value of 2 where 13 lies between Value 10 and 16 for which 2 (Name) would be the custom grid's displayed coordinate position?
View 1 RepliesI am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesWhat type of collection should I use to store data from a table (in a book) that has multi-dimensional Keys to get a single value result?
What is the best way to store and retrieve these values in a program?
I can achieve in VB what the following C# snippet does but it seems very clunky since I perform a Linq query to obtain the events for the relevant user. Is there a neat way?
ctx.FetchEventsForWhichCurrentUserIsRegistered((op) =>
{
if (!op.HasError)[code]........
I am having a problem understanding the following error message:
Value of type 1-dimensional array of string cannont be converted to 2-dimensional array of string because the array types have different numbers of dimensions This line seems to be causing the error:
New String((13) - 1) {}
I did a Google search on this but didnt come up with anything useful. I didnt even change the code.I just found this example online and copied/pasted it into a project that Im working on.
All code is listed below!
Calendar.aspx.vb
Imports System
Imports System.Data
[Code].....
I need to append STRINg to Array and cast it 1-dimensionalArray
Dim remoteFileNames(0)
As
String
[Code]....
Here "FtpRemoteDirectory" is a string and ftpFileNames() is the Array String which list the FileNames.
and remoteFileNames is 1-dimension array
I am new to .Net Programming and would like to know if Reflection is suitable for traversing an Object to discover Collections within an instance of a class. I am working with the Microsoft.SqlServer.Management.Smo Namespace.
The plan is to connect to a database, determine what collections exists, then for each of those collections, if the Collection exposes objects which implement the IScriptable Interface, generate a script for the object.How do i do the following (This is pseudo-code as I am seeking assistance with using reflection or some other method to do the following)
[Code]...
I would like to enumerate all objects in db with one function if possible
I have a 2d array of data that I have performed the sum of the individual column of the 2d array. I want to send the results to a datagridview and also will like to have the result as a 1d or 2d array.
Below is sample of my code
Dim Array1(,) as double
Array1(0, 0) = 5
Array1(0, 1) = 7
[code].....
I am looking to remove an element from an ArrayList using a query, E.g. DELETE FROM arraylist WHERE (0) = "User1" (Where (0) is the index of the second dimension).
Code:
Dim Users As New ArrayList
Users.Add({"User0", "Details"})
Users.Add({"User1", "Details"})
Users.Remove("User1")
The reason I am looking for a query way to do this is because I will not know what the second dimension value will be.
I developing a roster application (asp.net with VB + sql server) to let user input shift duty record, proposed screen as follows:for the database design, each staff will have one record per day.[code]I want to create a multi dimensional array to bind the gridview.Is that correct that I create a arraylist (for 7 days) and then a subarray for each day? How can I create a 7 dimensional array & sub array under this 7-D array in asp.net + VB ?
View 1 RepliesHow to redim a two dimenational array in VB.NET, when it reached it's upper limit,.Also want to preserve the data.
View 2 RepliesI have the following code in my project:
rivate Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code].....
I've been working on a VB project where I use a 1st drop down list to select a movie category and then in the 2nd drop menu, movies from that category will be displayed. The movies are stored in a 2-dimensional array by category. I've been able to edit my array but I'm having problems with my .AddRange() function. What would I have to put in those parentheses for the list (for each category) to appear in my 2nd combobox when the category is selected?
[code]...
Ive got a jagged multi dimensional array, how to work out the length of a single row of the array so;
My array is ;
CODE:
And i wish how to find the length of this;
CODE:
I declare 2-dimensional array at class level
Dim delItems(9, 9) As String
The array elements are then each set to "EMPTY". I create a new form in memory
Dim frm As New Form
I create a new DataGridView add columns to it and add it to the new form
Dim d As New DataGridView
frm.Controls.Add(d)
Now the problem.....this code give error when try to load contents of 2-D array into DGV:
For i As Integer = 0 To 9
d.Rows.Add()
For j As Integer = 0 To 9
d.Item(i, j).Value = delItems(i, j).ToString
Next
Next
Error is ArgumentOutOfRangeException (Index was out of range...)
When I check value of loop control variables, i = 0 and j = 1
For my programm I am supposed to store the minimum points in a five-element, one dimensional integer array name points. And I need to store the grades in a five-element, one dimensional string array named grades. These arrays should be parallel arrays. I am supposed to code the display grades button click event procedure so that it declares both arrays. It also should search the points array for the number of points entered by the user, and then display the corresponding grade from the grades array.
Here is my code:
Option Explicit On
Option Strict On
Option Infer Off
Public Class Grades
Private Sub exitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles exitButton.Click
[Code] .....
I want to convert a stringbuilder to a matrix.[code]...
View 3 RepliesI have an application in VBA that gives to my VB.Net dll one bi-dimensional variant. It is a an array, in which every component is a another array containing two positions.
I want to get this two-position array. When I am using VBA I can access directly the data from each position by doing:dataArray(index, 0) or dataArray(index, 1)And when I want to get the two-position array I can use:
Dim posArray as variant
posArray = dataArray(index)
[Code]...
I have a VC++ DLL, which returns the sum of two long double values, passed as one dimensional array?l the right syntax to pass array to this dll from vb.net
currently, my code snippet is as follows: DllClass.vb
Imports System
Imports System.Collections.Generic
[code].....
Here are the facts: Consider the following program. Sub Main()
[Code]....
Compiling the program in Visual Basic Express produces no errors. However, if the program is imported into the Excel Developer environment; I get the following error: Expected: end of statement with the equal sign highlighted. A side comment: About eight years ago, I wrote a Visual Basic simulation program to study financial trends. I found that version of Visual Basic user frendly! I find the 2010 version very difficult for doing simular projects.
i want to make a vb.net program that reads from a text file a movie, with the help of a Open Dialog (called openFD in my program) (we don't know how many movie we've got), the actors, the release date, the country, and the rating.
The text file look like this:
Movie1;Actor,Actor,Actor1;Date1;Country1;Rating1
Movie1;Actor,Actor,Actor1;Date2;Country2;Rating2
...
First question: How can I make a 2-dimensional array? line(0,0) - Movie1, ... , line (1,5) - Rating2. Here Is my try, but it's not good:
Dim line As ArrayList = New ArrayList()
Dim itm As ArrayList = New ArrayList()
Dim i As Integer = 0
[code]....
And here is the code for the Delete Button. It deletes a movie from the listbox, but the details of the deleted movie remains for the next one, I must delete the details for the deleted movie, too.
ListBox1.Items.Remove(ListBox1.SelectedItem.ToString)
i'm extremely confused. my professor gave us this as the FIRST problem to do in this intro to VB class...on page 380 of our text. it is due today and i have been up all night trying to figure out where to even start. i'm so frustrated. could someone please help me and steer me in the right direction? use a one dimensional array to solve the following problem: a company pays its salespeople on a commission basis. the sales people receive $200/week, plus 9% of their gross sales for that week. for example, a salesperson who grosses $5,000 in sales in a week receives $200 plus 9% of $5,000, a total of $650. write an application (using an array of counters) that determines how many of the salespeople earned salaries in each of the following ranges (assuming that each salesperson's salary is truncated to an integer amount): $200-299, $300-399, $400-499, $500-599, $600-699, $700-799, $800-899, $900-999 and over $999.
Allow the user to eanter the sales for each employee in a TextBox. The user clicks the Calculate Button to calculate the person's salary. when the user is done entering this information, clicking the Show Totals Button displays how many of the salespeople earned salaries in each of the above ranges.