UltimateSniper's Q&A profile

• Visual Studio Express Editions Another Question

  Currently I'm making a media player which is using Windows Media player DLL. And I would like to get the length of the sound which is currently playing in Progress bar, How would I do that Please Help . Sorry. I don't completely understand your new question. If you want to avoid using PlayList altogether, you could write your program to load another song when the current song finishes playing. If your problem is that your program calls the newPlaylist() method everytime you click your "Play button", then I suggest creating another button or menu item which does nothing but load the PlayList. ...Show All

• SQL Server Avegage from 4 columns

  I have 4 columns and i need average from this columns. I can sum values from this columns and divide by 4, but this is inproper in case of nulls. Is there any easy way to do that Right now I'am using: You can use some other syntax to shorten the notation, but you will have to do essentially the same logic. If you have the choice to reorganize you tables, you might want to put the four columns in a separate table. That would allow you to use the Aggregate functions, which already have the NULL handling. Here is an example that shows how to use other functions to shorten the notation. In order to prevent a divide by zero in the case where all 4 columns are null. I chose to return 0, but you could also return null. drop table #colAvg ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Could we translate this soft to chinese？

  The beta will be released tomorrow,it's a exciting moment!We wait this moment for a long time.... I am a member of "XNA Union Of China" ,and it's the first group of the XNA technology in china.It's no-commercial group,We have the same hobby,most of us are students. In order to extend the xna technology in china,Could we translate the XNA GSE( beta )to chinese？ we just want translate the tools of the xna,not the c#, we also don't publish it,we just share them to other chinese XNA fans. I wait your reply........  thanks   EMAIL:yc_dc@126.com  MSN:  yc_dc@hotmail.com For V1, XNA Game Studio Express will only be available in English. We are looking into localizing future ver ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. The error appears to be a web page error I copied what was displayed for the error Line 56 Char:2 Error 'windows.external' is null or notan object Code O URL:http://runonce.msn.com/runonce2aspx ...Show All

• .NET Development Interop troubles with excel

  I asked this in the VB forum, but think it is more suited here. My application (VS2005) uses the interop assembly 11.0 to communicate with excel. 11.0 is the version for excel 2003. When I put the application on a client machine, it's fine provided the user has excel 2003 and either the PIAs are installed, or I distribute the dlls with my application. However, I've just tried this on a machine with O2007 and it's not working. I have installed the O2007PIAs on the client machine. Any ideas I assumed the O2007PIAs would be compatable with O2003... No, the PIAs are version specific. If you are supporting multiple versions of Excel then you should be using late binding. How To Use Visual Basi ...Show All

• SQL Server Can I Debug Remote SQL Server 2000 Stored Procedure in Visual Studio 2005

  I can debug an SQL Server 2005 stored procedure in Visual Studio 2005 from a local database (e.g. AdventureWorks). However, when I try to debug a stored procedure on a remote server running SQL Server 2000 the debug process is not accessible (i.e. I can choose 'Step Into Stored Procedure' and it seems to run but I cannot debug it). Am I trying to do something that just can't be done Is this a compatibility issue between Visual Studio 2005 and SQL Server 2000 Or am I missing something Thanks for any advice on this. Richard As far as I can see, Server Explorer in Visual Studio does not give me a 'Modify' option. It gives me a 'Step into Stored Procedure' option that does not seem work fo ...Show All

• SQL Server Computed columns and constant

  Hi, I have a small problem with my database. I've got following situation: I have a computed column, which value is base on currency rate: rent * rate. Users have to have possibility to change currency rate easily (maybe another table or constant). Is there any way to create formula, which would compute value properly, via constant or something like this Or the easiest workaround would be load data into dataset (I'm building asp.net application - database will be very small - couple of hundreds of records) and make calculations programmatically Przemek hi, computed columns can only be based on constants, variables, functions and columns of the same table, and the last one exclude your Users hav ...Show All

