Will Merydith's Q&A profile

• Visual Studio Tools for Office How to create shortcut of excelsheet

  Hi, Actually i am working on VSTO (Excel) deployment. I have successfully created setup file for my excel application & its working fine without any error/exception. Now problem is: After installation user dont want to navigate to "ProgramFile\TargetOfTheInstalledFolder" & then search for excelsheet & double click on it to open. User want that, At the time of installation there should be a shortcut of the excelsheet file (not of the folder in which application installed) ctreated at the desktop & by clicking on that shortcut, the excelsheet that installed in the installation folder get open & start working. Please help me so that I can add this feature into my setup file. Thank you ...Show All

• Smart Device Development Array.Resize

  I'm trying to dynamically resize an array of objects and getting a error: Error 1 The type arguments for method 'System.Array.Resize<T>(ref T[], int)' cannot be inferred from the usage. Try specifying the type arguments explicitly. D:\Code\CSharp\StuntFighter2000\StuntFighter2000\StarField.cs 89 17 StuntFighter2000 I'm confused what this means my code is: Array .Resize( ref cStarArray, 210); cStarArray is declared as: private Array cStarArray = Array .CreateInstance( typeof ( Star ), 200); Any thoughts This might work Star [] cStarArray = new Star [200]; // instead of Array.CreateInstance( typeof( Star ), 200 ); Array .Resize< Star >( ref cStar ...Show All

• Windows Forms Designer won't accept custom ToolBoxItem on drag drop

  I successfully created a Tool box that uses the plain ToolboxItem and I can drag items from my toolbox to the design surface just fine. I need to customize the object before it gets to the design surface. Like say, set the color or something. From my reading, it seems the way to do this is with a custom ToolboxItem. So I made a class derived from ToolboxItem, but when I drag it over the design surface it won't accept the item. Two questoins 1. Is building a custom toolboxitem the correct way to go about this and if so 2. How do I get the design surface to accept custom toolboxitems ADDITIONAL INFORMATION FOR OTHERS: In case you are having this issue, I solved it by doing the following ...Show All

• SQL Server Which should be installed first SQL Server2005 or VS2005

  Hello, Need help about which should be installed first. Because I am trying to install SQL Server2005 the following message is comming. Uninstall the previous versions of Visual Studio, .Net framwork or SQL Server.. I have no SQL Server so I unstalled the .net framwork. Now I have only Visual Studio 2005 Professional on my system, but the same message occurs when I try to install SQL Server.....uffff I have to uninstall Visual Studio too And then have to install SQL Server first and then Visual Studio Hi Avols, By Default, when you install Visual Studio, one of the check buttons is for SQL Server Express edition. This is what you need to remove from your machine in order to install S ...Show All

• Visual Studio 2008 (Pre-release) InlineUIContainers not firing any events in the RichTextBox

  Hi, Up until the June CTP, I was able to trap events from elements inside a InlineUIContainer, e.g. // Wherever you create the InlineUIContainer Canvas can = new Canvas(); can.Width = 80.0; can.Height = 20.0; can.Background = Brushes.Blue; can.PrevewMouseMove += ........ InlineUIContainer uiCon = new InlineUIContainer(can); This used to work find as any delegate added to the elements (even though the InlineUIContainer was "Disabled") would fire. Now it doesn't. Can someone please help me Thank you very much, Jaco That is very strange, so is there any reason why the control inside the InlineUIContainer can't be disabled, but still fire events (I know its a b ...Show All

• SQL Server Calculating last non empty of measures that are not included in a month

  Hi! I have two tables. One is measures like this Product Measure Date Prod A 10 12, Jan 2006 Prod A 15 20, Jan 2006 Prod A 11 5, Mar 2006 The other is time dimension When I create a cube, I would like to see by months last value of measure. So in Feb I should get 15. My question is - should I create a query and run it on server to 1. Find which months are not icluded in measuers 2. Then find last value for each product 3. Write into new table measures, where February will have last non empty value from January Or can I do it cube in some way ...Show All

• SQL Server ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC source When I try to use OLE DB Destination it does not give me an option to use .Net Provide for ODBC. I tried other "destinations" with no luck. I use this version of SQL Server 2005: (Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86) May 24 2005 18:22:46 Copyright (c) 1988-2005 Mi ...Show All

