Zooz's Q&A profile

• SQL Server Problems with getting usersort control to work

  I am having trouble enabling end user sorting in RS2005. The sorting buttons do appear in the rendered report but dont propagate the sort back to the dataset. This is a generic "select * all rows" dataset on top of stored proc that has no params or fiilters. Is there anything special that needs to be configured on the data source end of this to support the end user sorting I have set the SortExpression to =Fields!LastName.Value to sort on a LastName field, and set the SortExpressionScope to the table named table1 and the SortTarget to the UsersDS which is the dataset. The UI structure is a Table named table1 with the UserSort settings configured in a column header. Whats the next thing to check to get this working Dal ...Show All

• Software Development for Windows Vista directshow filter : splitter

  Hi, When I want to run a mp3 file, could you tell me what is doing the mpeg 1 splitter As The mpeg1 splitter splits an MPEG-1 system stream into its component audio and video streams and I have only audio. Thanks a lot The source filter is pull-mode and the rest of the graph is push-mode, so you need a filter to convert between the two. Typically this filter will also do the seeking and timestamping of samples. So you will often get a demultiplexor in the graph to do these tasks even if there is no actual demultiplexing to do. G ...Show All

• Visual Studio 2008 (Pre-release) Updated WPF blog - with 3D navigation

  I have updated the WPF blog for June CTP: http://www.valil.com/Valil.Blog/Valil.Blog.xbap The new feature is the blog navigation - use "Navigation" button to enter, click on the left/right "tiles" (even if they are not visible) to navigate and click on the front "tile" to exit navigation mode. ...Show All

• Visual Studio Tools for Office VS SP1 Beta & VSTO 2005

  I installed Visual Studio SP1 Beta on one PC that already had VSTO 2005 installed. When I open an existing VSTO project and double-click the document.cs file in solution explorer VS exits completely without any error message whatsoever. Is this a known problem Is it your existing VSTO project Outlook Addin project Which platform did you install the SP1 Beta Thanks -Qiong Ou (MS) ...Show All

• Visual C# Condition to check the Window properties..

  Hi, I wish to modify some settings in a custom control based on the Window Properties -> Appearance -> Color Scheme.. How can I check with that.. Thanks, The simplest thing is to use System.Drawing classes like SystemColors, SystemBrushes, SystemPens and SystemFonts. If that's not enough then you'll need classes from the System.Windows.Forms.VisualStyles namespace (assuming that you are using .NET 2.0...): This property of VisualStyleInformation gets you the name of the current Color Scheme: http://msdn2.microsoft.com/en-us/library/system.windows.forms.visualstyles.visualstyleinformation.colorscheme.aspx You can also use the VisualStyleRender class to get specifi information about the current color scheme: htt ...Show All

• Windows Live Developer Forums Using .FindLocation with an address that contains a '#'

  Using .FindLocation with an address that contains a '#' I get an 'Object does not support this property or method.' This is in the: VE_SearchManager._HandleFailedWhereSearch method. Any ideas -Steve   Developer Steve wrote: Using .FindLocation with an address that contains a '#' I get an 'Object does not support this property or method.' This is in the: VE_SearchManager._HandleFailedWhereSearch method. Any ideas -Steve Thats because you have to escape the # sign in java correctly, one way to do this is to put in %23 rather than #.  Or you can google "javascript escaping characters" for this one ...Show All

• SQL Server Creating Total to-date query...

  I am trying to create a query where the data is for a time period but there is one column that would show a Total-to-date. I've tried google and searching this forum but everyone talks about year-to-date or period-to-date but I don't want that. I would like to do : [from whenever data started being entered]-to-date I know I can hack this by doing an aggregate like so: WITH MEMBER [Timesheet].[Date].[TimeChargedTotal] AS 'Aggregate ( { [Timesheet].[Date].[Year].&[1900].&[1].&[1]:[Timesheet].[Date].[Year].&[2006].&[9].&[15] } )' Here I am betting on the fact that there is no data before 1-1-1900 which is a safe bet, but I'd prefer to do it the 'right' way if there is one. Thanks. I am not familiar ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. KeyEvents?

  Is there no functionality for getting KeyDown/Up messages in XNA as well as gamepad button down/up messages If you just get the state of the keyboard once a frame, if the framerate slows the input will become unreliable. What kind of game are you writing All the commercial games I've ever worked on (mostly racing games and shooters, on N64, PS2, and Xbox) polled input 60 times a second, and never had any trouble with that. I would imagine that a beat-em-up could need to go faster, but having never written one I don't have a good intuition as to how fast would be needed. My advice would be to just ignore the problem until it crops up in practice. It's the kind of thing where you could spe ...Show All

