Hi, I am facing performance issues while reading/writing data from/to MS-Excel cells. I am using MS Excel 11.0 object library for automation with VB.NET. Currently it takes too much time to read and write from/to Excel files. (10 mins to read 1000 rows :( ). It seems the cell-by-cell reading and writing approach is not that effiecient....
I have a class library that i made in C#.NET. The class has a public event, public event EventHandler DataReadyEvent; that is triggered periodically. I have a VBA application that creates an instance of this Class Library using CreateObject(...). I can access the methods and properties of the class library easially through COM but I can...
When I run this and then go into the task manager and manually end one of the iexplore instances (there are 2 presumably since IE now also uses multiple processes) I see an error pop-up box that says a tab has been recovered. However, iexplore itself is invisible because of my process settings. Accordingly, I don't think that that pop-...
Hello all, I need to add some UCs for my app and I want to enable to enter to my UC parameter only values that i choose, for that i need to give the programmer the values while he/she is adding the UC to the app and choosing to use the param. Is there a way to create a live of optional values to pop when the programmer choose the param...
Using .net, I would like to be able to hash the first N bytes of potentially large files, but I can't seem to find a way of doing it. The ComputeHash function (I'm using SHA1) takes a byte array or a stream, but a stream seems like the best way of doing it, since I would prefer not to load a potentially large file into memory. To be cl...
I have a query that needs to be reused all over the place and I need to vary which property/column gets used for a join. What I'd like to be able to do is something like: query = RestrictByProp(query, x=>x.ID); An extremely simplified RestrictByProp() could be*: private static IQueryable<Role> RestrictByProp(IQueryable<Role> query,...
Given a relatively typical .NET 4 system in an SOA environment (i.e. Windows Server 2008 R2, RESTful Web Services on IIS 7, Windows Services for NServiceBus messaging, SQL Server 2008 R2, etc) what are the best practices or de facto solutions (without enterprise price tag) for performing 24x7 performance monitoring in production? Not n...
Using Hashtable I want to have multiple objects mapped to the same key. E.g. Key is 'Age' and Values are ojects of struct 'Student'. I suppose perceptually there will be a sort of linked list with Key acting as a 'Head' 25->obj1->obj2->obj3 Here are my questions: Is the above representation correct? If not, which data stru...
How do I convert guid to string in javascript. I am getting guid from the querystring, and m not able to process it as is. I have tried the following ways to do it but it doesnt seem to work. var guid = {<%=Request.QueryString["Guid"]%>}.toString(); var guid = <%=Request.QueryString["Guid"]%>.toString(); var guid = (string)<%=Request.Qu...
I recently came across a program that uses a Windows Form Control Library. To use the DLL, you would add it to references and then to make it run you would do. Dim DLL As New License If Not DLL.Check Then End ' VB.net Code Basically, the DLL would open and if the license that they entered wasn't in the database it would just close. ...
I'm trying to add all the nodes in an XML file into a listView, and I'm doing something wrong but I can't for the life of me figure it out even after looking at a load of examples. This is the XML snippet: <queue> <slots> <slot> <status>Downloading</status> <filename>file1</filename> <size>1 GB</size> </slot> <slot> <status>Downloading<...
Title says it all. I'm making calls in a transaction, and when an exception is thrown (thus preventing my scope.complete()) I don't see them, even though I know they were called. [Edit: For clarification - this is running on Server 2008 R2, .Net 3.5] [Edit: added example - basically answers the question, but if someone could cite docum...
Hi, I had a dotnet page with some input boxes and a bunch of validators on it that was working fine. However I decided to re-engineer it so that some of the functionality was parcelled up into webcontrols instead. Now in order to check validation before moving on I'm using Page.IsValid in the button click event, because the button whic...
I am having an issue using AutoMapper (which is an excellent technology) to map a business object to a DTO where I have inheritance off of an abstract base class within a collection. Here are my objects: abstract class Payment class CashPayment : Payment class CreditCardPayment : Payment I also have an invoice object which contains a...
Hi All, I've written an app with a simple textbox which attempts to identify a user from their typing habits (interval between key presses, duration key is held, time between key strokes ie a->s is quicker than a->v for some users, shorter for others depending on typing style). It's far from perfect but it does correctly identify modera...
We have Windows 2003 Servers running SQL Server 2005 and .NET 3.5 [separately]. We have a basic ASP.NET app running on IIS 6. What, if anything, do I need to do on the application end [IIS,Framework,ASP.NET] to make it IPv6 compatible? EDIT: We do use System.DirectoryServices, System.DirectoryServices.DirectoryEntry and DirectorySear...
Is there an easy way to delete all child records for an item using Linq to sql? ...
I know that in java when u want to create a high performance server you use nio instead of the regular socket. So is there such a thing for C#, to create high performance servers? ...
I'm looking for resources for learning MS Build (not just books). At this point I'm mostly concerned with merging assemblies and automating build tasks. (nightly builds etc.) ...
What is the difference between adding a reference to Excel 11.0 from .NET vs COM? (In C# if that even matters) -Edit- To clarify, I am talking about the .NET and COM tabs in the Add Reference dialog, thanks for pointing that out Hans Passant. ...