Leonardo Reis Cortes's Q&A profile

• Visual C# Supporting automation on Old and New Excel Versions

  I would like to automate Excel but my userbase has versions from 98 all the way up to 2003... I want to make sure my program is compatible, does anybody know if a compatibility issue exists from the older versions to the new one (in respect to automation) I don't plan on doing anything complicated but I would like to have the ability to set column data types and use basic formating on headings. I'm using The Excel 10.0 com object... My only other idea was to just create a .csv file and open it up as such (which removes my ability to format): System.Diagnostics.Process.Start(@"C:\car.csv"); ...Show All

• Visual C++ Compiler option

  What's the compiler option to remove all comments (if there's one). Thanks! I don't believe comments change the size of the binary produced. If you are not talking about comments then the answer is no. Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Visual C++ cannot convert from '_variant_t' to '__int64' Ambiguous user-defined-conversion

  anyone know the cause of this error I've looked at the manual _variant_t's extrators have a conversion to __int64 so why is the compiler giving me an error I do want to run it on NT5, those are the product specs and that includes windows 2000. I'm baffled why it's ifdefed to 501, VI_8 works, changetype to VI_8 also works. I changed the ifdef to 500, I'll test it on windows 2000 to see if there are any problems with it. ...Show All

• Windows Forms calling function in form

  i have a function in form1, and i want to call it from form2.  does someone knows how can i do it make the method static public static void MyFunction() that way form2 doesn't need to know what the instantiated name of form1 is. ...Show All

• Visual FoxPro Remote View SQL 2005 REQUERY Puzzle

  Hi, I have an interesting puzzle. I'm using Remote Views in VFP9 for the MS SQL Server database access. I'm trying not to store the connection string within DBC with remote views. When I'm opening remote views I'm supplying a nStatementHandle ("USE a!b CONNSTRING nStatementHandle") from the established shared SQLSTRING connection. Everything works OK till I'm doing REQUERY() for some parameterized views. Program gives me and error: "Base table fields has been changed and no longer match view fields. View field properties cannot be set". But I didn't not change my basic table! Trying to solve this ...Show All

• SQL Server execute DTS from asp.net 2.0 - package does not exist error

  I am trying to execute a dts from asp.net, but getting an error “The specified DTS Package ('Name = 'DTS_USERS_LIST'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.” I know I have saved the dts package on the sqlserver, and have run it from the server successfully. Here is my code: Package2Class package = new Package2Class (); object pVarPersistStgOfHost = null ; package.LoadFromSQLServer( sServer, sUID, sPWD, //DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, DTS. DTSSQLServerStorageFlags . ...Show All

• Visual C# Any good examples of how to use Applications settings

  Hi, I'm trying to use Application settings to persist the size of a window between sessions in c# Express. I've tried following the help files but it's all way too complex - I can work up to comlpex once I've got something working!  Does anyone know if there is a simple 'how to' anywhere, covering the basics What code do I need to add (to save ) What are the steps in the designer Many Thanks for any help Baffled The most painless and simple example of this is at: http://www.microsoft.com/uk/msdn/events/archive.aspx#section_p5 Go to the Winforms and and Smartclients section and view the preserving appl ...Show All

• Visual Studio Express Editions How do I view Console.Writeline?

    I'm rather new to programming. I've read two VB Express books and everything that I could find concerning Console.Writeline, and yet I still cannot figure out how to view what I write to it. When I use Debug.Writeline, I can view what I write to it in the "Immediate" window. I guessed that I should be able to view Console.Writeline in the "Output" window. Is that correct I tried things like the example below, and nothing appeared in any of the windows that I looked at: ' System.Console.WriteLine Imports Microsoft.VisualBasic Imports System Public Class TipCalculator    Private Const tipRate As Doubl ...Show All

• SQL Server Adding data to columns

  Hi I'm am using SQL Server 2005 Express on my home PC. To practice some of the SQL skills I learned on a course I was recently on, I am trying to build a mini database which I can run some queries from. I have created some tables and added columns to these tables. However, I cannot find how to add data to these columns. I'm sure it's pretty simple but I just can't find it! Can anyone help Cheers! Hi, use http://www.microsoft.com/downloads/details.aspx FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en to do this with an administrative console, otherwise, cod ...Show All

• .NET Development Soap Serializer does not support serializing Generic Types.

  I tried to serialize an object contains list (List<>) of objects and I got this exception: Soap Serializer does not support serializing Generic Types : System.Collections.Generic.List. It works fine with the  BinaryFormatter. Yeah, Let me post more codes about the configuration. What I am doing here is, I have a remoting server start, also to have the capability for a client to event call back to server, we defined a delegate and an event wrapper as the book "Advanced remoting said". Here is the definition: public interface IFactory { IWorker getNewWorker(); } public del ...Show All

• Visual Studio SourceSafe detects different character encodings on different versions of the same project file (.csproj)

  Using Visual Studio 2005 with Visual SourceSafe 2005 (Version 8.0.50727.42). We have a Visual Studio project file (.proj) that has been changed 21 times, resulting in 21 SourceSafe versions. I personally checked in version 20. Now using the history and compare functions on any version (including version 21 checked in by another programmer) as compared to version 20 results in the message: "The character encodings on these files are different." It appears that the version 20, which I checked in, reflects a different encoding format from all the other version. I've looked at the properties of this file in SourceSafe, and the " ...Show All

• Visual C# Missing editor (I think !) for solution properties

  Hi ! I am new to C# (and programming generally) but I enjoyed working with  C# Express 2005 Beta 1, and made some dlls for some software I already have. This required using the properties interface to build and debug. I recently installed Beta 2. The compiler works fine, but when I click the Properties in the solution explorer I just get a message: Package 'Visual Studio Settings and Project Designers Package' has failed to load properly (Guid {67909806-91E9-4F3E-AB50-495046BE9A9A}). Please contact package vendor for assistance... Then another message about not having an editor for .csproj files. I have "repair and reinstall"ed VCS but ...Show All

• SQL Server Can't Start SS Business Intelligence installed from SS 2005 Express Edition Toolkit

  I downloaded and installed Microsoft SQL Server 2005 Express Edition with Advanced Services and Microsoft SQL Server 2005 Express Edition Toolkit. Installs completed successfully, and I can launch the SS Management Studio, but when I launch SS Business Intelligence Development Studio, I get message saying " Windows is searching for devenv.exe". When I search for this file I don't find it on my hard drive. I thought I'd reinstall the SS Express Edition Toolkit, but I can't find this application in the Control Panel Installed Programs list, so I can't uninstall it. Any ideas as to how I can get SS Business Intelligence Studio ...Show All

• .NET Development getting a connection string from a text file

  Hi I have created a small data access app. I want to pull the connection string for the SQL database from a text file. But I am getting it a bit wrong can anyone help at all   Dim connStr As String = "" Dim SqlConnection1 As SqlConnection = New SqlConnection Dim sr As New StreamReader("C:\Program Files\MDM\ScanViewSetUp\ConnectionString.txt") connStr = sr.ReadLine() SqlConnection1 = connStr Try creating your connection by passing it the connection string like so: Dim connStr As String = "" Dim sr As New StreamReader("C:\Program ...Show All

• Visual Studio Team System Working with Visual Studio .NET 2003

  I have Nokia Developer's Suite which has an add-in only for Visual Studio .NET 2003. Can I use TFS with Visual Studio .NET 2003 Thank you, Sammy Daniel is correct.  Additionally, we will be making a VS 2003 plugin for TF version control available as a download near the time version 1 of TFS ships. Buck ...Show All