• Visual Studio Team System Do shelvesets save all workspace file versions?

  When you shelve does it save the current version information for all files in your workspace, so that you can be sure to get back to where you were when you shelved The typical example is I am working on some files but need to work on a different issue, I shelve my current changes, then do a get latest to make sure I'm in sync, make my new changes, checkin then unshelve the code I was working on previously. The question is would my workspace be rolled back to the point prior to me doing get latest or would I potentially have files out of sync at that point (sync I was editing the files I shelved possibly related to early versions of other files in my workspace.) I don't think I hit a scenario like this yet, wondering if that i ...Show All

• Visual Studio Team System Paging in Reporting Services

  Hi, I was wondering if any1 no's how to get pagin in Reporting Services in terms of Page 1 of 2 Page 2of 2. I can only manage to get page numbering like 1, 2, etc... does any1 now how i can do this.. many thanks in advance but any work around to make use of it in the body area because it says 'These global variables can be used only in the header and page footer' i need this because i have a report where i need to show a subreport along side the group subtotal on certain page numbers :-) ...Show All

• Visual C++ static const array of CString

  Hi, I've a problem with an initialization. I would like to have in my class an array like this: static const CString rgszColumns[26]; And I would like to initialize it in my costructor: Myclass::Myclass() { const rgszColumns[] = { "aaa", "bbb", "ccc" ....}; } why this code doesn't works   Salvatore Di Fazio wrote: Where I must fill the array, inside the constructor The static rgszColumns member must be initialized outside the class in a .cpp file:   const CString Myclass::rgszColumns[] =                    { _T("aaa"), _T("bbb"), _T("ccc") }; &n ...Show All

• .NET Development connection string problems

  I have 2 projects, 1 as the UI and another as the DB and DB connections. I originally used it to connect to a local MySQL DB and the connection string looked like: public class dbCommunication { string dbConnStr; string dbName; string HostIP = "127.0.0.1"; string uname = "root"; string pword = ""; MySqlConnection myConn; MySqlCommand myCommand; MySqlDataAdapter myAdapter; DataSet returnds; public dbComm() { BuildConnectionString(); } private void BuildConnectionString() { dbConnStr= "database=" + dbName + ";" + "host=" + HostIP + ";" + "username=" + uname + ";" ...Show All

• Internet Explorer Development Persistent cookie overwrite session cookie

  In this code: <!-- Begin code --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd "> <html xmlns=" http://www.w3.org/1999/xhtml " xml:lang="es-ES"> <head> <title>cookie</title> </head> <body> <script> function setCookie(name, value, expires, path, domain, secure) { document.cookie = name + "=" + escape(value) + ((expires == null) "" : "; expires=" + expires.toGMTString()) + ((path == null) "" : "; path=" + path) + ((domain == null) "" : "; domain=" + domain) + ((secure == null) "" : &quo ...Show All

• Visual Studio Tools for Office Post It Note Type Comments Control In Word Document

  I knew there was a reason I was looking at VSTO, I have a C# Windows App, and I am showing the user a Word doc using the DsoFramer control for viewing and editing. All this works fine, what I would like to know how to do (and I do not know if an AddIn or a WordProject is my best bet) is how do you create a "Post It Note" type control allowing the editor of the document to "Add Post It Note" , and also veiw other comments that were previously created. (preferably in a yellow balloon or box like a "Post It Note"). A super plush would be a way to toggle "View Comments - turn them all on if they are there - and Hide Comments - make them all invisible if there are any. Another plus (or point to note) is ...Show All

• Software Development for Windows Vista Event raising in workflow ?

  Hi Can my workflow have some events that I will handle in my application [for example windows forms code] I have application that should run in infinite while loop and stop for one hour after each succesful execution. So I would make while with with true condition and on the and of sequence I'd put Delay activity. But how do I know what's going on in my workflow if it never ends It will finally be used in Windows Service so it should be running every our do what it has to do and than go idle... But for now I'd like it to communicate with me by some messages. So if certain conditions happen I'd like to have an event raised. Can I do such thing in workflow If yes, tell me how :) Jarod Hi, The ...Show All

• SQL Server Load Ordering for Dimension and Fact tables

  Hi , I have situation where I get data from SRC Flat file and have to load Dimensional table and also fact table, using same data flow(have no other choice since I have to unpivot some src data). Since I have to load both tables in same data flow, I have to have a way to put load ordering constraint (I know informatica allows that). Does any one have any idea on how this can be done in SSIS I would be really grateful. Thanks The SSIS package designer contains a Control Flow tab and a Data Flow Tab. On the Control Flow tab, you would create two Data Flow tasks linked by a precedence constraint. The first task would load the dimension data and the second would load the fact data only if the first task succeeds or completes dep ...Show All