Fositron's Q&A profile

• SQL Server Valid Scope Values for the function RowNumber(Nothing) ??

  Hi there I have a sales report that is pulling up data and displaying the detailed lines and the aggregate/summary lines grouped by a single field. THe report say has 10 summary/aggregate lines and each summary lines have a maybe 20 more lines to it. I want to NUMBER the SUMMARY lines only. In a new column on the summary line cell, if I type, =RowNumber(Nothing), I get a count of all its sub-lines displayed. How can I limit the scope of numbering to just the summary lines and make sure it does not include the sub lines involved This does not appear to work. I, too, am attempting to number each group but still get a count of records within the group. The number does not change when I add the group name. Any other suggestions ...Show All

• Visual Studio Team System Unreferenced component WebtestFramework

  Warning 1 The referenced component 'Microsoft.VisualStudio.QualityTools.WebTestFramework' could not be found. I have tried re-installing VSTS, but am seeing this when I try to build a project with a web test plug-in. While this worked at one time, I cannot say when it started failing. Thanks, Tom Uninstalling VSTS and .Net 2.0 framework, then re-installing them did not work. I tried manually re-installing into the GAC (see below) but they still do not work. It lists the assembly in VSTS when I try add refernce .Net, but it then shows up under references with a yellow alert, and when I try to build I get the same error. C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemb ...Show All

• Visual C++ CTime alternative in WinForms apps

  Is there a CTime alternative for use in Windows Forms application For example, instead of using CTime's FormatGmt(), is there an alternative in the managed class library ...Show All

• .NET Development Debugging C# scripts with Mdbg

  I am developing a scripting environment for an application. The basic structure is as follows: 1. HostApplication ( launches the script environment) 2. ScriptEnvironment( provides the environment to create, execute, and debug scripts) 3.Scripts( implements behavior that execute against the domain model in the host application). 4. Scripts will be written in VB or C# What I want to do is to use Mdbg to debug these user created VB or C# scripts; I would prefer to have the debugged script to be in the same process as the HostApplication. Though it is not clear as yet; what I have read seems to say it can be done. Meaning that the scripting environment would have to invoke the debugger (Mdbg). Does this approach ...Show All

• Visual Studio Team System How to log worked time for each work-item?

  Hi: I want to use VSTS to log time for each employer, and generate related reports. Does VSTS provide and how Thanks Ron There is no built-in mechanism for this purpose, but there are few options: - Using custom links to store this information - one link per logged time - Using a longtext field in workitem to store this one-to-many data in xml format. Optionally using a custom control can give a rich UI to edit/view such information. In either case, the reporting isn't clean and needs work. In future versions we will have much better linking story to store such data and do rich queries. ...Show All

