Harryc#site's Q&A profile

• SQL Server SQL Query Help

  I have table called "Workout" with column name WorkoutID,MemberID,WorkoutDate One more Table Called "Rebate" with column MemberID,Month,Year,Resubmit In temp table I wanted to insert WorkoutID,MemberID,WorkoutDate whose Rebate.Resubmit ='Y' and Workout.MemberID =Rebate.MemberID and (DATEPART(MM,WorkoutDate) = Rebate.Month AND DATEPART(YYYY,WorkoutDate) = Rebate.Year) now it is possible that there will be a row in Rebate Table with ReSubmit='Y' but has no workout in workout table for that row i wanted to insert MemberID only how the query will look like its not working. i forgot to mention before that i have to join "Program" table also to get only those members wh ...Show All

• Smart Device Development Keyboard scan code in emulator skin

  I've been remapping an adding some buttons in the smartphone skin to emulate the form factor of my final device but I can't figure out what the scan code values are. I've looked at the output from my keyboard device driver and they don't match the values in the skin. e.g. volume up 0x40 = device scan code 0x47. Some values simply don't even reach the device driver e.g. 0x59. What is going on here Petchey, The emulator emulates the Samsung SMDK2410 board, which has a fixed set of scan codes. Therefore some of the possible 255 scan codes are invalid. Please tell me if the unchanged buttons on the skin generate the correct codes. Thanks, Vijay ...Show All

• Visual Studio Express Editions BgWorker report Progress

  Im trying to get my BgWorker to report his progress.. i do private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { progressBar1.Value = e.ProgressPercentage; } and it dont work :s *Reportprogress support is Enabled = True ---- *My BgWorker downloads a file with WebClient Whilst perusing another tutorial site, I ran across this link: http://www.geekpedia.com/tutorial196_Creating-an-advanced-download-manager-in-Csharp.html which might be relevant to your problem. ...Show All

• Windows Forms how to show nothing when a 0 is in a binded textbox

  Hello everyone, I would like to show a blank textbox when the binded value of that textbox is 0. Any idea of how can I achieve that Thanks in advance. Hi, you could try either: a] Setitng your binding's null value to '0', or b] Handling binding's Format event. Note that depending on your needs you might also need to handle its Parse event for transforming the empty value back to '0' when storing data back to underlying datasource. Andrej ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX 10-Vista

  I owe a computer with W. XP.I'm going to upgrade it to Vista.My question is if directX 10 needs only Vista to run.My system is fueled by ATI radeon x1600 pro.Do I have to change it or just have Vista Vista supports any former DirectX Interface. There are some limitations on the 64 bit version but Direct3D 9 will be fine there too. As D3D10 requires D3D10 hardware you have to use Direct3D 9 for any older hardware. If you want to support a wider range of techniques (fixed function to Shader Model 4) in your application you will need some kind of engine abstraction that uses both versions of the API. ...Show All

• .NET Development JScript.NET compilation in debug mode taking an extra-ordinarily long time

  Hi, We have a web site project that is using JScript.NET as the language for our aspx and app_code files. Since we are migrating legacy ASP to ASP.NET we chose JScript.NET. We have about 250+ class files (.js files) in the App_Code directory. On a machine with 1 GB RAM and 2.0 GHz CPU, we find that normal compilation (of the App_Code and App_GlobalResources) takes around 2-3 minutes. However, when we compile under debug mode( setting debug=true in web.config file), it takes an extra-ordinarily long time. As long as 15 minutes for every single change you do to files in the app_code directory. This is killing our development time. We have set the build option to build a single page and not the whole web site in the web site property pages ...Show All

• Visual Studio Adding (and editing) .suo files to source control

  Hi, I hope I've asked the question at the right place. Our project uses a different than default working directory, so this has to be set in Debugging > Working Directory for the clients. The problem is the working directory is saved in the hidden .suo file which one cannot edit by hand so easily. Is there a way of creating a new .suo file with only the binary data for the working directory in it, add that to source control I presume on checkout VS will then reconstruct all other paths and stuff in there for the users. Solutions either for VS2003 or VS2005 would be great. Donnu why that file has to be binary though, if it were like the .sln or .vcproj files it would've worked. Hi, I don't know ...Show All

