Eli Lopian's Q&A profile

• SQL Server SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• Windows Forms Label with invisible background.

  I have a form with a label in it. I want to show the label, covering the whole form, with a number in it. The app is a multii screen image viewer, I'm trying to show which monitor is which. I've set the style to allow transparent background ( I'm interested to know what genius came up with that idea ), I've set the deprecated 'DrawTransparent' property, I've set the background color to Color.Transparent, but no matter what I do, including downloading several controls on the web for transparent labels, I cannot get a label that doesn't erase it's own background to the color of a general dialog box. Does anyone have any suggestions Thanks Historically, "Transparent" in Windows has meant that a control uses the same backg ...Show All

• Windows Forms Checkbox group

  If I have three checkboxes in a group, and want to ensure a minimum of one out of the three is checked...what is a good way of enforcing this Prasant Swain wrote: why are you not using the radion button in group . so that you have to do nothing. it automatically managed. Because the minimum is 1, but there could be more or all checkboxes checked. ...Show All

• Windows Live Developer Forums Firefox Polylines

  I'm trying to add a polyline for tracking of the previous location of mutiple objects. This works fine in IE(Of course) but on Firefox 1.5.0.4 on Mac and Windows all the lines are being put in one place instead of actually having the correct locations. The code is at http://www.wormley.com/t1.html The pushpins were added to illustrate the locations where each line should be(you have to zoom in, the tracks aren't very long) but both polylines are ending up near the left side in firefox. It still doesn't work without the pushpins. Thanks, -Steve Yeah you see that is useful and yet not useful. I'm really glad you guys are fixing things Is there a list of bugs / wanted features somewhere that have been identified are are being "w ...Show All

• Visual Studio Express Editions Problem #including files in a project when the files are contained in another project.

  Hello, I’m attempting to create a win32 console application where, in order facilitate the design, the application’s components are organized into various projects. Therefore, I have one solution containing multiple projects and a main project contains main(). In any given project, I am not capable of including files from other projects in the solution. For example, in the source file containing main(), I use: #include “MyClass.h” where MyClass.h is a file located in another project of the solution, however an error appears at compilation time indicating MyClass.h cannot be found, even though the project encapsulating MyClass.h is in the solution. The same is happening for component projects wh ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How not to display debug FPS in videos

  Hi to everyone. After installing the DirectX 8.1 SDK (debug version) I had noticed that some of my videos (.wmf and other, but not the .mpeg) display the FPS in the middle of the screen. Although this is useful when I am writing some code for testing, it is very disturbing when I want to see any movie or clip. I had entered to the DirectX Control Panel but I do not have an option to select between Debug and Retail (which I believe is the solution of this). However I have several debug sliders in some DirectX components. I have had moved those sliders to Debug minimum but the FPS numbers display on screen, even after a reboot. Any ideas Thank you very much for any help. P.S. : I am using Win98SE and the DirectX 8.1 and corresponding SDK ...Show All

• Visual Studio 2008 (Pre-release) Listview: dynamic loading content possible?

  I've got a listview containing a GridView. I'd like to fill the content of this listview dynamically. So, instead of loading all my items (could be thousands) into an observablecollection I'd like to give the ListView the count of items, and just load those items that are displayed right now. To get this data from the database is no problem, but I need a way to know which lines I need to load to be displayed right now, need to know when scrolling, resizing or similar is changing these. Is there any known way to achieve this Thanks, Sam You could write your own descendent of ViewBase that adds paging You would also need a paging descendent of ObservableCollection Then you could notify the ne ...Show All

• SQL Server Export/import Maintance Tasks

  Hello, is there any way to export/import maintance tasks from one SQL Server to another We have two SQL Server with same DB. Every day launch a couple of maintance tasks for DB to stay in good state. It will be very helpful to make possible to export/import maintance tasks. I see that maintance tasks are SSIS packages stores in SQL Server. But don't know how to export it. Any suggestion Thanks Anton Kalcik Open SQL Server Management Studio Select File and then Connect Object Explorer Change the Server Type to Integration Services, connect to the server Expand to Servername (Integration Services) | Stored Packages | MSDB | Maintenance Plans Right click the desired Ma ...Show All