• SQL Server Using Merge Replication, Parameterized Filters

  Dear ppl, I am using Merge Replication between SQL Server 2005 (Publisher) and Pocket PC (SQL Mobile 2005-Subscriber). I have a Windows Mobile appliction on the Pocket PC that replicates data from the server. I am using SqlCeReplication class on the Pocket PC application to synchronise the data. By default, when i call the Syncrhonise() method, it pulls all the data from the server. What I want is to pass a parameter from the Pocket PC and filter the data based on that paramter. E.g. from the Employee table, I want only those Employee that belongs to a CompanyID that I pass as a parameter. Is there a way to do this, so that i can pass parameters from my PDA application (Windows Mobile), and make the Filters specified in the Pu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 Wireless Controller on a PC

  I've downloaded the drivers for the XBox 360 controller from the MS hardware website, yet when I connect my wireless controller via the USB cable, the "Found New Hardware" wizard fails to recognize it (and continues to prompt for the drivers). What am I missing here Thanks, -dn that's funny I have 2 as well, but the only time the second gets used is when my brother comes to visit.       ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. FileNotFoundException

  Running the game get's me: System.IO.FileNotFoundException was unhandled Message="The specified module could not be found. (Exception from HRESULT: 0x8007007E)" Source="MySpacewar1" StackTrace: at Spacewar.Program.Main(String[] args) at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.Threa ...Show All

• Windows Live Developer Forums Problem with pop-up and search

  Hello everybody, I have been using Virtual Earth API for just a little while, but I have to say that they are great and very easy to use. In my project I have some problems and I don't know how to work them out. The first problem is the pop-up window that appear when you perform a search. I would like my search to go on the first result, without showing the others on the pop-up, but I can't find a method that allow me to control the window. Is there a way to control it The other problem is related to the search operation. Is it a problem of mine or Virtual Earth doesn't perform search operations on a specific address I mean that you can search a city, but not in it. I try to search in this way: address, city, state; but without positive r ...Show All

• Visual C# FileWatcher - Windows Service needs to be restarted periodically in order to work.

  I have a Windows Service that spawns a couple of threads and looks in two separate directories for files to be dropped. The service works fine, and has run fine for over a year, but every once and a while the service needs to be restarted and I want to fix it so it doesn't need to be restarted. It sometimes seems to be related to the database restarting or server restarting but not always. What can I build into windows service like this that runs all the time in order to protect itself and prevent manual intervention. use try catch blocks at spots where you think necessary. I had suffered the same problem....the database server was not working and my windows service started to misbehave. I reviewed the code ...Show All

• .NET Development Trying to pass parameters to my Windows Service but how?

  hi everyone, From my Service Manager built-in in MMC no problem at all because I can perfectly allocate both parameters in "start parameters" box but how do the same from NET START command Or even better, how from another VB application I've tried to do this: NET START "MyService", "sql1","Bd1" but it did not work. Let me know if possible do (at least) from DOS session. Thanks in advance for your time. I've seen sc utility but it doesn't support parameters either nobugz is pointing out that when you asked about starting your service from another app you can use the ServiceController class to start a service. You call ServiceController.Start with a string and get that string ...Show All

• Visual Studio Express Editions Word 2003 and C# Express 2005

  Dear Consultants, Do someone know how to work on word 2003 document through Microsoft Visual C# Express 2005 I am interested especially in cut and paste of text from document to document and macro initiation from out side of word. Sincerely yours Ron Here's some select snippets from a recent project. You probably need to add a reference to Word/Office (project/add reference/ Microsoft Word COM Object library). Use Word's macro recorder to gather info about the methods your code needs to invoke. I found I had to resort to sendkeys in some instances. using Word; . . // method variables Word.ApplicationClass wordInstance; object objMissing = System.Reflection.Missing.Value; . ...Show All

• SQL Server min server memory option and memory paging

  I have problem with sql memery usage. In same case sql paging the data to virtual memory on disk and relese physical memory. And if SQL relese physsical memory, he dont consider min server memory (MB) option (4012MB), after relesing sqlserv physical memory usage is only 500MB. And after sqlserv restart his memory usage is only about 500MB. Perfmon counters: Pages/sec 1450 %Commited Byte in Use 43% %Usage Total Page File 87% Available MBytes Memory 6480 MB My server is: 9.00.2153.00 SP1 Standard Edition (64-bit) Server memory 8GB sp_configure: awe enabled 0 1 0 0 min server memory ( ...Show All