Greg Hoover's Q&A profile

• SQL Server How to change data Dynamically in report services

  Hi, Please help me. I created a report and works fine but I am wondering  how to change  data dynamically. For example I have different data base and want to run the same report in different places I can't go and change the report each time. Any suggestion please Thanks in advance. You should change the query so that instead of returning one column per day you "denormalize" it to return one day per row: Day Count ----- -------- Mon 2 Tue 2 Wed 4 ... In the report, you could then just group by the Day field (in a matrix), or use conditional aggregation if you choose a table ...Show All

• Windows Forms Problem updating Manifest-file.

  Hi, I seem to be having a strange problem with the Manifest-file appupdater.xml. If the file exists I get an error reporting that the AppManigest.Update() fails because the file is in use.  The only other place in the code that I find that accesses this file is the AppManifest.Load-function that reads the file and the closes its stream.  So it seems&nb ...Show All

• SQL Server RECEIVING messages from a Windows service

  I've done a bit of work with the External Activator but I think it may be a bit overkill for what I need to do (which is RECEIVE messages from a single queue and process them with managed code). I've tried creating a Service Broker Interface service that retrieves messages from this queue, but I notice that if I set the timeout to -1 to watch for messages indefinitely, the Service never completes the OnStart code. I notice if I change the service's timeout to something greater than 0, the message is retrieved, but this defeats the purpose of using a Windows Service app, which I want to continuously monitor the queue. I noticed the Externa ...Show All

• Windows Forms Formatting a string

  hello all, Can u please tell me quivalent of below string in C#.NET strVehiNumber & " " & strVehiLocation & Chr(13) & strVehiTime & Chr(13) &strVehiSpeed & " Kmph" specifically,How to insert chr(13) in my C#.NET string Thanks , Anil Dhiman Anil, I belive that the string in C# is a follows string s = strVehiNumber + " " + strVehiLocation + ( Char )13 + strVehiTime + ( Char )13 + strVehiSpeed + " Kmph" ; Regards, Vallari Kamble (VB team) ...Show All

• Visual Studio Team System Assigning a task to more than one user

  Hi all, I'm used to manage my tasks in MS Project, and assign each task to one or more of my developers. When I've started using TFS, I tried to publish my gantt to the TFS, but I received an error that the "Assign to" field in TFS supports only one person. First of all, if TFS want's to support MS Project, why doesn't it allow me to do this Second, is there any way of working around the problem I've been thinking of creating a new field for the "assign to" (extend the TFS schema) but it just looks like to much overhead (since I'll need to change all the reports to display the new field). Any ideas of the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 16 channel Real Time signal rendering: Should I go for DirectX?

  I'm refurbrishing an old VB6 application that displays up to 16 signals, at 100 samples per second, along with some icons on the screen. The user decides on the on-screen resolution by means of a zoom function key. Now in the design phase, I need some more information to decide on taking Direct-X or GDI+ path. I've been going through several sample applications, and so far, I've got the feeling that Direct-X is suited to heavily drive the graphics processor in order to render very fast moving sprites and meshes. Instead, GDI+ is a more generic interface layer in between the old API's and the application. Not as efficient as Direct-X. ...Show All

• SQL Server User Defined Number Generator

  Hello all! I have a windows forms app and I'm trying to add functionality that would allow the user to enter a number into a textbox control on a setup form and then that number would autoincrement by one each time a new record on another form is inserted into the DB . I've searched high and low and can't seem to find much information on how I can put this together. I'm sure I'll need a "numbers" table in the DB that stores the numbers and is joined with the parent table where the records are being inserted into. After that, I'm pretty much lost on how to generate the numbers in the "Numbers" table. If anyone cou ...Show All

