Stefan Tresch's Q&A profile

• Windows Forms regarding microsoft.office.interop.excel(how to copy a excel sheet single cell content and paste them to cell present in another

  hi, i need to know how we can copy a cell content from one excelbook and paste that to another cell present in another workbook.note : iam having 4 to 5 sheets per workbook so i have to locate the sheet also.... can you give any sample.... Thanks. I found this Microsoft KB article. It's in VB.NET: http://support.microsoft.com/kb/306022 Here's the same thing in C#: http://support.microsoft.com/kb/306023/ ...Show All

• Visual C# Save Before Exit?

  So I have a text editor I'm working on. One of the things I need to add is where when you close the program, if one or more of your files aren't saved, it will ask you if you want to save them before closing, and it gives you the options "Save", "Don't Save", or "Cancel", the last telling the application that "sorry, I didn't mean to close". Is there a tutorial or something that I could read to learn how to do this Before you close your form, you can use the Form.FormClosing event. This way, if you click on the X in the upper-right or you your menu exit, it will still throw this event. Here is a quick event handler that I wrote to illustrate how to keep the applicat ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Anyone know any good 3D (for 2D) programming tutorials?

  Hiya, after playing with XNA, I decided my best bet would be to delve into DirectX using c# and the SDK, I've looked at loads of tutorials regarding programming a 2D game, and mostly (and surprisingly), I understand whats going on! :) The problem I have is that nealy all the well versed tutorials I've found for 2D in Managed DirectX are based on DirectDraw, which for most of my understanding, is obselete! Can anyone point me in the right direction on how to setup Direct3D for 2D game programming in C# e.g. links to tutorials, examples etc Any advice would be great! Thanks in advance Dabz   P.S. I'm not sure if this is in the right place, if it isnt, sorry about that!   Thanks for the links Glenn! :) ...Show All

• Visual Basic Firing new event in existing control?

  Hi, I'm new to Visual Basic 2005 (Express Edition) and I' decided to build my own PrintPreviewDialog using the PrintPreviewControl. One of the properties of the PrintPreviewControl is the Zoom Propertie. Unfortunately, the control doesn't provide a ZoomChanged event and I need to know when this propertie is modified (by the user, by the program or by resizing the control). Is there a way to trigger a ZoomChanged event everytime the value of the Zoom propertie change I created a new UserControl that inherit from the PrintPreviewControl but I'm not sure where to go from there. That is incorrect. What you are referring to is the "overrides" keyword, not the "overloads" keyword. However, for that ...Show All

• Visual Studio 2008 (Pre-release) Create an svc file

  Please forgive the beginner question, but I have been going through the help and all the examples that come with the SDK and for the life of me I cannot find, or figure out, how to create an svc file for my WCF service. I understand that they only need to be used when hosting the service in IIS which is what I am trying to do. Any help is greatly appreciated. Scott There were a couple of issues getting the Visual Studio extensions for NetFX 3.0 out the door in time for the July CTP, which might be why you haven't heard of them. There will be a new drop forthcoming as part of the Vista RC1 release, so stay tuned ( http://netfx3.com will have the announcement when its release). In the mean time, an .svc file is really just ...Show All

• .NET Development opc automation

  I am trying to develop an opc - da client using .net. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Hello, To create an OPC DA Client different solution exist. it depends on you dev skill and the performance you need : The best way is to use custom interface see OPC Specification for detail. Easier you can use the OPC Automation wrapper Easier, and the best way for .Net you can use the OPC .Net API available for OPC Foundation member you can use some commerciale tools Regards Michel4CE ...Show All

• .NET Development Asynchronous Receive Method and Threads

  Hello All, I have Asynchronous method to read bytes from the network stream. I wrote below code 2 months ago, now when I come back, I wonder why I used "while(true)" for backgroundWorker. Are there any alternative method to use asynchronous read method with backgorundworker Or the method written below is OK receiveBackgroundWorker.DoWork += new DoWorkEventHandler(Receive); private void Receive(object sender, DoWorkEventArgs e) { while (true) { dataTransfer.Reset(); clientStream.BeginRead(receiveBuffer = new byte[socket.Available], 0, socket.Available, new AsyncCallback (AsyncReceiveDataCallback), clientStream); dataTransfer.WaitOne(); } } private void AsyncReceiveDataCallback ...Show All

• .NET Development Reading file size and then store the name, date and size in database

  I'm trying to make a program that basically say that every morning run this directory and scan through all the files. Then record the name, size and the date and then compare with the one that already existed in the database. If everything is match then pop up message say GOOD. If something has been changed then pop up a message say NOT GOOD. But aslo if i know that there was an update on the file so the date has been changed, that program should also have an update function to update the database. For instance File1 800kb 7/18/2006 File 2 1mb 7/17/2006 because this is the first time i run this program so i have to insert this into the data base. so after inserting, the database will have a list of file 2 and 1 with ...Show All

• Visual C++ Convert System::String to Double in Managed C++

  Hi, I am just starting to use Managed C++ in Visual Studio.NET and I have a problem converting a System::String to double. I have this code: System::String^ money = txtMoney->Text; How do I do to make money a double I am grateful for all answers /M double foo = System::Convert::ToDouble(money); ...Show All

• Visual Studio 2008 (Pre-release) Cool feature for Orcas

  Hi! What about having multi-lines #region...#endregion when minimized I don't like commenting my code line per line and prefer having it surrounded with comments instead. That way, it makes the sources more readable by enabling switching between code and comments. For example: MyMethod() { //Instantiates a new service x = new ...(); x.blablabla(); x.blablabla(); //Subscribe this form to the service events x.Subscribe(this, ...); //Connect the service to other instances for replication for (); x.blablabla(); x.blablabla(); x.blablabla(); x.blablabla(); } Isn't it nicer to have this instead MyMethod() { [+/-] Instantiates a new service [+/-] Subscribes this form to the service events [+/-] Connects ...Show All

• Visual Studio Team System Error: Additional code analysis warnings or errors cannot be displayed

  I'm getting a couple of errors consistently when I enable Code Analysis on my ASP.NET Web Project in VS 2005 RC1.  The build fails, and around 200 warnings from FxCop are displayed.  Here are the errors: Error 204 CA0503 : Additional code analysis warnings or errors cannot be displayed Error 205  FxCopCmd.exe returned error code 8.   I looked up error code 8 for FxCop, and found it to be an "Assembly load error".  It did give me a couple of other errors related to the loading of external referenced assemblies (which do exist locally): Error 1 CA0055 : Could not load XXXXXXX.dll. I can't understand what the problem is.  Those DLLs are in my project's Bin, and when I unc ...Show All

• SQL Server SQL Server Express 2005

  I have a developer version of SQL Server 2000 on my pc and wondered if I can install 2005 Express on the same machine without wrecking my 2000 installation. Is there anything I need to do differently Unfortunately this pc can only run Windows 2000. Does express take up much room Also, how do I create a restore point in case of problems thx, Kat I believe you should be ok but don't quote me as I have not used the Express edition but shouldnt differ much with SQL 2005. As for restore points, Windows 2000 doesnt have that feature, the feature was implemented with Windows ME and XP and Vista. Be sure to backup your databases just in case, if anything goes wrong you can uninstall it and re-install/repair the other installed ver ...Show All

• Windows Forms Date Range for Data Grid

  Hello Could anyone please help me. I have a form and a datagrid. I want to attach a query to the data grid so that it displays content between 1 date range and another. Firstly I am using an access database so on the query I use for teh filter I use = for teh date field which then creates a toolbar an a little text box to enter the date. What I need to do is have an option to pull data into the grid using a date range instead. If anyone can help it would be great. Thanks Joe so you only want to calculate data from the data shown in the datagridview I believe you would have to iterate through that column on the datagrid and add the values as you go along. ...Show All

• Visual Basic "Cannot access disposed object" - Object is NOT disposed!

  Module Startup 'create the instances of the form at this level so we can talk to it Public gamescreen As New frmBehrendopoly Public auct As New Auction Dim mainscreen As New MainScreen Public Sub Main() Dim frmWelcomeNew As New welcome Dim scrsize As New ScreenSize Dim frmplay As New Players Dim frmplyNames As New PlayerNames frmWelcomeNew.ShowDialog() 'Displays Splash Screen scrsize.ShowDialog() frmplay.ShowDialog() frmplyNames.ShowDialog() mainscreen.ShowDialog() 'Displays main Form End Sub End Module This code worked perfectly under VB.net 2003. After converting the project to VB 2005, I get the error "Cannot access disposed object". The error refers ...Show All

• Software Development for Windows Vista Enumerating Audio Source Lines in Vista ?

  hi, What Interface or API to use for enumerating Audio Source Lines (i.e Line IN, microphone, phone Line, CD Audio) In Vista Anis, this was answered offline, but the answer is: You can't. Here's the rest of my private email to you on the subject: If you want to set the volume of the audio device, then the IAudioEndpointVolume is what you want. The "source" lines that you used to see on the mixer APIs are only used for certain VERY specific scenarios (for instance, the "CD Audio" source line is only used when playing back CDs using the analog cable output from the CD rom drive – to my knowledge, no non-home built computer has shipped with this cable connected in almo ...Show All