Sharezxx's Q&A profile
SQL Server Getting SQLDependency to fire the OnChange
After many problems with permissions I have got got SQL to accept a notification request but the public static void OnChange(object sender, SqlNotificationEventArgs e) is never triggered. The notification registers and de-registers ok. The same connect string successfuly connects to the same database to process queries. I can see the GUID suffixed stored procedure, queue and service being created. Where does SQL2005 store the address/name of the routine it is to trigger (When the notification is cancelled, the guid-siffixed items disappear) I have looked at the generated stored procedure, queue and service, but there is no indication of what is to be called back. I have followed the instructions at http://msdn2.microsoft.com/en-us/library/ ...Show All
Visual Studio Team System I can't get environment variables to work in 1.35
I couldn't get environment variables to work in FxCop 1.35. Not sure what I'm doing wrong. Here's what I've tried. * start a command prompt from a batch file that sets up various environment variables that we use in our build environment. * launch FxCop from that command prompt. * Add a reference to an assembly DLL. * Right-click on the target and choose Properties. * Change the save name to replace the first part of the path with the environment variable that has that part of the path as its value. * save the project out to a file. * Quit out of FxCop and open up the project file in Notepad. * Note that the Name attribute for the target is now shown as relative to $(FxCopDir), not the environment variable that I ha ...Show All
Visual Studio 2008 (Pre-release) Polygon.Points Binding TwoWay
So, I have a class that has a PointCollection, that is used to store some polygon geometry. I have a DataTemplate that I am using to display the polygon data, and am databinding its Points collection to my object's Pointcollection. This works well for displaying the polygon the first time, but if I change any of the points in the object's PointCollection, then the polygon is not updated with the new shape information. The weird part, is that if I just set the Points value of the polygon to the object's points property, it works as expected. I was able to create a custom shape to get around this problem, but I was wondering if this is a bug. Here are the important bits. By the way, I am running RC1. <DataTemplate DataType="{x:Type ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Any Plans for Support for VS 2005?
Does anyone know if there are plans to support VS 2005 at some point There are a number of missing features in VC# Express which I have come to rely on. Most notably, Macros. My productivity is hindered in Express. I would really like to be able to use VS 2005. At the moment, I am using a custom pipeline content generator and the XNA assemblies under VS 2005. Which is a complete hack, but it does work (on Windows). Basically, it means I have to eventually recreate the projects in XGS in order to make them work on the 360. So does anyone know if there will ever be real support for VS 2005 Any one know what the MS Connect bug-flow process is I noticed that all 500 of the "GSE should work with VS 2005 Pro/Std" requests hav ...Show All
SQL Server Transaction
how can with in transaction execute statment1 and statment2 then rollback transaction but statment2 not rollback Set "Enlist = false" in your connection string. This tells ADO.NET not to enlist the new connection in a distributed transaction. -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- <David Sakhelashvili@discussions.microsoft.com > wrote in message news:b1b6bb81-47e1-4b58-af02-ba810f017fad_WBRev2_@discussions..microsoft.com ... This post has been edited either by the author or a moderator in the Microsoft Forums: http://forums.microsoft.com how i can use CLR SPs I w ...Show All
Software Development for Windows Vista DirectShow 2 input filter
I have created a Directshow filter that has 1 input, the base class is CTransformFilter. The input is MEDIASUBTYPE_RGB24. The filter does some color correction. Now I would like to add another input and make it a two input video filter for DirectShow. The idea is to use the second input for doing a composite. Both inputs should be both MEDIASUBTYPE_RGB24. Has anyone done this before Should I still be using the CTransformFilter base class Or should I use another base class or extend CTransformFilter base class to support 2 inputs. If anyone has any code samples for 2 inputs vide filter that would be great Don James I am outputting the result of the filter ...Show All
Visual Basic Creating a Listbox programmatically and selecting items
Hi everyone, Basically I've created a function that can be called to create a new listbox that will be filled with items from a data table (they will have both a text value and an integer ID), one or more of those values will be selected, and then the listbox will be returned where it will then be displayed on screen. So far using the below code I can happily create the control and fill it with items and display it on screen. The problem is that I can't make it so that the required items are selected. Something that I've noticed when I'm debugging is that after i set the datasource the ListBox still doesn't have any items. If anyone has any idea how to fix this please let me know Dim Ctrl As New System.Windows.Forms.ListBox C ...Show All
Visual Basic .
Visual FoxPro report tool bar
After a report is generated and appears in a preview you get a small toolbar that floats undecked in full view of the info that you try to read. It was an annoyance until I had only 1 page in the report and once I moved the bar down the report page and believe it or not it DISAPPEARED behind the frame's lower edge. It was not a big alarm for me then since I had only one page but now I have many and the only way to flip pages as I can see is to get the toolbar back. I cannot possibly retreive it no matter what I try. When I moved the toolbar down I hoped that it would deck somewhere and become available as part of the frame but it is not what actually happened. The toolbar disappeared at design stage but the same form's report appe ...Show All
.NET Development .NET remoting and local web server
We have a backend application and ASP.NET web application running on customers' sites. Once in a few weeks they would report that they could not run our web application. They get the "Cannot find server" error on the browser. If they try to go to http://localhost/ they will get the same error. The ASP.NET application communicates with the backend application through .NET Remoting. To fix it, they would have to kill the backend application and restart it. Then the web app would come up just fine. What could be the problem in the backend app that caused the local web server down Any help would be greatly appreciated. hong2007 ...Show All
SQL Server Is it possible to upgrade to SP1 for my existing SQL 2005 Express edition?
I just downloaded the "SQL Server 2005 Express SP1", but I found that there is no upgrade option, it will just install a new instance of SQL 2005 Express. So, I just curious to know, how do I upgrade to SP1 smoothly Thank you! Here's the link to upgrading Express to SP1. The quick summary is to make sure you back up your system and user databases and restore them after the install. http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm#_3461_prepare_for_a_sql_server_2005_sp1_i_d3jb Thanks, Sam Lester (MSFT) ...Show All
Visual C++ Q: How to disallow users to terminate my program?
Hi, I'm building an application to monitor users so as to prevent them from abusing the PC. This program must not be stopped. How can I disallow users to terminate my program I found out that if I want to terminate ZoneAlarm's vsmon.exe from Windows Task Manager, I'll get an error message "Unable to Terminate Process: The operation could not be completed. Access is denied." Can I make my program like that The users are running on a limited account (I have access to the administrator a/c). Is there a simpler way that I can solve my problem I am using C++ w/ MFC on Visual C++ 2005. Sam is right. This issue really has nothing to do with C++ itself. Here is the security newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx d ...Show All
SQL Server alter databse TestDB set TRUSTWORTHY on fails
Hi all, When I try to execute the following command: alter databse TestDB set TRUSTWORTHY on I get this error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'databse'. Msg 195, Level 15, State 5, Line 1 'TRUSTWORTHY' is not a recognized SET option. Can someone tell me why Thanks in advance. sobo1 wrote: Hi all, When I try to execute the following command: alter databse TestDB set TRUSTWORTHY on I get this error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'databse'. Msg 195, Level 15, State 5, Line 1 'TRUSTWORTHY' is not a recognized SET option. Can someone tell me why Thanks in advance. oh... god it i ...Show All
Visual C# Global access to arrays
Hi, I am a beginner at C# and am probably trying to run before I can walk! However, I need to build an application which has several Forms. I was brought up on the concept of only writing code once and using it everywhere. So, What I need to be able to do is to: Hold data arrays in one piece of code, say MyData.CS and access it from all of my Forms. Hold pieces of code,( like subs in VB ) which perform specific tasks and which are, again, accessible from all my forms. these may access the API or just do general stuff. I can write the code, but I just can't access it. So far, I have been able to handle single point variables in this way, but I don't seem to be able to do the same with arrays. Also, I can never access my 'g ...Show All
Visual C# Professional C# Games and Appz
Are there any professional games developed in C# Are there any professional apps developed in C# Can you link to some examples I want to see what's capable in C#... There are some games that are starting to pop up, one of them is a version of rocketcommander (Wich is developed in C# and uses MDX). You can download the code to the base application on the coding 4 fun website. Also if you go to www.thezbuffer.com the zman has a list of commercial apps that are using managed directx (Which in turn are using managed code). ...Show All