• Visual Studio Team System error in custom rule to check is string.Empty is used instead ""

  hi, i wrote a custom rule to check is string.Empty is used instead of "". It checks only the first "". It doesnt check other "" . That is if there are two checksas follows string str = "Hai"; if(str == "") { //do something } string str1 = "Hello"; if(str1 == "") { //do something } In the above case it finds only the first if condition and it doesnot find the next check method. The code is as follows public override ProblemCollection Check(Member member) { Method method = member as Method; if (method == null) return null; In ...Show All

• SQL Server SAN Replication

  I'm wondering if the technology exists to use SAN replication for sql server 2005 disaster recovery. I have a bunch of prod servers I want to add to a san, I then want to have another bunch of servers at a dr site connected to another san. Is there a technolgy ( non sql ) to enable full ( real time ) san replication of the data ( for SQL Server databases ). I don't need alternate suggestions, this solution has been proposed to my clients, I don't think it's available, any confirmation one way or another would be very helpful, thanks. Yes, I am working with the HP tecnology Continuos Acces ...Show All

• Visual Studio Express Editions How do I reset a form

  I'm real new at this so bear with me.   I set up an application similar to a calculator with two text boxes for input and then it does a calculation.  After it runs, I want to click a button to reset it (i.e., restart the application over again with blank text boxes and reseting the variables).   Problem is I can't seem to find anything that does that.  Any help would be appreciated.   Casgo.     casgo wrote: I'm real new at this so bear with me.   I set up an application similar to a calculator with two text boxes for input and the ...Show All

• SQL Server Authentication an application using Windows Integrated Authentication

  Hi all, My work is using a shared application which accesses a MSSQL 2000 database. To access the application, the folder on the Windows 2003 Server is shared and users can access the folder through a shared drive. For the application to access the database, it uses an ODBC connection to the MSSQL server which originally used the SA password. We have recently switched to using Windows Integrated Authentication because we believe it offers a higher level of security. However the only way in which we have been able to enable this is to add the windows users to the SQL server. The problem with this is that t ...Show All

• Smart Device Development Close the form that is initiated by ShowDialog()

  Hi All, I would like to know on what is the proper way to close the form Currently, my first form (loading form, like Splash Screen) is displayed using the command static void main() { new LoadingForm.ShowDialog(); } In this form, I will initialize and load some of the data to the object that will be used in my next form (that is, my main form). Then, after everything has been properly done... I will call Application.Run (new MainForm(ref etc)) inside the loading form to start my main form and I suppose the message loop is being set inside this new form. However, this command seems to block the whole application until the Ma ...Show All

• Smart Device Development SSL Stream

  I have a multiple layer application, that communicates with sockets I have UDP and TCP sockets, for 2 way communications, the problem is that I need to encrypt the channel and a good way is using SslStream, but it’s not supported in the compact framework, because I’m using embedded systems. The question is when the SslStream will be supported in the compact framework Hi bistok, NETCF V2 does not support SslStream. We will be considering adding support for the class in the next release. Thank you for your suggestion. Cheers, Anthony Wong [MSFT] ...Show All

• Visual Studio Tools for Office problem with shaed add-in macro settings

  I have developed a shared add-in in vb.net for MS Word 2003 which i am adding a new commandbar button in "Tools" commandbars and i have written a commandbar control event which displays a message box. everything is working fine but after displaying a message box i am getting a dialog box saying that "The macro caanot be found or has been disabled because of your macro settings". Currently my macro settings are medium and i tried even with low and i did check in "Trust all installed addins and templates". I did develop the same addin in couple of boxes but i am getting this dialog box("The macro caanot ...Show All

• Windows Forms ClickOnce and client configuration

  I've searched pretty much everywhere on the web and have come up with nothing to this question. We have an application that connects to a webservice, but we want to change the url of the webservice depending on certain conditions. For instance before we move to the production database and web servers we want to test the service in a testing environment. This means deploying a new client when we want to switch the code from development to test, then to production. What we'd prefer is that there is a config file somewhere on the users PC that means we can change the url of the webservice. Can anyone help me do this ...Show All