Richard Watts's Q&A profile

• SQL Server Query the results of another query

  I'm new to the database world - I know what I want to do, but not sure if or how to do it... Is there a way to run a query and then build on it to query the results of that query My example is as follows: Query the number of distinct machines by ID in Week 1 = Results Query the distinct number of machines by ID in Week 2 minus the Results from Week 1 - NOT EXISTS SELECT pub_name FROM publishers WHERE NOT EXISTS (SELECT * FROM titles WHERE pub_id = publishers.pub_id AND type = 'business') - Use NOT IN SELECT pub_name FROM publishers WHERE pub_id NOT IN (SELECT pub_id FROM titles WHERE type = 'business') - Perform a LEFT OUTER JOIN and check for a NULL condition SELECT pub_nam ...Show All

• .NET Development direct network traffic to specific network address

  I am developing software for a machine which will have 2 internet connected network interfaces. The first is a DSL broadband connection, the other is a GPRS wireless connection. How can I prevent ALL applications running on the machine from sending and receiving packets over the GPRS connection, except for the specific application I am writing The ideal solution would be to only allow packets being sent and received from a specific IP address on the internet, to pass through the GPRS connection, but everything else goes over the DSL... Any ideas Thanks on Windows Vista binding to all interfaces, but the GPRS interface will also do it for you. see Strong Host section of this page: http://msdn.mi ...Show All

• Visual C++ can some on help me

  Here is picture of my error. Can u help me fast plz. http://img341.imageshack.us/my.php image=untitledvk0.png This is one of the DLLs in the C++ runtime. They are used by native C++ code so they are not installed with .NET. But they are installed with Visual Studio 2005 so I am assuming you haven't got this error on your development machine You may have to distribulte some of these DLLs with your app. ...Show All

• Visual Studio Express Editions might have acciddentally modified the..

  Hi, While following the intstallation instructions for VC++ EE with SDK I might have accidentally edited the file Corewin.vsprops instead of corewin_express.vsprops. What should be there for the parameter "additional dependencies" is it the same as for the corewin_express.vsprops or soemthing different if its not the same will please someone post the content as I dont want to go through the uninstall-install process. I am using vc++2005 EE and platform sdk for windows server 2003 R2. thanks for your help. hi mexy there are two different "corewin.vsprops" in your ...\Microsoft Visual Studio 8\ folder, you are probably refer to the first one, i pasted both of them for your reference. ...Show All

