Mike Danes's Q&A profile

• SQL Server problems creating report (parent child hierarchy)

  hello, im working with as/rs 2005 and need help in creating a report. my cube has a parent child hierarchy in "category". structur is as follows: A a 1 2 b B C f g 10 11 12 I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...) there is a function called children, but i am not able to obtain my desired result. (in fact, i dont get any result with this fucti ...Show All

• SQL Server Passing Parameters to the ReportView

  Here is the problem. I have a report that accepts multiple parameters. Two of them are "hidden" from the user. I don't want them prompted for these values. I set up the parameters so that it says Hidden but I get the following message. The report parameter 'CustomerID' is read-only and cannot be modified. (rsReadOnlyReportParameter) Here is the source in my ASPX page: ReportParameter [] parameters = new ReportParameter [2]; parameters[0] = new ReportParameter ( "CustomerID" , CustomerID.ToString()); parameters[1] = new ReportParameter ( "UserID" , UserID.ToString()); parameters[ ...Show All

• Visual Studio Team System Reinstallation of Beta 3: Error 28704.Unable to connect to the Analysis server

  Good afternoon, Yesterday I completed the installation of a single server instance of Beta 3.  It worked (for the first time!!).  The only problem, was that I couldn't see domain users from the Team Explorer.  I put 2 and 2 together and realized that the problem was the service account. It was a local user, and didn't have rights to see the domain. So, I uninstalled TFS and STS.  I deleted the DB's that got created, as well as the application pools and COM+ packages. And of course, an obgligatory reboot. After running through the setup a second time (and third and fourth :0) ), I hit a snag.  I received a setup er ...Show All

• SQL Server Help...!

  Hi, Could someone, maybe Jamie, help us We can not use a forrest of Ds-trees to predict. Se previous post; http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=350778&SiteID=1 We really need some help with this as soon as possible, /Erik Posted a response here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=365474&SiteID=1&mode=1 ...Show All

• Smart Device Development Windows CE5.0: unable to hide command bar!!!

  I developed  an application for critical healthcare that must run in fullscreen mode. Now I'm trying to migrate to Windows CE 5.0, but I can't hide the bottom bar (command or menu bar ). I already tryied various combinations of CCommandBar SHFullScreen SHFindMenuBar CommandBar_Show ecc... this issue will jeopardize the entire project. Hope someone can help me...... Sorry, this isn't an answer but more of a uh yea..... I've also tried for about a month now to figure this out without any luck.... I've recently moved to a CView instead of a CDialogbox approach but I am running into many problems making the CView act and show ...Show All

• SQL Server Can ODBC be used in Report Builder or Report Model?

  Dear All, Our company use DB2. When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source. Can Report Builder or Report Model use ODBC Thank U. First, go to BOL and search on 'sp_addlinkedserver'. Then here are a couple of links to get you started. http://www.sql-server-performance.com/linked_server.asp http://www.databasejournal.com/features/mssql/article.php/3085211 R ...Show All

• Visual Basic .Net certification

  Do you know any web site for .net or SQL server certification practice. I m beginner and I have no idea how they look like. Also if any web site to prepare for them I appreciate your help. (sorry I didn t know where to put my question) There are tons of web sites out there. For eLearning and practice exams, try www.selftestsoftware.com . If you just want the paper and not the knowledge, try www.testking.com . ...Show All

• Visual Basic Programmatically Changing Screen Resolution

  I have an application that needs to run at a particular screen resolution. How do I detect current screen resolution and then change it if it needs to User needs often trump abstract 'practices'. Since Microsoft chose to no longer support individual user screen resolutions (available in Win98; not available in XP - MCE at least), all users of a computer must use the same resolution (or go through the dialog at least once a session) unless someone comes up with a little app that makes the switch programmatically. As an example :     my XPMCE capture card has a resolution of 1024 x 768   ...Show All

• .NET Development How to protect my assembly

  Assembly a.dll is used by application b.exe, while we distribute the application b.exe, a.dll is also shipped together. My question is how to prevent a.dll from abusing by other appliations than b.exe. In other words, I like to make sure a.dll can only be used by b.exe. Is there any ways to achieve this Thanks Pass a security key between the two, and hope that no-one uses reflector to find out what it is. The only way to write secure code is to use C++, even obsfucated code can be reflected on, and read, although it will be, well, obsfucated. ...Show All

• Visual Studio Express Editions Help! Want to create basic user input form tied to database in VWD

  Hello everybody. I have used VWD (Visual Web Developper) for the past few weeks and love it so far. As a inexperienced ASP.NET developper, I have run into difficulties when trying to design user web form input to populate a database. Indeed, the medical unit I'm working at whishes to create a webpage with simple user forms ( checkboxes, textboxes) - to keep track of patients medical records - that will then fill a database (SQL preferred). Should the page have an .aspx or .ascx extension Do I need to create a dataset I've consulted the online help but I'm still confused and don't know how to proceed. I'm sure there should be a wiza ...Show All

• .NET Development Will this become a memory hog?

  I made a FileWatcher object. Once a new file is created, all works fine. I would like the FileWatcher to begin watching for files again after it finishes with the file is it processing. What i have below is how I do it. I am just not sure if what I am doing is the best way. I am worried that a new FileWatcher will continue to be created, and after a while will begin to take more and more memory. I would like just one FileWatcher and one instance. public static void XmlWatcher() { FileSystemWatcher watcher = new FileSystemWatcher (); watcher.Path = WatcherDir; watcher.Filter = "*.xml" ; watche ...Show All

• Windows Forms Excel (latebinding with c#) and Instanciation

  hello again I'm just wondering about 2 parts inside Excel-Export: 1. Dim excelApp As Excel.Application     ... 'Some other lines     excelApp = New Excel.Application() How is it possible to instanciate an interface  In the intellisense I see, that Application is an interface ( ) - In my opinion, it should be Dim excelApp As Excel.Application excelApp = New Excel.Applicat ...Show All

• Visual C# rich textbox question

  Ok I have 1 richtextbox + 1 textbox the richtextbox.text=richtextbox.text+textbox.text but if textbox.text contains the word: "mother" i want in the richtextbox the word mother to be colored with red any ideas how to do that Here is some self-explaining code: private void richTextBox1_TextChanged( object sender, EventArgs e ) { // Store the current selection start position and length. int selectionStart = richTextBox1.SelectionStart; int selectionLength = richTextBox1.SelectionLength; // Set the word to find and get the first index of it. string wordToFind = "MyWordToColorRed"; int index = richTextBox1.Tex ...Show All

• Visual Studio Team System How to specify the user when connecting to TFS

  Hi, How can I specify / change the user, when I connect to Team Foundation Server from Visual Studio Currently, always my Windows login is used. Thanks for your help, Dirk You can run the following command to reset the user data. The next time you open VS and connect to a Team Foundation server, you will be prompted for credentials. start | run | devenv.exe /resetuserdata Let me know if this helps! ...Show All

• Architecture XP or XPE for POS application

  Hi, Not sure if this is the correct place to post this - apologies if it's not. I'm developing a custom POS application in VB.Net 2.0 for no more than 4 terminals. The touch terminals all have P4 processors with 512 MB RAM and 40 GB HDDs. I'm just wondering if there are any advantages to installing XP embedded (or XPE for POS) instead of XP Professional. Because of the limited number of clients, it would be more expensive to buy the developer tools for XPE and then license each client rather than just buying 4 copies of XP Pro - I already have VS 2005. Because the terminals are reasonly well specced and they will only by ru ...Show All