iq662000's Q&A profile

• SQL Server Union Ordering

  Hello, I'm attempting to run three separate queries and have them returned as one recordset. I need to show the top 10 customers based on the number of orders they placed for each of three months, then combine them to give a representation of which customers have been within the monthly top 10 for the overall period of three months. My problem is when I run a count on the number of orders they have placed and order by that count, it is in ascending order which in escence shows me the bottom 10, not the top 10. To resolve this issue, I can specify descending order. This works fine with one query, but when I run all three queries using union statements, I can only have one order by which returns incorrect results. Here is my query. In thi ...Show All

• Visual Basic VB 6 help

  Hi. I am 10 and I am trying to write a VB6 program and I am having problems. I want to have a form with two text windows, one on the top and one on the bottom of the form. I want to type something in the top window, and have it appear in the bottom window IN COLOR. I want to use IF statements to change the colors. For example, when I type an "a", I would want it to come out blue in the bottom window. If I type an "A", I would want it to come out red in the bottom window. I would write IF THEN statements for all 26 letters, both uppercase and lowercase. I want it to be realtime. As I type in the top window, I want it to appear in the bottom window in the correct colors. But I am stuck. I would appreciate any help. Thank ...Show All

• .NET Development SQLQuery syntax error using MS ODBC driver for Paradox

  There is a table named #2006_06.db. Query "SELECT * FROM #2006_06" results in a syntax error because of a sharp sign. If changed to "SELECT * FROM '#2006_06'" or "SELECT * FROM "#2006_06"", the same error occurs. How do I change the query to make it work I use: MS Visual Basic 2005 Express, .NET Framework 2.0, MDAC 2.81.1117.0 The '#' symbol is used as the delimiter between the file name and file extension (if specified) in the SQL expression. As Val indicated, you will need to rename the file. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Ref Device

  Is wether there is there any work on optimizing the reference device, although it is nice to play around with DirectX10 the frame rates makes it difficult to get valid visual feedback. I am using Vista RC1 x86 on a NV40 with NVIDIAs 96.33 forceware driver. David Weller - MSFT wrote: Jack Hoxley wrote: As Ralf said - the RefRast is not really designed to be fast (although I'm pretty sure they will, if not already, optimize it where possible). RefRast isn't supposed to be "optimized"..it's a reference implementation, which means the focus is on accuracy and debugging, not speed. I wouldn't expect that to change much. Fair eno ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Books on XBox 360 and XBox Live Development for eLearning?

  Hello, I'm sorry to be such a noob, but if you have children, please consider offering me some assistance. I'm studying what it would take to put a SCORM compliant Learning Management System like Moodle ( http://moodle.org ) on XBox Live with the goal of offering downloadable eLearning that would lead to "Achievements" in things like basic math, geography, and other academic topics, in an entertaining manner. Before I get started, I'd like to read a book on XBox 360 and XBox Live development and find out a few things. Can someone please recommend a good book on XBox 360 and XBox Live development, targeted at an intermediate level C# programmer with Visual Studio Is there a Macromedia/Adobe Flash player for XBox 36 ...Show All

• Visual Studio Express Editions How to create user control textbox that accept only numeric characters

  How to create user control textbox that accept only numeric characters and has all his properties and methods i create that but how can i add textbox properties and methods in my user control create a class of you own and inherit it from TextBox and Override the KeyPress event and write the code there to accept only the numeric key value. Private Sub myTextBox_KeyPress( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles MyBase .KeyPress If (KeyAscii < 48 Or KeyAscii > 57) And KeyAscii <> 8 Then e.Handled = True else e.Handled = False End If End Sub ...Show All

• Visual Studio Printer setup at runtime?

  Where can I find printer setup function in .net cr viewer (vs2005) I want to change the paper size and preview it at runtime, cannot cr viewer only has a print button, which will print report to printer directly. In non .net cr viewer (crpe32.dll), it has a printer setup button, which allow to preview and change paper size on fly. Does .net cr viewer have the same function too If not, is it possible to implement it by myself Thank you very much!!! ...Show All

• Visual Basic Help! Insert Text Into Rich Text Box

  I can't seem to figure out how to take text read from a listbox and insert it into a richtextbox. I thought this would work: Dim insertText As String = ListBox1.SelectedItem.ToString myPos = RichTextBox1.SelectionStart RichTextBox1.Text.Insert(myPos, insertText) What am I doing wrong Help!!!! Thanks! Thanks for the quick response! I should have explained better... My bad... I am populating RichTextBox1 with what amounts to a tab-delimited text file that I am reading from my UNIX server: Dim file As New System.IO.StreamReader(editFile) words = file.ReadToEnd() file.Close() Kill(editFile) Me .Hide() Dim frm15 As New Form15 frm15.RichTextBox1.Text = words frm15 ...Show All

• SQL Server Column index

  Hi there: Is there any way to retrieve the column index based on its name I tried using the ColumnCollection property of the Table object, but it is not a "real" collection, so the IndexOf["MyColumnName"] doesn't exist. I have the Database, Table, ColumnCollection and Column objects available, is there any other way I can retrieve a column's index in the table Thank you If you create a variable of type Column, say colThisOne, you can populate it by the following statement: colThisOne = table.Columns("MyColumnName"); Does that help It doesn't give you the order number of the column in the table, but relational theory says that the column order doesn't matter. If it does, the best I can ...Show All

• Visual Basic vb6->.NET 2.0 conversion 'ByVal sName As Any' argument for c++ 'char szName[128]' param

  what would be the appropriate .NET 2005 equivalent parameter be for this vb6 pinvoke declaration Public Declare Function foo Lib "foo.dll" ( ByVal sName As Any ) where the c++ argument for the parameter sName is is 'char szName[128]' Related question (I hope) I am confused as to when I should use 1. <MarshalAs(UnmanagedType.LPStr)> ByVal sVar as String rather than simply 2. ByVal sVar as String for cases where the vc++ parameter is char *sVar Thank you, -Greg Thank you for your patience Abel.  And  this application is going to be running on a 64 bit machine rather than the 32 bit which it has been run ...Show All

• Visual Studio 2008 (Pre-release) Return a strongly type DataTable problem

  I have a method which will return a strongly type DataTable in WCF service. While calling it in client it will return a new DataTable but in fact it should return 5 records. Anybody know what happen and how to resolve it Thanks, Zhihao For example: I have a method named "GetCode" in service: public TFDataSet.T_CODE_TABLE GetCode(). it will return 5 records normally from DB. but now it return 0 records. I don't know why ...Show All

• SQL Server Management Studio Express installing error in Vista

  At installation Management Studio Express in Vista there is a mistake with what that number. Management Studio it is not supported in Vista Same error trying to install on Vista Ultimate 64 bit. Warning Icon The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506. [OK] Installation is rolled back. The Event Viewer shows that the MsiInstaller errored with Event ID of 10005. Tried it twice with the same result...   Finally I enabled the Administrator Account and logged in as Administrator. Then I ran the .msi successfully. ...Show All

• Software Development for Windows Vista Error while running application on VISTA

  we are developing some multimedia application, everything is working fine on XP and 2000, but on Vista I'm getting the following error when I'm calling a COM server method with a BSTR parameter: "Duplicate Memory Free operation. Get a stack trace and report bug against the calling app (not against OLE Automation). File: d:\rtm_edw\com\oleaut32\typelib\oautil.cpp, line 602" Anyone could help me Sorry - none that I now off - automatic elevation would betray the thought behind UAC. You might try to patch RegSvr32.exe to add a manifest which states that RegSvr32.exe needs admin privileges. That might at least trigger the UAC dialog in your post-build step. Check this blog to get an ...Show All

• SQL Server Current package reference.

  hi Iam developing a custom ssis source component, in that i need to get the reference of the current package where this component is added. I can get get the reference of the current package using this line of code Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); Microsoft.SqlServer.Dts.Runtime. Package pak = app.LoadPackage(@"C\DTS\Package1.dtsx" , null ); Here i need to pass the path of the package. Is there any other way to get it (without the path) Thanks Mani If you just want to read the variables from the User Interface then it is easiest to just the "Variables vars" variable that should have been p ...Show All

• Visual Studio 2008 (Pre-release) Loading and displaying TONS of images.

  I saw a movie of how the Nintendo Wii handled images and it was the coolest thing i've ever seen. There was a grid of at least 500 pictures and you could seamlessly zoom in on one image and get it in full resolution. Then you could scroll sideways and see the other images in the same size. Here's a video of how it looks: http://uk.wii.com/movies/photochannel/ So i thought, if that little toy with 800mhz cpu and 64mb ram can handle that, then my gamingcomputer must be able to do the same thing at least 4 times better So i started to write a wpf-program that did the same thing. But i got stuck pretty quick. As grid i use a ListBox like they do in here http://www.infusionblogs.com/blogs/jsmith/archive/2006/09/21/867.aspx ...Show All