• Software Development for Windows Vista Custom State Activity with Custom Designer

  I have a custom activity which inherits from StateActivity. I implement my own FreeFormActivityDesigner and override the OnPaint event. When using a the state workflow designer either in VS or the re-hosting example the OnPaint event gets called and the shape is correctly painted while dragging the shape to the designer surface. However after dropping the shape it is not rendered even though the properties show up in the property sheet. I have looked at the FlowChart custom designer code but I must be missing something. If I drag and drop the shape in a sequential workflow it renders just fine. Any help would be greatly appreciated. smc750 So, if I create a custom StateActivity (MyCustomStateActivity) and set designer to [D ...Show All

• SQL Server ALTER TABLE ADD Column question

  This has always puzzled me, so I really just wanted to know if it's possible through T-SQL. TableA has 3 columns: ColumnA ColumnB ColumnD Is there anyway through T-SQL to add a new ColumnC *between* ColumnB and ColumnD. ALTER TABLE TableA ADD ColumnC [varchar](1) Thanks. SQL Server GUI might be updating the System Catalogs Instead of the above procedure, In that case It will be faster than the Normal procedure ...Show All

• .NET Development How to xml serialize a value type designed to appear as a simple type.

  Hello, I wish to serialize a struct called Real that is designed to hold a numeric value and appear as a float or double in expressions, you choose the target type at compile time. It shall serialize using XmlSerializer just as it was a float/double type and that's the problem. (Btw. It comes from a friend project (Axiom 3D, http://axiomengine.sourceforge.net/wiki/index.php/Main_Page )) Let's make a simplified example of such Real datatype: using Numeric = System.Single(); //here you can choose public struct Real { //value storage private Numeric _value; //constructor public Real( float value ) { this._value = value; } //implicit conversion operators public static implicit operator R ...Show All

• SQL Server SSIS package

  Hi, I created a SSIS package and saved in SQL server. But now I can't find where is the package stored Have anyone know this Thanks in advance and I suggest the following topic as well. http://msdn2.microsoft.com/en-us/library/ms137916.aspx ...Show All

• Visual Studio 2008 (Pre-release) DP of type BindingBase and XAML

  I have EditorBinding dependency property of type BindingBase in my class ViewerEditor. When I set it in XAML to some Binding, it is null afterwards. The result is the same whether I specify {Binding Path=MyPath} or {StaticResource MyBindingInResourcesKey} or <Binding/> syntax. I need to get a BindingBase from XAML and manipulate it in code. When I specify the binding in .Resources, I can find it through FindResource, but is it possible to get it directly from EditorBinding DP Like this <ViewerEditor EditorBinding="{Binding Path=Name} "/> and it is in DataTemplate for ListBox item. But now I do it in diffrent way without directly modifying Binding like this: <View ...Show All

• Visual C# SqlParametersCollection only accepts non null paremater types

  Trying to pass parameters to an Sql Stored Procedure I got this error (the first parameter: Table name): SqlParametersCollection only accepts non null parameter type objects, not String objects. I do not understand it. I do have string parameters and I have null parameters, some of them may well be null. What am I going to do about it Thanks. Ok guys, this may be my last ditch effort for tonight. I am still kicking. I think I get an error over this concoction, although I am not sure. Is it correct L1Quote.DateTime = Convert.ToDateTime ( Encoding.ASCII.GetString ( Data, i, 14 ).CompareTo ("yyyyMMddhhmmss")); Now that ( Data, i, 14 ) is a byte subArray of length 14. Data is defined as byte[] Data = byte[some ...Show All

• .NET Development how to access the database report using asp.net c#?

  1)if im creating the report at microsoft access..how actaully im going to access the report 2)if im using dataReader to display the records from database...how should i actally do it while(dtrData.Read()) { display records.... } how to code the print, page navigation,go to page,zoom and so on using asp.net c# can anyone help me..thanks im using web matrix thanks........if i format manually... if im using dataReader to display the records from database...how should i actally do it while(dtrData.Read()) { display records.... } how to code the print, page navigation,go to page,zoom and so on using asp.net c# can anyone help me..thanks im using web matrix ...Show All

• .NET Development Connect to a Sybase Adaptive Server Anywhere ISQL Ver. 7.0 database using ADO.NET 2.0

  Hello all, can anyone tell me what the recommended way is to connect to a Sybase Adaptive Server Anywhere ISQL Ver. 7.0 database using ADO.NET 2.0 1)What database provider should be used in terms of performance and framework support 2)I am creating a web application that needs to connect to the Sybase db. I am storing the connectionstring information inside the web config file. ie: < add name="REPORTS" connectionString="Protection Level=None;Integrated Security=SSPI;User ID=;Data Source=cc4db2;Provider=ASAProv.70;Cache Authentication=True;Persist Encrypted=True;Impersonation Level=Identify;Mask Password=False;Persist Security Info=False;Initial Catalog=;Extended Properties=;ASA Multiple Results=False;Location=;Encrypt ...Show All

• Visual Studio Visual Studio 2005 Service Pack 1 Beta

  Has anyone else tried to install the beta of Visual Studio 2005 Service Pack 1 Just running the setup program hogs my machine. It literally took over an hour, maybe more, for the message box to come up asking me if I wanted to install it. I tried it around 4:15pm yesterday and since it was still going even past 5pm I just left work figuring it would be installed by the time I came back in the morning. Well, I'm back and all I see is the message asking if I want to install. I say yes and then a few minutes later it comes back saying I have to uninstall the Web Application Projects addon because the release version is included in the service pack. Great, I hit OK and now I have to start all the way over! I've never seen an install program h ...Show All

• Visual Studio Express Editions MediaPlayer for VB Express??

  I am looking for a device that was included in VB 5.0 called MediaPlayer. So far I have been using it to detect several parameters from Audio and Video files like: Duration, Screen Size, Encoder etc. These data are used to update my (MS Access) database. If it is available in VB Express, I have not been able to find it. But I need to have it because my old VB 5 files do not compile (in Windows XP). Thanks for your effort. ...Show All