Mr Fluffy's Q&A profile

• Visual Studio Express Editions Visual Basic 2005 Express, MS Office 2007 Beta, and Excel .Net Reference

  I downloaded and installed Microsoft Office 2007 Beta and have discovered a problem with the Excel .Net references when working with VB 2005, but can't find where to report it. The 2007 version causes overload errors in the part of my code that accesses Excel. I had to reload the Excel 2003 .Net advanced option and load Excel 2007 without the .Net advanced option to get rid of the errors. This is my first experience using a Beta product from Microsoft and I thought I woud be able to find a link easily to report things like this, so if I'm just looking in the wrong spot, I would appreciate being redirected. Thanks! Cindy ...Show All

• Windows Forms IssueVision.msi cannot find my SQL instance

  I downloaded both the VB.net and C# version of IssueVision.msi to check out, but during the initial setup process neither one can locate my running instance of SQL on my local machine. Has anyone had this type of problem If so, how do you fix it I would really like to review this application. Thank you for your help. Nice one John ...Show All

• .NET Development .Net Oracle process error

  hi This is regarding a performance issue in my windows application... Maximum possible process in my oracle server is 150... Sometimes my users wont be able to log on to my application since it exceeds maximum processes.. so we have to restart my oracle server.... Can anyone suggest the best practise to avoid this...im using Visual studio 2003 and coding in VB.Net Thanks i wil change the exception to oraclexception... i tried to debug closeconection method..no exception in that code... i hav heard abt using key word in C#... will the result b the same if we write the same code in c# with 'using' block and..when ...Show All

• SQL Server User-Defined Datatypes based on abstract classes

  I am trying to create a set of spatial datatypes for SQL Server 2005. Each datatype inherit from the abstract class "Geometry". ie.   public class Point : Geometry   public class Line : Geometry   public class Polygon : Geometry ...and several more. The reason for using the abstract class Geometry, is that they all share a common set of functions that return a Geometry object. For instance   Geometry Intersection(Geometry g1, Geometry g2)   bool Geometry.Within(Geometry g2)   Polygon Envelope(Geometry g) etc.. The problem is that when I deploy the assembly to the database, I'm told that the Parameter "Geometry" ...Show All

• Visual C++ Microsoft Visual C++ Runtime Library error question

  I recieve this error when I launch Internet Explorer - version 6.0 OS Windows XP Home edition 2002 Service Pack 2.  Error is as follows: Microsoft Visual C++ Runtime Library Runtime Error! Program C:\Program Files\Internet explorer\iexplore.exe This application has requested the Runtime to terminate it in an unusual way.  Please contact the application's support team for more information. I am not certain where to post this question and problem.  Your assistance is greatly appreciated.  Currently, I am using Firefox as my back-up web browser.  had the problem with runtime error, removed google tool bar, ...Show All

• SQL Server Intersecting Drillthrough results - an MDX challenge

  Hi, Anyone have any guidelines on how to intersect the results of 2 or more DrillThrough operations In other words, say, if I drillthrough on Cell1 and get Factkeys: 1 to 20. I drillthrough on Cell2, and I get FactKeys: 15 to 30. Now what I want is to run my MDX Select query, which returns only Cell1 and Cell2. Then I want to do an ' Intersected Drillthrough ' operation, which should give me the intersected Factkeys: 15 - 20. This is the common set of keys from the two drillthrough resultsets (1 - 20) and (15 - 30). Thanks, JGP ...Show All

• Visual Studio Express Editions Creating a Database in Code

  I've tried 3 (three) different scenarios to create an access MDB file from code. I can "create" the MDB file successfully using ADOX, after I added a COM reference to it for my application. My first attempt to create tables was a blind alley. I was using DataTables, and I couldn't find any way to have the DataTable create itself in an OLEDB. The second one was to use a create statement in OleDBCommand and then perform an ExecuteNonQuery. This option met with limited success, as long as my create statement was brain-dead. I am attempting to define default values for a couple of columns (user_name or user, getdate, etc.). Even ...Show All