• Visual Studio Express Editions reading numeric data from excel sheet

  Hi All , I am trying to read data from the excel sheet but i am facing problem when there is any numeric data is cell it gets Null value. Can some one please help me how can i read the numeric value from the excel sheets. If the same cell is having some other kind of data it is reading that data. Thanls Avinash Kundal HI , Thanks a lot i am able to solve this with your help.I am really very greatfull. If i can help you somewhere i will be really happy. My id is avinashkundal@gmail.com you can contact me here. If i get any issue i will mail back. Thanks ...Show All

• Windows Forms How can I change the size of Mouse pointer from csharp code?

  Hi All, Please let me know ,how can I change the size of Mouse pointer.I know there are some functions some where in a dll.But cant fifure out . Thanks in Advance. Joy Hi, Thanks for the explanation. Is there any method to does this programmatically Is it possible to make these changes through programmatically If so what is the method need to use.. Thanks for your time. ...Show All

• SQL Server uninstalled SQL SERVER 2005 Express but SQL server 2005 CTP component not uninstalled

  hi, i tried to uninstall SQL Server2005 Express Edition which was installed as a component when i installed visaual studio 2005. i removed it from control panel, add/remove programs. but SQL server 2005 CTP component is still there in programs section. it is not removed. what should i do to completely remove all the related files of SQL server 2005 Express edition, as i want to use SQl Server 2000 for my project. plz reply asap. Have a look at this blog, perhaps that might help you uninstalling everything that is related to the Beta products: http://blogs.msdn.com/astebner/archive/2005/04/19/409555.aspx HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# How to check if .Net 2.0 and SQL EXPRESS is installed?

  Hi I have developed windows application using VC#2005 Express and then I create a Setup file for my Project using VS2003 I want when the user try and install my application to another machine it first detect if .Net 2.0 Framework and SQL EXPRESS is installed so that the application can run properly. is there a way to do this inside C# code or any other way or when you create a setup file in VS2003. Your help will be highly appreciated well, you would be best creating a setup installer in VS2005, as it will install the appropriate framework if it does not exist on the machine however I believe this is one of the limitations in the express editions Otherwise, take a look at this, which will show you the CLR version: htt ...Show All

• .NET Development Cannot load type ...

  Hi, i have a problem. I have a class to do remoting, but i can't do it. The class is: namespace PoolHCService { public class RemoteHCPoolRef : MarshalByRefObject { } } In the server app.config i have: <configuration> <system.runtime.remoting> <application name="RemotePoolServer"> <service> <wellknown mode="Singleton" type="PoolHCService.RemoteHCPoolRef, PoolHCService" objectUri="RemotePool" /> </service> <channels> <channel ref ="http" port="7782"> <serverProviders> <formatter ref ="soap" typeFilterLevel="Fu ...Show All

• Smart Device Development Some Boot problems with WM5.0

  Hi everyone, I am new to WM5.0 ,and now i have some problems with the startup of the kernel,someone plz help me ,thx a lot! Here is the problem: I have removed the driver for intel statra flash from the .bib and the .reg ,and add some hive boot reg setting to platform.reg .But when i download the NK.bin to my RAM var Ethernet ,the kernel always handup, and from the SecureCRT those message is displayed: Windows CE KernelInit .......................... 0x83fcea40: Unable to unset simulation mode 0x83fcea40: Unable to clear update mode flag in IMGFS. Someone plz help me out, and many many thx ! ...Show All

• Visual Studio 2008 (Pre-release) Hiding a window triggering the Closing event?

  Hi all, maybe i'm a novice to WPF but, is there a way to hide a window during the closing event or better, is there a way to disable\hide the closebutton of a window object Using the following code I get this error: Cannot set Visibility or call Show, ShowDialog, Close, or Hide while window is closing. private void SearchForm_Closing( object sender, CancelEventArgs args) { Save(); // Doing something Hide(); // Trying to hide args.Cancel = true ; } Thanks Hi Fabio, what you are seeing is expected behavior. There are couple of options: (1) As suggested, you can turn off the default Window system buttons by setting WindowStyle to None, and create your own custom system buttons, so you can call ...Show All

• SQL Server Importing a SQL Server 2005 database into SQL Server 2000

  Hi there, Just wanted to ask is it possible to 'restore' a SQL Server 2005 backup file into SQL Server 2000. What I mean is that we are being supplied with a SQL Server 2005 backup file, but we currently use 2000 Can we use this or do we need to upgrade etc Thanks. Simon Jefferies by using import/export wiz we can only import/export tables & views, what about other objects like SP, triggers, user functions etc ...Show All