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 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.
So I've been doing some research on the singleton factory design pattern, and I am wondering if my example implementation is correct (warning I did get carried away creating animals):
[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.
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 RepliesIs 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 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.
Code:
Tables:
- Company
- Department
- Employee
- CertificationA
- CertificationB
I am trying to return a recordset that gives some summary information about each company. The fields in my returned recordset should look like the following.
Company.Name, NumberOfDepartments, NumberOfEmployees, NumberOfCertificationA, NumberOfCertificationACompleted, NumberOfCertificationB, NumberOfCertificationBCompleted
There are actually about 10 different Certification tables but, with Certification A and B you should get the hang of it. When an employee starts a certifaction, a record is added to the that certification table.Below is a query I wrote that works (gets me the data I need), but I am unsure if it is the most efficient way. There will be quite a lot of data so performance is an issue.
Code:
Dim sqlNumberOfDepartments As String
sqlNumberOfDepartments = _
"(SELECT COUNT(*) " & _
"FROM DEPARTMENT " & _
[code].....
I'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."
Is there anyone can post a simple code using vb,that start building a simple games ?
View 2 RepliesTrying to make a simple browser with some simple addon's. What Ive done is setup a menu(forum) for the user to enter their email providers web address and it will save it in a xml file. When they click on the email link, it should load the email xml iformation and place that info in the tb_html.text and navigate. I keep getting a null exception and im not sure what going on here. Here is the code:
Browsers:
Private Sub btn_Email_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Email.Click
'Load Action
Dim SavedEmailObj As Storage
[code].....
I'm getting an intellisenxe error saying that the statement below is expecting a ')' and is positioning the correction ater the parenthesis following "Approved". I'm not familiar with this IF syntax and I can't seem to make the correction; trial and error isn't working ;o)) If (reader.Item("Approved"), True, False) = 0), (reader.Item("DoNotDisplay"), False, False) = 0)) Then
View 2 RepliesI am having a problem setting up my combo box to pull its menu from a SQL Server table and store to the main data table.Currently my drop down list displays correctly but saves 'System.Data.DataRowView' to the data table. My main data table is called 'Survey' with staffname as a column, then I have another menu table of staff member names which populates the drop down menu.I found that when I remove the DataSource and populate the Items collection instead the combo box saves the correct value as expected but when I use the datasource it saves the words ''System.Data.DataRowView',[code]
View 2 RepliesI have combox1 and i want to dispaly Foure Columns in combox1 and I make this
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.Text, "select FirstName,FatherName,GrandFatherName,FamilyName from dbo.PersonalData")
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "GetSpecialFieldOFPersonalData")
Do While dr.Read
Me.ComboBox1.Items.Add(dr(0) & " - " & dr(1) & " - " & dr(2) & " - " & dr(3))
Loop
How do I use complex numbers in Visual Studio 2008 and in Visual Basic, dont tell me I spent all this money on VS2008 Pro only to find out that it cant handle complex number arithmetic!
View 1 RepliesIn my spare time i give myself programming stuff to do. Today i want to write a function that goes through a string, if the string contains any numeric value the function must return false, if the string has any special characters it must also return false else return true. For example the following strings would return as follows:
String Return Value
Travis True
78* False
[code].....
I am currently working on a project, which purpose is to call a webservice through a VB script. VB is by far not my first language and I simply reach the point where I do not know how to go on from here.
I have a Webservice descriped in a WSDL document that defines a service that takes a complex type as parameter and returns such one as answer.
The complex type is basically just a string that is wrapped inside a class object. So what i did was to create a new class module and added a public variable to it. I created a new instance of this class, gave it for the purpose of testing a value and tried to call the webservice. Everything goes well untill i reach the call to the webservice, where the program throws an exception that says:
"Class does not support automation or does not support expected interface"
My first thought was that the initialization of the object might have gone wrong but i am quite able to set and get the values on it. So i have to assume that the object is okay. I know that the url to the WSDL document is correct, due to the fact that I can call the document via the browser and it will throw an exception of "wrong type" when i feed the soap method with a primitive.
With out luck I browsed several pages on the net to find a clue what this could. So now i wanted to give this forum a shot.
You should know that i am not able to alter the WSDL file. I have to go with the way it is. In addition am supposed to stick to VB 6.0.
I used a Form in VB to make the call to the webservice.
Here is the call procedure:
Private Sub Command1_Click()
On Error GoTo ErrorHandler
Dim tS
[Code]....
I have a custom modelbinder built to handle my accountRequest class.This class consists of some boolean values and a UserViewModel.The UserView Model is made up of strings such as Firstname, Last Name, Address.Originally I was just passing the UserViewModel as the action parameter but I now I need to package UserViewModel inside of accountRequest.however, now my modelbinder will not map the strings in the httpContext.Request to my UserViewModel inside of AccountRequest. All of the booleans map just fine.Is there an easy way to get his data to map to the UserViewModel properties other than hardcoding it? [code]
View 1 Replies