Zoctan's Q&A profile

• Visual Studio Tools for Office Is it possible? excel named ranges.... subtotaled?

  I have an excel spreadsheet with named ranges on it, I am total the named ranged: this is one named range column header1 column header 2 columnheader3 sum of column header2 this another column named range So what I would like to do is add another section just below this one…. this is one named range column header1 column header 2 columnheader3 ...Show All

• Windows Forms FolderBrowserDialog

  Hay folks. Last evening I succesfully installed Visual Studio.Net 2005 Beta, so I converted my main project to it. Strangly enough this 2003 project on some files there was need to change line-ending to: Windows( ) <cr><lf> ( ) A bold translation made me deactivate some debug statements. However in one of my methods I use <strong>FolderBrowserDialog</strong> th ...Show All

• Visual Studio Problem with Conditional Import inside VS

  Hello I have a .targets file that supports multiple platforms, and has 3 elements like this: <Import Condition=" '$(Platform)' == '...' " Project="..."> When I build using msbuild.exe and specify /p:Platform=... it works ok for all platforms. When inside VS, it always imports the first one, regardless what Platform I choose. I also have a dummy Platform called "BuildAllPlatforms" that invokes the msbuild task for all platforms, and that works ok in VS. If instead of the import, I literally replace the import, and add the condition to every target, propertygroup and itemgroup, it all works ok. Is this a bug in VS I'm using RC1. Regards, ...Show All

• SQL Server Querying Data from Report History

  Can we query data in the report histories So that trend analysis reports can be created. Consider there exists a report, “Shelf Position Product Wise” and it’s scheduled to be generated each day. Now we want to create another report querying the data from the history/snapshots of that report for Product Wise Shelf Position Trend. Hello, One way to do this is to render the historical snapshot using the XML rendering extension. Then, you can consume the XML emitted by the rendering with the XML data provider in a new report. -Chris ...Show All

• Visual Studio Express Editions How to print formatted text in VB Express.

  I have been reading everything I can find in the forums on printing. There is lots of good info for printing plain text and printing a single line of formatted text . What I want to know is whether or not it is possible to print several pages of formatted text with varied formatting within a single line and have the page breaks be at the end of a word not in the middle of a word If it is possible then I sure would like to see some sample code of how it is done. If it is not possible, then what is one supposed to use VB Express for I can't think of hardly any program I use that doesn't print. Thanks, Lowell How about loo ...Show All

• Windows Forms DrawIcon on Memory Graphics.

  Why will DrawIcon not draw the AlphaData on a Memory Grahics Object  I thought it was because the bitmap was 24bpprgb, but then why does the following code fail. The bitmap object is definately 32bppArgb. DrawIcon works fine a Controls Graphics Object.     Private Function AlphaIconToBitmap(ByVal ico As Icon) As Bitmap         Dim bd As New& ...Show All

• Smart Device Development where soes the emulator stores the project ???

  In my App i 'll create some sub-directories to store data. Where can i find these files / directories on my machine So i can can copy them or update thanks Sound fine, but i've data files (some with the same names) stored in an IN and OUT directory and it would nice to see them in on the PC temp dir's. But i think i've touse the real cradle to do what i want to do thanks ...Show All

• .NET Development Datalist over Datagrid

  Hi, How a datalist has an edge over datagrid in terms of functionality Thank you! Deepa! The DataGrid displays data in a table format but DataList uses templates to display items. DataList allows more customization of the rendered HTML markup than the DataGrid Control. Please check the following link for getting more information. http://msdn.microsoft.com/msdnmag/issues/01/12/asp/ Regards, Jimmy ...Show All

• Windows Forms Problem with Minimizing both Forms

  I have asked this question before but I may have described the issue a little poorly. Basically I have 2 Forms. Form1 & Form2. I start the application with Form1. On Form1, I have a button and it's click event has the following code to launch Form2. Form2 frm2 = new Form2(); frm2.ShowDialog(); When I minimize Form2, Form1 is still in the background. Now, the first question is, how do you minimize Form1 as well, when Form2 is minimized The second question is, Am I doing this the correct way What is the best practice for launching another Form Has anyone got a fix for this I'm having exactly the same pro ...Show All

• SQL Server Data Comparison Question

  I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do Thank you very much you have been excellent help I was able to do exactly what I needed. For updates should it work the same or do I have to run a check on a particular column(s) and see if they match ...Show All

• SQL Server Using custom assembly problem. Help!

  I've created C# assembly which was included into Script Task code as following: -------------------- Imports DTX55AppDefaults.DTX55ApDefaults --------------------- The ScriptMain window recognize this assembly and can see all methods with no problem. The class View window see the assembly with whole list of methods with no problems. I build the code when ScriptMain window was open and save the code. Then I close window and run the package in Debug mode. Debuger throw out exception : "Error: The script threw and exception: Could not load file assembly 'DTX55AppDefaults, Version=1.0.0.0,Culture=neutral,PublicKeyToken=null' or one of its ...Show All

• Software Development for Windows Vista Workflow Runtime and Pooling

  I'm building an application that will be used by an ASP.NET application running on a different server. I'd like to expose the workflow using remoting hosted in IIS on a seperate machine. I'm concerned about the ASP.Net application creating a new instance of the engine everytime a postback occurs. I figure I can store the proxy to the workflow instance in session, but when this application scales larger, I'd much rather expose a pool of workflow engines on the workflow hosting machine and simply connect to server each time. More or less my question becomes, Is the Workflow Runtime a pool of instances, or is there a way to use it as a pool of ...Show All

• .NET Development Why must a type be marked as Serializable to be serializable???

  I think when we want to serialize a type, we mean it. Why the Framework forces us to attribute it as Serializable In this way I have to add [Serializable] to the following simple class that contain ONLY simple privimite types, just to let it be serializable. class person {     public string name;     public uint age; }   And more worse, if this class comes from a third party class library, I don't have a direct way to serialize its instances - I have to write custom converters or wrapper/mapper classes. Can someone wise enough to explain the reasons behind this design Thanks. Yes, it depe ...Show All

• Visual C# buttons

  how do i have it so a button when clicked goes to a website Hi, Do you mean mark as i declare If so: <datatype> <variablename>; eg int var = 0; myClass c = new myClass(); string myString = "Paul June A. Domag"; As you can see its pretty much similar to C++. cheers, Paul June A. Domag ...Show All

• SQL Server Can I schedule SQL extract using SQL Server Express

  I have downloaded almost all file related to SQL Server 2005 Express edition. Before I wast time finding out that what I want to do it not possible afteral. What I want to is to connect to an SQL Server and extract data from that into my local db (Gues that will be my local SQL server db ) and than pass the data onto MS Access. My question is: can I  automate this procedure I.e. schedule to download  and export to Access using the Express Edition . Appreciate any feedback Thanks, Bogdan yes, thanks and this is the code for the batch-file Rem1 connect SLQ-Server (ServerName = SQ ...Show All