Get The SUM Of The TicketBillableTime And TicketProfit For Each DISTINCT TherapistID?

Dec 29, 2008

I have a table called Tickets where it has 3 columns in particular that I'm working with... TherapistID, TicketBillableTime, TicketProfit and I'm left joining the TherapistID with the Therapists table to get the associated TherapistName.What I need to do is get the SUM of the TicketBillableTime and TicketProfit for each DISTINCT TherapistID or TherapistName as it goes..

[Code]...

View 3 Replies


ADVERTISEMENT

C# - Get Distinct Rows From Datatable Using Linq (distinct With Mulitiple Columns)

Jul 13, 2010

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.

View 3 Replies

Distinct Filter In .NET?

Apr 15, 2009

I'm having some trouble extracting a distinct value out of a dataset.. I have a database table with 5 fields,

ProjectName, VendorName, ExpenseType; TxnDate; Amount

In VB6 I would have several different recordsets opened one after another to

A. Find all the unique project names within the table (and put them into a For/Next loop)

B. For each unique project name open a recordset to look up unique vendor names applicable to it (add For/Next)

C. For each unique projname, unique vend combination find unique exptype....for next loop....

D. For each unique projname, vendor name, exptype, date combination, sum up the dollar amounts...

The end effect is that you have a net dollar amount for each unique combination of project/vendor/expensetype/date.I dont like doing it like this because I have to keep hitting the database, I wanted to know if there was something I could do within the actual dataset which will be filled when I open the application with the values of the entire table..I got to ds.tables("Text").select.distinct( ....not sure how to proceed and everthing I've read online leads me into a complicated direction of creating new datatables...

View 1 Replies

List<Of T> Distinct In .NET 3.0?

Feb 9, 2011

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 Replies

C# - How To Do A Distinct On List(Of Integer())

Jun 6, 2012

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?

View 2 Replies

Distinct Data From Gridview?

Dec 22, 2011

I load a 47,000 line Text file into a Datagridview, not a problem at all.

I would like to get the Distinct values for Column1. I have been scratching my head on how to do this, I have not as of yet found an easy way to do this,

View 6 Replies

Distinct Query For Datatable

Oct 22, 2011

If I would connect to database I would run a query like this: "Select distinct Column1, column2 from tablename where somefield=somevalue order by column2". How can I run this query to a datatable? I know .select but that's not enough like dataset.datatable("name").select(filter,short). Still need distinct.

View 2 Replies

Distinct When Using Union On LINQ?

Nov 18, 2010

When the user has typed in some information I would like to output possible matches in a descending order, so if someone types in a full first name and a full surname, it should be listed above a result where just the surname matches.I've done something similar in SQL before which worked perfectly, but this time I'd like to do it in LINQ.

Firstname, Surname, City, Country as string variables.
Dim DataEnum As IEnumerable(Of frmTelephone.clsPerson) = alPerson.OfType(Of frmTelephone.clsPerson)()

[code].....

View 4 Replies

Get Distinct Values In Column 2 Of A DGV?

Aug 9, 2010

I am trying to get distinct values in column 2 of a DGV using the following LINQ query:

Dim AllocatedRoomTypes = From r In Me.AllocatedDGV.Columns.Cast(Of DataGridViewCell)() Select r.ColumnIndex = 2 Distinct

but I get the following error:

Unable to cast object of type 'System.Windows.Forms.DataGridViewTextBoxColumn' to type 'System.Windows.Forms.DataGridViewCell'

I understand that the problems lies with the Cast, but I do not know how to correct it.

What I am trying to acheive is this:

Value is Column 2 of DGV

Double
Double
Single
Twin

[Code]....

View 6 Replies

How To Count Distinct Value From DataGridView

May 31, 2010

I need to Count row with Distinct from Datagridview.

View 2 Replies

.net - Getting Distinct Words From String Via ReGex?

Mar 12, 2012

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]...

View 2 Replies

.net - Linq To Object - Select Distinct

Mar 18, 2010

I can't quite figure out why this Linq Statement isn't working as i would expect:

[Code]....

