Léo Gagné's Q&A profile

• Visual Basic Documents in VB.Net

  Just like a picture box shows a picture...I would like to know how could i show a picture of a word document in an application... If all you need is to open a Word Document in Word, then you can use Process.Start(). For details on Process.Start with a VB code snippet take a look at the following thread: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=77106 If you need to programmatically use the Word Object Model, read the following KB Article: http://support.microsoft.com/default.aspx scid=kb;en-us;316383 From VB you can open an instance of word with a document loaded using something like the following. Dim wordApp As Word.Ap ...Show All

• Windows Forms About KeyPress functions in Visual C# 2003

  Hello I have an question to the forum about the eventargs used by the "KeyPress" eventhandler: In this there is a property example "IsNumber()", which has number in the function. I have some textboxes where the text should only be letters and then no numbers and others only number no text. 1) The question is can you open this build in functions and create my own function to this Because if I would use "Backspace-Key" and write number, then I should use both "ISNumber()" and "IsControl()", so I hope someone can telle that you can create your own function and use these build in function as template (Example so I get both something fro ...Show All

• Visual Basic Export data to excel

  What code do I need in VB6 to take numbers from boxes in my display and append them to the end of a excel sheet , i would like to do it once per day and have it just added onto the end, so that I can graph the data later. Thanks Ryan, from http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21195163.html Write (appends data to an existing file): Dim intFileHandle As Integer Dim strRETP As String strRETP = "Hi There" intFileHandle = FreeFile Open "path to file" For Append As #intFileHandle Print #intFileHandle, "---------------------------& ...Show All

• Software Development for Windows Vista Persistence without serialization

  Hi, I would like to write my own PersistenceService but dont wanna use these serialized data in the db. Lets say I write a issue tracker where I want the ticket workflow be handled by workflow foundation and these workflow is a state machine. So I have a table issue where all data about the issue is stored. I normaly implement the state machine on my own and use a int for the current state in this table. Lets say I only handle one kind of Workflow, the issue-workflow, and only want to save the current state (as varchar) to the db. So when loading the workflow I don't deserialize but just create a new instance and set the state. My first ques ...Show All

• SQL Server Access SMO objects in CLR proc

  I would like to write some CLR procs that use SMO objects. In visual studio I am unable to add refrences to the SMO objects. How can I do this Thanks Bert Because CLR was designed to work within the SQL Server engine the references available for a CLR assembly are limited. The assemblies actually run within the SQL Server context, not as operating system processes. What would you want to do using SMO that you can't do using Transact-SQL ...Show All

• Visual C++ Importing enum under C++/CLI

  I am trying my first attempts with C++/CLI but I have a minor problem. I am building a wrapper usable by all .NET languages which is importing unmanaged C/C++ code and is linking with a custom library file. I am creating a ref class as: public ref class CMyTest { public:  int Init() { ...call old style function } } This function returns an integer. This integer is encoded as a old style typedef'd enum: typedef enum _errors { .. } Errors; I would like the client code to look like this: CMyTest ^test = gcnew CMyTest; if (test->Init() != CMyTest.EnumError) ... Is there any way to get this old style enum to become a type inside my wrapp ...Show All

• Visual Studio Visual Studio 6.0 on Win XP

  I have just purchased a new computer. It uses Windows XP Media. I need to have Visual Basic installed. I have a copy of Visual Studio 6.0 that I never used before. When I run the setup program I receive an error stating that it can not be installed. But under programs, I can see the following components under Visual Studio 6.0: Microsoft Visuao Studio 6.0 Tools Microsoft Visual Basic 6.0 Microsoft Visual C++ 6.0 Microsoft Visual Foxpro 6.0 Microsoft Visual Interdev 6.0 It looks like Visual Basic is working. If I select the About Box shows Visual Basic 6.0 (SP 5). Will this copy of Visual Basic work correctly u ...Show All

• Visual C# How to serialize unexpected complex type contained in class being serialized.

  Hello, hope you can help me, I can't get instances of SomeNode serialized using the XmlSerializer()   public class SomeNode {     public object Data = new CustomDataType(); } public class CustomDataType {     ... }   I'm trying to have a serializable tree-arranged collection of nodes, each node can hold an object instance of custom type (similar to the TreeNode.Tag property for example). When all the custom data is null I can serialize all the tree well (by serializing the root node - passing root node object to the method below). However when SomeNode.Data ...Show All

• SQL Server XQuery to SUM multiple XML fields

  select SUM ( B . n . value ( '.' , 'decimal' )) from _Daily_Index cross apply FormXML . nodes ( '/A/value' ) B ( n ) WHERE CompanyName = 'A CORP ------------------------------------------------------------------------------------------------------------------------------ select SUM ( B . n . value ( '.' , 'decimal' )) from _Daily_Index cross apply FormXML . nodes ( '/B/value' ) B ( n ) WHERE CompanyName = 'B CORP' Each of the above Select statements will sum xml nodes found in multiple rows of an SQL table. If I want to combine the results of both Select statements and then r ...Show All

• Visual C++ error C3861: 'snprintf': identifier not found

  Hello everyone, When I tried to compile a C++ files in Visual Studio 2005, I got this error: C3861: 'snprintf': identifier not found.  I suspect some standard C lib are missing but not sure what they are. Can someone please give a pointer thanks a lot for your help.   Its _snprintf or the corresponding new safe function would be sprintf_s http://msdn2.microsoft.com/en-us/library/ce3zzk1k.aspx ...Show All

• SQL Server Grant Showplan to <user>

  I was trying to review some query statistics and received the following message: SHOWPLAN permission denied in database Test I gave the user permission by the following command: Grant showplan to user. I am curious as to how much perfomance does this effect Is there an alternative regards The SHOWPLAN permission only governs who can run the various SET SHOWPLAN statements. It doesn't impact performance of the server per se. And with some of the SHOWPLAN statement in effect, the statement(s) is not executed and goes through compilation phase only. There is no other alterna ...Show All

• Visual Studio inbuilt Report Designer(CR)

  Hi All, I want to incorporate feature in my application where users can Design/Modify Reports at runtime from within my application. My application is developed using BV.NET 2005 and inbuilt Report Designer(CR). How can I incorporate such feature ...Show All

• .NET Development Setting ScrollBar width

  Hi, I am using a ListView in my application, it is having scroll bar as the number of items in the listview is greater than the height of the ListView, now the width of the scroll bar is set as same as there in the windows display property. But i want the width of my ListView's scrollBar to be much lesser than what is set in the window's display property, how shall i set the width of the Vertical scroll bar Please suggest me some solutions. Thanks and Regards, Benin. ...Show All

• Visual Basic Create File In Windows Service App

  How can i create a file in windows service I am working on a windows service application. I want to create a filestream ( File.Create(Path)) but i get an access denied error.   I tried to create a "Windows Service" with c# , it works fine Locally , But it can't write a file on a shared Directory on the LAN , the Exact statment: Copy("c:\Sourcefile.txt" , " //\\10.0.0.20\sharedFolder\filename.txt",true)   I can do so from any windows application , but Windows service always gives me : 'System.UnauthorizedAccessExeption' occured in mscorlib.dll and additional info : 'Access to the pa ...Show All

• .NET Development Register ATL control.who can help me?

  I have created a ATL control with c++.net 2003. I find the control can be registered on local PC by regsvr32.exe,but it can't be registered on other PC. Why You are probably missing ATL.dll. By default, ATL requires this DLL for the registration component. You can eliminate this dependency by adding the _ATL_STATIC_REGISTRY #define to your project. ...Show All