Starlionblue's Q&A profile

• SQL Server how to get Lastest two records for each cutstomer_number

  Hi , My Requirment goes like this. In a table say X , i have two column called Customer_number and date_received. What i need to find is, lastest two enteries for the customer number. That is top 2 records for each customer_number. the query out put is some thing like this, Cust Number Date_received 1234 06/06/2005 10AM 1234 06/06/2005 08AM 1235 06/06/2005 10AM 1235 06/05/2005 10AM 1236 06/05/2005 11PM 1236 06/04/2005 06AM How can i achieve the above functionality. I hope i was clear in my explanation. Regards, Chetan CREATE FUNCTION y ...Show All

• Visual Studio Express Editions Runtime Error

  I have a problem with Word on XP I keep getting a dialouge box up that says Microsoft Visual C++ Runtime Library X Runtime Error Program C:\program files\microsoft office\office 10\WINWORD.EXE abnormal program termination Any suggestions anyone Yes this worked for me i have not had this error since Grey Bob ...Show All

• Visual C++ SOS:VC2005 B2 Express VC++ Directories Problem

  I downloaded and installed VC2005 B2 Express, I can't set "VC++ Directories". screenshot: http://member.netease.com/~lilong/temp/VS2005ExOpt.jpg is this bug this is a BIG PROBLEM!!   NNTP User wrote: ... 1. Create a directory "PlatformSDK" under "%ProgramFiles%\Microsoft Visual Studio 8\VC" 2. Copy the "bin", "include" and "lib" directory from the PSDK-installation into this directory. Then you do not need to change any config file. ... Thank you very much. I just encountered the same problem and found this thread. ...Show All

• Visual C# Working with database data in textbox controls instead of datagrid?

  I've learned how to display/update data from a database in a datagridview control. But when working with one row at a time, i would prefer to make a nicer GUI, with textboxes/checkboxes etc. Are there any easy way i can achieve that Reading and displaying is one thing, but what about updating Does anyone know where i can find any tutorials that demonstrates working with data in other controls than the datagridview Example: A GUI with a button that fills the textboxes with data from a data source, a button that updates any changes to the db, and buttons that lets me select previous/next records. Btw, i'm working with a Mysql database, so i ...Show All

• Visual Studio Express Editions How to rearrange filter groups in VC++ Solution Explorer

  By defining specific "filters" you can subdivide a project into subgroups like "Source Files", "Header Files", Resouce Files" etc.. Is there an easy way to change the order of these subgroups I could, of course, manually edit the XML-formatted .vcproj file of the project, but I think there should be a less awkward and error-prone way to achieve this. Note this is new behavior in 2005. In 2003 it maintained the arbitrary ordering. See this to vote on it: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=778458ae-2259-4778-b5a5-5cab963168 ...Show All

• Visual Basic AnalogTVTuningSpace and MSVidCtl

  I´m trying to develop a decent tv tuner/capture application (since there are no such apps, nowhere, I say) in Visual Basic 6.0. I´m using the MSVidCtl component together with the AnalogTVTuningSpace and IChannelTuneRequest object to achieve this, as described here:  http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/directX/htm/hostingthevideocontrolinavisualbasicform.asp  and here:  http://msdn.micro ...Show All

• Software Development for Windows Vista autoexec

  where do I get the answers for the questions posted in the forums You will get the answers here, or what do you mean Read this post for how to get general Windows Vista support. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=423586&SiteID=1 ...Show All

• Visual Studio Express Editions C# express installation... Please please please help...

  When I try to install the C# Express edition I am having a big problem. I am told to install the service pack 2 for XP. I tried to do this but I then have some kind of problem with my product key. I bought my computer on ebay and I think that my xp version must be copied or something. I am told to go to howtotell.com but I cannot figure out how to fix this. I am a young guy trying to learn C# programming and I really want to get the new express edition. I would be so happy if somebody could help me get around this problem.... Thanks, Virtue Well, apart from this being the wrong forum. You w ...Show All