I would assume that this would create a new collection of anonymous types, that would be distinct. Instead it creates a collection the size of the "ThisParentCollection" with duplicate "MyAnonymousType" in it (duplicate id's).

View 1 Replies

.net - LINQ To XML And Distinct Custom Class?

Oct 14, 2009

I have a very interesting LINQ question. I have a document, that I am trying to filter results on, but to filter, I am matching on a REGEX result from one element of the XML. I have the following, working LINQ to XML to get the individual data that I'm looking for.

[Code]...

View 3 Replies

Asp.net - Generate Columns From Distinct Values?

Oct 25, 2011

I have a three column table which lists every person, every event they may have attended, and what percentage of the time they were there. I would really like to display this on one page with the person names on the side and the event names across the top.

Here' an example of what I have:

NAME EVENT %ATTENDANCE
Smith Rock Climbing 50
Allen Rock Climbing 78

[Code]....

View 2 Replies

C# - How To Get Distinct Values From DataTable In DataSet

Dec 23, 2011

I am using strongly typed dataset and have many tables in that. The problem is now I want to filter data from
GetData()
function which has a query like
select * from table_name

How can I filter a particular table and distinct values from it. Also if I try to filter it return all column but rest have null values except the one I asked, so I cannot assign it as a datasource to a datagrid or combobox. How can I do this..

View 3 Replies

C# - Selecting Distinct Elements From A Collection?

Dec 14, 2011

I need to select distinct highways from a roads collection.

I suppose I could use LINQ for this.

I have (stub code)

Dim roads As List(Of Roads) = myRegion.Roads
Dim highways As New List(Of Highway)
For Each road In roads

[Code]....

View 5 Replies

Constraint Violation When Using Select Distinct?

Aug 6, 2009

I have a problem running a simple query: "select distinct payee from table". This query is set up in the dataset and is called GetAllPayee.My code goes something like:

Dim dtSources as new Datatable
dtSources =
Me.TblExpenseRecordsTableAdapter.GetAllPayee
Upon running I get the error:Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.The problem is, I haven't set ANY constraints on either the new datatable, or the dataset table (tblExpenseRecords). i.e. there is no primary key etc.

Can someone please help me out with this problem?I have no problems running the query through the wizard where I can view the results successfully.

View 3 Replies

DataView RowFilter - How To Select Distinct

May 29, 2003

Is it possible to select distinct in the rowfilter method?

I have something like:

VB
'Create a data view so we can get each items name
Dim dvwItemNames As New DataView(dtlItems)
dvwItemNames.RowFilter() = "SELECT DISTINCT Name"

This gives me a syntax error exception. I tried just "Distinct Name" but this had the same result. "Name" is the column name. I would rather do it this way then looping through the entire table and putting the name in an array list or something.

View 11 Replies

DISTINCT Output From Multi-Columns?

Aug 4, 2010

I'm trying to fill a ComboBox from 3 columns in the same table. I need output DISTINCT and the drop down box would look better if it had no spaces between groups.

Using myCommand As New MySql.Data.MySqlClient.MySqlCommand("SELECT ten_id1, ten_id2, ten_id3 FROM tenants", myTenConnection)
Dim myReader As MySql.Data.MySqlClient.MySqlDataReader

[Code].....

View 2 Replies

Finding Distinct Values In Array?

Feb 15, 2012

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].....

View 2 Replies

Get Distinct Values From List(Of T) Using Linq?

Mar 10, 2012

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?

View 1 Replies

Get Distinct Values In A Column Of Datagridview?

Mar 9, 2011

Like "SELECT DISTINCT(Col)" in sql query, how do we perform this in datagridview?[code]...

View 3 Replies

LINQ / Select Distinct From Dataset?

Aug 20, 2010

I have a single columned datatable inside a single tabled dataset.I just want to convert this dataset to distinct rows. Here is my code, it gives compile error '.' expected.

Dim query = _
From email In ds.Tables(0) _
Select email.Field<string>("Email").Distinct()

EDIT: I changed to (Of String) and it works... BUT NOW 'query' is an ienumerable collection of characters... not a datatable... so how do I convert back easily without manually doing a loop?

View 1 Replies

Linq Join On Parameterized Distinct Key?

Sep 9, 2010

I'm trying to LINQ two tables based on a dynamic key. User can change key via a combo box. Key may be money, string, double, int, etc. Currently I'm getting the data just fine, but without filtering out the doubles. I can filter the double in VB, but it's slooooow. I'd like to do it in the LINQ query right out of the gate.

[Code]...

"Range variable name can be inferred only from a simple or qualified name with no arguments."

View 3 Replies

Linq Join On Parametrized Distinct Key?

Jun 9, 2011

I'm trying to LINQ two tables based on a dynamic key. User can change key via a combo box. Key may be money, string, double, int, etc. Currently I'm getting the data just fine, but without filtering out the doubles. I can filter the double in VB, but it's slooooow. I'd like to do it in the LINQ query right out of the gate.

LinqMasterTable:
-------------------------------------------------------------
| AppleIndex | AppleCost | AppleColor | AppleDescription |
------------------------------------------------------------

[Code].....

View 1 Replies

LINQ To SQL Using GROUP BY And COUNT(DISTINCT)

Jan 15, 2009

I 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]...

View 5 Replies

Returning Just The Distinct Rows From A Dataset

Jun 25, 2009

I have a strongly typed dataset that has rows with duplicate [sopnumbe] I am looping through them and displaying row data I want to only display the Distinct sopnumbe rows in my initial loop1.. but the sub loop uses the data out of all rows.. So I cant filter the actual dataset.

[Code]....

View 6 Replies

Select Distinct In Linq Query?

Jan 4, 2012

I've a collection with the data like this.[code]...

how can select the distinct data using linq?

View 2 Replies

Select Distinct Items From A BindingList?

Jun 5, 2010

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 Replies

Select Distinct Not Get Result Wanted

Jul 4, 2011

I used the following code to select unique values from the database [code]And it does not retrieve the unique values, it remains the same. But if I use only SELECT DISTINCT Author FROM tblBook it works fine.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved