Can this be rewritten any better using LINQ? I'm a C#er trying to think in VB.NET for this current project. It's in an ASP.NET Web Forms .vb codebehind:
Public ReadOnly Property AllowedCategoryIds As Integer()
Get
Dim ids = New List(Of Integer)
[Code]....
i have a requirement like i need to filter out the distinct values from an array to another array.
Dim str As String
For Each str In all
If (Not all2.contains(str)) Then
all2.Add(str)
End If
Next
i tried the above logic to get the distinct list but it is telling contains and Add are not the members of system.array?
I have been tasked by my boss to create an application that takes information from an excel database holding sales figures, margins, budgets etc calculates all the figures and exports the totalled values to a table and graph also in excel. Although this is fairly easy, there is some complications I am dealing with. In the database there are many territories, and each employee has 1 or more territories.I'm not sure what I have done wrong, however the totals are not adding up properly. My code is:
'Defines Excel Objects
Dim objExcel As New Excel.Application
Dim objWorkbook As Excel.Workbook
Dim objSheet As Excel.Worksheet
[code].....
I am trying to distinct on multiple columns and get datarows from datatable. but getting error.
Dim query As IEnumerable(Of DataRow) =
(From row As DataRow In SourceTable.AsEnumerable() _
Select row.Field(Of String)("ColumnName1"),
[Code]....
I want another datatable with distinct row based on given columns from SourceTable.
I have a database which need to be assigned into array arr()(), e.g.
arr(0)(0) = aa arr(1)(0) = ab arr(2)(0) = aa
arr(0)(1) = bb arr(1)(1) = ba arr(2)(1) = ba
arr(0)(2) = cc arr(1)(2) = cc arr(2)(2) = cc
I need to find distinct / unique value in each arr(k)(0), arr(k)(1), arr(k)(2); where k=0..2. Then i need to insert the result into array cat as follows:
cat(0)(0) = {aa} cat(0)(1) = {ab}
cat(1)(0) = {bb} cat(1)(1) = {ba}
cat(2)(0) = {cc}
I've tried code below but it doesn't work. The assigning process into array arr()() from DB is OK. Problem only come up if I try to find the distinct value (If Not (cat(j).Contains(ds.Tables(0).Rows(i).Item(j))) ... End If).
For i = 0 To 2
list(i) = New Integer(3) {}
For j = 0 To 2
[Code].....
I have an array with wild character at the end. I use the value in this array in Select statement. Some times the array has same values. I want only distinct values in the array before the select statment.
Code:
for i=0 to count
select * from tbl where item like ' " & itemname(i) & "'
next
I need distinct element in itemname array.
I 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'm trying to combine two arrays. Simply append 1 array to another. I have two string arrays. Lets just say array1 and array2.would the following be correct?
array1.Copy(array1, array2, UBound(array1)) I guess I'm slightly confused about the parameters. When I try to use the above code I get green squigglies with the following error.Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.
I would like to update string arrays in batchlets say I have 3 string arraysI want to for example redim them and then up load them with data.I have tried for each on array of arrayI have tried list.at the end none of them are updated.
Dim Str1(10) As String
Dim Str2(10) As String
Dim Str3(10) As String
[code].....
Supposed that I have two arrays:
Dim RoomName() As String = {(RoomA), (RoomB), (RoomC), (RoomD), (RoomE)}
Dim RoomType() As Integer = {1, 2, 2, 2, 1}
I want to get a value from the "RoomName" array based on a criteria of "RoomType" array. For example, I want to get a "RoomName" with "RoomType = 2", so the algorithm should randomize the index of the array that the "RoomType" is "2", and get a single value range from index "1-3" only.
This is a school project, supposed to be a beggining VB.Net class. I'm having difficulty with one section, sorting the array is OK but I need to only return a 3 of it. I had it working when I was selecting single files but when I went to selecting multiple files at once the formula stopped working for me. I'm retuning the array just fine but the select a 3rd seems to just pass by without being acted upon. I've been working on this a long time and don't know where to look for an answer. Here is what I have for the sort method;
Private Sub sort()
Dim Count As Integer
Dim count2 As Integer
[code].....
Is there any way to have an array that holds other arrays in VB? So you could call it like Array1(Array2(0))
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 an array for all 26 chars of the alphabet as a boolean. What I want to end up doing is have the program take the user's guess char and set the corresponding number in the array to true. I'm new to arrays and I have no clue how to begin doing this. this is how I am declaring my array. I am declaring the array as a char for now because I don't know how to go about using a boolean array for my game, but it seems like it would be the best way to do it. [Code]
View 2 Replieshow to combine two 1-D arrays of the same length into one 2-D array ?
View 7 RepliesI have two arrays
a={a,b,c,d}
b={1,2,3,4}
now I want to create a 3rd array which should at least contains one numeric number and rest of alphabets, this code will generate unique usernames so it should not repeat the pattern of selection which is present in main array[code]...
How do i divide an array into small 5 arrays.it is a byte array
View 2 RepliesA project requires to allocate a varying number of byte arrays (buffers).
It would be ideal if the following definition would be possible:
Dim ArrayOfBuffers() as buffer(10000) as Byte
The byte arrays must be ordered sequentially because they have to be written to a file by efficient procedures destinationFile.Write(ArrayOfBuffer(3),1000,1000)
The number of buffers will change during program execution sometimes. Therefore it would be nice to be able to do a ReDim on the data structure when needed.
This does not compile. Dim Tom As New List(Of String) = {"Tom", "Tom2"} This does Dim Tom As String() = {"Tom", "Tom2"} IMO this features should be allowed for all collection types and not only arrays.
View 2 RepliesI originally developed a simple application software [VB.Net + MS Access] (Lets call this project A) but now I want to include more functionality in it. I have an encryption/ decryption software utility (Lets call this project B ) and a Text to speech generation utility(Lets call this project C) . That is, I want to add Projects B and C to project A. [Such that clicking on the main form of project A calls a form from project B or C as desired].In solution explorer, I right clicked--Add Existing Project--and added both the above mentioned projects 1 by 1. (Added B and C to the solution explorer with the already present A).As the application software's (Project A's) main form is the main form of my project, I want to have a menu option on the main form (Of Project A) so that a user could click on one of the menu options and the main form of my other projects ( Project B or Project C or Encrypt/Decrypt or Voice Generation) should open by him doing so. To this effect, I tried the following:
1. I dragged the form simply from one of the projects (From B or C ) into the folder of my Application Software (Project A).This generated a lot of Build errors and the Voice Generation utility (Prj. C) would not work like this.
2. Tried to reference a dll, however the authors of Projects B and C did not include a dll in their projects.
3. Now I came to know that to call a form residing in another project folder or even another folder within the same project, you have to give a path for the form. HOW DO WE DO THIS?
As you can understand, I cannot copy the entire code of the 3 projects here....I will try attaching my project here though..Here it is: http: rapidshare.co...MY_Prj.zip.html[Dear Administrator: The downloading option on the webpage does not allow files bigger than I mb, thts why I used an external link]As I said, in the application, Project A is TMS.NET ; Project B is EncryptFile and Project is C.I encountered a problem while adding project C [spoken word], so the project contains only projects B and A. I will try to attach project C seperately.That is, TMS contains proj A+B and Speech contains C.
I want to combine two projects into one i.e. image and audio steganography with a single .sln file. How do I connect them? I'm using Visual Studio 2008.
View 2 RepliesI am trying to port a program I wrote with old VB 1 and I have many control arrays in the program, and it was so easy to do this in older versions of VB, now I am trying to find how to do this and all the answers I have found are a major productions, to replace something that was so easy to do? I would think that microsoft would make programming easer with each new incarnation. instead they are making it harder. doing away with the DATA and READ statement, now it is much harder to fill an array with a loop, now you have to enter each item in an array ONE by ONE. they did away with the ON statement, I had several ON statements, I had to make complex Select case constructs. to replace a simple one word statement?
To make an array of controls in OldVB all you had to do is Name a Second control the Same as the First, and a dialog pops up and ask if you want to make an array, you click Yes, and that's it, what could be easier than this?
Is there any way to create a multidinensional array that contains arrays of different lengths (similar to nesting arrays of different lengths in python).
Because if I were to declare a variable Dim accounts(2,2) As Integer all 1D arrays at each dimension have the same length. Is there any way to create an array so that this is not the case?
e.g The above code would create an array like this:
[[0,0],[0,0]]
but would it be possible to create this:
[[0,0],[0,0,0]]
How to get values for array elements in VB.nET from the user.also i wanted to display these values in the combo box.[this is easy i could manage this].
View 2 RepliesI have several parameters consisting of separate System.Byte() arrays. What I need is the syntax for a function declaration where the parameter is an array of arrays - I do not want to delve into System.Collections, and it's my preference not to CType each array into an Object and then back into a Byte().
Problem I'm having here is that:
Public Function MyFunc(arrayparam() As System.Byte) As System.Byte()
accepts a single-dimensional Array of individual Bytes.
Then Public Function MyFunc(arrayparam() As System.Byte()) As System.Byte()
if its possible to split an array into multiple smaller arrays?
View 7 RepliesI want to split an array into two smaller arrays at a given index?
View 5 RepliesI have 2 groups, the information i get comes out as follows.
Dim group1 As String = "3 4 7 8 10"
Dim group2 As String = "0 1 2 5 9"
The placements are predetermined, so when the first perso
[code].....
I have a VB.net console app and I am opening a function in a dll written in fortran. I am passing 3 arrays through the function by reference. When they come back out the otherside they ahve all tunred to arrays of only one element And that element is 0.I read on the internet somewhere that when doing this kind of thing it is a good idea to only pass the first element of the array into the function.I tried changing my function declaration to accepting single elements rather than single dimensional arrays, and now the arrays are the same length before and after the function call, but they don't seem to be changing at all, so i'm not sure that this is working
View 1 RepliesI would like to add items to a new line of a message box from an array. I gave it a try and should have known it wouldn't work
Dim messageString As String
If (count = 0) = False Then
i = -1
[Code].....
