Pi in the Sky's Q&A profile

• SQL Server Green Bar Report for matrix

  I have a matrix and I am trying to create a green abr report by adding a group called rowcolor and setting it equal to 1.  Then the hitchhiker's guide says to put =ReportItems!RowColor.Value for the background color but I keep getting the error (The background color expression for the textbox ‘textbox4’ refers to the report item ‘RowColor’.  Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.) I dont understand what I amdoing wrong. Please help Matt I'm not exactly familiar with the approach suggested in the Hitchhiker's Guide ...Show All

• Visual C# writing value to Registry

  Hi all, I have a problem with writing a value to a registry. I want to change the pocket pc registry at run time by my application. On of the keys I want to change is : BDDevClass = 06 05 80 the key value type is REG_BINARY. When I write to this key by the SetValue methode : SetValue("06 06 07") I get in the key the value "06 06 07" (I mean with the "" marks. This is the problem, I want to set the value without the "". How can I do that. Please help me... Best regards...   How do you write to the registry in real time on pocket pcs I've been having a lot of trouble trying to figure that out today. ...Show All

• Visual C# Refactoring: Encapsulate field.

  Hi All, Just started to look at VS2005 beta 2 - I don't seem to be able to use the encapsulate field refactoring function.  I select a private class level variable and click encapsulate field.  The IDE then prompts for the property name and displays a code preview window which has the original field renamed to that of the property (highlighted) and no get/set type code.  Am I doing something wrong here Cheers, JW. I guess not supporting most of the refactoring options in Express is by design, It's one way to add value to Visual Studio. In VS2003 I used a plug-in that provided ...Show All

• Visual C# Getting the environmental variables

  hai, Is there any possible ways to get the value of the environmental variables. I set one variable "set SING=Y" in the command prompt. how to get that value in the c# program. thanks in advance, singam Hi you can use Environment.GetVariable method for instance Environment.GetVariable("windir") returns windows folder Hope this helps ...Show All

• SQL Server Excel connection properities -

  In my package I need to change the filename name for my input Excel based on a the contents of an external file.  I want to read the external file, get the filename/location from this file and then dynamically set this as the property for the Excel Connection.  I saw some posts related to this but did not understand which tasks I need to use and in which order.   thanks No I'm not - I had a feeling that I was doing something stupid - first time at using SSIS - I will give it a try - sorry for the confusion Thx ...Show All

• Visual Studio Team System Error under load/concurrency but not when run serially - $HIDDEN1._xxx

  When I run a webtest serially for 50 iterations, I do not get any exceptions, errors or warnings displayed in the VSTestHost.log. The test executes fine. However, when I run the webtest as part of a load test with just 1 other script, the following web test exception occurs very frequently invalidating my test results: at Microsoft.VisualStudio.TestTools.WebStress.WebTestInstrumentedTransaction.UpdateBindingSites(String preBoundString) at Microsoft.VisualStudio.TestTools.WebStress.WebTestInstrumentedTransaction.PerformRequestDataBinding() at Microsoft.VisualStudio.TestTools.WebStress.WebTestInstrumentedTransaction.Execute(WebTestCas ...Show All

• SQL Server Bitwise operation in SELECT killing performance, *sometimes*?

  Hi there, We have a high volume SQL Server which gets into trouble at times, with one query blocking out others for 10-15 minutes. The query looks something like this: SELECT * FROM MyTable WHERE MyQueryColumn & 128 = 128 ORDER BY MySortColumn There is an index that exists containing MyQueryColumn.  MyTable has somewhere around 550,000 rows, around 50 of which might match this query at any particular time. Almost every time this query executes in under 1 second, and everybody is happy.  However, once every few weeks (or months, even), this thing takes a dogs age, blocking loads of other queries trying to hit MyTable. We did a s ...Show All

• Visual Studio ReportServerCredentials in a WebApplication

  Hi there, A similar thread on ReportServerCredentials was very enlightening however we still are not seeing our way through our problem.  We have implemented Custom Authentication and we are using webforms, which requires us to manage a authcookie. Ideally we are looking for a simple sample that demonstrates our objectives.  Let me know if you require more information. Cheers, Shaun An exception is being thrown here: svc.LogonUser(Username.Text, Password.Text, null); The error received in the debugger is A first chance exception of type 'System.Web.Servi ...Show All

• Visual Studio 2008 (Pre-release) Parameterized queries in DLinq

  In Linq I can write: int [] arr = new int [] { 1, 2, 3 }; int i = 1; var q = from a in arr         where a == i         select a; i = 2; foreach ( int ii in q) Console .WriteLine(ii); The result is 2. In DLinq it's not the same. If I write: int valField1 = 1; var q = from t1 in db.Table1         where t1.Field1 == valField1         select t1; valField1 = 2; foreach (Table1 t1 in q) Console .WriteLine(t ...Show All

• Visual Basic ToolStripButton and PrintDialog (Vb.NET Beta2)

  I find the Print Dialog Box is not in activate when fired by button on ToolStrip, like: Private Sub ToolStripButton1_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles ToolStripButton1.Click    PrintDialog1.ShowDialog() End Sub   The printDialog has to be made active by clicking once before making any print options. However, it is alright by normal buton, like: Private Sub Button1_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles Button1.Click    PrintDialog1.ShowDialog() End Sub   Is this a bug or no ...Show All

• Visual C++ CBitmap - Simple example

  Hi, I am trying to load some images in a Picture Area. I only have the pointers to the images, and this pointers are of the type unsigned long* (I can also convert it to IplImage* to use with OpenCV). This unsigned long* get the images grabbed from an camera and I would like to display these images in this Picture Area (it is real time, I get the images from my camera and display them). I have tryied to use this (HBITMAP)LoadImage function, but the last parameter is always LOADIMAGEFROMFILE but this is not real in my application. So, can you help me with convert my unsigned long* to an Bitmap and than load it on the exacly place that I want ...Show All

• Smart Device Development VB6 application & VS.NET 2005 Smart Device application

  Hi all, I have a vb6 app with an Access database. There is no intention to upgrade this app to .NET in the near future. I need to further develop the app so it installs a subset of the data on smart devices (eg. pda, smartphone) What tools do I need to develop this pda app, and how can I sync between the 2 apps Thanks, Ivan nope there is a serparate installer located here for example C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4 called sqlce.wce4.armv4.CAB. this will need be insatlled on the device.... here's how you can create an installer for multi ...Show All

• Visual FoxPro Unexpected disconnecting of remote connections under VFP 9 SP1

  I have problem with unexpected disconnecting of remote connections under VFP 9 SP1 runtimes (only under SP1 runtimes). For example, using _VFP object to access forms will cause this and I am analysing other situations. Using _SCREEN object does not cause this. Does anyone found this too and in what situations   Because this problem can be seen only under runtime, we need to create aplication, which for example runs one form. This form will open some remote views (for example in load event - does not matter). Then i added command button and in Click() event this code : nPoc = 0 nPoc = ASQLHANDLES (aPom) IF nPoc = 0 &nb ...Show All

• SQL Server Windows XP SP2 (32-bit), Athlon 64 X2, SQL Server 2005

  I upgraded from a P4HT processor/mobo to an AMD Athlon 64 X2 platform and now, I cannot install SQL Server 2005 on this new build. Does SQL Server 2005 install to this setup Getting Windowx XP 64-bit IS NOT an option given how little hardware and software support currently exists. Short answer is: Yes, this configuration is tested and supported. With that said, I've made the following assumptions in my answer: You are running Windows XP 32-bit on your AMD 64 hardware You are installing the 32-bit version of SQL Server on your 32-bit OS Without seeing any error message you maybe receiving, ...Show All

• Visual Studio 2008 (Pre-release) New exception in Beta 2 makes no sense?

  I do not have a clue on what this exception means. From the stack trace I see none of my code in the call stack. It appears to be a problem with applying a property value that changes the template of an element. Any help would be welcome. "Dispatcher processing has been suspended, but messages are still being processed." at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at Syste ...Show All