PrashaG's Q&A profile

• SQL Server Invalid length parameter passed to the SUBSTRING function

  Hi all, I am having a weird issue after we upgraded our DB server to SQL 2005. I have a SP used to extract exchange rate, and a job calls this SP daily. This job worked fine on SQL 2000, and works very well in Management studio if I call this SP seperately, but failed in sql job in 2005. The error statement pointed to: select left(@row, charindex(',', @row)-1), REVERSE(left(@reversedrow, charindex(',', @reversedrow)-1)) The error ...Show All

• Visual Studio Team System Team Build Error using external references to virtual drive

  Hi, I have a team project that uses external references to the virtual drive 'V'. The drive is correctly mapped at the Build Machine. The build fails with the following error: Solution: InventorySolution.sln, Project: Base.csproj, Configuration: Debug, Any CPU C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(0,0): warning MSB3245: Could not resolve this reference. Could not locate the assembly "xxx.Diagnostics.Tr ...Show All

• Visual C# Dynamically changing an image!

  Hi, Can anyone help me solve this problem. I need to dynamically show different images on a web page without refreshing the page. Plz tell me how this can be implemented. It would be great if you could provide mw with the code too. By the way i'm using C# as code behind. Thanks & Regards, Ken Then you need Javascript to do it. You can also take a look at AJAX , there are some good free libraries. ...Show All

• Windows Forms Add button control inside DataGridView

  1) I would like to show my table in the DataGridView and allow the user to edit some of the fields which are integer type. I need to put two buttons next to the value. One of them is to add 1 to the value while the other one will minus 1. It's idea to put the add button on top of the minus one. However, I can't find any good reference on how to do this. Please advise. 2) Moreover, how can I control the button behaviour I've tried adding the D ...Show All

• Visual Studio Express Editions Visual basic 2005 express app with XML data store

  im writing a small app to track rental bookings and im considering using XML files as the data store. anyone know a sample application or good online tutorials for doing this the main reason for doing this is to remove the dependency on SQL due to the size of the app, but if anyone can convince me otherwise i would love to hear from you :) thanks   hi, if your app will be used much i mean in a ...Show All

• Visual J# High School Teacher needs help

  Hello, I am a high school math teacher and my students and I am having difficulties getting my first java applet to work for my students using j# 2003.   I have successfully written applets in miscrosoft visual j++ and want to run some of the same applets with j#.   Here is my problem.   I would like to run the same applet found at http://www.mrpowell.net/progra/java/example1.htm   But can not get the applet to run. & ...Show All

• Visual Studio Tools for Office VSTO Installation included in Visual Studio 2005 Team Suite

  Hi At the end of the installation I get an error message saying that vsto couldn't be installed, and propose that I run VSTOR.EXE manually. Running VSTOR.EXE I get an error message saying that I need to uninstall "Visual Studio .NET prerequisites - English", but I don't have that. From the support page ( http://msdn.microsoft.com/vstudio/express/support/uninstall/ ) I downloaded the uninstall tool, even if I never installed beta version before. ...Show All

• SQL Server SP permissions under SQL Server 2005

  I am just migrating to SQL Server 2005 and I am having difficulty figuring out how to do some tasks that were easy under SQL Server 2000. Specifically, I am not sure about object permissions. (This is what I did for SQL Server 2000) For database access by my web application, I added a SQL login for the IIS_WPG group. I then added a database user (name ASPNET) associated with this database login and give it only datareader and datawriter privil ...Show All

• Visual Studio Team System Detecting unused code across multiple assemblies

  In an older version of FX Cop (a few years ago now), I think there was a public class called Graph. I wrote an app that used this class to detect unused code across multiple assemblies (we have 247 assemblies at present and around 4.5 million lines of code). Is there any current way of performing the same operation with the current version of FX Cop We have an investigative set of re-factoring rules in developm ...Show All

• Windows Forms When the user has input one char in one of the cells inside Datagridview I want to validate it. How?

  The user makes a lot of inputs to different cells in a datagridview. They are only allowed to input one character between 1-9. When the user inputs a character my validation starts after they have pressed enter or moved to anohter cell. But if I wanted to step out of "editmode" directly after a user has typed a single character, how would I do that I tried beginupdate, but that happens before I am able to read the input right ...Show All

• Software Development for Windows Vista Adding parameters at runtime before instancing

  Is There any way to add parameters to a workflow instance before instancing it I tried with: IRootActivity ra = workflowRuntime.GetWorkflowDefinition(type); WorkflowChanges wc = new WorkflowChanges (ra); ParameterDeclaration pd = new ParameterDeclaration (); pd.Name = "MyParameter" ; pd.Type = typeof ( string ); ra.Parameters.Add(pd); wc.ApplyTo(( Activity )ra); But maybe I'm wrong doing this... Regards, M ...Show All

• SQL Server Clearing/Unselecting Multi-Value selections made

  I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections Up to the top... Come on now, where our options for this !!! Microsoft can do better than this. ...Show All

• Visual FoxPro Spell checking?

  Well, as sort of a follow up, I am using the ActiveX RTF for one of my forms. What I'd like to know if there is a way to do sort of a spell check for what a doctor would type into it. Any one know I want your sample code too. It is a neat idea. Will this method highlight the misspelled words in RTF There is also another option: APSC - All Purpose Spell Checker which is also downloadable: you can find it on the web. It will have to be lo ...Show All

• Windows Forms Java to C# Conversion

  Hey everyone i used the JLCA that comes with Microsoft VS.Net Enterprise, it only converts 85% of my program. anyone know any good tips for converting the rest manually or any sites that teach how to do the conversion properly  thanks! ...Show All

• Windows Forms DataGridView - Null Values & DataGridViewImageColumn

  Hi, I have a simple DataGridView with a DataGridViewImageColumn.  I add rows programmatically to it in Form_Load. When I add a null value to the image column a 'placeholder' image appears. I want no image at all to appear for null values. How can I achieve this This is for VS2005 Beta 2/C# by the way. Many thanks, Ben Hello, I now have VS2005 Release Candidate but am still unable to get it to work ...Show All