How To Compare And Sum Values Of Multiple Periods Using LINQ

Sep 23, 2011

I have the following example datatable:[code]And now the user should be able to compare multiple periods. In this example the user chose two periods: 1.1.2010 - 31.12.2010 and 1.1.2011 - 31.12.2011. The result of the example should be:[code]

View 2 Replies


ADVERTISEMENT

VS 2008 Compare Multiple Database Table Values?

Jun 18, 2009

I have to compare an item value in two tables. these two tables are on different database(same server).

I have succesfully generated sql query to return both table values.

the query runs in sql server without any problem and gives the results.

The same query i used in vb.net doesnt gives any result ...

It is resulting with no rows.

Does the connection to multiple databases wont work from vb.net.

The following classes are used to get the result ...

SqlConnection
SqlCommand
SqlDataAdapter

SqlDataAdapter is showing with no records returned. The same query returns the results in sql server query window...

View 3 Replies

Add Multiple Numeric String Values In Linq?

May 11, 2012

I'm using Entity Framework code first and pulling some data back from our database. In the table I'm accessing is 13 columns that store the number of a items a customer purchased per week for the last 13 weeks as a char field. I have no control over how this data is stored. I need to total the 13 weeks results together to get a combined total, so take week1 + week2 + week3.... = Total Items Purchased over 13 weeks.In SQL I'd just Cast the char to an Integer and add the values together. But I'm struggling finding a solution to do this in linq.

