StuartMiller's Q&A profile

• SQL Server T-SQL Query that looks for multiple records.

  I need a T-SQL query that will pull out records, that have certain values in common. The goal is to find duplicate records in one of our tables. Any help or suggestions would be appreciated. Thanks, -Ben select p1.keyfield1 = p1.keyfieldN from paycheck p1 left join paycheck p2 on p1.keyfield1 = p2.keyfield1 and p1.keyfield2 = p2.keyfieldN where p2.keyfield1 is null ...Show All

• Visual Basic Publish Error - Application Improperly Formatted

  Hi. I have developed an application using VB Express Beta 2. I am trying to publish it to share the application with others. When I try to publish it to my hard drive and then run the setup.exe, I get an Application Failed pop up that says the application is improperly formatted and the details are as follows: PLATFORM VERSION INFO  Windows    : 5.1.2600.131072 (Win32NT)  Common Language Runtime  : 2.0.50215.44  System.Deployment.dll   : 2.0.50215.44 (beta2.050215-4400)  mscorwks.dll    : 2.0.50215.44 (beta2.050215-4400)  dfdll.dll    : 8.0.50215.44 (beta2 ...Show All

• Architecture XP or XPE for POS application

  Hi, Not sure if this is the correct place to post this - apologies if it's not. I'm developing a custom POS application in VB.Net 2.0 for no more than 4 terminals. The touch terminals all have P4 processors with 512 MB RAM and 40 GB HDDs. I'm just wondering if there are any advantages to installing XP embedded (or XPE for POS) instead of XP Professional. Because of the limited number of clients, it would be more expensive to buy the developer tools for XPE and then license each client rather than just buying 4 copies of XP Pro - I already have VS 2005. Because the terminals are reasonly well specced and they will only by ru ...Show All

• Windows Forms Side by side execution

  Hello, I have a ClickOnce application that needs to be deployed to different environments (US and UK). I did the deployment to those environments and everything went fine. However, when I tried to run them both from the same machine, only one is run. But if I look at the Program menu, there are 2 separate links. It almost seem like ClickOnce recognizes that they are the same application therefore only one instance of that is run. How do I tell ClickOnce that these are 2 different application and allow them to run side by side (I cannot change the application version. They need to be the same for both environement.) Thanks. ...Show All

• Windows Forms Designer loading error

  Hi, I am working on a project in visual c++ 8 beta 2 using a windows forms application. At a certain point visual just shut down and after reloading the project I can't load any of the forms I have created anymore... The following error appears for all of the forms: One or more errors encountered while loading the designer. The errors are listed&n ...Show All

• Visual Basic Problem reading Chinese characters in Excel file using Visual Basic

  I open the excel file, which contains Chinese characters, to read its contents, with: Set appexcel = Excel.Application Set appexcel = CreateObject("excel.application") appexcel.Workbooks.Open "file.xls" temp = appexcel.Cells(1,1) appexcel.Workbooks.Close appexcel.Quit Set appexcel = Nothing PROBLEM: When the excell cell contains Chinese characters, temp reads them as just question marks, . QUESTION: How can the above be fixed, so that VB can retain the Chinese characters This may be a text encoding issue , I recall issues like this in the past. Instead of ...Show All

• .NET Development Create new Icon object

  Hi, How can I create new Icon from content or embeded resource Thank's Alexei Hi, Solution: public override Icon getIcon() { // get a reference to the current assembly Assembly a = Assembly.GetExecutingAssembly(); // attach to stream to the resource in the manifest System.IO.Stream imgStream = a.GetManifestResourceStream("Win32E5.Basic.Icons.Title.ico"); Icon icon = new Icon(imgStream); return icon; }   Thank's Alexei ...Show All

• Windows Forms add unbound data to combo box

  Hi guys! I bound my combo box data using data source and I want to add an item at the top of my combo box. Is this possible Please help! You can find an example of what you're trying to do in an article I've just posted at CodeProject: http://www.codeproject.com/useritems/UnboundItemsComboBox.asp ...Show All

• Visual C# richtextbox not keeping font when form is minimized

  I have a form with a richtextbox in it. I have a thread that is running seperate from the main thread. This thread invokes a method in the main thread, sending it a string and a color. This method takes the string, changes the selection font color to the color that was passed in and appends the string to the text box. Here is the code: delegate void printToTextBox(String data, Color color); private void setText(String data, Color color) { richTextBoxLogs.SelectionColor = color; richTextBoxLogs.SelectionFont = new Font(richTextBoxLogs.SelectionFont, FontStyle.Bold); richTextBoxLogs.AppendText(data); } private void myThread() { //C ...Show All

• Visual Studio Problem to display report from SSRS

  Hi, I want to display report from SSRS in my VB.net application (winform). I have set the report path,report server,display name. What's the HistoryId for When i run my application the report viewer did't display mt report and show msg "The source of the report definition has not been specified" What else i have do Please help me! It sounds like you want to use server mode. By default, the control is set to local mode. Be sure to set ReportViewer.ProcessingMode. The HistoryId property allows you to view history snapshots on the server. ...Show All

• Windows Forms Suspending Paint Event

  In the paint event of a control I'm using at work, we end up drawing some rectangles with GDI+ calls. Unfortunately, each time the rectangle gets drawn the paint event ends up firing again, thus it get's repainted 20 times.  Is there a way to temporarily suppress paint events I guess you should try using the ControlStyles enumeration, and ...Show All

• Visual Basic Tabbed Browsing in VB .Net

  Hi, I have a question regarding tabbed browsing. I am writing my own custom web browser in vb .net studio 2005. I can create, dynamically at runtime, additonal tabs on a tab control, which will - in each - have a dedicated webbrowser control. So what will happen is 5 search engines will be searched and the results be placed in seperate webbrowsers under 5 dynamically-created tabs. The user can then tab throw each set of results. The problem is, I cannot crack for the life of me the creation of the dynamic webbrowser controls in line with creating the tabs. I will need to send a URL to each webbrowser too, to show the resulting searc ...Show All

• Visual C++ How do you develop an interface for an existing C++ program?

  Hello Everyone, I have a large and complex program, which to be honest I dont fully understand, that I have to develop an interface for. I understand how the program works to an extent, but the level of C++ used in the program is way beyond me. It has to do with genetic programming, programs writing programs, so I dont think that im going to be learning how to do that anytime soon. Although I am alot better with VC++ than C++ and can comfortably develop simple interfaces to perform a variety of functions. I have been working my way slowly through sams VC++ for beginners and have learned quiet a bit, although I am still mos ...Show All

• Visual C++ CRT heap in DLL

  I used to believe that each process has a default heap shared by everybody in the process space including code in loaded DLL and heap manager works as described in http://msdn.microsoft.com/library/default.asp url=/library/en-us/dngenlib/html/msdn_heapmm.asp Then I’ve found out that if DLLs are linked with CRT each has own heap manager http://msdn2.microsoft.com/en-US/library/ms235460.aspx My questions: how those individual default heaps are allocated and grow if the DLL needs more memory What is their initial size and limit My application is ISAPI filter/extension that runs out of memory once in a while. I wa ...Show All

• SQL Server sys.objects vs. sysobjects in master..sp_ stored procs

  use master go create procedure sp_GetObjects as select * from sysobjects ; calling this procedure from different databases will return different results (behavior similar to 2000). use master go create procedure sp_GetObjects as select * from sys.objects ; calling this procedure from different databases will return results for master db only...  (ditto for all other sys. catalog views) how can I create database agnostic stored procedures using the new catalog views thanks!   Clifford Dibble wrote: BTW - In SQL 2005 you can GRANT/DENY/REVOKE at different levels of scope.  This can be an ...Show All