I've been assigned a homework assignment where I need to use LINQ to find certain numbers within an array. I've read through the book and some online tutorials, for some reason I just can't seem to understand it. I'm not asking anybody to do my homework for me... Just asking if anybody could explain it better, maybe in more detail?
View 2 RepliesI need to find consecutive numbers in an array and return a string which tells the range and numbers that don't form a range.I found some of the already asked questions but none of them is in VB.Net:Add to array consecutive numbersIf the array of numbers looks like {11,12,67,68,69,70,92,97} then returned string should be of the form 11,12, 67 through 70, 92 and 97.
View 1 RepliesI am having trouble in finding duplicate numbers in an array.the first one is to create an array with duplicates and then display the number that has been duplicated and how many times it has been duplicated.
Here is my uncompleted code:
Dim arry(4) As Double
arry(0) = 4
arry(1) = 44
[code]....
how do i find the Mode of an array of numbers.this is what i have so far, sacount1 is the max index
For j = 1 To SAcount1
If NFAI(j) = NFAI(j - 1) Then
x1 = x1 + 1[code].....
I have stores some numbers as strings and also some non-numbers as strings in an array. How do I find and store the numbers in one array and non numbers in another array?
View 9 RepliesHow can I check an array for duplicate random numbers and replace the duplicates with new random numbers?[code]...
View 7 RepliesI'm creating an application that creates a list of 20 ramdomly selected numbers within an array and displaying those numbers in a listbox. I then need to display the duplicate numbers in an adjacent listbox by clicking the find duplicates button. How would I be able to access those 20 numbers in order to find the duplicates?
View 2 RepliesCan 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'm trying to get my course done for this class. My question is find the even numbers from 6 through 16. The thing is i'm working with events. How should i do this? i did a lot of research and i did find some code that might work but i'm not sure how it works and understand it. I'm by no means advanced with vb.net i'm just trying to finish this course. What i did find was that i have to use MOD? I'm not even really sure how i can use that with an event? Any code would be awesome to getting me on the road to finish this assignment.
I took this code out of a program that had to find even numbers and it works great but the only downfall is that it starts from 1 and then whatever number you want it to stop at. I only need 6 through 16 .
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports System.Diagnostics
[Code]....
How should I use linq to sort my data when my data contain both numbers and letters? For example my current linq
Dim MyQuery = From c In XDoc.Descendants() _
Where c.Attribute(Y) IsNot Nothing And c.Attribute(Str) IsNot Nothing _
Order By Val(c.Attribute(Y).Value), Val(c.Attribute(X).Value) _
Select Str = c.Attribute(Str)
Returns something like the following
13
167
172
231
44
49
Which is not what I would like it to be...
The output should be like the one below:
13
44
49
167
172
231
I am trying to write some Linq to SQL that will bring me back a list of rows containing a single instance of BaseQuestionIDs but I want the row with the highest version, so, from the following table of data:
Id CreatedDate Version BaseQuestionID
2 2009-10-07 13:47:27.687 1 2
3 2009-10-07 13:49:35.010 1 3
4 2009-10-09 16:03:45.973 1 5
[code]...
I want to return:
Id CreatedDate Version BaseQuestionID
2 2009-10-07 13:47:27.687 1 2
3 2009-10-07 13:49:35.010 1 3
[code]...
I have tried a variety of things, but have not nailed it yet. I am working in vb.net?
My program has 2d array to find number of blocks in a certain level and total blocks of a pyramid. I need to also find the number of odd and even blocks.
Do I redim with different logic? O could I use the same population and make the specific button calculate for me. What is the logic?
Here's what I have:
Public
Class
Form1
[Code]....
Sqlserver Table1holds data as follows
date---------------sno
01/01/2010-------1
01/01/2010-------2
01/01/2010-------4
[code]....
How to findout missed sno in 01/01/2010?I want to get this result
3
6
An assignment in my computing class is to find if any numbers from a set of 5 add up to 15, if they do award a point. I cannot figure out how to find if multiple specific numbers can be made from adding up a random set of 5 numbers. Are they any algorithms specific to this? Also it has to be written in visual basic.
View 2 RepliesI have two functions to find the high and low numbers from 5 different textboxes. I want the high in one label (which I have) an the low in another. I cannot seem to get the low number to be anything other than 0. Here is the code:
[Code]...
I have a Dynamic DataTable Created at runtime. The Setup is like so
Id | Name | Age
-----------------
3 | Mike | 21
6 | John | 43
8 | Sara | 34
What I am trying to do is come up with a linq statement I could use to find and update specific rows.
Such as a statement to change AGE to '33' WHERE ID = '3'
My code So far is:
-[VB.NET]-
Dim MyRow As DataRow = From column In MyTable.Rows Where column("Id") = 3
MyRow(0)("Age") = 33
But this is not updating my DataTable entry.
I tried the following code:
Dim T5NHCEDCavg As Double
qry = From employee In empList
Where employee.HCEDC = False And employee.X5 = False _
Select employee.DCFSA
T5NHCEDCavg = qry.Average
But I'm getting a design-time error that says "Overload resolution failed because no accessible 'Average' accepts this number of arguments." I realize that I'm missing an overload here, but I'm not sure what to use or how to do this. I'm pretty new to LINQ. I've got a dataset in memory that I'm querying, and there is a double-precision property DCFSA, of which I'm trying to get the average based on my query above.
gefundeneID = drTerminal.AsEnumerable().Single(Function(s) s("TerminalID") = RandomID)Have an array of DataRow and want to look if the RandomID is in one of the rows.What's wrong with this code?
View 2 RepliesSay for instance, I gave you the numbers
1, 2, 3, 4, 4, 6, 9, 1, 3, 4, 5, 5, 2, 4, 7, 9, 1, 5, 3, 6, 6, 8, 1, 1, 4, 7, 7, 8, 2, 4, 2, 1, 9, 1, 0, 1, 6, 3, 2, 1, 8, 8, 9, 8, 1, 5, 3, 2, 3, 4, 7, 9, 0, 1, 2, 4, 7, 4, 3, 9, 7, 2, 0, 1, 6, 3, 8, 1, 2, 4
What number appears more than any other number?This is very important to me, ...I need to find the MODE, of those group of numbers, ...the way that I did it before, I would make 10 TextBoxes, and have another text box to enter the number, and when the number gets entered it would increment the value of which ever textbox the number was in the main textbox, so if I entered a 1 into the main textbox, then the zero in textbox (1), would be incremented to 1, and if another 1 was enered and the button was clicked, the 1 in the Textbox for 1, would be incremented to 2, because 1 has a popularity of 2 now and has apeared 2 times..
Here's some code, to show what I've come up with by myself.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
ONE.Text = ONE.Text + 1
End If
[code]....
I am new to VB and need to make a program that does the following:Write a VB.Net program that allows users to enter a series of numbers(separated by a comma) in a text box called series. When the users clicks the command button called Average, the program extracts the number one by one from the series and calculates the average, and outputs the average onto a textbox called Result.I understand how to get it to do the average, but how can I make the program count the numbers that I input and then divided by the sum? Also, how would i get it started.
View 2 Repliesway to write the LINQ query. The parent class is simply a student's name and a list of test score data. The child class is a single test score datum. I want to find the worst (or best) score out of all of the TestScore values and then identify the student who had the best score.
Dim query = From s In studentList _
Where s.ScoreList.Select(Function(d) d.TestScore).Min _
= studentList.SelectMany(Function(g) g.ScoreList).Select(Function(h)
[Code].....
I have a generic list - SupportedTypeGroups. Each SupportedTypeGroup has SupportedTypes property (generic list of SupportedType). How to construct a Linq query to locate SupportedType with required name?
View 3 RepliesI need to mdify the code below to capture all files in all directories and write them to a grid
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
get files from current directory
Dim Files = From file In My.Computer.FileSystem.GetFiles(CurDir)
[Code]...
I have a table with the below structure.
ID VALUE
1 3.2
2 NULL
4 NULL
5 NULL
7 NULL
10 1.8
11 NULL
12 3.2
15 4.7
17 NULL
22 NULL
24 NULL
25 NULL
27 NULL
28 7
I would like to get the max count of consecutive null values in the table.
I am learning Linq, so bear with me. I have a class object that holds 4 other class objects with each holding a List(Of T) of the next. Think tiered classes. As these lists as built I need to search all the Group2 for all Group3 to see which Group3.units.count is the largest. "units" being a List(Of T). [code]
View 4 RepliesFor a class project I am supposed to search through the attached file, and write to a new file the years between 1789 and 2009 that are not present in the fifth field. What is my best bet for determining what years are not present?
[Code]...
Should I make an array of integer between 1789 and 2009, then search for every year in the file, then set a flag to false if not found; is there a simpler way to accomplish this using LINQ?
[code]How i can make The Program to find Numbers On Form and Do That without making So Many "Same" Codes?Its Pretty Annoying To Make Big Program nad only Copying and Pasting Text.
View 3 RepliesI have a group of 3 numbers:
-SideA
-SideB
-SideC
I need a way to detect which one is the largest, and which is the smallest, and assign them to a variable.If SideA is the largest, then it is variable C, and SideB is the smallest, so its variable A, leaving SideC as variable B
I have a specialized string dictionary of (string, string) (_RulesAndTheirDescriptions) that contains the name (key) and description (value) of methods in a given class. I currently do the following query to search for a match on the key or value and then bind that to a grid.
[Code]...
This question is very similar to a previous question of mine, Use LINQ to count the number of combinations existing in two lists, except with some further twists.
I have a list of CartItems that can receive a discount based on the items specified in the list of DiscountItems. I need to be able to pull out the items in the Cart that can receive a discount and apply the appropriate discount specfied in the DiscountItem. The discount is only applied for each combination that exists. Here's what the two lists might look like to before the discount is applied[code]...