Johnny O's Q&A profile

• .NET Development Can I run a 16-bit app on Windows Vista?

  Hello, The title says it! Thanks. Hi, As of now Virtual PC cannot be installed on a 64-bit OS. Virtual Server 2005 SP1 which will be released soon supports 64-bit Windows as the host OS. Regards, Vikram ...Show All

• SQL Server SCD and populating dimensions and facts

  Hello, This is my first task in attempting to populate a fact and dimension table from SSIS. I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row. I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer dimension. I am filling the customer dimension by using the slowly changing dimension. If I have 2 records having same BusinessKey but each with a different first name, where first name is set as a ...Show All

• SQL Server Custom connection manager doesn't show up in VS?

  I've created a very simple custom connection manager, and I followed the deployment instructions at http://msdn2.microsoft.com/en-us/library/ms345276.aspx .  Basically, that was just copying the assembly to %programfiles%\Microsoft SQL Server\90\DTS\Connections, and then registering the asssembly in the gac. However, when I open VS, right-click on the connection manager pane, and then choose new connection, my custom manager does not appear.  What am I missing Here is the class: using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; using System.Data.S ...Show All

• Visual C# About Conditional Compilation Constants ?!

  Hello all, I will transfer the project from VS2003 to VS2005. Is there any Conditional Compilation Constants   has difined for VS2005,so we needn't difine it and use it directly. I hope some one has been write the code like this: VS2005 is defined by me in the properties of the project #if VS2005 //comiple with VS2005 #else Compile with VS2003 #endif A better way is to do this with project templates. Armand du Plessis has done something here: http://dotnet.org.za/armand/archive/2005/11/01/47857.aspx ...Show All

• Visual Basic Which to use: file deletion methods in vb.net 2005

  I have a routine that deletes files.  I want to know the following about the various delete file options to decide what to use.  1.  I understand that my.computer.filesSystem.DeleteFile  allows you to send a deleted file to the recycle bin.  Do any other file delete commands allow this  2.  Does my.computer...deletefile, or file.delete, or fileinfo.delete or kill.delete  allow deletions of files on the network computer from a computer on the network or on the network server itself Thanks Suzanne Haig       "My.Computer.FileSystem" i ...Show All

• Windows Forms IDesignerHost CreateComponent Method

  Hello Everybody I am having a bit of trouble with this method, I have downloaded the Custom Forms Designer sample project at http://msdn.microsoft.com/msdnmag/issues/04/12/CustomFormsDesigner/default.aspx but am having a lot of trouble working out what is causing the createcomponent method in the Idesignerhost based class to be called. When I try calling the method bypassing, a control is added to the form but is not visible. hope you can help us on this one. regards ronnie Please post your solution as it seems that anyone who dares playing with IDesignerHost and CreateComponent on a Web Form ends up ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual Basic vs Visual C++

  This is a question that has long lingered about my mind - Which language is better for DirectX, Visual Basic or Visual C++ I have been using Visual Basic for a long time now so that is the language that I am used to. I have dabbled some in Visual C++, but it was Version 3.1, so in all fairness, I haven't really learned Visual C++. As far as Visual Basic is concerned, I'm running version 6.0 Professional. The problem is that there aren't many resources that I can find for Visual Basic and DirectX. I even checked out a book at the library and it has the same flow as the rest of the resources I had to scour for. It goes something like thi ...Show All

• SQL Server Creating aomething similar like SCD wizard interface

  HI, I created a script component that is doing some transformations and it works very well. Now, I want to use the same script component on other dataflows in order to use it with other tables. Since my script component uses three outputs and some of my dimensions may have sometimes 50-60 columns, and the fact that I need to customize the column names used in my script, I would like to be able to have some kind of wizard like the SCD wizard to create columns into the outputs based on a list of columns that the user would and and input some columns (historical attributes, etc) into my script component logic . Has anybody did that before, o ...Show All

• Visual Studio Team System Building with multiple projects in different files

  We have 2 Team Foundation projects with their own source control. Data Access - DataAccess.proj Application - Application solution file - Application.proj We are attempting to make a build type for the Application Visual Studio solution. The solution has 2 Visual Studio Projects in it. Application.proj and DataAccess.proj. The problem we are having is that the build type when executed is not able to do a get latest version on the DataAccess project. I am assuming this is because it resides in a different Team Foundation project. Does anyone know of a different way around ...Show All

• Visual C++ Just one more conversion question, please.

  I need to get the lResut into _bstr_t type so I can concatenate with other _bstr_t type string to form the DN for creating an Active Directory object. Please help me with this and I hope this is the last conversion I need for this code. Thanks a million! p.s. I assme the lResult in the 2nd SendDlgMessage points to a string of the name of the item selected in the comboBox. Is this correct typedef LONG_PTR LRESULT;//From windef.h LRESULT lResult; lResult = SendDlgItemMessage(hwndDlg, IDC_LIST_CONTEXTS, CB_GETCURSEL, 0, 0); int *intIndex = ( int *)(lResult); if (lResult != CB_ERR) { lResult = SendDlgItemMessage(h ...Show All

• Visual Studio Tools for Office How can I call a managed code extensions function from another project?

  I have a Excel Workbook project in Visual Studio with a sub like DoSomeComplexThing(parameters) as code-behind. I wan't to call this function from a windows forms project. In the windows forms project I create and reference a new excel.application, then open the workbook, but then I don't know how to call the function. I wan't to activate a function in my workbook with some parameters supplied by the windows forms app. Is this possible Is there some kind of excelApp.ExcecuteDotNetCodeBehind("DoSomeComplexThing",parameters) or something like that Thanks, Hector Hi Hector, There is no ...Show All

• Visual Studio Express Editions Visual basic buttons control html buttons

  I need to be able to have a user input test into a text box and then press a button that then inputs the text into a text box on a website ad then the ok button to click the webite button. Help please ...Show All

• .NET Development How do I find a value inside an Excel spreadsheet?

  Hi all, I am trying to use the Excel.Range.Find method on a range object in order to find a particular value inside an Excel spreadsheet. However, everytime I execute the find method it throws an exception that says, "Find method of Range class failed." I don't know why this is happening. Here is a snippet of my C# code: using Excel; string workbookPath = @"C:\someworkbook.xls"; Excel. Application excelApp = new Excel. ApplicationClass (); excelApp.Visible = true ; Excel. Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false , 5, "" , "" , false , Excel. ...Show All

• SQL Server Problem Installing SQL Mobile 2005 Tools

  I'm trying to install the SQL Mobile 2005 Server tools on a Windows 2003 Server with IIS & MSSQL 2000 sp4. I've stuck .NET 2.0 on already, but the installer for the server tools Sqlce30setupen.msi just goes straight to the last page of the wizard and says the install was interrupted. I've run the install with logging turned on and this is the last portion of the trace. Can anyone shed any light on whats going wrong. -------------------------------><------------------------------------- MSI (c) (9C:14) [14:12:35:912]: Doing action: FindRelatedProducts Action start 14:12:35: FindRelatedProducts. Action ended 14:1 ...Show All

• Visual Studio Express Editions C# retrieve database

  I am using Visual Studio 2005. However, I faced some problems in retrieving data from SQL server database. I intend to extract a data from and show it on a label,but i could not do that. It is not same like VS 2003, could someone help me about this thank you very much~ Hi, it can run well if you access the database as a remote database from all your applications (Client Applications). Weclome! ...Show All