fuzzfoot's Q&A profile

• Visual Studio Tools for Office Populating a Word Document

  I'am using data from a SQL Server to populate a report in MS Word. Part of the report is a bulleted list. I cannot figure out how to populate the bulleted list with out leaving a blank bullet at the bottom. I’m using the code below to write the SQL data to a bookmark in Word. Using the writeline statement creates an empty bulleted line at the bottom of the list. Any ideas Dim cnn As SqlConnection Dim dr As SqlDataReader Dim cmd As SqlCommand Dim rng As Word.Range Dim sw As New System.IO.StringWriter ' Set up the command text: Dim strSQL As String '= _ ...Show All

• Architecture Who do you turn to for Industry Standard best Architecture Practices?

  In this blog (  http://realworldsa.dotnetdevelopersjournal.com/rational.htm   ) I say good-bye to Rational and mention I use SEI as one of my primary resources for Software Architecture Industry standard best practices. I would be interested in who you guys and gals turn to... Hi Tad, While Rational has indeed became much more IBM oriented, I still find a value in their opinions, just as I find value in Microsoft's views which are Microsoft oriented. Nevertheless, I spend most of my "learning" time reading blogs (Fowler, Booch, John Cavnar Johnson, Udi Dahan, Harry Pierson and m ...Show All

• Software Development for Windows Vista Using AudioVideoPlayback to play AVI files

  Hi all, I am trying to show a video file in my sampleframework. The problem is that when I load the avi file and try to play, the sampleframework popup an active-X control and then play the video. Is there any way to show the video inside my framework I want to show the video somewhere inside the framework. I have tried to call the function rendertotexture in the Audio Class (But don't know how to use correctly) using the device of the framework. Then I found that the display cannot show the video, and also the debug text that I want to render (using TxtHelper) Thank you very much for your help. Mov ...Show All

• Visual Studio Team System Changing passwords. Beware! :)

  If you change the pasword of your TFSService/TFSSetup/TFSReports accounts, beware. You need to change the password on the following components: Services: ====== TFSServerScheduler Sharepoint Timer Code Coverage Analysis Service Application Pools (IIS) =============== Check them all : You should change the passwords which use the TFSService, TFSSReports or TFSSetup accounts. Shared Data Sources on Reports Server ========================== Change the passwords for the OLAP and DS shared data sources, and for any other Shared Data Sources, Models or other objects as the case may be. Any other places   Please post I would imag ...Show All

• SQL Server Error when I setup website to sub level

  Hi, I am getting the following error when I use the Membeship Controls w/ Roles enabled. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS. I use ROOT>USER>WEBSITE for FTP Directory Setup. If i need to change my old ways please inform me on the best direction. ...Show All

• .NET Development SQL Express Connection Problem - Please Help

  I get the following exception from SQL EXPRESS An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) from the following three lines of code: Dim SQLConn As SqlConnection = New SqlConnection() SQLConn.ConnectionString = "server=local;database= ; user id=sa; password=;" SQLConn.Open() I am running this on a single XP Pro system. The SQL ...Show All

• SQL Server Separate date and time datatypes - come on guys!

  Oh for crying out loud, how come there aren't separate date and time datatypes in SQL 2005!   I know for a fact that this feature has been requested for YEARS!!!!  Thanks for giving me the YAGNI feature of renaming my menu items in SQL Management Studio.  I guess that was somehow a higher priority than a time datatype.   NNTP User wrote: TimeSpan supports full milliseconds.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- I'm assuming you mean the TimeStamp type which is referenced as @@D ...Show All

• Visual Studio Express Editions NC messages oddity UPDATE

  I'm using VC++ Express to create a DLL for a global hook system I'm writing. The unusual thing is that as I'm trying to catch the non-client messages I can't seem to get the to trigger properly. For example I'm trying to catch the WM_NCRBUTTONUP message anywhere on the non-client area and it doesn't trigger unless I click the tiny little border around the non-client buttons. If I click directly on the minimize button ... nothing happens except for the system menu popup, but if I click on the tiny little border around the minimize button, the callback triggers. Could anyone possibly explain this behavior to me or tell me what in the world I'm ...Show All

• Windows Forms ConfigManager filename issue

  My problem concerns using custom config files. When I load a config using 'System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration("example.config");' the manager saves to "example.config.config". How can I stop it appending an additional ".config" to the filename I have been unable to duplicate this. Are you calling (essentially) the following two lines of code... System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration("example.config"); config.Save(); In this case, Save doesn't create a new filenam ...Show All

• Windows Forms Adding Record to Details Table

  Hello, I have a form showing information from two tables which are related one-to-many as Master-Detail records (as in Customer-Order relationship).  Information is shown in two DataGridView controls, bound to the underlying database tables via BindingSources by dragging & dropping in Visual Studio. I wish to write some code which adds the first Detail record to the database whenever a new Master record is created.  Can anyone help with: Which event on which object is best to attach to How one finds the key value (and possibly other contents) of the new Master Record being created so one can add it  t ...Show All

• Software Development for Windows Vista How to use the cancel handler?

  I have two workflows A and B. In workflow A I have the instance Id of workflow B. How do I gracefully cancel workflow B from workflow A Is this where the cancel handler should be invoked How When the cancel handler completes does the workflow exit Thanks. Can we trap the cancel event raised by using ' Terminate this workflow now. ' link on WrkStat.aspx page I was trying to capture but was not successful. Please advice. ...Show All

• Visual Studio How can I get data fields to repeat on each page, since they cannot be placed in the Header?

  For example, we need the document number at the top of each page.  Also, when using a table, is there a way to make the table Header print on each page when the table goes to multiple pages Thank you. Try this: Click the row you want to repeat on each page, on the properties window, set RepeatOnNewPage to true . Good Luck. Long ...Show All

• .NET Development CLR Profiler results are conflicting

  I recently started using the CLR profiler to track down a memory leak. After playing with it for a while, I am starting to get the hang of it. However, the different screens seems to give me different resutls. For example, I am running profiling an app that opens up a dialog window with a main menu. What seems to be happening is that the Dialog form remains after it is close and even after I call dispose. Allocation by address shows "n" instance of the form. Show Heap shows only a different number of instances. The timeline shows different values as well. In the case of timeline, the manual did say that the timeli ...Show All

• Visual Basic Initialization and Finalization of Modules and ClassLibs

  Is there a way to cause Modules and ClassLibs to run code automatically under their own power when they load Or is there a better way to do what I'm doing Module A Public requingInitialization as someType ... End Module In some other systems I'm familiar with you can say Unit A ... Initialization ... Finalization ... End. which makes it very nice because the user of the "unit" doesn't have to worry about what it needs to do to provide its services. In the particular case that I'm concerned with I need a dictionary of lists for later populating comboboxes based on the tag of the combobox. What I'd really like to be able to do is combox ...Show All

• SQL Server XQuery Question

  When I run the following script.... declare @d xml set @d = '< xml version="1.0" encoding="UTF-8" > <Subsidiaries> <Subsidiary id="0"> <TypeMove id="0"> <Orders Type="1"> <OESourceID id="1"> <StageID id="10300">ODS.ProcessOrderTotals</StageID> <StageID id="10400">ODS.ProcessOrderTotals1</StageID> <StageID id="10500">ODS.ProcessOrderPayment</StageID> <StageID id="10600">ODS.ProcessOrderItems</StageID> </OESourceID> ...Show All