Vinod Anand's Q&A profile

• SQL Server Previous Row Calculations (sql server 2000)

   if anyone know a way that you can look up a value from the previous row in a View to do a calculation on (in sql server 2000) for example: expr1=PreviousRow.Expr1/30 + expr2 - expr3 =100 so the next row is expr1=100/30 + expr2 - expr3 =300 so the third row is expr1=300/30 + expr2 - expr3 =100 or tell me if it not possible please and special thanks to Umachandar Jayachandran - MS for help. Hi, Im not quite sure if this is possible in a view. But you can do this in a stored proc. You can use a cursor and manually traverse your records...     cheers, Paul June A. Domag ...Show All

• Windows Forms Force update and block restore in ClickOnce?

  Can I force user to update or slient update application if a newer version is found, instead of asking user to update or skip And can I block user to restore to old version in add/remove programs I want to ensure application is up to date all the time, because it is a distributed system, client application must have the same version of file with application server in order to establish communication. Thank you very much! If you use minimum required version to mark an update as required the rollback option in add/remove programs will be greyed out for that application version. Regards, Sameer ...Show All

• Visual Studio Team System Microsoft Partner Program License Benefits FAQ

  The Partner team has provided me with the following FAQ, which I'd like to share with all of you in the hopes that it answers many of your questions. Thanks, Ajay 12/8/05 - I've updated the FAQ with a new version that I received from the partner team. This information will be making its way to the partner Web site as well. Eligible partners are scheduled to have access to Team Edition for Software Developers on 12/16. In the meantime, the Team Suite 180-day trial is available for your evaluation. We apologize for the delay. Microsoft Partner Program License Benefits FAQ   MicrosoftR Visual StudioR 2005 with MSDNR Subscrip ...Show All

• Smart Device Development Get selected text in WebBrowser (PocketPC2003 in .NET)

  Hello all, do you have any idea how could I retrieve the text that the user has selected in a Web Browser control (the one found in CF2 or the one from opennetcf.org) I want to do this so as to know what word or phrase the user has selected. I'm programming n VB .NET and the only solution I found till now is the control wrapper provided by Intelliprog.com which has this functionality. Visual Studio 2005 - Compact framework Thanx in advance, sakis. I found this response to the scenario (generally, getting text from the HTML control) in the .NET CF 2.0 FAQ on http://msdn.microsoft.com/smartclient/comm ...Show All

• Visual Studio Team System Unable To Share Files With Team Foundation

  How can I share code files between projects using Team Foundation source control   We currently share code files between projects using the full framework and the compact framework.  VSS has the ability to share, branch, and merge.  TFS only allows branch and merge. We have similar problems and the lack of shared files is a total show stopper as our whole build process relies on it. Every other version control system on the planet can handle shared files perfectly fine. You say: "If you're so sure a file will always be exactly the same in two or more projects, why not add it as a link ...Show All

