Pooyan.R's Q&A profile

• SQL Server Using CASE in the WHERE clause

  I am attempting to write a stored procedure that will accept a column name in the form of an nvarchar parameter along with a corresponding value to use to filter the returned results. Obviously I can write a CASE statement with the query repeated for each case with the applicable WHERE clause, but after some research I did find that according to some sites, using the CASE statement in the WHERE clause is perfectly legal. However, I have tried the following code, which is basically a cut & paste version of what I found described, but SQL Server keeps generating errors at the first WHEN clause. I would appreciate anyone's guidance getting ...Show All

• .NET Development the My namespace and terminal services/ citrix servers

  To quote a recent article in MSDM mag:-"My.Settings encapsulates a powerful infrastructure for manipulating application settings, such as Web service URLs and user preferences" I am particularly interested in the storage and retreival of these setting on a terminal server and/or a citrix server. Before i spend too much time playig with this feature, i am curious to know about any implications or problem that My may have in this kind of environment, ie which computer is  My.Computer (i assume the terminal server on which the app is running) and what about persisting user settings locally- how or even can these work, e.g are local fo ...Show All

• Visual C# When are drawing objects GC'ed in this scenario?

  If I create a class that holds brush objects that are passed to it, like this: public class myPrinter { private Dictionary < string , Brush > aBrushes = new Dictionary < string , Brush >(); public void AddBrush( string Brushname, Brush oBrush) { aBrushes.Add(Brushname, oBrush); } } and I new-up a Brush (on-the-fly) and feed it to my class, like this: myPrinter oPrint= new myPrinter (); oPrint.AddBrush( "HHatch" , new HatchBrush ( HatchStyle .Horizontal, Color .Black)); Then when does the GC recover the Brushes memory--if ever --Mark ...Show All

• Visual Studio Express Editions Problem with aspx file extension

  Hi. I am new to ASP.NET I am facing a problem when i try out the Visual Web Developer 2005 Express Edition Beta 2. My provider supports only .asp file extensions for asp.net script files. Can I change the extension in my projects from .aspx to .asp   Thanks!!! http://www.AspSpider.NET offers free ASP.NET 2.0 web hosting for developers. It is free, have SQL Server 2005 Express. ...Show All

• Visual Studio Express Editions How to examine HTML from a web page?

  I'm a bit perplexed with this. I've got about 4096 characters that are returned from Webbrowser.documenttext property, but the rest of the page is lopped off when assigned to a string. Any idea if there is someway to get at this information with VB 2005 Express WebBrowser is type web.   Thanks,   Ben   Here's the failing code Private Sub FGSADiscountAutomator_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim WebPage As String If CBoxAutoUpdate.Text = "On Startup" Then WebBrowser.Navigate( New Uri( "http://www.gsa.gov/Portal/gsa/ep/ ...Show All

• Visual C++ Dual threaded bitmap creation

  Hi there, I have a simple example below showing how I create a bitmap from a data array: void Form1::ImageUpD(array<double,2>^ image) { ImageBmp = gcnew Bitmap(image->GetLength(0),image->GetLength(1),PixelFormat::Format24bppRgb); BitmapData^ data = ImageBmp->LockBits(Drawing::Rectangle(0,0,image->GetLength(0),image->GetLength(1)),ImageLockMode::WriteOnly,PixelFormat::Format24bppRgb); unsigned char *bits = (unsigned char*)data->Scan0.ToPointer(); int bytesPerPixel = 3; // 3 bytes per pixel for 24 bpp rgb int val; for (int i = 0; i < data->Height; i++) { for (int j = 0; j < data->Width * bytesPerPixel; ...Show All

• Visual FoxPro Active Foxpro Pages Setup Problem

  I tried to install the Full Setup of Active Foxpro Pages (afpages) on my Windows 2000 Server. It gave errors of not being able to locate gdiplus.dll or msvcr71.dll. When I tried going into the Active Foxpro Pages control center, I got an error that "Cannot locate the Microsoft Visual Foxpro support library." This is a computer without any native Foxpro installed. I then tried installing both the VFP7 run-time files and the VFP 9 files, but it did not help. The VFP 9 download also gave errors about msvcr71.dll. I tried copying those 2 files from the backup folder in the AFP3 directory into c:\winnt\system32 and registering th ...Show All

• Visual Studio Team System Pointless documentation.

  Hi, Just found the following link on the MSDN relating to performing a nightly build using VSTS: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/NtBldTmSrv.asp Is there any point in having documentation on the web if it is quite blatently incorrect or at best misleading. I've done a search for the .sln file discussed and it doesnt exist. This means that my install has gone wrong, or this is relating to a beta version, or the code never existed in the first place. I find it funny I need to do Google searches for blogs to get the information I need to carry out a relativelty straight forward task! ...Show All

• Visual Studio Team System MS Project - can't get work items

  We get the following error on MS Project : TF80071: Team Foundation encountered an error while accessing the work item database.  Please contact the Team Foundation Server administrator. We have Office SP2 and Project SP2 Any ideas Please try the workaround in: http://forums.microsoft.com/MSDN/showpost.aspx postid=159182&siteid=1 and let us know... [look for Sridhar S] ...Show All

• Windows Forms Progressbar on a different thread

  Hi all, Im kinda stuck here. Let me tell you some background info. Users can create a shift, but within that shift they can create a recurrence pattern. Now, those recurrence patterns can be long, like from 1 january till 1 february. What the program does is it create's a copy of the orginal shift, change's the dates and inserts it into the database. This take's some seconds and i want to popup a progressbar. The shift saving stuff all occurs within the UI thread ( i know..im going to seperate that ) When the saving starts, a form show's up with the progressbar. But the thing is, it won't show up very nicely as it is loading when the sh ...Show All

• SQL Server MS Time Series: Absurd predicted number when stdev = 1

  I have noticed that for the prediction of MS Time Series, the number is usually absurdly large when the standard deviation is 1. I always get a bunch of them. Does anyone have any clue about what this means In most cases, we stop predicting with the time series algorithm when we detect that predictions are not stable, so you'll see NULL values for future steps beyond a certain number. You might be hitting a corner case where this doesn't happen. ...Show All

• SQL Server Reporting Services Error-URGENT!!!

  This is critical. The company I am in runs 3 reports that calculates huge amounts of data and it takes about 45 minutes to run. Unfortunately I get the following error after about 30 minutes. I need to fix this today. No one is cancelling the report it just appears to time out. Any clue guys Reporting Services Error -------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help Operation cancelled by user. I face t ...Show All

• Windows Forms Embedded User Control and lost focus ....

  Has anyone else seen this   Is it a bug, or am I doing  something wrong I have a window with a user control within a user  control.  The problem is that text boxes within the child- user control do not receive proper focus when clicked  on.  The keyboard focus is sent to them but not the tab  focus.  For example, given the code&nbs ...Show All

• .NET Development Failed to load dataset because of the following error: Unable to find connection ...

  Everything was fine last night, but this morning when I opened my VS 2005 web project, I got this message: Failed to load dataset because of the following error:  Unable to find connection X for object 'web.config'. The connection string could not be found in application settings, or the data provider associated with the connection string could not be loaded. Also, in my DatSet.xsd file, there are not 102 warnings that were not present before, and when I try to switch to Design view, I get "Cannot open a designer for the file because the class within it does not inherit from a class that can be visually designed." I cannot see anyt ...Show All

• Software Development for Windows Vista How to generate X.509 v3 certificates

  Hello, how can I generate X.509 v3 certificates with Windows 2003 It seems I have only v2 templates. Thanks, Pierre ...Show All