Timpany's Q&A profile

• Visual Studio Tools for Office VSTO and C# Automation Dll

  I make use of IsWeekDay function in an C# excel automation/add-in dll (Like the example in Visual Studio Tools for Office - Carter and Lippert) in my VSTO project.  For some reason when i open the VSTO document all the calls to my automation dll show up as #NAME in the cells.  Looking in process explorer my automation dll is not even loaded into memory. Now if any other non VSTO workbooks are opened that makes use of the automation functions they too show #NAME . To make it work I must open a workbook with no VSTO code behind that uses the functions.  Then when I can open my VSTO the #NAME s resolve and call the func ...Show All

• Visual Basic panel question

  im tring to remove controls from a panel Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim ctrl As Control For Each ctrl In Me .Panel1.Controls Me .Panel1.Controls.Remove(ctrl) Next ctrl End Sub this only removes half the controls. what am i missing Thanks, dan Not sure why, but you could always just say Me.Panel1.Controls.Clear(). Hope that helps, Jonathan Aneja The VB Team ...Show All

• Visual Basic Connecting to Different servers

  I am writing an application (VB 2005.net) that will be installed on different sites; hence the Connection string needs to change depending on the location. How can get the application to change the connection string that have been setup in the Project /settings when developing the application, to a different connection depending on the Location i.e. different SQL server EG developed on Myserver\dev need to be run on newsever\prod or oldserver\UAT Initialize the connection string during setup and store the string (ie in the Registry)... Initializing the string can be done progmatically or by p ...Show All

• Visual Studio 2008 (Pre-release) BitmapSource.UpdateBitmapSourceResource Question

  I just have a quick question: I'm working on a WPF project which involves an unmanaged module which continuously generates bitmap data into an unmanged block of memory. [It's a fractal renderer!] I then create a BitmapSource object which points at this data, and a custom UIElement to render the bitmap to screen. One problem I'm seeing is that to update the screen with fresh imagery, as new data is written into the unmanaged buffer, I have to continuously create fresh BitmapSource objects from over the unmanaged data, otherwise the image remains unchanged on screen, even though the UIElement is being continuosly invalidated [My custom UIEleme ...Show All

• Software Development for Windows Vista Changing Dependency Properties from Code

  Hi guys, as I'm getting always the right answers here - I have another "simple" one. When I change a dependency property of an activity in code the WorkflowDesigner is not persisting it because it does not "realise" that the prop has changed. No matter if I do it directly like activityinstance.Property = "string"; or through activityinstance.SetValue(Activity.PropertyProperty, "string"); This is different if I change the settings through the UI using the Properties pane. Question is - what function or property will cause the WorkflowDesigner to persist the workflow definitions ...Show All

• SQL Server SQL Server Network Utility

  How do I enable / disable "Named Pipes" and "TCP/IP" protocols using a batch file rather than using "SQL Server Network Utility" on GUI mode. Please, can someone help me. Hi, simply go in regedit, export the branch to a reg file and call that at the target computer. It will be imported into the registry and will override the existing values. -Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio EXCLUDE-like command for labeling sources in VSS

  Hi all, There is possible to label recursively all projects under the root except some specific ones I have the following structure: $Root project 1 project2 project3 project4 ......... ..and many more.... I want to assign a label ‘xxxx’ to all project recursively at the root level, except project3 After running the command, I want to have project1, 2,4,5 with label ‘xxxx’ and project 3 without label. Do u know an easy way to accomplish this ( I work with VSS 6 and VS.NET 2003.) Thanks Francesco ...Show All

• Visual Studio Express Editions Cannot connect to server

  I can download the ~3mb files, but when they are run and they are trying to download and install everthing, it says that the transfer rate is 0, then goes to say that it is trying to re-establish it's connection with the server. It can't do this, and when 5 attempts to do this fail, it exits. Any ideas I am assuming that you are talking about installing the express editions from the web installer. Have you tried downloading the full img files and installing from there. Visual studio express editions FAQ http://msdn.microsoft.com/vstudio/express/support/faq/ Visual Studio Express edition Registration FAQ http://msdn.microsoft.com/vstu ...Show All

• Visual Studio Team System Issue for printing out work item

  Hi: I tried to print out the work item as the record to be kept in folder.  I found that I could not see the detailed information in History category.  Under History, it always printed time, Edited by or Created by, but no detailed information. I did print out a detail in history.  This happened in MSF for CMMI Task WIT.  After expanding in History textarea under Summary tab, right-click to print, I saw the detailed information but without other information like ID, Title, etc. I think exporting to Excel or Project might solve such issue, but I still want to print them out directly from Visua ...Show All

• Visual C++ Newbie: Can't use WinAPI because included twice

  Sorry for this lame question, but I've spent hours trying to solve this ridiculous problem. I'm trying to use the Windows API GetGUIThreadInfo, but because (I believe) it is declared twice (in winable.h and winuser.h, which I believe are implicitly included) I cannot use it. I get an identifier not found error. What do I do so I can use GetGUIThreadInfo I haven't used C++ for a long time, and I'm not sure if I ever encountered this problem before. Please help. TIA Problem fixed! Seems that the problem was in the definitions #define WINVER 0x04 #define _WIN32_WINNT 0x04 in the program's main head ...Show All

• Windows Forms Connecting Remote Server

  Hi All, What alteration in TaskVision (Client/Server) application are required to connect it from a remote location. regards Tmaora  ...Show All

• Windows Forms It debugs.. then it won't debug?

  I have spent hours today with a winform with some comboxes bound to data. And something really weird has been going on. I set some*space space*points and lately it just ignores the*space space*points.. THEN it might stop at one so I continue and I press the button again which has a breakpoint and it ignores the breakpoint Any idea what could be going o ...Show All

• SQL Server How to Insert One Row with Multiple time depding on Source Column value in SSIS Pacakge

  Hi ! I need help for SSIS Pacakge. using condtional Split How to insert One records with Multiple time depending on Source column value .Is there possible to wrtie the condition in Conditional split. For Exmaple : Source Table Name : tbl_source following Column Name: col_Name1,Col_Name2,Col_Name3, col_Id,Col_Descrip table contain only one records:GRD1,SRD1,FRD1,100,Product I want Insert the Destiantion table the Follwing Condition. using Conditional Split. 1)Cond1 (!(ISNULL(GRD1)) 2)Cond2 !(ISNULL(SRD1)) 3)Cond3 !(ISNULL(FRD1)) I need the Following output Destination Table Name : tbl ...Show All

• SQL Server Complex query involving multiple tables

  I'm attempting to create a complex query and i'm not sure exactly how i need to tackle I have a series of tables: [tblEmployee] empID empName deptID jobtID [tblDept] deptID deptNum deptName [tblJobTitle] jobtID jobtNam [tblTrainng] trnID trnName [tblTrnRev] trnrevID trnID trnrevRev trnrevDate [tblEduJob] ejID jobtID trnID [tblEducation] eduD empID trnrvID eduDate The jist of this database is for storage of training. The Training table is used for storing a list of training classes. The TrnRev links and shows each time the tra ...Show All

• .NET Development Escape Sequenze in Resource File

  Hi! I've the following problem. I've created a multilingual application and put all the strings in a resource file for each language. This all works fine so far. The problem is if there are any escape sequences in the strings like "\n". If I show this string in a MessageBox "\n" is not replaced with a NewLine. How is the best practice to accomplish this greets, Markus The problem is that you are using the string after compilation - this means that the c# compiler never gets the chance to swap "\n" for a new line. Could you split the string into two parts and add them seperately e.g. MessageBox.Show(resourc ...Show All