tomnmoore's Q&A profile

• .NET Development plain text serializer

  Hi there, Suppose I have plain text data in a csv file, sort of CT-3227,50,$280,07/12/1998,John Doe If I know that the entries are separated by commas, I can use a FileReader to scan for commas, create a String with the content and call Parse with the corresponding entry type (which is known in advance).  However, what happens if I encounter a number like 1,500 meaning "one thousand five hundred"   e.g. UInt32.Parse( "1,500" , Global ...Show All

• SQL Server Global search & replace stored procedure

  I am trying to work with a rather large SQL server database with a few hundred stored procedures that I inherited. In trying to understand the structure, would like to be able to search the SP text globally, and then be able to rename variables and otherwise edit the whole set of SPs will global string search/replaces (refactor). In SQL studio, or VS 2005 all i can can do is open one SP at a time. Hi, there is no refactoring tool in SQL ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Height of a picture

  I'm starting with DirectX (working with C++), and I'm loading some pictures with the function D3DXCreateTextureFromFile into textures. How can I know the dimensions of the picture I mean the height and the left. Texture.GetSurfaceLevel gives you a surface (there may be mutliple of these if you created mipmaps) Surface.Description gives you information about the surface SurfaceDescription .Height etc gives ...Show All

• Visual Studio Tools for Office It works

  Hi everybody, I know I should not run away from my problems. But what else can I do I have an VSTO Word solution. This part works fine. I also installed it on a other pc than my, and it just works perfect. But there is one small thinh that is missing. And this is where my problem starts: When the user starts "Word" for example. There shlould be a button in the "Standard" Menubar. I tired this with a shared add-in. And it also works but only on ...Show All

• Software Development for Windows Vista DelayActivity dynamic update

  Hello, I would like to ask you if it is possible to update DelayActivity.TimeDuration value when DelayActivity is executing I want to achieve scenario like this: workflow is configured to simulate delay specified in the DelayActivity. After DelayActivity starts waiting, user wants to change delay value for the running instance (increase or decrease the delay value). Applying WorkflowChanges to the running workflow instance with dif ...Show All

• Visual Studio Team System How to assign state transition to certain roles?

  I've been customizing my own template based on the MSF Agile one. I created three new project user groups (in addition to Contributos, Build Services etc) called Business Analysts, Developers and Testers. How can I limit the work item state transition to individual roles For example, I'd like to allow only Developers to move a work item from Active to Resolved. There are two attributes you can use on the TR ...Show All

• Windows Forms 'global' key events ?

  Good [insert word according to your daytime] to you, when I have a UserControl on my form, and there are some controls placed onto my UserControl, the thing no more receives key events. My UC needs to be notified whenever the Ctrl key just got& ...Show All

• SQL Server Importing unicode data from Oracle Database

  Hi everybody, i try to import data from an oracle database configured in unicode. When i run the package i have an error message Error at Data Flow Task [Source - ACCOUNT]: Column "ACCOUNT_CODE" cannot convert between unicode and non-unicode string data types. how can i resolve this regards. Thanks for your help. I have change data type in advanced editor but now i have this error the output column "ACCOUNT_CODE ...Show All

• Visual Basic Why don't all the properties work for my controls in VB express 2005 Beta 2?

  I've downloaded Visual Basic 2005 Express beta 2 and have been trying to teach myself through various tutorials and VB.Net texts.  Generally I've been making progress, but there is one major problem I can't seem to solve - the refusal of certain controls (dropped on the form at design time) to implement anything other than their default properties.  Oh, and all my attempts to use controls at runtime just don't work at all. For example, ...Show All

• .NET Development How transactions work in a nested method call without an explicit using scope

  I'm working with the new System.Transactions model in .NET 2.0, and I wanted to clarify something on the semantics of the TransactionScope.  Let's say I have the following: public void RootMethod() { using ( TransactionScope scope1 = new TransactionScope ()) { // code that hits SQL Server InnerMethod(); // code that hits SQL Server scope1.Complete(); } } public void InnerMethod() { // code that hits SQ ...Show All

• SQL Server How to view permissions of user-defined database roles in Management Studio?

  As part of our security project, I've done the following when logged in as 'sa': Created database roles 'dbrole1' within dbAccount Created login and user 'user1' and added user to be a member of 'dbrole1' Granted execute permissions on sp1 and sp2 to 'dbrole1' However, I didn't see the above permissions listed in SQL Server Management Studio - Database - Security - Roles - Database Roles - 'dbrole1' properties - securables A ...Show All

• .NET Development Database connection

  How can i change the path of the location of the database associated to a dataset at runtime Dataset objects are not associated with the database connection string, only  the connection objects such as SqlConnection, OleDbConnection and Odbc connection objects are associated with the connection string. to simply change the database location, change the connection string and fill the dataset programmatically ...Show All

• .NET Development BIG problem with huge storage procedure execute on SQL Server 2000 SP4

  Hi! I have a big problem with one of my storage procedures. First of all some information about the server: Dual XEON 4 gig RAM Windows 2003 SQL Server 2000 with SP4 On the database work at the same time 30 peoples…. But not all execute storage procedure. The storage procedure with that I have problems is executed only one time a day. The storage procedure is so huge that the SQL Server needs 11 minutes to execute it. The storage procedure ...Show All

• Visual Studio Team System [1.32 bug] Save As fails to append extension FxCop if filename contains a period

  Just a minor whinge: FxCop does not append the extension FxCop if the filename entered by the user contains a period (e.g. MyCompany.MyNamespace). To repro: - Start FxCop - Select File / Save Project As - Type "MyCompany.MyNamespace" in the File name text box and click on OK Expected result:  project should be saved as "MyCompany.MyNamespace.FxCop" as indicated in the "Save as type" ComboBox. Actual result: project is saved as "MyCompa ...Show All

• Visual Studio Express Editions array questions for a VB Learner?

  i am having problems putting text from 8 tb's on a dialog form into an array and  passing the data back to a mainform as a single object, i then want to put this object into an array of like objects and be able to display each of the values/references from a selected object in the mainform array of objects.  NE help would be greatly appreciated as i have read all the articles on arrays i can find and am still having trou ...Show All