lokeya's Q&A profile

• Visual Studio Tools for Office Upgrading excel workbook solution from VSTO v2 to VSTO v3

  Hi all, I've an existing app working on Excel 2003 & VSTO 2.0, now I want to upgrade it to Excel 2007. The problem is that everything is different, the worksheet constructors, there are interfaces that are no longer present, the objects are different... Is there any tool to migrate the solution Any manual procedures Thanks. Hi Enrique, The CTPs of VSTO 3.0 that we currently ship do not have any migration tools at this point. The release bits for VSTO v3 will have the migration wizards in them to upgrade from VSTO v2 to VSTO v3. I do want to understand why you dont want to continue using VSTO v2 runtime The "Cypress" product will ship Office 2007 compatibility updates for s ...Show All

• .NET Development What is the best way to compare columns of 2 DataRow objects?

  Hi, I need to compare values of 2 DataRows. They have the same columns. When I tried to do this: drA[k] = drB[k] // k is an int holding the column number it did not work even though both columns had the same content because I did not explicitly specify the data type. When I used string.Compare, with ToString it worked fine. In my situation, the data row column could have any data type, so string.Compare and ToString may not be the correct way for all type of columns. So what is the general way of comparing 2 columns so that one covers all possible data types like float, boolean,...etc. without worries Thanks for your help in advance. You could try the following: If (drA(k) Is Nothi ...Show All

• Visual C++ How to create a msi file from command line?

  hi, all who knows about how to create a msi file from command line i cannot find which execute file Visual Studio was using to create a msi file. thanks. If no answers at http://msdn.microsoft.com/library/default.asp url=/library/en-us/msi/setup/windows_installer_development_tools.asp , I think you can make the MSI file using Visual Studio ( devenv.exe ) from command line, like this: devenv MySetup.sln /build ...Show All

• Visual C# How to draw this image using GDI+

  Could you show me the way to draw following image by using GDI+ Thank you very much. You need to use the Graphics.DrawPie and Graphics.FillPie method to draw a pie. Here is a little example: public void FillPieInt(PaintEventArgs e) { // Create solid brush. SolidBrush redBrush = new SolidBrush(Color.Red); // Create location and size of ellipse. int x = 0; int y = 0; int width = 200; int height = 100; // Create start and sweep angles. int startAngle = 0; int sweepAngle = 45; // Fill pie to screen. e.Graphics.FillPie(redBrush, x, y, width, height, startAngle, sweepAngle); } ...Show All

• .NET Development What Trim function do i use??

  i have this string 2004-07-31 00:00:00.0 i want to trim the underlined text off so that it only shows 2004-07-31....I used the TrimEnd and passed it an char array but that did not head the results i needed...any help on how i should do this Tryin2Bgood wrote: I found this cool function String.Remove(10, 11) that did it for me...thanks 4 the help lol one of many it seems .. glad you sorted it though :) ...Show All

• Visual C++ Const, copy constructor, collection classes and My Issue !!

  #include <iostream.h> #include <vector> using namespace std; struct First { int data; First() { } First(First& first) { data = first.data; } First& operator=(First& first) { data = first.data; return *(this); } }; struct Second { First first; Second(){} Second(Second& second) { first = second.first; } Second& operator=(Second& second) { first = second.first; return *(this); } }; void main() { std::vector<Second> vec; Second sec; vec.push_back(sec); } The problem is solved when const argument is used copy constructor and operator=. I have two questions now: 1) I dont want to use copy constructor with const argument so can some ...Show All

• Smart Device Development adding items to listview is very slow

  I have 300 items to add to the listview suing CF 1.0. ListViewItem lstItem = new ListViewItem(finalList[ i ].qNum.Trim()); lstItem.SubItems.Add(finalList[ i ].qDesc.Trim()); lstItem.SubItems.Add(finalList[ i ].qDesc2.Trim()); lstItem.SubItems.Add(finalList[ i ].qDesc3.Trim()); if ((_check || finalList[ i ].alreadyChecked) && listView1.CheckBoxes)        lstItem.Checked = true;           listView1.Items.Add(lstItem);   I clear the listview and then we see the scroll bar getting smaller as the listview is filling up. Anyway to make it faster Thanks   sorry fot the delay but j ...Show All

• Windows Forms C# Printing Problem

  Dear All, I have been tasked with the following: Firstly design a class that allows the user to enter their name. The class should contain only one method and uses the console namespace to ask the user. Once the name is obtained the method should fire an event that will initiate the printing process In the event handler, a PrintDocument object will be required to initiate printing, a seperate method that controls printing of pages will need to be created. In the print handler the name entered by the user should output to the middle of the page The print page handler will need to access the name entered, this must be done via the use of a private class field. I have developed the following code, but cannot f ...Show All