• SQL Server Wrong values stored in a field of Datatype Float

  Hi, When i try to insert a value in to a field of datatype float(8), it is storing the wrong values(approximate values). For example, if i try to insert 2.62 , it takes it as 2.6200000000000001 But i can see the correct values displayed in the frontend. Heard that there is a fix available for this issue. Could any of you help me in getting the details about that fix Thanks in advance. ~ Chaitanya In addition to what Jens said, read here about the float datatype: http://msdn2.microsoft.com/en-us/library/ms173773.aspx It is what is called an approximate datatype, so you can have some minor (mathematically insignificant) differences between what you expect and what ...Show All

• Architecture what is more performatic? a single join or multiple selects?

  In my app we have some methods where we start it by selecting a whole bunch of information (in DB), compute a lot of of things and then fire some save commands to update this new information in DB. Well my question is what to choose when I have 2 options: 1) to query a huge SELECT command joining all needed tables all at once. Then all information I might need would be brought in this select. 2) to select the main table and then in each step of the iteration, based on what I really need, I go selecting information in other tables, passing the IDs I brought in the main table. Why would I choose one or the other What is more performatic I am using an ORM, which, for the moment, does not work directly with joins, so if this wou ...Show All

• Visual Studio Report Viewer (Local) & Dynamic Input

  I'm trying to figure out how to make a report based on dynamic input or how can I do a report from an specific SQL query instead of a DataSet Table. -Thanx Can it be posted here. My company proxy only allows me to view microsoft pages. For what I've found so far, to be able to create a report in Local mode, I have to have the data in the Data Source. So the only way is to have a table already created and fill() it with what ever I want the report to show or create a Data Source from an Object. If I remember right in MS Access all you needed was a query to creat a report and it was basically the functionality I was looking for. I haven't looked in to Crytal Reports, can someone with experience with both co ...Show All

• .NET Development https server requesting a certificate

  i manually go to a website and login, at first it had me set up a certificate, now it just asks me for my password. i want to run my app so that it starts iexplorer goes to that page sends a certificate info to the https server and sends my password so that i dont have to manually enter it. i am not really sure how to connect to the https server and send it my certificatio info and when its accepted how to send it my password. any ideas on how this might be accomplised what objects should i be looking at under Framework 2 that cert issue is not really that big of a deal its just rather annoying for testing. i have a few other small issues that i would like some advice on if possible. I believe i am access ...Show All

• SQL Server How to Show Last Admit Date

  I have a report that shows patient information, such as patient number, name, and admit date. It also has a date parameter. I enter in the date and it shows all the patients admitted that day. I would like to show the last date the patient was admitted before the date I ran the report for. For example, if I run the report for 12/20/06, I want to see the patients that were admitted that day and their info like name, and patient number. I would also like to see the last date they were admitted. Could you just do a subquery to get the max date for each patient from before the date parameter Something like this: select ... (select max(admit_date) from patient_admittances pa where p.patient_id = pa.patient_id and admit_date < ...Show All

• Visual Basic how to write a loop to access all labels on a form

  I have more than 200 lables on a form. When a button on this form is clicked, I need to update the display of all these lables. How can I write a simple loop to do that Hi, the following code will loop through all controls, put directly on your form and assign a new text to all controls that are labels: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click     For Each control As Control In Me . Controls         If TypeOf control Is Label Then             Dim myLabel As Label = DirectCast (control, Label ...Show All

• Windows Forms RitchTextBox

  Hi all I am using a RichTextBox Control in my program and want save the contents of the Rich TextBox to a file. Here I have used the ritch textbox cntrol's Savefile method to do that but when i call this method it is giving the following error. An unhandled exception of type 'System.NullReferenceException' occurred in system.windows.forms.dll Additional information: Object reference not set to an instance of an object. I donot know why it is happening. Please help me; ...Show All