jdunlap's Q&A profile

• SQL Server problems with salesman parameter

  Hello, I'm working with a cube and I want to show in my report matrix the percentage of a salesman's hours against the total store hours in a month. I have the month, store name, and salesman's name as parameters in my dataset, but when I select a salesman, it seems as if the total hours of the store are the same as the salesman's and I get a 100% instead of the 20% I'm expecting. And if I don't filter by the salesman in the report, the percentage is fine :( Any ideas of what I'm doing wrong in the report Thanks. ...Show All

• Visual C# How to Save/open data to/from a file

  Hi, I have a Rich Text Box and I want to save the text in that Text Box to a file. What I want is when the user finish entering data in the Text Box, then they press the "Save" button, then the SaveFileDialog would popups and let the user save the data to a text file anywhere they want to. The user can also re-open that file and then the data would populate the Text Box. How do I go about that, please help!! Thanks Jason You can retrieve the text data using either the Text or Rtf properties. The former returns raw text while the latter returns RTF text. In both cases you need only send it to a file. You can load the box with data by setting these properties as well. To display the Open/Save dialogs create an in ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed DirectX10 on XP64

  Hello, I am porting a C# app which uses DirectX from 32bit to 64bit. I downloaded the Aug 2006 SDK. I looked around and saw that in the folder: C:\WINDOWS\Microsoft.NET\DirectX for Managed Code There are many versions of the DirectX dlls, but there is only one version for x64, and that version is 2.0.0.0, which is DirectX10. I guess this is more of a request for a confirmation rather than a question. Is DirectX10 indeed the only version whose managed code dlls has been ported to 64 bit Or, put another way, if I'm going to use DirectX on Win64, does it have to be DirectX10 Thanks Native 64-bit development using MDX 1.1 is not possible as of now. You can develop the application in a 32-bit environment and ...Show All

• SQL Server Prediction Join to MDX with nested table

  If your prediction join is to a SQL datasource, you can easily write a SQL query which returns a nested table like: SELECT Predict([Subcategories],2) as [Subcategories] FROM [SubcategoryAssociations] NATURAL PREDICTION JOIN (SELECT (SELECT 'Road Bikes' AS Subcategory UNION SELECT 'Jerseys' AS Subcategory ) AS Subcategories ) AS t What about if your datasource is a cube Is there some special MDX syntax similar to the SQL syntax above Or do you have to utilize the SHAPE/APPEND syntax as follows SELECT t.*, $Cluster as ClusterName FROM [MyModel] PREDICTION JOIN SHAPE { select [Measures].[My Measure] on 0, [My Dimension].[My Attribute].[My Attribute].Members on 1 from MyCube } APPEND ( { select [Measures].[Another Measure] on ...Show All

• Visual Studio Express Editions How to make a simple function

  Hi, I was wondering if there is anyway to turn a huge amount of code into a simple function. Right now I have a bunch of check boxes and they are all named C1-C7 and W1-W7, instead of putting in code for each one when clicked, which results in a large amount of code, is there anyway I could make one function to handle all of these. I tried something like this. If C(num).checked=true then W(num).checked=false endif its just a basic example of what i want and i could really use this later on. Thanks Well WayneSpanglers example does work but the other one might be nice for future use, ad thanx for showing me how to use cases.    Just note that all the cases ...Show All

• SQL Server Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 637B7FC0 at 0x77387EAC

  Hi i am connecting to a DB2 database on a AS400 machine from SQL server 2005. I have setup a linked server to connect to the DB2 database. Most of the time the query ( select * from OPENQUERY(lnkd_svrname,'select abc from svr_name.lib_name.tablename') ) works fine but at times it comes up with the following error. I am running SQL server 2000 Std. Edition on a WIN 2000 machine. Any help would be a ppreciated . *****ERROR***** From the Exception.Log file 11/30/06 09:38:59 spid 69 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 637B7FC0 at 0x77387EAC STACK DUMP ---------------------------------- ============================== ============================== ========= ...Show All

• Visual Studio Express Editions Formating a Drive in vc++ express

  I've written a program, in another language, that stresses a 1 GB flash drive our company will be selling soon. I fill it with 0x55, format the drive, fill it with 0xAA, format, fill with 0xff, format, then fill it with various file sizes... The fastest way to fill and delete if to write 512 files then format the flash drive (6 minutes faster then deleting). I'm re-writing the program in an exercise to learn VC++ 2005 (express) and I can't figure out how to format a drive directly or through a shell command. What do I do Is there a shell namespace for drive class or something Thanks, Desperate and sick of MS Help lack of examples and obscure syntax. (will i ever figure it out ) You are actually ask ...Show All

• SQL Server Help with mail that send mail when database bakcup fails

  Hello I have got a script which gives the mail to the dba mail box when database backup fails. In the script I want to make a change so that I get the particular database name , on what ever database i implement. Can you tell me some suggestions. The script I am using is : use master go alter PROCEDURE dbo.SendMail @to VARCHAR(255), @subject VARCHAR(255), @message VARCHAR(8000) AS BEGIN SET NOCOUNT ON; DECLARE @rv INT, @from VARCHAR(64), @server VARCHAR(255); SELECT @from = 'testsql2000@is.depaul.edu' , @server = 'smtp.depaul.edu'; select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13) EXEC @rv = dbo.xp_smtp_sendmail @to = @to, @from = @from, @messa ...Show All

• SQL Server SQL Server Compact Edition RC1 Released

  Dear Community, The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn’t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ . Please check out the RC1 bits. Thanks Sachin, Program Manager, SQL Se ...Show All

• Visual Studio Express Editions Missing Template Files For New Projects In Visual Basic 2005 Express Edition

  I've installed Visual Basic 2005 Express Edition and when I click on new project I get them message "No Visual Studio template information found. See the application log in Event Viewer for more details..." If you are familiar with this, I'm sure you know the rest of the line. However, I can see where those files are in my installation folder when I use Windows Explorer. When I try to unzip these files, it would not let me. Anyone else have such a problem and how did you fix it Is there any other way of getting these files in place and showing up when a new project is clicked Suggest looking at the following thread and trying some of the ideas out. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID ...Show All

• Visual Basic saving an Excel Worksheet via Visual Basic 2005 automation

  Hi all, hopefully someone can help with this question, I've searched some forums but not found an instance of it. I've successfully opened an excel workbook via automation from a VB2005 application. The application populates the cells with data as it is received by the application. I want to use the Excel workbook to store data so that I can in the future access that information (weather data) and display it in Graphs etc or read the data into another application. The problem I'm having is that when I close the application I can't save the workbook, however I can trigger the save dialog box and do it that way but the whole point of the application is to run unattainded and collect and store the information. Here is the code I've trie ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .. Tridex for C# guys here is the code to Render OBJ file, but only rendering poinst ...

  I am having problems rendering the obj file with Trianglelist, mabe some one can help here!!! The code loads the obj file with no problems, but when rendering tringle list I get mushed up mesh, can some one hep as I can only render points at the moment!!!! namespace WindowsApplication1 { using Microsoft.VisualBasic.CompilerServices; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Graphics; using System; using System.Collections.Generic; using System.IO; using System.Runtime.InteropServices; using WindowsApplication1.TridexConsultants.Engine.SceneObjects; public class ObjMeshFileObject : SceneObject { public ObjMeshFileObject(GraphicsDevice UseDevice) { this.VertexSizeI ...Show All

• Windows Forms Can't disable a button

  I am programming in c#. I have a button on my form that when clicked, it plays a wav file using the PlaySound method from winmm.dll. The wav is about 3 seconds long. The problem is that if I keep clicking the button during the 3 seconds the sound is playing, it queues all of the clicks, and plays the wav over and over. My Button is named btn. So I tried: this.btn.Enabled = false; PlaySound(...); this.btn.Enabled = true; Doing this successfully greyed out the button while the sound is playing, but it still accepts clicks, so it didn't fix my original problem. Is there some way to clear the event queue Or is there something else I'm doing wrong. I just want the button to not work while the sound is playing. I have also tried ...Show All

• SQL Server Submitting defect reports and suggestions

  There have been a number of questions about how to submit defect reports and suggestions for SQL Server. The SQL Server team uses the http://connect.microsoft.com/SQLServer site to gather customer input. Defects reported on the connect site go directly into our internal issue tracking system so we don't lose any information that customers provide. The SQL Server team uses defect reports and suggestions from customers to prioritize future work. Customer issues are given extra weight in our decision making, so filing defect reports and suggestions on the connect site helps us solve the problems you care about sooner. The procedure for filing an issue on the site is as follows: 1) Navigate to http://connect.microsoft.com/sqlserver 2) Lo ...Show All

• Visual C# Convert Windows Application to Windows Service

  Hi! I have Multithreaded Windows application having two windows for its GUI. I am trying to convert this Windows Application as it to Windows Service. While Starting windows service it gives me message that "The servcie did not respond to start ot control request in timely fashion". Can anyone help me out regarding this Thanking You in anticipation. Regards, Manish Hi Windows services inherit from the ServiceBaseClass http://msdn2.microsoft.com/en-US/library/system.serviceprocess.servicebase.aspx you need to: Any useful service overrides the OnStart and OnStop methods. For additional functionality, you can override OnPause and OnContinue with specific behavior in response to ch ...Show All