• Visual Studio Express Editions Microsoft SQL Server 2005 Express Setup - Installation / Incompatible Components

  Hi, I'm having trouble installing SQL Server 2005 Express.  It keeps giving this message:  "SQL Server 2005 Setup has detected incompatible components from Beta versions of Visual Studio, .NET Framework, or SQL Server 2005.  Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again.  . . ."  I installed a Beta version of Visual Studio over a year ago, and this may be causing the problem, however, I have tried uninstalling everything (Add/Remove Programs), and I still get this message.  I have also tried manually deleting in Windows Explorer the "Microsoft SQL Server" fold ...Show All

• Visual C# Published VC# 'setup.exe' fails.

  My project runs with no errors when started from the IDE with or without debug. I am publishing it to the desktop, and is intended to run from cd, with no upgrades. It publishes with no errors, however, when I execute 'setup.exe ' I get the following error message: "project name" has encountered a problem and has to close. publish to another folder, not the desktop. see if that helps. It also looks like your project does not have a name, you should name it something useful so your users know what it is (once you get it working). mcm ...Show All

• Visual Basic GetOpenFileName API

  Hi, I am relatively new to the use of APIs but have been able to use GetOpenFileName API to display open file dialog box. The OpenFileName structure has an interesting member lpfnHook. Some article that I have read from the net describe how to use this to hook a cmndlgHookProc to this dialog box. But those articles give info on C, C++ etc. and I haven't been able to use this in Visual Basic. When attempt to assign addressof cmndlgHookProc or simply cmndlgHookProc to this member I get a compile message error(actually I am trying it in MS Access 2003). I am greatly fascinated to calling hook procedures for doing various exploratory things. Can ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Simple DirectX 2.0.0.0 question

  I'm wicked confused. the Managed DirectX 9 (v1.0.2902.0) dll doesn't have any XFile handling capabilities. the DirectX v2.0.0.0 has Xfile support but doesn't have ANY documentation support and is much different than 1.0.2902.0. Then i hear both of these are to be replaced with XNA all i want to do is make a managed program that can import Xfiles. MDX 2.0 is not a complete API - its still in beta and since XNA framework is announced it will never actually release in its current form. If you have specific 2.0 questions head over to the beta newsgroup http://msdn.microsoft.com/directx/beta/default.aspx If ...Show All

• SQL Server Problem attaching a database using user instancing

  I have a database that I am distributing with my C# 2.0 application as an .mdf file meant to be attached at run time. I created the database on a copy of SQL 2005 Developer edition, and detach it and copy it to the test machine for testing. It has recently been complaining about not finding the .ldf file. According to the article here: http://msdn2.microsoft.com/en-us/library/ms165716.aspx I am not supposed to distribute the ldf. The only way I can get the database to attach properly is to put the .ldf in the Data directory under 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data', though the .mdf file is fine in my application direct ...Show All

• Visual Studio Team System False positives with IsTrue/IsFalse

  Hi - I have recently started using FXCop version 1.35 on Visual Basic 8.0 code. After corrections I have a dll with just two messages: D:\EAH\Shared\SqlServices\SysAdmin.vb(15) : warning CA2225 : Microsoft.Usage : Provide a property named 'IsTrue' as a friendly alternate for operator SysAdmin.op_False(SysAdmin)Boolean. D:\EAH\Shared\SqlServices\SysAdmin.vb(20) : warning CA2225 : Microsoft.Usage : Provide a property named 'IsTrue' as a friendly alternate for operator SysAdmin.op_True(SysAdmin)Boolean. The SysAdmin code identifed in error is the implementation of the IsTrue and IsFalse operators as follows: Public Shared Operator IsFalse(ByVal ...Show All

• Visual Studio Express Editions Using Visual Fox Pro 9 DBFs files in Visual Basic Express

  Is it possible to use VFP 9 DBFs in Visual Basic Express I would suspect so, but cannot be certain. And to answer your next question (how), these web sites are a useful resource (swiped from a previous post with regards to database connections). http://www.connectionstrings.com/ http://www.carlprothman.net/Default.aspx tabid=81 Your best bet is to try it out. ...Show All