• SQL Server Problems with Roles and sp_helpRoleMember

  I have a database role named gc_stationAdmin. I have a user x who has this role granted him when via Mgmt Studio under Logins. In fact I have 50+ users who have this role. 1) when I execute sp_helpRoleMember I see only 20 users who have this role when I'm expecting to see 50 and user X is not amongst the 20 2) when sp_helpRoleMember is executed AS user X, they only see 1 user with this role (and it's not himself) 3) when I drop user X from Role using sp_dropRoleMember OR using Mgmt Studio under Login Properties, it never drops him according to Mgmt Studio. When I pull up the login properties, that role is still always checked no matter what I do...although he doesn't appear in the sp_helpRoleMember result ever. What is goi ...Show All

• Visual Basic Updating bin/debug and bin/release After Rebuild

  I am developing a VB 2005 windows app. When I make a change and then build the project it does not automaticallu update the stuff in bin/debug and bin/release folders. I can manually copy everything from the project to the bin/debug folder and then hit F5 to test my changes. There must be an option that I have not set properly but I cannot find it. IS there a way to have the debug and release files updated whenever I (re)build the project Thanks. Hmm, everything looks good. Your build trace specifically states that it copied both the .exe and the .pdb from the obj\Release to the bin\Release folder. Now, you are building the Release mode executable. When you press F5, you'd be debugging the Deb ...Show All

• SQL Server Why do I need to reference the server name now but not in MSDE 2000?

  With SQL 2000 and MSDE 2000, I only had to put a "." for the server name in a connection string. Now with SQL Express 2005 I have to acually reference the server instance name ".\SQLEXPRESS". Why is this Also, when running the command line tools for running scripts, I have to include the parameter "-S MACHINE\SQLEXPRESS" in the command line where as before I never used the -S parameter at all. Anyone know why I am curious because it is going to cause an impact on our upgrades for the client. My only answer to these questions is that there is no SQL Agent running anymore. Thanks in advance, Scott That may be exactly what happened. I just looked under registered servers and I s ...Show All

• .NET Development Regular expression best practice

  With respect to the Regex cache , is there any advantage of using a static Regex instance for frequent matching For example I have a case where I know the pattern will never change at runtime, so I figure the most efficient approach is to share a static Regex object. This is surely more efficient than creating new instances and relying on the Regex class cache <bb /> Which performance are you interested in Load time or match time. If it is match time...this discussion is moot. If it is load...according to the post you referenced Regular expressions created by static methods are cached in 2.0 as users of the static methods do not have any way of managing the lifetime of their regular expressio ...Show All

• Visual FoxPro Using database in network

  I've build a database program with Visual Foxpro, and use Visual Foxpro database/table. Example : Select 1 use c:\data\table1 But sometimes my database/table located at server drive (my network place). So I typed, for example : Select 1 use \\server\data\table1 It doesn't work properly, because Visual Foxpro cannot recognize the network drive. How to solve this problem ....thank's....... Nothing wrong with the syntax. Simple and maybe obvious questions: Is there a share in the server folder Does the program (or you) have enough permissions on that shared folder ...Show All

• Visual Studio 2008 (Pre-release) Load and modifying DataTemplate from XAML is not working

  Is there a way to write a DataTemplate in XAML, then load and modify it in my C# Code and assign it to the control where I want to use it I tried it this way: DataTemplate dt; dt = ( DataTemplate ) this .FindResource( "myTemplate" ); StackPanel sp; sp = ( StackPanel )dt.LoadContent(); ItemsControl ic; ic = ( ItemsControl )(( StackPanel )sp.Children[1]).Children[1]; Binding b; b = new Binding ( "myPropertyPath" ); b.Mode = BindingMode .OneWay; ic.SetBinding( ItemsControl .ItemsSourceProperty, b); myItemsControl.ItemTemplate = dt; But only the definitions from the XAML file are applied to the control... I've also tried to use dynamic resources und add the dynamic resou ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need help running this game.

  I have just compiled DeadJustice. It is a game using the catmother engine (http://www.sf.net/projects/catmother). From the forums I downloaded the version that supports Visual Studio 2005, once I compile and run it, it gives me an error and says that lightmap.fx is not compatible or something. I am using the version of DirectX before February 2007. Can anyone help me The shader code is below. If you want the exact error, I'll give it too you. Thanks. [code] // // lightmap shader without transparency // // diffuse texture * lightmap texture // // COLUMN MAJOR MATRICES // // -------------------------------------------- // Input parameters // -------------------------------------------- // transforms float4x4 mWorld; // model->world t ...Show All