david7520's Q&A profile

• SQL Server Copying table data from SQL Server 2005 to SQL Server 2000 - Very Slow when using OLEDB Source and Destination sources?

  An SSIS package to transfer data from a DB instance on SQL Server 2005 to SQL Server 2000 is extremely slow. The package uses an OLEDB Source to OLEDB Destination for data transfer which is basically one table from sql server 2005 to sql server 2000. The job takes 5 minutes to transfer about 400 rows at night when there is very little activity on the server. During the day the job almost always times out. On SQL Server 200 instances the job ...Show All

• Windows Forms Seperate Thread progress form

  I am trying to create a Progress form for my program that loads in a seperate thread so that screen updates and animations on the form are smooth and timely. I have had some success with the following code. The Form Used as a "Template" for the threaded progress form: Public Class frmDebug Private m_Thread As Threading.Thread Private m_CloseByCode As Boolean Public Shadows Sub AsyncShow() m_Thread = New ...Show All

• SQL Server Very high transaction log growth in SQL Server 2005 (RTM version)

  We recently upgraded from SQLServer 2005 CTP version to SQL Server 2005 RTM version (Standard edition). With the RTM version, we are finding a very high transaction log growth and at a very rapid rate. A 87MB database has a log file of 325MB, although none of the db operations in that database participates in a transaction. The recovery mode is simple and 'trunc. log. on chkpt.' is enabled. Another database of 5GB, which is frequently updated ...Show All

• Visual Studio Applying a stylesheet to a report

  I am having trouble getting my reports to pick up the styles in my stylesheet. I have tried setting the stylesheet class to an object on the report and linking the stylesheet in the html on the aspx page which has the reports viewer control on it. I have even tried writing the style straight in the html page instead of linking it from a stylesheet but it makes no difference. When the report is run, looking at the source, it seems to automatica ...Show All

• Windows Forms MDI Maximized children forms without controlbox?

  MDI Maximized children forms without controlbox I have been searching the web and everywhere I asked the question, the answer is that it is a Microsoft Bug. Well instead of telling me that it is a bug, how do I fix this My situation: I have a parent form (frmMain), a welcome/startup (or background) form (frmWelcome) and other child forms for data capturing. The idea is that when the program runs, the welcome form is displayed and stays displ ...Show All

• Visual Basic Type to Structure conversion

  I have just started using vb.net 2003 and trying to convert an old vb program.  The old defined datatype was: Type OrderHeader     InvoiceNo As String * 10     CustomerNo As String * 6 End Type I understand that it is now structured like: Structure OrderHeader     Private InvoiceNo As String      Private CustomerNo As String End Structure but since vb.net will not handle a fix ...Show All

• Microsoft ISV Community Center Forums VBA XmlMap.loadXML problem - repeating call

  Hi all, I have the following XSD load to XML Source of excel: < xml version="1.0" > <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs=" http://www.w3.org/2001/XMLSchema "> <xs:element name="stock"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="quote"> <xs:co ...Show All

• Windows Forms DataGridView Performance issues with CellFormatting

  Hello: I'm using the DataGridView for displaying data to the user. The number of records that will be displayed at a certain time could vary between 0 and 150. I use the CellFormatting event handler to do some formatting like changing the font face and the background colors based on the cell values. Earlier we were iterating through the rows of the gridview to accomplish the same. Since the performance was dreadful, I changed the code ...Show All

• Windows Forms Format phone number

  Hello, I have a text field where the user types in a telephone number. When the user is done typing the number and the text field loses its focus I need to take whatever the user typed and format it to a standard format. i.e. ###-###-#### If a user types 1234567890  I need it to change to 123-456-7890.  Any ideas on how to do this or examples Thanks! The user will enter in different formats of a phone number. Two ways to ...Show All

• Visual Studio Team System errors in load test ("Object reference not set to an instance of an object")

  When I use the following code to enumerate dependent requests, I dont get the error "Object reference not set to an instance of an object" foreach ( string s in LastResponse.HtmlDocument.DependentRequestUrls) { WebTestRequest loopRequest = new WebTestRequest (s); yield return loopRequest; } if I add in the following check, I get an "Object reference not set to an instance of an object" mor ...Show All

• Architecture Synergising Whitehorse, DSL's, GAT, Enterprise templates etc

  Hi, This is my first post in this architecture forum. Theres some really good stuff floating around in the posts. Nice community. Hope I can contribute something useful. Anyway, heres something i've been thinking about since i attended TechEd Amsterdam last year. Beat Schwegler showed us a GAT package named Melted Cheese which created a 6 or 7 layer web service (one for the data, one for business, one for the service facade, one for an enterp ...Show All

• Visual Studio 2008 (Pre-release) Problem with P2P

  Hello, I am trying to run the "PeerTcp" sample on a fresh XP SP2 install. I installed and started the P2P windows service. However, when running the first receiver, I get the following exception. Any idea what could cause this Thanks System.Net.Sockets.SocketException was unhandled Message="Unknown error (0x2ced)" Source="System.ServiceModel" ErrorCode=11501 NativeErrorCode=11501 StackTrac ...Show All

• Visual C# Problem with axWebBrowser in a Multithreaded application

  Hi! So I have a MainForm. There is a timer on that form, and in a right time I want my application to shows four seperate forms with an axWebBrowser on them. These axWebBrowsers are automated with their OnDocumentComplete events. So, first I had the following error message: ...The current thread is not in a single-threaded apartment. So I searched the internet for this error, and corrected my code with this line: regThread.ApartmentState = ...Show All

• Visual Studio Express Editions Why Visual Web Developer Express needs Sql Server Express.

  Hello I just did a single application, it has not data components. And I cant see it. the error is the following I have sql 2005 abril ctp. Isnt it that enough Do I really need sql server express. for what Does the full version of visual studio also need sql server express SQLExpress database file auto-creation error: The connection string specifies a local SQL Server Express instance using a database location within the applications App_Da ...Show All

• Visual Studio Team System DisposeMethodsShouldCallBaseClassDispose and Windows service projects

  Hi all, I have a project that is a Windows Service. The code that's generated by the designer overrides the Dispose method of its base class. It does this in the following manner: Protected Overloads Overrides Sub Dispose( ByVal disposing As Boolean ) If disposing Then If Not (components Is Nothing ) Then components.Dispose() End If End If MyBase .Dispose(disposing) End Sub FxCop correctly indicates ...Show All