How can I query a DataTable to find all of the unique values in a column? SQL has the 'unique' or 'distinct' keywords, but I dont know how to do this against a DataTable.
View 6 RepliesI'm trying to make a method that can get unique values from a specified column of a DataTable. The problem is that the column may be string, integer, etc. I'm not sure what type of variable the (Of T) is.
Private Sub GetColumnUnique(ByVal dbTable As DataTable, ByVal ColumnNumber As Integer, ByVal ColumnType As ???)
Dim results As List(ColumnType) = (From item In dbTable.AsEnumerable Select item.Field(ColumnType)(ColumnNumber)).Distinct.ToList
End Sub
Is there a way to get a subset of Unique values in column(1) of a DataView?
View 6 RepliesIs there any way to set a column to accept only unique values?(Via Table Definition)
View 2 RepliesI'm using an Infragistics UltraWinGrid with a column of drop-down boxes. I don't want the user to be able to select the same value for multiple rows in that column. Is there a simple (or heck, I'd settle for advanced) way to do this? I'm using VB.NET
-EDIT-
I tried setting a filter on the data source for the drop-down box. But when I did that, the values in the other boxes in that column started disappearing (not the values themselves, but the descriptions that they were supposed to represent, so instead of reading "Information", it just said "1"). All of the cells in a column refer to the same combo box, so if you filter out a value from the data source for one of them, you filter it out for all of them. I'm currently trying to catch a CellChange event and check against all other currently-used values. If it was already used, I would put up a message saying as much and revert back to the old value. However, the value comes back as the previously-saved one, so... not helpful. About to see if I can use the "text" property.
I am having so trouble with the ToUpper() procedure with strings. I am using LINQ to find unique values in a list of objects. In that whole process I set the values to compare to all lowercase in order to get a proper list. My goal is to populate a dropdown list with the values. I'm attempting to set the first letter of of the string to uppercase and keep the rest lowercase however the toUpper() procedure is not working?
Private Function FixCase(ByVal strIn) As String
Dim strOutput As String
Dim intStringLength As Integer = strIn.Length - 1
strOutput = strIn.Substring(0, 1)
[code].....
I've got two data tables with store numbers. I need to find out what store numbers are in one data table that arent in another.say one table A might look like:
34, 35, 39
the other table B may be
34, 35, 39, 45
I need to find the 45 If I use nested For Next I can get matches but anything not a match would show up not just the 45 value as the next progresses.
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 want to loop through a databale and change the values of a specific column in that datatable.eg: the database returns Request_ID, Desc, Date and Status_Ind. The Status_Ind column contains integer values. I dont want to show the integer values to the user. I want to convert that to a string value based on the integer values returned in that columns.
View 2 RepliesI'm using the datagridview. This is the sample data:
[Code]....
How do I parse through the grid to rename the duplicate values in a particular column (in this example it's the l_name field) into such a format?
[Code]....
I have a datatable contain fId field. I want to update all values for this field to "1" without using loop. [Code]
View 1 RepliesI 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 am trying to populat a treeview with nodes that are the values of a column in a datatable. I have managed to get the correct number of nodes but the text is not displayed next to the nodes, there is just a 3 shape but the other way round and with square corners shown.
The code is below. I would like to have these parent nodes populated on the form load and then (i think this is what i have read) to be quicker i would like to then load the childnodes once a parent node has been selected, as i don't want to load the whole database on form load or when the form is refreshed.
Here is the code with more dtails below:
[Code]...
Unique constraint - these columns currently doesn't have unique values..?? I have created Unique Constraint with 3 columns. My code works perfectly but once - two users @ same time entered same data and somehow it saved in DB; after that incident. This UniqueConstraint gives me error - These columns currently doesn't have unique values. How can I check if user enters this kind of entry or how can I restrict the Entry?
View 2 RepliesHpw can I pass multiple values from same column in a query? I am using vb.net and sql server database.
With my query an exception is generated saying that @booking_date has already been declared try a different variable....
My query is:
Dim da As New SqlDataAdapter("select * from Bookings where booking_date Between (@booking_date AND @booking_date) AND booking_time Between (@booking_time AND @bookinbg_time) AND game = " & x, con)
I need to find rows in resultsets that have every column without null.these resultsets got variable number of columns.currently, the only way that I can think of is creating a view on each resultset and filter this way:
select field1, field2, field3, field4, ...
from "huge query"
where field1 is not null and
field2 is not null and
[code]....
and then in a storeproc/function or .net code(c# / vb.net) loop through all rows / columns and flag or remove every row that got any null?
If want to do a DataView.Find on a DataTable that is already 'ORDERED' by the Column I am seaching, so a DataView.SORT should not be necessary, but it throws an Exception if I don't give a .sort command before the .find command. Is there any way to avoid this apparant duplication ? and speed up the search time. Its a very large table - 1 million rows. I am using VB 2010
View 6 RepliesI have a datatable which has 5 column. It is possible to copy only its 2 column in and save it into new datatable.I used this code but it copies all the 5 column
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj).CopyToDataTable
i used this one but it is not supported
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj.item("Column1"), obj.item("Column2")).CopyToDataTable
I have a DataTable with multiple columns including AccountNumber, Year, and Month. I am exporting the information in this table to an Excel workbook. Since this table has the potential to be extremely large, I must check the number of records in the table (since Excel can only have 65536 rows or something like that. If the original table is small enough, I need to put all of the records in a single worksheet. If there are too many records for one worksheet, I need to separate the records into multiple worksheets based on AccountNumber. Additionally, if there are too many records for a specific AccountNumber then I need to split that AccountNumber into multiple worksheets based on Year.ng:
Worksheet Name ---- Number of Records
1111 ---- 150,000
2222 ---- 50,000
[code].....
I have a datatable and I want to create a text file using this datatable. I want that each row of the newly created text file is unique. If there is a duplicate row, then it should add * to both rows ( duplicate rows)
I am using following code:
Dim str As String
For Each row As DataRow In dataTable.Rows
str += row(1) ' This is text data
[Code]...
I have a DataTable which I want to check if values in three of the columns are unique. If not, the last column should be filled with the line number of the first appearance of the value-combination.
[Code]...
I solved this by iterating the DataTable with two nested for loops and comparing the values. While this works fine for a small amount of data, it gets pretty slow when the DataTable contains a lot of rows.My question is: What is the best/fastest solution for this problem, regarding that the amount of data can vary between let's say 100 and 20000 rows? Is there a way to do this using LINQ? (I'm not too familiar with it, but I want to learn!)
I am working in vb2008.TableAdapterManagers are a new feature in vs 2008 and I would like to understand how to use them properly.I have about 30 tables in my database that are unique to themselves and donot link to other tables.I have created a dataset.xsd in my solution and dragged in my database tables of interest.A unique datatableadapter has been identified in the dataset1.xsd for each datatable.Rather than using the identified datatableadapter for each datatable operation, should I be using the dataadaptermanager for each unique table?
View 1 Repliesload the contents of a query from a dataTable Adapter into a datatable?
View 2 Repliesam trying to calculate the values in rows in column 6 based on values of column 5. Bellow is the the code I am using I get a run time error about the string not formatted properly
[Code]...
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders
FROM Report_qry
WHERE (Customer= 'JohnDoe')
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
For each loop through a DataSet, I need to store the values of 2 columns (we'll call them ColumnA and ColumnB) so that I can use them to search the same DataSet again later.The DataSet stores the results of a search and places the value of ColumnA into a ListBox as a new item.When the user clicks on this ListBox item, the application will loop through the DataSet again using the value of ColumnA and the value of ColumnB as criteria to identify the correct row in the DataSet to return.This would be a lot simpler if the value for ColumnA was unique every time, but a value will inevitably be repeated on occasion. That's where ColumnB comes in. This column's value is likely to be unique 90% of the time, and, given the nature of the information in the DataSet, if either column duplicates, the other won't.So I've thought of adding the values for ColumnA and ColumnB into a 2 dimensional dynamic array, but I'm doing something wrong apparently.[code]
View 3 Repliescurrently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already.
The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column is added already in the table, it generates an error since it has to be unique.
That is why i wonder if it is possible to know if a column already exists without viewing the form which contains the grid view of that table?
Is there a quick way to put unique value to column in a table? Assuming I want numeric values starting from 0.
View 4 RepliesI have a matrix which is in a text file.
ABMS101848 T G
ABMS101848 C H
ABMS101848 A S
SDFR236176 D Q
SDFR236176 2 X
[Code]...