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 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 am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
[Code]...
So i have 4 items in a listbox how do i count then up together to show in a label [code]...
View 4 RepliesIm trying to count how many items are in a list(of)
I looked it up on google but still cant figure it out.
I need to count the items that meet a criteria in a list(of structure) in .net 2.0. eg
Dim listcars as new list(or car)
Structure car
Dim Name as string
Dim year as integer
End structure
Now i need to count all cars with name toyota etc, how do i do it.
[URL]
I need to Count row with Distinct from Datagridview.
View 2 RepliesI have to perform the following SQL query: select answer_nbr, count(distinct user_nbr)
from tpoll_answer where poll_nbr = 16 group by answer_nbr The LINQ to SQL query
[Code]...
I have a DataTable that has several hundred rows.I want to get a row count of distinct values in a particular column.For example, I have a DataTable of Product Orders, but I want to get the number of unique Customers.
I was using this code, but I can't rely on it because my binding source is filtered from time to time.If my binding source has filtered out all rows datatable.DefaultView returns 0 rows.
I have a Table:
[Code]...
I'm trying by LINQ-query (VB.NET) to return a count for distinct value of Objects, Stuffs and Colours for every Room:
[Code]...
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]......
I have set up a class to hold song information - artist, title. I then created another class that containg a BindingList(of clsSong). I use this binding list to create a data object that can be used to create an RDLC report. This all works. Now I am trying to remove duplicates from the binding list so they don't show up twice on the report. I can't figure out how to get a distinct list for my report. [code]...
View 3 RepliesOk I have been working on a little project and it involves a list box.I want to be able to get all the text from the list box and set it as a String or somehow put it all in a text box (which will be set invisible).I tried using a text box before I started using the list box but it just wont work and all the buttond on my form stop working all together.
View 9 RepliesI got a combobox that I populate with items by using databinding options which works fine, but what if I only want to only select the distinct items, was trying to do that but no avail so far. if I could do that just by using an sqladapter in code but is that what I should really do ?
View 2 RepliesNET 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 small program that talks to a server, grabs the content from a website using a php webscraping program and then places the results in a listbox as a string. My problem is taking this string and creating a list from it. Each item in the string is followed by a | (pipe). I have included the code that I've tried below:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str As String
Dim start As Integer = 1
[code]....
I want my program to check the pagerank of all string list items, and than add it do a listbox. Now this is my code to open a list and add it to a string list ( itemlist as list(of string)
Dim stream_reader As New IO.StreamReader(OpenFileDialog1.FileName)
Dim line As String
line = stream_reader.ReadLine()
Do While Not (line Is Nothing)
line = line.Trim()
[Code] .....
I'm using the DLL from this website: [URL]. The problem is that it only checks the first website and the other websites will be 0/10 automatically while they might be 3/10 or something else.
i have a listview box full of items, image below:
when i click a button i would like a msgbox to pop up displaying how many are alive.
How would i do this ?
Also how would i remove all items that status is "Dead"
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?
I 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?
I'm having a problem recently, a logical issue so hard to determine various examples.I need the text that is inserted in textbox, which has been altered or modified or twisted to have a proper format through line accordance and constant white spaces etc. And some cases I stuck at defining the If statement within the loop. Here's an example of a text I'm trying to reformat.[code]I'm using Microsoft Visual Studio 2010 Ultimate version with Microsoft SQL Server Management Studio. This code is being fired on mouse click event of a button control. This is a snippet of my code there are more filtering after but here is what should be changed.
View 11 RepliesThis is what I have, but It doesn't work with strings for some reason (only text files):
[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 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].....
I need your help in creating a Regex for this. I want that the regex found are placed in an Array.
UPDATE tableName SET fieldA= @param1, fieldB =@param2,
fieldC = @param3 , fieldD=@param4
WHERE fieldE=@param5 and fieldF=@param2 and
fieldG = @param6
by using this Regex:
[Code]...
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
I have a list(Of transaction) :
[Code]....
How can I transform it to a list(Of transactionShortened) :
[Code]....
How do you let all the numbers of listbox2 count to each other to get a total?
View 4 Replies