I need a list from OldGuids that are not in the NewGuids, so I used the Contains method, the problem is that it is already running more then half hour, is there a faster way? or how much longer would it take about? [code]
View 2 RepliesI'm working on building an HTTPHandler that will serve up plain text for use with jQuery Autocomplete. I have it working now except for when I insert the first bit of text it does not take me to the right portion of the alphabet.[code]...
My question is, how would I implement this concept into my HTTPHandler without doing a fresh SQLQuery on every character change? IE: I do the SQL Query on the QueryString("ID"), and then on every subsequent load of the same ID, we just filter down the "Part".[url]...
My LINQ query contains the following Group By statement:
Group p By Key = New With { _
.Latitude = p.Address.GeoLocations.FirstOrDefault(Function(g) New String() {"ADDRESS", "POINT"}.Contains(g.Granularity)).Latitude, _
.Longitude = p.Address.GeoLocations.FirstOrDefault(Function(g) New String() {"ADDRESS", "POINT"}.Contains(g.Granularity)).Longitude}
The query works, but here is the SQL that the clause above produces
SELECT [t6].[Latitude]
FROM (
SELECT TOP (1) [t5].[Latitude]
[Code]....
but this produced an error: "A group by expression can only contain non-constant scalars that are comparable by the server."
I am trying to use a simple LINQ to Objects query.When I try to run my application I get the message:
System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Method not found: 'Void sharatTashlumimWS.paymentDetailsManager.set_ReleaseDate(System.DateTime)'."
Source="WindowsApplication1"
StackTrace:
[Code]...
I'm trying to implement multicolumn filtering using LINQ expressions in a class that extends BindingList(Of T). Here is the relevant code:
Public Function GetFilterPredicate() As Func(Of T, Boolean)
Dim expressionList As List(Of Expression) = New List(Of Expression)
For Each item as FilterInfo in _FilterList
[code]....
However, an exception is thrown at the Expression.Call statement. I can't quite figure out the right arguments to supply. As it is now, I am getting this error when I run the code:
InvalidOperationException was unhandled:No generic method 'Equal' on type 'System.Linq.Expressions.Expression' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic.
For I've tried this:Dim exampleItems As Dictionary(Of String, String) = New Dictionary(Of String, String)
Dim blah = exampleItems.Select (Function(x) New (x.Key, x.Value)).ToList 'error here
But I'm getting a syntax error and all the examples that I've seen are in C#.
I'm using LinqToSql classes in an ASP.NET website and let's say I have an entity named Testimonials. Two pages utilize this type - the first being a list of all existing Testimonial records and the second being an add / editor with which to manage the records. [Code] This allows population a DataGrid with the returned items, however on the add / editor page we alter the query ever so slightly: [Code] This query dies, prior to even trying to populate anything, with the following message: [Code]
I have pretty much identical methods for other data objects which have been and still are executing just fine. One immediate difference I can think of is that this table has been recently updated in the database, removed from the dbml designer and re-added to the dbml designer. None of the other tables have undergone this process for some time. [Code] Why is this exception occurring and how can I configure my project appropriately to correct the issue?
I had a code segment on an asp.net page in the code-behind file. I decided to move it into a public subroutine in a module (general_functions.vb). Once I did this, however, the code no longer works - it throws an error. On the original code-behind I replaced the original code with a call like so:
[Code]...
If I simply have this:>>
CODE:
I have a GridView and on a row being deleted I trigger the GridView1_RowDeleting sub, but I receive an error "LINQ to Entities does not recognize the method 'System.Web.UI.WebControls.TableCell get_Item(Int32)' method, and this method cannot be translated into a store expression." Code is:
Private Sub GridView1_RowDeleting(sender As Object, e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
' The deletion of the individual row is automatically handled by the GridView.
Dim dbDelete As New pbu_housingEntities
' Remove individual from the bed.
[code]....
The specific line erroring out is:
remove_bed.First.occupant = ""
When I execute the code below I receive the error message: LINQ to Entities does not recognize the method 'System.Object CompareObjectEqual(System.Object, System.Object, Boolean)' method, and this method cannot be translated into a store expression.It seems to be occurring on the line For Each row2 in PCstudent.
[Code]...
I'm using .NET 3.5 In my DataLayer class I have references of System.Core,System.Data.Linq, System.Data.DataSetExtensions. But I cantnot use this feature in Linq query if I have Option Strict ON:
[Code]...
I'm binding a DataGridView to a BindingSource to a LINQ IEnumerable, I found that the BindingSource.Find method throws an exception because .Find isn't implemented in IEnumerable (and the BindingSource just passes the call to it's DataSource). I need to use BindingSource.Find to select/highlight a particular row in the DataGridView.
Is there a feasable way to extend my DataContext to support this behavior w/o breaking anything else? I expected to find the code out there already, but I've searched exaustively with no luck.Without it, I cannot "move" the BindingSource using .Position and that's a pretty common use of the BindingSource I think.
The following LINQ query resp. call of the extension method Select in Visual Basic 2010 is working fine:
Dim qAvSalary = qJobData.Select(Function(e) e.AvSalary) But doing so I am not able to specify the name of property I want the query (e.g. AvSalary) using a string variable. This should be possible if I use a LINQ expression tree. Searching and trying a long time on how to translate the query to a corresponding expression tree was not successful. My final approach is:
[Code]...
I need to order lists of up to 100 addresses in optimized order. Is there a way to do this since getdirections is limited to 25? i don't se any way around this 25 limit. Is there one I'm missing?
No I'm trying to use MapPoint object model but it crashes as well with this many waypoints. Here is my example proof of concept code from Excel:
Sub OptimizeRoute()
Dim objApp As Object 'New MapPoint.Application
Dim objMap As Object 'MapPoint.Map
[Code]....
I had been working on a project that would generate a loan schedule.
But, It needs to factor in specified holidays and weekends.
Now, when running with a small 'term', it seems to work fine.[code]...
Consider this
bar = 1
foo = <1 or 2, depending on previous code>
if foo=1
while bar <= 5
[code].....
What I want to know is, is the compiler smart enough to optimize away the (apparently) repeated tests for "foo = 1" since foo is not modified in the body of the loop?If so, I might use the second construct since it is semantically equivalent (I think!), takes less code and reduces indentation levels.
Is it possible to use a string as an array? I mean:' I have several arrays
Dim a10() As Integer = {530}
Dim a15() As Integer = {370, 231}
Dim a20() As Integer = {305, 176, 126}
'I declare a variable as a string and I assign the name of an array to it
Dim tablaalfa As String = "a10"
'I retrieve data from the array using the name of the variable instead:
lbl1.Text = tablaalfa(2)
I guess it doesn't work in this way?
vbc.exe has something called /optimize switch right. If I enable that what are the optimizations the compiler can do for me? The MSDN documentation just curtly says 'does various compiler optimizations'. Where can I find the complete quantified view of the different optimizations that actually goes into.Here is the thing I am pursuing this route. One of the code blocks in a module I am leading has a lot of delimited array manipulations. I believe this is going to be a heck costly in terms of string memory handling. I am looking to see if I can retire them by way of simple properties or methods so that the compiler can internally do something like our c++ inline functions making a best win-win offer in terms of both memory and processing time. I admit when the compiler translates them as inline function, the JITed code might be big in size right?
View 7 RepliesI basically want to remove the formula from the cells but want to retain the calculated values.
SO, I implemented it easily and it works great but REALLY SLOW. (About 2 mins for 1800 cells)
I have : Dim col As Excel.Range = getRange()For Each cell In col cell.Value = cell.Value Next
I tried to do this to the first cell and then autofill the rest, but that copied the value of 1st cell to the rest of the cells in column.
Want to dump a fetched table to a excel sheet. [code] I am new to data fetching and ADO.Net concepts and just got it working.But. This seems to be very inefficient and lame to me. So, can you help reducing the complexity and may be improve performance ? A totally different (Better) implementation is most welcome !
View 2 RepliesHow can I Optimize my own code written by VB.net? Is there any tools for it? Does Visual Studio have any one? What's your suggestion? I use VS2008 as my editor.
View 1 RepliesOften it is very usefull to save data as a class by serialize and compress it. From few experiments I have noticed that
Class A
Public name as string
Public List as new list(of string) <---- empty
End Class
Class B
Public name as string
Public List as list(of string) <----- not instantiated
End Class
If I serialize and compress the 2 classes the class B uses less spaces once serialized and compressed. This suggests me that if a class contains a list that is instantiated but empty it is better to set that to nothing and reset as new when it is decompressed and deserialized. Is there any dll that optimizes a class to be stored (serialized and compressed) and restore it when it is decompressed and deserialized?
Public Function CalCheckSum(ByVal ByteList As List(Of Byte)) As List(Of Byte)
Dim total As Integer = 0
For Each b As Byte In ByteList
[code]....
I fairly new to .Net. I did a small project a year or so ago but haven't coded in it since. I'm picking up maintenance of a project where items are selected from one listview and copied to another removing the selected item from the "parent". The current code is in two steps:1. Get the selected items removing from sender:
Public Function GetSelectedItems(Optional ByVal pRemoveFromList As Boolean = False) As ListView
Dim mList As New ListView
[code].....
When my form first loads, it runs at about 30k CPU, but after about 10 minutes of use, it goes up to (and stays at) about 70k CPU.
What ways can i optimize my code to allow the CPU usage to stay low, or how can i lower it during the running of the program.
My most concerned areas of the CPU are:
1. I have a web browser, and when a user types in a url and presses go or enter, the CPU jumps about 4k:
Private Sub Go_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Go.Click
WebBrowser1.Navigate(OldURL.Text)
[Code]....
The second worry is when i open other forms, it boosts the CPU up aswell. the only code for this is:
Form.Show()
I 'm currently developing program which I can check the lines of each textbox if it has same length. The code is working properly in few lines like 2000 lines, but when I try to load a textfile which has 50,000 lines, my program is not responding anymore it takes forever. [code]...
View 7 Repliesthis is in reference to my main post here update mdb with data from different tables in dataseti have two tables in a dataset called dsSource. dsSource.Tables(0) has the following columns: ,,,,,,,code,art,sizerng1,sizerng2,sizerng3,etc...... dsSource.Tables(1) has the following columns: ,,,,,,,code,art,size1,size2,size3,etc...... the conditions here are: 1) to look for "1" in columns sizerng1, sizerng2, etc. of dsSource.Tables(0) 2) match code and art on both tables finally if both conditions are valid then the size values in columns size1, size2, etc. will be assigned to columns in sizerng1, sizerng2, etc. my main concern here is i have to loop through all rows in both tables which takes a long time, so is there a better way to do this than the code i have below?.
'***put the sizes from weights to traps file
row1 = 0
For Each dr As DataRow In dsSource.Tables(0).Rows
[code].....
I have this seperate class to fill a treeview from my database.There are over 33000 records and when this class runs, it takes almost 1 minute to finish.When i run this query from the server it takes for 5 seconds to retrieve all items.Is there a way to optimize this class?
Option Explicit On
Option Strict On
Imports System.Windows.Forms
[code]....
I've read several articles and questions/answers that conclude the best practice is to let the JIT compiler do all the optimization for inline function calls. Makes sense. What about inline variable declarations? Does the compiler optimize these as well?
[Code]...
Of course I prefer the latter because it's easier to read and debug, but I can't afford the performance degradation if it exists. I have already identified this code as a bottleneck -- No need for retorts about premature optimization.