sgcook's Q&A profile

• Visual Studio Tools for Office regarding list object

  i have a list object in excel binded with data and few text boxes when i select a record in the list object, the data fields of that particular record should be displayed in the text boxes pls let me know Hi, Please see the databinding docs to help with this scenario. If you bind the list object and the text boxes to the same datasource this should work. http://msdn2.microsoft.com/en-us/library/3z66 ...Show All

• Visual C# Problem Installing New Windows Service

  (Not sure if this is the best forum, but I am using C# and did not see a forum for Windows Services). I have just created a new Windows Service using C#, Visual Studio 2003, .NET 1.1 on my computer running Windows XP v5.1. The whole thing compiles without any errors and when I installed it using installutil, all messages indicate that it was installed correctly. However, my new Windows Service does not display on the list of available serv ...Show All

• Software Development for Windows Vista CodeDomDesignerLoader

  My problem is getting drag drop of toolbox items when using CodeDomDesignerLoader. I have a designer hosting application that provides the workflow designer and a toolbox allowing for drag drop of toolbox items onto the designer. Everything works fine when using a loader based on WorkflowDesignerLoader and you can drop toolbox items onto the designer and everything updates fine on the display with the activity added. However when I use a loa ...Show All

• Visual Studio Team System All my unit tests pass, no matter what!

  For some reason, all my unit tests pass on one machine. I've created projects at home, including tests. But no matter what I do, all tests just pass. I rebooted, I created new projects, I did Assert.Equals(0, 1) but they just keep passing. I'm running WinXP SP2, VS2005 Beta 2 Team Suite, C# Normal thing I do is create class library, create test project, set a reference to my class library. Either give them the same namespace or specifiy a using. ...Show All

• Visual C# import/export to several formats

  Hi, I have a question about importing and exporting data for a mssql server to several outputformats. I want to create an application where the user can select some tables from a database and export the data from those tables to a textfile, xmlfile or a Word-document. (Maybe some other formats too later on if possible) Are there any known components to do this job I have tried to DTS for this, but it seems that the packages created with DTS a ...Show All

• .NET Development Passing NTLM credentials from a web application to a web service.

  I have a web application that has impersonation set to TRUE, and anonymous access disabled. The only authentication I am allowing is NTLM integrated auth. I am making a web service call to another server in the same forest. I have set the web service call's Credentials to the DefaultCredentials in the CredentialCache, yet it returns a 401 Unauthorized when I attempt to make the call. I checked the logs and it does not appear that the username is ...Show All

• SQL Server Frequent SP recompiles in proc with many temp tables

  I noticed a specific stored proc was getting recompiled quite often, so I decided to try to optimize it a bit. In the proc, there are 9 and sometimes 10 temp tables created; the tenth table is created conditionally: I F @param IS NOT NULL BEGIN CREATE TABLE #tbl ( col1 VARCHAR ( 21 )) CREATE UNIQUE INDEX XIDX_tmp_tbl_pk ON #tbl ( col1 ) INSERT #tbl ( col1 ) SELECT @param END All the create table statements are at ...Show All

• Visual Studio Visual SourceSafe Compatibility Matrix

  It looks like there is no way to use VSS 6.0d's SourceSafe Explorer to browse a VSS 8.0 data store via web services. Does anyone know of an open source equivalent that can access a VSS 8.0 data store via web services In any case, I've been attempting to verify the following scenarios. Can some please confirm this   VSS 6.0d Data Store File System VSS 8.0 Data Store File System (same as 6.0d) VSS2005 Tea ...Show All

• Visual C++ Resource Editor: Add/Remove operation is impossible '(null)' is read only

  MESSAGE: Resource Editor: Add/Remove operation is impossible, because the code element '(null)' is  read only   So, I moved files from /ProjectA/ProjectA to just be /ProjectA fixed the project settings deleted and added files to go with the changes.  My 'ClassView' contains duplicate classes CMyClass and CMyClass with two different paths one in /ProjectA/ProjectA and the new one /ProjectA; I can't delete the old /ProjectA/Project ...Show All

• SQL Server Can't Route to another LOCAL Broker Instance

  I have two databases (A and B )on the same SQL Server instance. Both have SSB enabled and running fine within themselves. All athorizations are at present set to dbo. Recently I had a requirement to start a dialog and send a message from within data base A to a queue via a service that is in database B. I tried coding the SSB instance in the BEGIN DIALOG then I set up a route and tried that. On both occoasions I got the following on sys.tr ...Show All

• .NET Development Datagrid header cut off if right aligned

  I have searched and found this question asked, but there never seems to be an answer.  In my datagrid header, if the column is right aligned, the last 1 or 2 letters of the header label are cut off.  Is there a solution for that   Thanks. I know this sounds as a joke, but appending " ." (a space and a dot) to the column title solves your problem, at least visually (the dot gets hidden behind t ...Show All

• Software Development for Windows Vista Sequential workflow 'caches' event

  Hi all, We created a sequential workflow containing the the following sequence: eventSink1 - methodInvoke - eventSink2 - code Following the normal sequence of the workflow everything works fine. However when not following the normal sequence, the workflow behaves slightly different then I would expect. When the workflow is waiting for eventsink1 and an event is fired that corresponds to eventsink2 the workflow does not continue, as expected ...Show All

• SQL Server Page Number Needed in Report Header

  I need to create a page number in a report header. I wrote a function to calculate a number, however I do not know how to associate this with a new page event. How can this be handled and is there an easier way Here is my simple function: Public Function getPageNumber(ByRef iPageNo As Integer) As Integer Dim iNo as Integer iNo = iNo + 1 Return iNo End Function Thanks, cj I don't think that will ...Show All

• SQL Server launching Report Manager url fails

  Under Books online, topic "Install client and server components on a single computer" Configure the Report Server and install samples 3. Verify that installation succeeded by launching Report Manager. In the URL address, type https://localhost/reports or http://localhost/reports . You should see the Report Manager Home page. I get in IE with url http://localhost/reports : <%@ Page language="c#" Codebehind=" ...Show All

• Visual C# How to us the FolderBrowserDialog

  FolderBrowserDialog Dialog = new FolderBrowserDialog (); Dialog.ShowDialog(); label32.Text = Dialog.RootFolder.ToString(); My problem is, I only get Desktop to lable132, but i need to get the root folder to Steam "C:\Game\Stam\SteamAmpps" If i select "C:\Game\Stam\SteamAmpps" in FolderBrowserDialog and click OK i only get Desktop... Plz help me.. ^^ RootFolder property can only ...Show All