Shyne79's Q&A profile

• SQL Server Excel problem

  I am trying to import data from sql server to excel. it creates a new worksheet with name 'mytable' and excel file also has 3 sheets (by default as well). when package is executed, Data gets transferred first time. When I try to execute package again it gives me an error - that Table 'mytable' already exists. To solve this I added another task before it creates the table ('mytable' sheet in excel), where I drop this table with the statement " DR ...Show All

• Visual Basic Serialization of a control

  I hope I ask this question clearly enough so someone understands... The basic goal is this: I need to be able to serialize all the properties of a control, which is added via CODE at DESIGN time so the control can then be re-created and all properties set at run time. Did that make sense Ok, here is a simplified example: Private myControl as Control Public Property Control as Control Get Return myControl End Get Set (val ...Show All

• SQL Server Problem with nested try catch blocks in SQL 2005

  hi All, Code: begin try begin transaction trans1 //some transaction begin try begin transaction trans2 //some transaction //Raise Error //commit transaction trans2 end try begin catch //Raise error end catch //some transaction //commit transaction trans1 end try begin catch //Rollback trans1 end catch] ...Show All

• Visual Studio How to implement CODE SNIPPET by native code?

  Hi, Our language service is COM components written by native code. We want to implement CODE SNIPPET. Someone have told us how to implement that function in MPF. But we can't use the languagesevice.dll file correctly in our project. It seems that we have to inplement the interface IVsExpansionProvider by ourself, But there is no valid help information about this interface in VSIP document. Could any one give us some advice Thanks. Best ...Show All

• Visual C++ Problem In MFC AppWizard(exe) 2

  my code is like this: double kk; kk=1234.123; bb.Format("%d",kk); pOUTPUT->SetWindowText(bb); The output from the program above is not 1234.123. How come like this Is %d incorrect Please help me solve this. This control might help you out: http://www.codeguru.com/Cpp/controls/editctrl/maskededitcontrols/article.php/c3915/ Tom ...Show All

• Visual Studio Tools for Office .Net 2.0 Windows Application in Outlook2007

  I am calling .NET 2.0 windows application in Internet Explorer 6.0 using the <object> tag in a summary.htm. the tag in summary.htm looks like this <object id="myComponent" classid="http:WA1.exe#WA1.UserControl1" height="500px" width="500px"> </object> where WA1.exe is the .NET 2.0 windows application and WA1.UserControl1 is the class of a user control in the WA1.exe The code works fine ...Show All

• Windows Forms Ignore , reject or remove one row from dataset?

  Hi, I bound a dataset to a datagrid to represent a detail table for a master in a form. Two rows changed in datagrid/dataset One deleted and the other Added .  I want to ignore , reject or remove the second row from the dataset b ...Show All

• Visual Studio Tools for Office Table insertion in Word

  Is there a way to override the table insertion tool in Word Here's a little background on what I'm trying to do. I want to check to see if the current point in the document is hidden before the table insert happens. I want to insert a blank space before the hidden area when a table is inserted. I'm basically trying to prevent the user from inserting table in hidden areas. Since there doesn't appear to be a way to detect when the cursor is place ...Show All

• Smart Device Development wcebar.h for CcecommandBar

  HI, I am trying GUI with MFC using visual studio 2005 beta 2. It seems that it is missing everything i have ever know. Now after CBitmapButton, it is missing wcebar.h for CcecommandBar. I think that it isn't missing, it just merged with other header than can you show me a little Thank you so much Now visual studio 2005 using CCommandBar instead of CCeCommanbar. You can see other change in www.msdn.com ...Show All

• Smart Device Development Installation of Compact Framework 2.0 failed. Why?

  Hi all, can somebody tell me why my installtion of the cf 2.0 on an HP 2490 PDA failed Log file of installation: 26/02/2006 23:14:42: Entered Install_Init(). First Call: Yes Previously Installed: No Installation folder is: '\Programme\.NET CF 2.0'. 26/02/2006 23:14:42: Build 2.0.5238.00 26/02/2006 23:14:42: Device CPU: 'ARMV4I', 05020000 (84017152) 26/02/2006 23:14:42: PocketPC 5.01 26/02/2006 23:14:42: Our trust lev ...Show All

• Visual Basic Reading INI files

  I tried using search and the help feature in vb 8 but could not find any matches on this subject. I want to read info from an ini file. Is there an API I could use to get this done Or is there an easy way to do it with vb 8 Thank you. You could use the GetPrivateProfileSection API to try and read a section. If it does not exist (i.e. couldn't be read) then create it. However, if it was read, then it exists and you shouldn't create it. I do ...Show All

• Visual Studio SolutionDir macro in post build event

  Hi, I have a project with a post build event that looks like:     copy $(SolutionDir)$(ProjectName)\$(OutDir)*.dll $(SolutionDir)DestFolder My MSBuild file lookes like: <Project DefaultTargets="Build" xmlns=http://schemas.microsoft.com/developer/msbuild/2003>     <PropertyGroup>         <SolutionFile>MSBuildIssue.sln</SolutionFile>     </Pr ...Show All

• Visual Basic compile questions, help needed

  How to fix the errors. Thank you. F:\>vbc upload.vb Microsoft (R) Visual Basic .NET Compiler version 7.10.6001.4 for Microsoft (R) .NET Framework version 1.1.4322.2032 Copyright (C) Microsoft Corporation 1987-2002. All rights reserved. F:\upload.vb(5) : error BC30002: Type 'Scripting.FileSystemObject' is not define d. Dim fsoSaveFile As New Scripting.FileSystemObject ~~~~~~~~~~~~~~~~~~~~~~~~~~ F:\upload.vb(6) : error B ...Show All

• Visual Basic using a timeout for file.exists

  When I use the file.exists in visual basic, if the file in fact does not exist or there is a firewall involved, etc.... the time to return a value is longer than acceptable for my program. Is there a way I can use a timeout I would like to check to see if the file exists but only if it can give me a return within 2 seconds, for example. Thanks, Arkman5 Hi Arkman5, I haven't experienced a long return time with File.Exists. Are you ...Show All

• Visual Studio Final Year Project

  My Final Year Project for my degree is to create a Visual Studio Add-in that improves the intellisense. However, I'm having a few problems. When I compile and run the code generated by the add-in wizard, the thing loads into the IDE perfectly, however, when I add code to deal with key presses, it fails to work. Here are some code samples: public void OnConnection(object application, ext_ConnectMode connectMode, object addInInst, ref Array custo ...Show All