• Smart Device Development TAPI lineIntializeEx() Compact Framework V1

  I have an application that successfully uses the TAPI functions with a .Net Compact Framework Version 2. I am trying to port that to Compact Framework Version 1 and am having issues. Here are my structure and method definitions: public delegate void LineCallBack (System. UInt32 dwDevice, System. UInt32 dwMessage, System. UInt32 dwInstance, System. UInt32 dwParam1, System. UInt32 dwParam2, System. UInt32 dwParam3); public struct lineinitializeexparams { public uint dwTotalSize; public uint dwNeededSize; public uint dwUsedSize; public uint dwOptions; public System. IntPtr hEvent; public uint dwCompletionKey; } [ DllImport ( "coredll.dll" , SetLas ...Show All

• Windows Forms Results from a worker thread into main thread?

  I have a C# dll which provides an event of SqlDependency Notification messages to clients via a delegate. The event fires ok and I get the expected data. The problem lies when I try to get the resulting dataset into a DataGridView without having to implement a manual refresh via button click. I'd like for this to automatically update upon change. I'm thinking the reason is because the data is coming from a worker thread within the SqlDependency class and I have to create some means of marshalling it into the main (gui) thread. Below is my first whack at the event handler but for some reason it does not work. That is I still have to mash a refresh button. Can anyone offer a suggestion void ExcepNotification_NewExceptionNotification(Data ...Show All

• Smart Device Development Strange Issue with String.IndexOf()

  I am using Function(String b)//where b="FunGroup" { String Categories= Contact.Categories // Categories return "FunGroup" Categories.IndexOf(b) // returns -1 .. where as it shall return 0 } What can be the issue Airan wrote: Found the answer, i was reading categories from Contacts and it returns categories with a space before the category name ..Culprit found and fixed too :) good to hear ... if you wouldn't mind though, mark mine as answer, since I did bring up checking for spaces ... would appreciate the credit. ...Show All

• Visual Studio Express Editions Visual web asp 2.0 build to a dll

  Howdy, This will most likely be a complete newb question but: How do i compile an entire asp 2.0 project to a dll. I was using visual studio 2003 and it did it automatically. It was a student version and now that I am no longer in school, i thought i would try to be legal and use Visual Web Developer 2005 Express Edition. I would even be willing to read up, but when i searched the help tools, i didnt find much in the way of a guide in how to compile all the .vb files into a nice dll i can put in my bin folder like i use to. any help would be greatly appreciated. thanks! I would try posting you question in the asp.net VWD Group on http://forums.asp.net as this is where the web developers hang ...Show All

• Visual Studio 2008 (Pre-release) I need a simple example using netMsmqBinding

  Can anyone point me to a tutorial that can get me started. I'm looking for something simple - just drop a message in a queue and pick it up. I have seen some tutorials, but they seem very complex and are not working for me. I need a little more hand-holding and a little simpler example in order to get my head around this. For example, I have built just such a simple test. In order to generate a client proxy, I have tried exposing the metadata as with web services. But when I try to hit that metadata in a browser I get "The protocol 'net.msmq' is not supported". If I could find something that walks me through a simple example I think I could get over this hurdle and start doing more serious work with WCF. ...Show All

• .NET Development multicast and voice ???

  Hi,I want ask you about voice. you know the voice on UDP is very bad but on TCP is good. but TCP is not support multicasting. are there another way to sending voice on LAN Network and support multicast if there are another way Please give me anything about it. Thank You hi i have spend a week looking for sending voice using UDP .to make a voice chat between many users ..using C# please can you help ...Show All

• Visual Studio Team System Trouble using both VSS and VSTS

  We are keeping our old code in VSS, while new development is being stored in VSTS. When I try to open an older project with VS2003 it is trying to use the MSSCCI provider instead of the VSS provider. How can I control which provider is used Just to clarify - are you using TFS Msscci provider to connect VS2003 to TFS, or you using only VS2005 to work wit it If the first is true, please check my blog post to see how to switch between different Msscci providers. ...Show All

• Visual Studio Remote Debug VS2005 Debug Symbols Not loaded

  I am receiving the following message while attempting to remote debug an application: "The breakpoint will not currently be hit. No symbols have been loaded for this document." I have successfully installed the remote debugging components on the server. I am able to attach to the remote process fine. My program is just waiting for a request in order to start executing, but it will not be able to do such since the debug symbols are not loaded on the remote server. On my dev machine, I've located the debug symbols for my application in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\.... folder, but this still does not fix the problem. Suggestions, please. Am I pulling the right debug symbol ...Show All

• .NET Development Strange XmlSerializer error

  Dear all, I am programming in VB.NET , using the .NET Framework 2.0 on a Windows Vista machine running VS 2005 with the SP1 beta applied. I have a VB class which was derived from an .XSD schema using the XSD.exe tool. I am able to instantiate objects from this class and build by "XML" object up using it, without too much difficulty. However, when I come to serialize the output to an XML stream, it fails, with a FileNotFoundException on the serialize line, e.g.: Dim serializer As New XmlSerializer( GetType (eGov.IRenvelope)) Where eGov is my class namespace, and the IRenvelope is the class within the namespace that corresponds to my object which I am attempting to serialize. The interesting thing is, tha ...Show All

• Visual Basic VS2005 managed WebBrowser opening Office docs

  Hi All, I am using the new managed WebBrowser control (within VS2005) to display locally stored office documents (see code below). But when I navigate to the document I always get the 'File Download' dialog box. If (htmlFileName.Text.ToLower.EndsWith("doc")) _ Or (htmlFileName.Text.ToLower.EndsWith("ppt")) _ Or (htmlFileName.Text.ToLower.EndsWith("xls")) _ Then With webBrowser1 .Visible = True .ScriptErrorsSuppressed = True .Navigate(htmlFileName.Text, False) End With End If Is there anyway to suppress the display of this dialog box without having to change any internet explorer options Thanks In Advance George ...Show All

• Visual Studio Team System FxCop throwing error

  Hi all, I just ran an compilation of FxCop rules. It's giving 2 error message: CA0001: Rule=Design Rules#CA5035, Target=Welcome.Page_Load(System.Object,System.EventArgs):System.Void: Object reference not set to an instance of an object. FxCopCmd.exe returned error code 2. The above rule CA5035 when run independently doesn't throw this error but when I ran it with a combination of some 10 rules. It's giving the above error messages. Can anyone tell me what to do with this Please note that the 1st error message is not being thrown when I run the rule CA5035 independently and I've rectified the conditions too. There is no cases of object no being set to an instance( I guess). Kindly advice somebody. Thanks ...Show All