Ed Reid's Q&A profile

• Windows Forms Copy and Past Excel spreadsheet

  I want to create a Windows Forms application that can be used to copy a spreadsheet from MS Excel and paste the contents into the winform.  I also then need to be able to add and remove rows and columsn. I am relatively new to .Net and Windows Forms programming so please forgive if the question is pretty basic! Regards, Wallace You need to develop and Excel Interop. and connect to the Excel spreadsheet in code.  Excel.Worksheet.Range( A1,AX) should give you the value of the rows covered.  You can then take that object and dump it in a grid or whatever.   ...Show All

• Visual C# How To Send a Mail Using CDO 1.21 with C#

  Hi I try to write a console application in c# whichs sends a mail using CDO 1.21  (I can't use a smtp server). I found a good description for j++ ( http://support.microsoft.com/kb/216723/en-us ), but don't know how to write the cdo parts in c#. I could logon to my profile, but I wasn't able to create or send a message. I would be very happy for a code example which shows how to send a mail using CDO in C# (just a simple console application would be great). Thanks for any help. Ralph The non-simple part of MAPI is also exposed as C functions and structures, so you should be able to wrap i ...Show All

• Visual Studio VB.NET Intellisense when using VSS

  I added a VB.NET project to Visual Source Safe 6.0d and observe that intellisense is no longer functional. Is there a way to restore VB.NET intellisense when opening a project from Visual Source Safe in VS.NET Dan I cant get to repro this on VSS6.0d and Visual Studio 7.1. Like Roman said, you should try re-building you solution. ...Show All

• Smart Device Development How to run visual studio 2005 beta 2 project EXE on a smartphone device

  I am developing applications for a smartphone using visual studio 2005 beta 2. I am unable to run my dotnet exe on my smartphone device.Does it needs any framework to be installed If So,how to install and where to install that frame work Thank You, Amar. That's expected should you try to run NETCF V2 application on SP 2003 which has only NETCF V1. Make sure you're using V1 project type unless you have WM 5.0 SP (not likely unless you got hold of some engineering sample). If your device is SP 2002, it's not supported. ...Show All

• Windows Forms Screen Transition with DirectX

  Hi everybody, I have been developing a graphics application using DirectX 9.0. I am a beginner at this graphics programming. My application is a kind of screen (Windows.Form) designer that users could design graphics elements within a screen as they like. The graphics elements are scrolling text, pictures, video, and so forth using DirectX components. After they design&nb ...Show All

• Windows Forms move a form without the title bar code taken from microsoft game example

  Public Class MainForm Dim matrix As Guid Dim score As Integer = 0 Private mouseOffset As Point Private paused As Boolean = False Private isSoundOn As Boolean = True   Private Sub Form1_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles MyBase .MouseDown mouseOffset = New Point(-e.X, -e.Y) End Sub Private Sub Form1_MouseMove( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles MyBase .MouseMove If e.Button = Windows.Forms.MouseButtons.Left Then Dim mousePos As Point = Control.Mou ...Show All

• SQL Server Extracting month, day, year from dates

  I need help in building a Select statement for an ODBC connection to an AS400 DB2 system. I am using this Select statement for SQL Reporting Services. Unfortunately 15 years ago one of the main datatables on the AS400 was set up splitting the transaction date into THREE FIELDS! One for Month, one for Day and then one for Year. I need to take yesterday's date and somehow use this in my WHERE statement to connect the transaction records that are in this AS400 table. This is what I have now that is not working: WHERE QS36F.BRDMST."BREED#" = QS36F.DOGOWNR.BRDCOD AND (QS36F.DOGOWNR.TMONTH = "MONTH"(GETDATE() ) AND ( ...Show All

• SQL Server Synchronisation using web service for PDA application

  I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service. The reason for going to webservice is based on the client request. Will anybody help me on this, how to perform conflict management etc. Hi again Perhaps you could give me some more information. What do you exactly mean, with web service (sync over http://......... ) best regards ...Show All

• Windows Forms Connect to Yahoo search

  hi is there a way that i can send a word to yahoo search from my application and get the results displayed on my application  thanks Yes, but depending on how you wish to use the service it might be a viable option. I would also caution Sami in culling the search results from Yahoo without also entering into a similar agreement& ...Show All

• Software Development for Windows Vista Checking the status of a running workflow/orchestration.

  This question is really more about BizTalk than WF but with the obvious similarities (and the complete absence of a BizTalk forum) I thought I'd post it here. Really it's a simple question, I would like to be able to have an application check on the status of a running orchestration based on a correllation set. Is there a way to expose a web service end point that can look up the status of running workflow/orch instance. I'm guessing there is based on what BAM is doing but I'm trying to figure out if there are limitations before I dig deep into trying to figure this out. Any help is much appreciated! Thanks! This is a WF forum so ...Show All

• Visual Studio Team System DeclareEventHandlersCorrectly

  TypeName: DeclareEventHandlersCorrectly CheckId: CA1009 Category: Microsoft.Design Message Level: Error Certainty: 95% Breaking Change: Breaking Event handler methods take two parameters. The first is of type System.Object and is named 'sender'. This is the object that raised the event. The second parameter is of type System.EventArgs and is named 'e'. This is the data associated with the event. For example, if the event is raised whenever a file is opened, the event data typically contains the name of the file. I have two questions : Why must the arguments be named "sender" and "e" Why must the ...Show All

• Visual Studio Tools for Office Excel interop The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))

  Hi All, I am working on some excel automation logic. Basically it writes some values into various cells and runs a macro. This is to be repeated for each record in the database. for e.g. if the database has 100 records the macro has to be run 100 times after pumping values into cells. My problem is the application runs fine upto around 80 records and from there it is giving the following error and finally application is not able to close the workbook. The Excel.exe process is still running. If I give 20 records each and run in 5 batches no problems. The error is System.Runtime.InteropServices.COMException (0x80010105): The server ...Show All

• Visual C++ code doesn't working, help.

  In Win32 project i have a code, that simmulating a left mouse click on Windows Start button and it work very well: #pragma comment(lib, "User32.lib") Add that just after the #include to <windows.h> (or anywhere else you find convenient for that matter) Alexxey wrote: In Win32 project i have a code, that simmulating a left mouse click on Windows Start button and it work very well: ...Show All

• Visual Studio Tools for Office edit -> delete on excel disabled, after excel vsto installed

  I have created a excel project utilizing VSTO 2005 and now I have installed it on different computer to test it. It works great on their computer and does everything it is suppose to do. The issue is now when the user’s tries to use their regular excel the “Edit-> Delete” is disabled. Any ideas, why And how to fix it… Thank you Hi You can try and run this snippet in a VBA command window and that should reset the commnadbars in Excel. Sub ResetCommnadBars() For i = 1 To Application.CommandBars.Count Application.CommandBars(i).Reset Next End Sub This should restore your command bars to their original sta ...Show All

• .NET Development Compensator and Transactions problem.

  I have a ServicedComponent (with [Transaction(TransactionOption.Supported)]) set on it. One of the methods has the following code in it: using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required)) { System.Transactions.Transaction txCurrent = System.Transactions.Transaction.Current; Clerk clerk = new Clerk(typeof(Transactions.FileSystemCompensator), "Create Batch", CompensatorOptions.AllPhases); ... } As soon as the Clerk .ctor is run I get a COMException with the following text: "The transaction has already been implicitly or explicitly committed or aborted (Exception from ...Show All