since this
(vb.net)
Dim test As New List(Of Integer())
test.Add(New Integer() {1, 2, 3})
test.Add(New Integer() {1, 3, 3})
test.Add(New Integer() {3, 2, 3})
[code]....
does not work, how would you do the distinct?
How can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
).Distinct()
_columnList = New List(Of CheckBoxListItem)(tmpQryColumn)
How can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
[code]......
NET 3.0. Is there a Distinct on List(Of T)? What packages would I need to import? If not, is there an equivalence?
View 4 RepliesI have a List(Of Hardware) - the List is called HWModels
Class Hardware has the following Properties:
ModelName
Status
CPUStatus
MemoryStatus
DiskStatus
The List is populated by reading a CSV file, once it's populated, I want to return the distinct records based on the ModelName
I've attempted by doing it as follows:
(From a In HWModels Select a.ModelName).Distinct
But this isn't right because I end up with a list of only the ModelName's and nothing else.
How do I get the Distinct function to return all of the other class members within the list?
On to my question.I have a List(of String) that contains multiple items in each index.
A list declared as:
Dim NewStrings As New List(Of String)
May contain the following:
item (0) - (1 MKNO ABC 2.45 STND 3.3)
item (1) - (1 MKGO ABC 1.34 STND 2.5)
item (2) - (1 MKNO ABC 2.45 STND 3.3)
item (3) - (1 MKNO ABC 2.45 STND 3.3)
[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 load a list from a database like the example below. The class has more properties that the database table holds so when I load the list from the DB, there are Null values for certain properties of each item in the list. When I try List = List.Distinct.ToList, it never works (when null values are present).
[Code]...
I want to display distinct items from a column in a checked list box then make a selection or selections and perform commands based on info from a second column in that database the database is a small Access 2010 database in the application directory right now I added the data source and items dont display even though I selected that source in the checked list box properties
Dataset = MyDataSet1
CheckedListBox = MyListBox1
I tried it with a combo box and it shows items but includes duplicates, did I setup the datasource wrong?
I need to get a list of distinct names inside the data table and the sum of values for each one. I know some basic stuff about linq, but i don't know how to put the distinct and the sums together.
The SQL Query:
SQL
SELECT DISTINCT username,
[Sum1] = SUM(day1),
[Sum2] = SUM(day2)
[Code].....
If I can generate a list of random integer with a click of the button and put the results in a list box using VB.Net but how do I randomly change several integer number generated by button 1 by clicking button 2? How I retain the results of button1 and change the results when clicking button2?I try before but the two button function code cannot relate to one another.
View 1 RepliesHow can i get the integer value alone from the combobox list. For examle, if the item in the combobox is "ABC 01", i want to get the value "01" alone into my code for processing. How can i do it?
View 3 RepliesI need to fill a List with data from a DataColumn fetched in dataset. How can I achieve that in 1 step without looping through the entire table in dataset.I want something like this:
Dim lst as List (of Integer) = ds.Tables("Customer_Data").Columns(0)
However the above line is wrong as System.Data.DataColumn cannot be converted to System.Collections.Generic.List(Of Integer)
Is there a way to get an integer value from a DataRowView? I have a list box with datasource set to a binding source. I would like to be able to do this:
dim num as integer
num = lstBox.SelectedValue
But I receive an InvalidCastException:
Conversion from type 'DataRowView' to type 'Integer' is not valid.
This is how I fill my list box:
myDataAdapter("SELECT CustID FROM Customers", cn)
myDataAdapter.Fill(myDataSet, "Customers")
myBindingSource.DataSource = myDataSet
[Code]....
I have one list box this works for and one it doesn't, so far. The only difference that I notice is: the one that works, the Query in the data apapter retrieves and auto number from my access table, the one that does not work, the Query in the data adapter retrieves a number.
Or, is there another way I should go about this?
The application that I am trying to make is a form with a list box for CustID, OrderID, ItemID, and others. The CustID is from table Customers, OrderID is from table Orders, and ItemID is from table Items.
1. How can I populate a List(of Integer) from datarow
2. How can I take only certain columns from datatable.select() and copy the data to datarow? So it's like this: datatable dt has columns ID,Name,age,address and DOB I want to take only the columns name, address and age where age>40 and put the result set into a datarow dr.
i want to build a datatable where each cell has a list(of integer)
is there a way to force the table to add automatically a new empty list(of integer) in each cell every time a new row is created without adding this cell by cell ?
What would be the easiest way for me to create a list of words with a sequential number appended to the string. I need the string and amount of numbers to be a variable. For example:
network1
network2
network3
network4
[Code].....
I have a function that returns a Datatable. I am passing a list of Integer as an argument. Then I thought tis would work.
Public Function GetEventsByEventType(ByVal EventType As List(Of Integer), ByVal DayInterval As Integer) As DataTable
Using con As New MySqlConnection(strCon)
[Code]...
as you can see. I use string.join to convert the list of integer to something like this. '1,2,3'. Problem is that is read as a string so i get the incorrect results. I need to have where EventType IN(1,2,3).
I am having problems removing an item from a List(Of Integer). I see you can remove it by doing a remove with the index, but I assume you can do some type of function where you provide the value that you want to remove and it removes it. I found it on the List(Of String), but not Integer.
View 1 RepliesIs there an easy way to search through a List(Of Integer) and find duplicates? Or do I need to do loops to search through it with each number, comparing it to each one?
View 3 Repliesi have data in an array list called txtarray which contains numbers, how can i loop through the array list and convert the values from into a integer variable?
View 7 RepliesWhat is the simplest/best practices way to get a comma separated list of the integers in the Integer array levels?
Dim levels(5) As Integer
Dim levelsStr As String
'put values in levels'
[code].....
I keep track of a score system for all users in a sorted list;
dim Scores as new sortedlist(of string, integer)
I can easely increse points for a cirtain person by;
scores("peter").value += 1
Now I need to display a top x list of the users, if users have the same score, it should sort alphabetically on the name. Of course it's also possible that users have the same score.I've already tried to make a new sorted list with as key the score, and added to that score the username. Later when displaying the scores, I've replaced the username with nothing. The only problem in this solution is that the numbers are sorted on asci value which has this order:
0
1
10
2
3
4
Also, if you make a sorted list like this:
dim Scores as new sortedlist(of integer, string)
You can't have two people with the same score... So, there must be something possible with the iComparer to sort on integers right?
I am trying to assign integer values to the items in 2 different list boxes called lstWorkshop and lstLocation. I then want the equation, intCost = intDays * intLodgingFee + intRegistrationFee, to be executed and the result to be displayed in a third listbox named lstCost. This is what I have so far, but whenever I run the program the value that always gets displayed is 0, which is obviously not correct.
Public Class frmWorkshopSelector
Dim intCost As Integer
Dim strTotalCost As String
[code]....
ive got some simple problem i cant understand how to solve.
str(1) is an array and integer(or double, tried both)
a(1) is an array and integer (or double, tried both)
a(1) = a(1) + 1
Label1.Text = str(1) + a
the big part is where i get: operator '+' is not defined for types 'integer' and '1-dimensional array of integer'.why do i get that message and what does it mean? how do i make the code do what i want?
I faced an error when upgrading VB6 code to VB.NET. The error occurs at AddressOf WindowProc
AddressOf expression cannot be converted to 'Integer' because 'Integer' is not a delegate type
My declaration for SetWindowLong is:
Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA"(
ByVal hWnd As Integer,
ByVal nIndex As Integer,[code]....
What is the reason for the error I get?
I'm trying to create a linked list of an array of integers. Why is the following implicit conversion required?
When I run the code that contains that conversion, I get the following error.
As a real-time data acquisition user control data (a packet of an array of bytes) arrives every second, is converted into an integer array and inserted into a linked list.
The most recently arrived data is painted as coordinates on a grid at the right of a PictureBox using Graphics.DrawLine (pen,X1,Y1,X2,Y2).
The oldest data (arriving 120 seconds ago) will be drawn at the leftmost portion of the Picturebox.
Why a linked list rather than a list? To display 120 views of time sequence data, the draw routine the most recently inserted node to a node that points to Nothing. How do I limit the length of the linked list to 120 nodes and always ensure that the last node points to Nothing?
Do While Not item Is Nothing
item = item.NextItem
Loop
I am a newbie in VB and I got a piece of code which can display the current running program. I need to use that in VB2005 and I got the below error message. Can anyone help how to fix it?[code]
View 18 RepliesI'm trying to convert a VB6 project to .NET, but I get problems with some callback functions, and the following message comes up: "AddressOf' expression cannot be converted to 'integer' because integer is not a delegate type" I've seen several solutions to similar problems like this, but I am not able to understand this issue with delegates.
After the conversion, the code look like this:
Declare Function vsmsgwSetDataPackageCB Lib "vsmsgwW.dll" (ByVal PACKAGE As Integer, ByRef arg As Integer) As Integer
Dim arginitP As Integer
[Code]...
Which gives the error: Method 'Public Function PackageCB(HisNodeID As Integer, ByRef data() As Byte, ByVal length As Integer, ByRef arg As Integer) As Integer' does not have the same signature as delegate 'Delegate Function DelegatePackageCallback(hwnd As Integer, lparam As Integer) As Integer
I have a LINQ2Entity problem, I want to get the value, string, from a database, so I select FProducts.Serial_number, and to end the query, I do .ToDictionary. The problem is, it tells me that it doesn't have sufficient parameters, to convert ToDictionary. So I need something like select FProducts.Serial_number, Nothing). ToDictionary. Also FProducts.Serial_number, 0).ToDictionary doesn't work.
Sub GetStatistics(ByVal ProductNumbers As List(Of String), ByRef Passed As Integer, ByRef FailedProducts As List(Of String))
Passed = 0
FailedProducts = Nothing
[Code]...
