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
ADVERTISEMENT
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
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
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
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
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
Apr 29, 2009
Public Class File_Compare
Inherits System.Windows.Forms.Form
Private Dir1, Dir2 As String
[code].....
View 18 Replies
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
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
Sep 27, 2009
When i save data in my xml file i save a bunch of cities that the user has selected, i then proceed to load the data back into the program and populate the check fields besides the city
vb.net
'// Loop through each one and re-check them
For Each cityToCheck As Xml.XmlNode In nodeList
[code]....
This string stringSplit(0).tostring returns the city name say "Glasgow" i was trying to loop the listview that stores the cities, if they match then put a check mark, this is where the cities are located: (formAddCities.listViewCities.(FIRST ITEM IN COLUMN WHICH IS CITY NAME) the very first column in the listview, but i can't seem to get the right syntax?
View 2 Replies
May 27, 2012
I have a listview with checkboxes for each items in the listview. You can see in the listview1_itemcheck event that when I tick and untick for each checkboxes in the listview, it will add the subitems text in the label. Can you please help me with a button event as I would like to know how i can check the subitems in the listview when I add each subitems text in the label?
[code]...
View 2 Replies
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
May 25, 2009
How do I fill a listview using Linq-to-Sql? Once filled, will it be editable?
View 3 Replies
Apr 21, 2012
[code]The scroll bar appears so some thing is being added but nothing is displayed. The items are in the annon member.
View 5 Replies
Aug 3, 2011
also i have a table called Orders with several columns, they contain information about the order and store the ID of the Customer they belong to.Question is: how can i query that table with (preferably) linq (the datacontext is from LinqToSql) to return the following dataI want to search for any entry with the matching CustomerID which took place, group them by Year, Sum the Totals respectively and add them to the listview?I now i could use lamda expressions and aggregate, its just not clear how (option infer on,db is a datacontext object,CustomerID is an int32 variable):
Dim Orders = (From order In db.Orders Where order.CustomerID = CustomerID).GroupBy(Function(p) p.Date.Year).GetEnumerator
I reckon i'd have to create an anonymous type like the following:
[code].....
View 1 Replies
Mar 3, 2010
I have two textbox in my application.
Textbox1.Text="19-Jan-2010"
Textbox2.Text="Jan 2010"
May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?
View 1 Replies
May 20, 2011
they need to make some compare version between host version and client version.. and each 1 version different will download the file to the client..[URL]..with both example, how can i make a program in VB.NET just like i said just now?
View 15 Replies
Jul 14, 2011
given this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
View 1 Replies
Aug 6, 2009
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 Replies
Apr 20, 2011
I have a listbox on my xaml form that I bound to a List(Of MyType) property. I populated this list like so:
Dim fields As List(Of CheckableFields) = New List(Of CheckableFields)
Using context As ITIPEntities = New ITIPEntities()
Try[code]....
Now I'm at the point where the user selects the fields they want included in a report and I need to iterate over the required fields. This is my linq query:
For Each checkedField In _requiredFields
If checkedField.IsChecked Then
If checkedField.FieldData IsNot Nothing AndAlso checkedField.FieldData.Trim IsNot String.Empty Then[code].....
View 1 Replies
Mar 12, 2009
i want to format listview head of listview textalign = center and item of listview textalign = right
View 1 Replies
Sep 10, 2009
Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
View 2 Replies
Mar 31, 2011
Forgive my ignorance on this.I have this LINQ Query:Dim ngBikersDataContext As New CarBikeWalkDataContext
bikersList = (From c In ngBikersDataContext.Reg_Bikers _
Order By c.L_Name _
Select New Bikers() With { _
.BikerID = c.BikerID, _
.F_Name = c.F_Name, _
[Code]...
with the error "Overload resolution failed because no accesible 'Select' accepts this number of arguments."
Over the "NEW" I get an error " ')'expected."
View 1 Replies
Jan 27, 2011
We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)
Dim oPkgProducts = _
From b In oBillPkg.BillProducts _
Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _
[code]....
View 1 Replies
Feb 28, 2012
The pattern I'm trying to avoid is checking if a string (normally a control's text value) is null/empty, and if it is, comparing it using Contains to a field in my data. Obviously the field isn't hard-coded into my extension, neither is the object type.What I've got works perfectly in Linq to Objects, but I get the generic run-time error "LINQ to Entities does not recognize the method 'System.String Invoke(GenericQueryHelper.Customer)' method, and this method cannot be translated into a store expression." when using an entity framework model.
Here's what I have:
<System.Runtime.CompilerServices.Extension()>
Public Function CompareAndFilter(Of T)(source As System.Linq.IQueryable(Of T), expressionField As System.Linq.Expressions.Expression(Of System.Func(Of T, String)), compareTo As String)
[code]....
I want my usage to look something like this:
Dim results = repository.Customers.CompareAndFilter(Function(c) c.FirstName, searchText)
I do need to get this running against a SQL database really, as it is filtering results, so I don't want to be doing that in memory.
View 2 Replies
Jun 27, 2012
How can I convert this code LINQ to SQL in C # LINQ to SQL in Vb.net
[Code]...
View 2 Replies
Aug 31, 2011
How do I add ROW_NUMBER to a LINQ query or Entity? How can I convert this solution to VB.NET?
[Code]...
I'm having trouble porting that last line. I have been unable to locate a VB.NET example. I'm actually not looking for any paging functionality like the example provides, just good old-fashioned Row_Number(Order By X) row index.
View 1 Replies
Oct 21, 2009
How can I convert an object of type System.Data.Linq.DataQuery to System.Linq.IQueryable?I'm working with Visual Basic/Silverlight, and the source code of my query is as follows:
Public Function Get_Cli_Pag() As IQueryable(Of V_Cliente_Pagare)
Dim Qry = From P In Me.Context.Pagares Join C In Me.Context.Codigos On C.Codigo
[code]....
View 1 Replies
Apr 20, 2010
I just upgraded a project from VB 2008 to VB 2010. Before, the project did not use LINQ. I have started implementing it. So, I have updated the target framework from 2.0 to 3.5, and added a reference to System.Core, and imported the namespace System.LINQ to the entire project and also imported System.Data.LINQ into the form I'm working with (because it was not available in the list for Imported Namespaces in the references tab).
It's not throwing any errors now, but my IntelliSense is not working for LINQ stuff.
For example... I write this:
[CODE]....................
Then, if I type S. on the next line, the IntelliSense doesn't grab what it should for S (Only get Equals, GetHashCode, GetType, ReferenceEquals, and ToString, instead of the options I should get like Count, First, FirstOrDefault, etc...). If I Type S.First. then its the same thing, no IntelliSense that lists the available fields for S, just the standard options (Equals, GetHashCode, GetType, ReferenceEquals, and ToString). I should be seeing my column names in my table when I type S.FirstOrDefault.
So any ideas what is going on? When I type the code, for example, MessageBox.Show(S.FirstOrDefault.FirstName), it works perfectly. But it doesn't change the casing of the text (so it would read s.firstordefault.firstname) and no intellisense while doing it. But no errors. BTW - Everything works perfectly when creating a NEW VS 2010 application, it's just my projects upgraded from Visual Basic 2008 that have this issue.
View 2 Replies
Apr 19, 2012
I want to populate a listview and leave selected records that are true
I have a DB record which is ID int, desc varchar, selected boolean.
I have tried the code below
LVProducts is a Listview and DS is a dataset
CODE:
View 3 Replies