• Visual Studio 2008 (Pre-release) Can't stop StoryBoard

  I am creating an animation in procedural code. Nothing fancy, it just rotates a canvas. I initiate the animation like this TheAnimation.From = 0; TheAnimation.To = 360; TheAnimation.RepeatBehavior = RepeatBehavior .Forever; TheAnimation.Duration = new Duration ( TimeSpan .FromMilliseconds(2000)); // 2 secs per revolution SpinCanvas.BeginStoryboard(TheStoryboard); How can I stop it The sample code in the SDK ( How to: Control a Storyboard After It Starts) suggests that this will do the trick, but no dice. TheStoryboard.Stop(SpinCanvas ); Is it taking me too literally on the "Forever" part ...Show All

• Visual Studio Team System Satellite Assemblies not available during unit test runs

  I am trying to set up a unit test that references an assembly that has satellite assemblies.  When the unit test runs, the language-neutral assembly is copied to the Out folder correctly, but the satellite assemblies are not copied. As a workaround, in the deployment section of .testrunconfig I included “<Solution Directory>\UnitTest\bin\Debug\” which contains the assembly and its satellite assemblies in sub folders.  This configuration worked fine on my local machine but failed on the TFS server with the following error: C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.ta ...Show All

• Visual Studio Express Editions C# Interface Class

  Can someone explain how to use C# Interface Class and show me a simple example. Having difficult time getting my head around this. thanks Nick In what way are you having a difficult time with them An interface is simply a generic declaration/definition of a set of the public methods, properties, events, etc that any class implementing the interface must itself have. By using an interface (or any base class) you can have a reference of the type of the base class or interface to a more complicated type in memory and access only those methods that are part of that interface or class. Does this answer your question If no ...Show All

• Visual C# Changing File Permissions

  I have a file that I want to copy to a different location. Sometimes the files will be marked as ReadOnly. I want to change the permission to not read only and then copy the file and change the permission back. Is there any way to handle this Here is how I detect the attribute: string file = @"C:\File.jpg"; FileInfo info = new FileInfo( file ); if ( (info.Attributes & FileAttributes.ReadOnly) != 0 ) Console.WriteLine( "Read Only" ); else Console.WriteLine( "Nope" ); Something like this: FileInfo sourceInfo = new FileInfo("source. ...Show All

• Windows Forms Doubleclick interrupted by MessageBox

  Hi, in my app I use a TreeView control. Single click means selection of an item and filling some information about it to some different window. Doubleclick does the same plus the item is moved to the root of the tree. So far so good. Problem is that during the process of "filling information" about an item, some exception may be thrown. I use MessageBox to present the exception to the user. But the MessageBox "eats" the second click of doubleclick if some exception occurs. Is there some simple way to use doubleclick reliably or do I have to write my own form for MessageBox, handle its Click event, test if it means a Doubleclick and manipulat ...Show All

• SQL Server Comparing two dimensions

  Hi, I'm writing an MDX query in VS2003 (using RS2000) with AS2000 and I want to know how can I just display the mesaures for the members of a dimension that are equal to another dimension. For example, If I display dimension1 and dimension2 I get (not all of the members in both dimensions are equal): Cat - Cat Cat - Dog Cat - Car Cat - Horse Dog - Cat Dog - Dog Dog - Car Dog - Horse Car- Cat Car- Dog Car- Car Car- Horse Horse - Cat Horse - Dog Horse - Car Horse - Horse But I really want to get: Cat - Cat Dog - Dog Car - Car Horse - Horse I've tryed using FILTER and I can't make it work, need help here. When I try to use INTERSEC ...Show All

• Visual Basic Trouble reading bits.

  I am trying to read a byte from a certain address in a file. But, I am trying to read the byte in bit format (bits 0-7). I have tried to use the BitConverter and the BitArray classes but I cannot figure it out. I am pretty sure that BitArray is the one I need but there are no methods that look like they would do anything I want. Maybe I am just missing it. I checked the help section but the examples there were not what I am trying to do. Any help would be greatly appreciated.   Remember I was saying were going to demonstrate how to set bit 3. in binary, setting bit 3 would look like 00001000   = 8. ...Show All

• Visual Studio Team System What is the design purpose/usage of Test List in Test Manager of VSTS?

  Dear all, I have a question. What is the design purpose/usage of Test List in Test Manager of VSTS Users can create Test List in Test Manager, but one test case cannot belong to more than one test list at the same time, which is inconvenient. Sometimes, we want to the test list only at a view/logical level, that means, one test cases can belong to different test list. Therefore testers can select the test list they want and run the test. Does VSTS support such kind of functionality Thanks, Hello, Leon Zhu Test case can   belong to more than one test list at the same time. You should click right button on the ...Show All