I tried
(From c in Table
Select New With {.Usage = (Convert.ToInt32(c.week1) +

[code]......

View 1 Replies

Use Linq ToDictionary To Return A Dictionary With Multiple Values In The Dictionary Items?

Jan 25, 2010

I want to group items from a linq query under a header, so that for each header I have a list of objects that match the header title. I assumed the solution would be to use ToDictionary to convert the objects, but this allows only one object per "group" (or dictionary key). I assumed I could create the dictionary of type (String, List Of()), but I can't figure out how to write it. As an example I have written a simplified version below.

[Code]...

View 2 Replies

In MS Access, Have To Compare Values From Two Different Tables, And Find The Difference Between The Values?

Jul 15, 2011

I have a two different tables, Table 1 and table 2.

Table 1
-----------
Resource
Start Date
End date

[Code]....

Here I have to match the total hours of each table according to the resource,
then have to find the mismatched data and find difference with that values of mismatched data.

View 2 Replies

LINQ Group By Multiple Values Does Not Work Well But Work Well In C#

May 29, 2012

I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:

[Code]...

View 1 Replies

Using Linq To Compare Listview?

Jun 12, 2011

I've recently been exploring the uses of linq to use for comparisons,but really need a bit of a kickstart.Say for instance i have a listview populated with numbered names and I want to put up a message box if certain conflicts arise

such as this:-

This string combination is ok:-

1 fred
1 fred
2 fred

[code]....

So to summarize, the prefix number can only have one unique name assigned to it, and that unique combo can be used as often as you like.

View 10 Replies

Is Not Like Linq Query - Take Two Integers And Compare Them

Jan 11, 2011

I am trying to write a linq statement that would take two integers and compare them, if they are not alike then it would select a name from a database. I have ho idea how to write this and i have already tried a statement with <> and it didn't work.

View 5 Replies

.net - Case Insensitive String Compare In LINQ-to-SQL

May 8, 2009

I've read that it's unwise to use ToUpper and ToLower to perform case-insensitive string comparisons, but I see no alternative when it comes to LINQ-to-SQL. The ignoreCase and CompareOptions arguments of String.Compare are ignored by LINQ-to-SQL (if you're using a case-sensitive database, you get a case-sensitive comparison even if you ask for a case-insensitive comparison). Is ToLower or ToUpper the best option here? Is one better than the other? I thought I read somewhere that ToUpper was better, but I don't know if that applies here. (I'm doing a lot of code reviews and everyone is using ToLower.)

[Code]....

View 6 Replies

Compare Nullable Types In WHERE Clause Of Linq To Sql .NET?

May 4, 2012

I am trying to query for records where that column IS NULL:

Dim UnassignedSubSvc =
From c In CurrentContext.SubService
Where c.Product.ProductSubServiceId **is null**
Select c).ToList()

View 1 Replies

Compare Two Datatable And Delete Some Rows By Linq?

Nov 18, 2010

there is two datatable at some datasetsone of them is tbl1 and fileds is (pcode,points) other table is tbl2 and fields is (pcode,stoped)"pcode" is equal at two tables

View 6 Replies

Dir With VbDirectory Returns Periods

Jan 8, 2010

I just started using macros two days ago in excel, programming them by hand in VB (i've never really used VB before this). In one of my macros I need to make an array of all the files and folders with a specific path, so i used a variation of the following code:

Thedir = Dir(some_path, vbDirectory)
Thedir = Dir(, vbDirectory)

Of course there is more to my specific code but this is where the problem occurs (I've tested the return value with MsgBox and i still had the same problem) What should happen is that the first line would assign Thedir with a String representing the name of the first file/folder in the path. The second line would then assign a string representing the second file/folder in the path that the first Dir was called in. What instead happens is the first line sets Thedir = "." and then the second sets Thedir = "..". any successive call of Dir(, vbDirectory) will return the remaining files and folders in the path.

[Code]...

View 2 Replies

Compare LINQ-to-Entity To Date Results In Error?

Mar 14, 2011

I have a simple If..Then like so:

If rhcexists.First.SignatureDate > Date.Today.AddMonths(-6) Then
End If
rhcexists is a simple query to the Entity Model:

[code].....

View 1 Replies

Linq Query To Compare If Collection Contains List Of String?

Feb 3, 2012

I am using a path comparison to find any children tags which works well when there is only 1 tag selected. This is my code for when multiples tags are selected but it is not working. Can you point me in the right direction?

Single Tag Selection (working)
Dim tagpath = uxTags.SelectedItem.Text
lnqCases = From i In lnqCases Where i.HelpDeskTagItems.Any(Function(x)

[code]...

View 1 Replies

Xml - Mix Values From Local Data With Values Returned From Database While Using LINQ To SQL?

Oct 27, 2010

I am creating an xml file with LINQ as follows...

Public Sub CreateXml()
Dim db As New MDataContext
Dim Customers = <gallery columns="3" rows="3">

[code]....

Could i mix local values with the ones returned from the LINQ query...Something like the following?

Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String)
Dim db As New MDataContext
Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">

[code]...

View 1 Replies

Pass Multiple Values And Return Multiple Values?

Jun 10, 2011

When I click on button1, employee_id and P values need to be transferred from button1_click to Cal_Category13() and go through all the calculation. After the calculation, udtnew.X and udtnew.MTD values need to be transferred back to button1_Click

I've no problem to return multiple values Cal_Category13().MTD and Cal_Category13().X from Cal_Category13() to button1_Click but i've no idea how to transfer employee_id and p values from button1_click to Cal_Category13().

Program Code
Public Structure PCB
Public Employee_ID As String
Public MTD As Decimal

[Code]......

View 2 Replies

Way To Compare Values

Mar 28, 2011

Comparing value from the same table for my final project.[code]...

View 1 Replies

Compare Text Box Values With Others?

Mar 29, 2010

Basically i have 12-16 text boxes, with certain values in them.

i think i need a nested loop one to take first box and go through the rest to compare them and then a second loop withint that to do the actual comparison.

View 10 Replies

Compare Two Hash Values?

Aug 10, 2009

I'm trying to figure out a way to compare two "salted-hash" strings. How can I do this? I know that the salt is a random generated value that's appended to the plain text, then we just compute the hash of that new string.So how can I compare these two values? O_O (The new hash that the user hash written in a textbox and the hash stored in a database)

View 9 Replies

Compare Values Of Two Different Strings?

Oct 4, 2009

how to compare values of two different strings.

View 2 Replies

How To Compare And Match Two Values

May 10, 2009

I wanted to ask how should i read the text file find a value and place it in textbox then find for the same value from other part but at the same text file.

I give the example of my text file:This is one part.

[Code]...

View 1 Replies

How To Compare Two String Values

Nov 13, 2009

How can i compare two string values in vb.net? i've tried compare, equals functions but it's not giving me the correct result. what i'm trying to compare is as follows. also let me know if the code is correct. i'm new to vb.net

[code]...

View 3 Replies

How To Compare Values From Same Table

Jun 8, 2011

I need comparing value from the same table for my final project.
Example :
Table 1 :
SubjectCodeClasses
Sub Aclass 1
Sub Aclass 2
Sub Aclass 3
Sub Bclass 2
Sub Bclass 3
Sub Bclass 4
Sub Bclass 5
Sub Cclass 6
Sub Cclass 7
Sub Cclass 8
...

My task is, I need to compare the classes in the subject. Sub A with class 1, class 2, class 3 have to compare with Sub B and Sub C. if classes from Sub A exist in Sub B then the output is 0, if not the output is 1. then Sub A again will compare with Sub C and the rest. After Sub A compare its value with other subject. Sub B will start comparing with all the subject and so on.

Below is the concept.
Sub ASub BSub C
Sub A001
Sub B000
Sub C100
I really don't know to do the loop..

View 6 Replies

How To Compare Values In A Array

Apr 5, 2012

I have an array with 35 "cells" each with a value. ( CheckValue(34) ) Now i want to compare all values with eachother to find out wich 7 of they are the biggest. Is there any easy way to to that?

View 1 Replies

XML With Periods In Element Names Throws ArgumentException Error

Sep 6, 2011

I have an XML file where some of the elements have periods in their names. Using the code below, I receive the error:

"System.ArgumentException: Child list for field Stock cannot be created"It successfully reads the file if the periods are removed( i.e. StockAdjustment instead of Stock.Adjustment)

Dim myXMLfile As String = "C:file.xml"
Dim ds As New DataSet()
Dim fsReadXml As New System.IO.FileStream(myXMLfile, System.IO.FileMode.Open)
Try

[code]....

Is there a way to handle elements with periods in their names?

View 4 Replies

Database - Implement A Login System Using LINQ To Compare Information With An Access Table?

Sep 27, 2011

I have been requested to implement a login form into a friend's Visual Basic .NET application. He specifically requested that I should do this using LINQ to compare the input to a table in an Access database. I don't really know why he imposed these restrictions, but who am I to judge? However, the problem is I am not overly familiar with VB .NET, or LINQ.

View 1 Replies

Compare A Checkedlistbox To A List Of Values?

Dec 6, 2011

I have a checkedlistbox full of values, and then a list of values that's a subset of of those in the checkedlistbox. I need to check all the items that are on the list--preferably without repeating through both of them.

View 1 Replies

Compare String Values From Database?

Jan 18, 2010

I have a tblVersion that contains the versions of my application:

VersionID Version

VersionID is a bigint primary key, version is a ntext column that holds the current version... I want to be able to pick the row that has the highest version number, but version could be in this format:

MyApplication 1.0.1

If I try to convert that to a int32 it will throw an exception obviously. I would like to know if some of you have a idea how to solve this issue. I could of course make sure the column will only contain numeric values but this gives a little more flexibility.

View 4 Replies

Compare Values From Two Text File?

Jul 20, 2009

I have two text files which contains are like this[code]..

When the original files find the same values in drill file than it must overwrite the original file the line from drill file. Let say original file contain T230 than it must serch for same value in drill file if it find than it must overwrite the original file line with drill file line. The content of drill file is not fix. It will allways be update according to need.

is that posible to connect two text file?

View 4 Replies

Compare Values In Single List?

Oct 18, 2011

This is a 2 part question about list comparisons. I see lots of threads on comparing two separate lists, but I need to know how to compare values in a single list.

Part 1:I have a bunch of string values that I am first splitting and then adding to two separate lists. The strings look something like this... 3-ABC, 6-DEC, 11-RFG, 6-ABC, 12-ABC, etc... So, with the code below(vb) I am splitting the numerical portion of the string and putting it into myLeadQtys(saved for later). I then take the rest of the string and put it in another list (myLeadVals):

Dim myLeadVals As New List(Of String)
Dim myLeadQtys As New List(Of String)
Dim strMtextValue As String

[code]....

View 3 Replies







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