LINQ Except Using Custom Comparer?
Jun 17, 2009[code]....
View 4 Replies
ADVERTISEMENT
Use Custom Comparer When Sorting By Multiple Columns?
Apr 7, 2011I have a ListView (GridView) that I want to sort by 2 columns, so if 2+ items have the same value in Column 1, it sorts by Column 2. Pretty easy. But empty strings show up at the top when sorting A-Z. I'd like to move them to the bottom. I made a comparer (IComparer) that takes care of this, but I'm not sure how to use it.[code]...
View 1 RepliesVS 2010 - Write A Custom Comparer To Make A Listbox Full Of Numbers Sort Itself
Jan 17, 2012So...numeric sorts. Do I really need to write a custom comparer to make a listbox full of numbers sort itself like:
[Code]...
.net - SortedDictionary - Comparer Only For Sorting
Oct 31, 2010I have a list of keys and values that I would like sorted by key via a custom Comparer(Of T). I tried using a SortedDictionary, but kept getting incorrect results because it used the comparer to see if the items were the same. For example calling SortedDictionary.ContainsKey() would return false, even though it did contain the key.
When I stepped through the code after calling ContainsKey(), it would go to the comparer.Compare(x, y) function. It would then only compare against a few of the keys in the dicionary, and somehow skip the matching item (which I ensured did exist). I take it that this is some sort of optimization, where some items are skipped depending on what is returned by the comparer.Compare() function? Is it possible to have a dictionary that only uses the comparer for sorting? EDIT: I am using a Type object for the dictionary's key
[Code]....
Asp.net - Reverse-sorting A Listview (with Comparer Class)
Oct 7, 2009I have a two-column ListView linked to a Datapager. The ListView lists all files of a particular type in a particular directory, so the data source is an ArrayList of type FileInfo. Consequently, I had to create a Comparer class to use in the ArrayList.Sort method.
[Code]...
IQueryable OrderBy Error: Cannot Order By Comparer
Sep 14, 2011I'm trying to sort a IQueryable dynamicaly.
Dim activities =From a In db.VW_Activities Select a
activities = activities.OrderBy(Function(a)
New ActivityComparer(SortFields(0).Sort))
definition of SortFields:
[Code]...
.net - LINQ To XML And Distinct Custom Class?
Oct 14, 2009I 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]...
Use Custom Type In A LINQ Query?
Jun 4, 2009If you have custom type, and you wish to assign a List(of T) to that custom type[code]...
View 1 RepliesAdd Custom Columns To A Table That LINQ To SQL Can Translate To SQL
Aug 26, 2009I have a table that contains procedure codes among other data (let's call it "MyData"). I have another table that contains valid procedure codes, their descriptions, and the dates on which those codes are valid. Every time I want to report on MyData and include the procedure description, I have to do a lookup similar to this:
From m in dc.MyDatas _
Join p in dc.Procedures On m.proc_code Equals p.proc_code _
Where p.start_date <= m.event_date _
[Code]....
Is there a way to turn a complex lookup (i.e. a non-trivial join) like this into something SQL can recognize so that I can define it in one place and just reference the description as if it were a field in MyData? So far the only thing I can think of is to create a SQL view on MyData that does the linking and bring that into my data context, but I'd like to try to avoid that.
Custom Date Format From Linq To SQL Query?
Jul 13, 2010Im using the folowing function to return a SelectList. I need a custom format on Descr, but replacing Key.ToString() to Key.ToString("DD/MM/YY") render me the error "Method 'System.String ToString(System.String)' has no supported translation to SQL.". How could i use a custom date format on Descr?
Public Function ReturnDates(ByVal Param_Pesq_Cod As Integer) As SelectList
Dim Qry = From E In DB.Execs _
Where E.Pesq_Cod = Param_Pesq_Cod _
[code]....
LINQ And Option Strict When Using Custom Object?
Aug 12, 2011http://127.0.0.1:47873/help/1-6644/ms.help?method=page&id=C318B79A-FA4D-4DE3-B62D-C1162BEB267E&product=VS&productVersion=100&topicVersion=100&locale=EN-US&topicLocale=EN-US
and i get the following error
[code].....
Asp.net - Convert SQL (Pseudocode) To Dymanic LINQ Query From List<Custom> Parameters?
Apr 5, 2012GOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
Ombine Two Linq Expressions Of A Custom Type (i.e. Expression(Of Func(Of MyClass, MyClass))
Nov 24, 2010I have a list of properties and values that i'd like to use to dynamically build an Expression(Of Func(Of MyClass,MyClass))
I can run through the list and create each Expression by itself, but the only way I know how to combine them would be to use Expression.And or Expression.AndAlso, but that returns a BinaryExpression rather than my original Expression(Of Func(Of MyClass,MyClass)).
.net - Filter Custom Dictionary With LINQ ToDictionary - "Unable To Cast Object Of Type 'System.Collections.Generic.Dictionary`2"
Jul 7, 2010I have created a Dictionary class (MyDictionary for the example). I am currently trying to pass MyDictionary into a function, filter it into a new instance of MyDictionary and pass this new instance into another method. When I am attempting to create the second instance from the filtered first instance of MyDictionary via Lambda Expressions and the ToDictionary Method, I am getting the following error:
Unable to cast object of type 'System.Collections.Generic.Dictionary`2[System.Int32,System.String]' to type 'MyDictionary'. I have simplified the example and recreated it in LINQPad and am getting the same error.
Here's the simplified version of my code:
[Code]...
.net - ActiveRecord Linq/NHibernate Linq Not Building Query Completely?
Jul 14, 2011given 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
Performance Gain In LINQ Query Vs LINQ Stored Procedure?
Aug 6, 2009if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 RepliesCreate A Custom Messagebox, With Varying Number Of Buttons With Custom .Text Descriptions?
Feb 6, 2009This is what I would like to achieve:To create a custom messagebox, with varying number of buttons with custom .Text descriptions, and other features. I intended to have a property array that would be redim-ed and have values (.Text values) set by the calling class:
[code]...
Apply Percentage Format To Custom Cell In Custom Column In DataGridView?
Jun 25, 2009I came across this great article on creating a custom datagridview column which creates a graph-like effect in the cells of a custom datagridview column:[URL]..Does anyone know how you would edit this to format the number in the cell as a percentage? And does anyone know how you would set this up to take 0 values which do not create any graph effects at all.I have been trying to do this but keep getting errors.
View 1 RepliesAvoid Closing Of A Custom Combo Box Popup Window In A Custom Datagrid?
Jan 31, 2012I was trying to block the closing of a custom combo box popup window in my custom DataGrid. The popup window comes by pressing F4 or ALT+DOWN keys in my datagrid which is getting closed if I press the down arrow for the first time, after showing the first value in the combo box as selected. Next time onwards, if I press the F4 key and down arrow, I can move to any item in the popup window and select the item using keyboard and in that case, the popup window is not getting closed till I press the ENTER key or selection using the Mouse. Is there any specific reason for this behaviour or something is missing in my code part? [code]...
View 1 RepliesAvoid The Closing Of A Custom Combo Box Popup Window In A Custom Datagrid?
Sep 2, 2010I was trying to block the closing of a custom combo box popup window in my custom DataGrid. The popup window comes by pressing F4 or ALT+DOWN keys which is getting closed if I press the down arrow for the first time after showing the first value in the combo box as selected. Next time onwards, if I press the F4 key and down arrow, I can move to any item in the popup window and select the item using keyboard and in that case, the popup window is not getting closed till I press the ENTER key or selection using the Mouse.
View 13 RepliesSpecify A Custom Icon For Display In The Toolbox Window When Create Own Custom Control?
Dec 29, 2011how to specify a custom icon for display in the toolbox window when you create your own custom control? Something other than the dreaded "gearbox" icon.
View 2 RepliesLinq To Entities. GetPropety(name).GetValue Not Recognised By Linq?
Apr 20, 2011I 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].....
Make Stand Alone, Custom Web Browser (with Custom Errors, Or Generic)
Dec 13, 2011Cookies to be stored in folder and on close delete the cookies The ability to watch youtube vids, view images, and play js/flash games good security, no ads?
View 6 RepliesC# - Custom XML Serialization, Write Custom Root Element?
Mar 15, 2010I'm using custom serialization and when the xml is generated it's putting the class name as the root element
Example:
<MyClassName>
<MyIntendedRootNode>
<ObjectType>
[code]....
I'm invoking the serialization by calling xmlserializer.Serialize(writer,Me) so I'm sure that has something to do with it.I've tried putting XMLRoot onto the class, but I think as vb is compiling this partial class with its aspx page, it's either overwriting this property or ignoring it entirely.I'd like to just tell it to either throw away everything it has and use a different root element.
Create A Custom File Association ( A Custom Extension ) In VB?
Dec 19, 2010know how to create a custom file association ( a custom extension ) in VB .Net and how to open it on the application
View 1 RepliesCustom Principal & Identity Missing Custom Functions
Jun 21, 2010I have a Custom Principal class that Implements System.Security.Principal.IPrincipal and a Custom Identity class that Implements System.Security.Principal.IIdentity. So when a user successfully login to my windows form application, I set My.User.CurrentPrincipal = CustomPrincipal, which worked great until I started adding custom functions to my Principal and Identity classes.
[Code]...
Not Getting Redirection To Custom Error Page Using Custom Errors?
Mar 24, 2010Here's my Application_OnError event sink in global.asax.vb:
Sub Application_OnError(ByVal sender As Object, ByVal e As EventArgs)
Dim innerMostException As Exception = getInnerMostException(Me.Context.Error)
[code].....
How To Get Lamda In LINQ To Actually Filter For Dynamic Linq
Sep 10, 2009Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
LINQ Query Using The Dynamic LINQ Library?
Mar 31, 2011Forgive 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."
Asp.net Mvc - Custom AuthorizeAttribute + Custom SiteMapProvider Related?
Jan 12, 2010I have a custom SiteMapProvider (populated from database) and a custom AuthorizeAttribute (validates current users roles + requested page against Role_Page database) for controller classes.I have to implement the function SiteMapProvider.IsAccessibleToUser(context, node). I also have to implement AuthorizeAttribute.AuthorizeCore(context).How are these two functions related? Isn't there some way to 'attribute' the SiteMapProvider?
Some code:
edit: Might this be a solution (inside AuthorizeCore())? context however is HttpContextBase, and IsAccessibleToUser() only takes HttpContext as parameter.If Not SiteMap.Provider.IsAccessibleToUser(context, SiteMap.CurrentNode) Then
current code:
Public Class CustomValidateAuthorization : Inherits AuthorizeAttribute
Public Sub New()
End Sub
[code]....