• Visual Basic VB.NET 2005: Windows Service That uses a Timer to read/write registry

  Hi All! I have the following problem: Timer1: Timer1.Enabled = True Timer1.Interval = 1000 The OnStart event writes the value Blaat1 to "HKEY_LOCAL_MACHINE\SOFTWARE\Test" , "Test" But the Timer1 doesent write Blaat2 to "HKEY_LOCAL_MACHINE\SOFTWARE\Test" , "Test" Can some one help me with this problem I know it worked in VB.NET 2003 but why doesent it work in 2005 anymore THX! Public Class Service1 Protected Overrides Sub OnStart( ByVal args() As String ) ' Add code here to start your service. This method should set things ' in motion so your service can do its work. My .Computer.Registry.SetValue( ...Show All

• Visual C# ArrayList Sorting

  I have a class called ScoreValues public class ScoreValues { public string ClassName; public double Score; public ScoreValues() { } public ScoreValues( string classname, double score) { this .ClassName = classname; this . Score = score; } } Now I have an ArrayList called scoringResults. Once passing through my code, the ArrayList fills with strings and a score value. scoringResults.Add( new ScoreValues (className.ClassName, typeScore)); I want to sort the Arraylist from Highest Sc ore to the lowest score. I keep trying to want to do it programmatically, but I know there ...Show All

• Visual Basic How to control margin in Crystal Report

  Hi, I am working on crystal report. I have fully utilised the margin in form view, but in real printing an A4 paper, its margin is bigger than designed. Did I miss any setting Thanks. ...Show All

• Visual Studio Express Editions Delaying a program

  I am wondering if there is a built in function for delaying a program in C# Something akin to C++'s "System("SLEEP")". I tried typing "System.Sleep();" in my program code, but that didn't seem to compile. If there isn't such a function in C#, how would I go about writing one Seeing as I'm a complete newbie when it comes to C#, I wouldn't know this. :( Greetings. If you are not using threads, you should not use Sleep. Ever. You want to use a timer or sleep in a secondary thread. Sleep() should always be read as Hang(). Makes more sense. Sleep _will_ get you into problem ...Show All

• Visual Studio Team System Support for Win2000 AD except NT4 mixed-mode

  VSTS is supposed to support Windows 2000 ADs by the time it RTMs.  I had heard from someone though that VSTS will not support Win2K ADs in NT4 mixed-mode.  I'm not a sysadmin and I'm not sure about the terminology.  However, I would like to confirm if this is true and if so, how would I go about finding out if our corporate AD is in NT4 mixed-mode Then again, if the MMC snap-in had said "Windows Server 2003 Native" instead of just "Native", that would have helped too. ...Show All

• .NET Development ForeignKeyConstraint exception (IDE: VS2005 Beta2 June CTP )

  Hi, Using the DataSet below to test ForeignKeyConstraint I get an exception "Invalid 'Key' node inside constraint named: FK_CatId."  when read from xml file. IDE: VS2005 Beta2 June CTP Any help Thanks Roberto Juca robjuca@pobox.com /* create parent table TB1*/ DataTable tb1 = new DataTable ("TB1"); tb1.Columns.Add ( new DataColumn ("CatId", typeof (Int32))); tb1.Columns.Add ( new DataColumn ("Name", typeof (String))); tb1.Constraints.Add ( new UniqueConstraint ("PK_tb1", tb1.Columns ["CatId"])); tb1.PrimaryKey = new DataColumn [] { tb1.Columns ["CatId"] };   /* create child table TB2*/ DataTable tb2 = new ...Show All

• Windows Forms Exchange Remote Host

  How can you programmatically (VB) retrieve the exchange server remote host   For example at my company our remote host is:  test.company.com I know it and can use it in code, but how do I retrieve the name in code instead of hard coding it   We use the ASPMail function here and should the name ever change it will kill these apps.  I ...Show All

• Visual Basic DataConnection with MS Access 2000

  I am writing a small app to interact with MS Acess 2000. I have setup all the data connections and have created a form with the detail records from the databse. I now find that I need to add a few fields to the databse which is also no problem. The problem is that after I add the fields to the db, the data sources and server explorer do reflect the added fields, even if I refresh them. The Question is, do I have to create a new data connection to see the additional fields If so, will I have to redesign my form becauses the detail fields all use the initila connection Thanks for any help John ...Show All

• Visual Studio Team System Automatic Checkout not Getting Latest Version Issue

  Hi all, We're having a problem with automatic checkouts using the Beta3 TFS with VSTS 2005. When we edit code, the call is made to automatically check out the code from TFS. Unfortunately, the behavior we are encountering seems to indicate that the call to TFS isn't performing a Get Latest Version before checking out the code locally. This results in us getting "Invalid Handle" errors on check-in and having to manually step through the auto-merge tool to get things back in sync. Is there a setting somewhere that will force a get latest from the TFS source control on auto-checkout Let me know if you can help! Best Re ...Show All

• .NET Development ExtendedProperties and MSDataSetGenerator

  I have (what is I hope) a simple question: Why doesn't MSDataSetGenerator generate the appropriate code for ExtendedProperties I have a dataset XSD that contains attribute markup of the form: msprop:PropertyName="PropertyValue" but I don't see any DataTable.ExtendedProperties or DataColumn.ExtendedProperties at runtime. If I create a weakly-typed dataset and call: table.ExtendedProperties.Add(...); ds.WriteSchemaXml(...); I see the appropriate msprop: attributes in the resulting schema. Why doesn't it work in the opposite direction for strongly-typed datasets ...Show All