• Smart Device Development This project requires .NET Compact Framework v1.0, which is not installed on this machine.

  When I try to create a new Visual Basic Smart Device Application (1.0) in Visual Studio 2005 I get a dialog box titled "Microsoft Visual Studio" with the message: "This project requires .NET Compact Framework v1.0, which is not installed on this machine." I can still create new projects in Visual Studio 2003. Add or Remove programs shows the following are installed: Microsoft .NET Compact Framework 1.0 SP1 Microsoft .NET Compact Framework 1.0 SP3 Developer Beta 2 Microsoft .NET Compact Framework 2.0 Microsoft .NET Framework 1.1 Microsoft .NET Framework 1.1 Hotfix (KB886903) Microsoft .NET Framework 2.0 Can someone tell me what I am missing and point me to the install that I need ...Show All

• Visual Basic Culture date format and system dat format conflicting

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july I'm using MS ACCESS2003. I'm using Insert statment insert into tbl1 (testdate) values ('"& date.now &"') so, how can I know what is the culture of the database ...Show All

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

  Hi everyone, first of all i'm not too experienced with c#, but i've been a java-programmer for years. Anyway here comes my question: Why do i get an AccessViolationException in the following code [code] public void draw(SpriteBatch sb) { sb.Begin(SpriteBlendMode.AlphaBlend); if (_tex != null) sb.Draw(_tex, new Vector2(_x, _y), Color.White); sb.End(); } [/code] Where _tex is a Texture2D object. Actually the code executes well until i get rid of the texture by calling _tex.Dispose() (that's the reason why i check if the _tex is null). The line where the error occurs is the last line (sb.End() ). I really appreciate any advice! Chris If your code look as in this snippet ...Show All

• SQL Server MDAC 2.8 Fatal Setup Error. This setup does not support installing on this operating system

  I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error. I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.  There's some other strange things, so I wonder if they are related.  1) I have Paul set up as an administrator account.  Some folders like MSSQL show that account with no permissions.  I grant all the permissions to Paul for that folder.  I come back later and t ...Show All

• Smart Device Development File Version Info On Windows Mobile 5.0 for PocketPC...

  Hello all, I am currently working on a C++ project for a PocketPC with Windows Mobile 5.0 in Visual Studio 2005. I am currently looking for a way to get file version information, i.e. file version, product version, file modified date, file creation date, etc. The only way I could find was using the functions GetFileVersionInfoSize, GetFileVersionInfo, and then VerQueryValue, but when I ran it, it gave me an error saying: "The specified resource name cannot be found in the image file." I noticed in the documentation that these functions do not work for 16-bit file images, which may be why I am getting the error. Is there another way to get this information (i.e. one that works on 16-bit file systems) If not, what infomation ...Show All

• .NET Development Use CoInitializeSecurity() managed code

  I use CoInitializeSecurity() for call method WMI in managed class library C++ but return code is 80010119: the COM security context is already initialize by Main MTAThread of the application. How initialize COM security context in NET managed application Thanks You can't call this from managed code as the CLR loader will already have called it before even a single line of your managed code is run. If you really need to do this your only option is to write a custom CLR host in unmanaged C++ and call it from that. ...Show All

• Visual Studio Express Editions Test plans

  Are there any guides available for writing up test plans How to test something properly, how deep to test the program, any specific ways of breaking a program I know that the programming side is one of the most important things, but as part of my course, I have to write up a program description and a fully detailed test plan with sample data. But I have no idea where to start. Writing stuff up has never really been my forte, I usually just do something and then leave it to be used but obviously, to be a professional, I need to learn how to jump through these hoops. Any advice appreciated well to test, do things like "what happens if I enter a letter instead of a number in this number only textbox ". Test the boundry levels ...Show All