Gerardb's Q&A profile

• SQL Server Wierd results with != operator

  Hi all, I have a table - customer with a Column state_code varchar(5) and another valid( smallint) select count(1) from customer where state_code != 'U' -- for unknown and valid= 0 -- for valid Returns different counts each time, even when the data in the table is NOT Changing. something with != operator Thanks for your help ! Sri Can you post DDL and sa ...Show All

• Visual C++ Windows Forms

  Using Visual C++ 2005 Made a windows forms application using Visual C++ 2005, but when i run it I get a console window popping up while my form is running. Guessing one of my project settings is messed. Anyone know which setting is causing the console window to appear when I run my windows form I didn't use the form designer either. Need some votes on this topic... http://lab.msdn.microsoft.com/P ...Show All

• Visual Basic Listbox update problem - easy one, i guess

  This should be an easy problem, i bet there is someone who can help me. I'm a begginer, so thanks in advance! I'm working in VB 2005 Express. The problem is: in one form there is a listbox with a MS Access database source, and in the other form si a datagridview throug which users change that particular data. Datagridview control works and updates perfectly, but how can I update (or refresh ) listbox in the first form after the changes have b ...Show All

• Smart Device Development What will be target binary CPU?

  Hi All, Created default MFC smart device application and checked its target cpu model using depends.exe. It shows THUMB. Then I removed MACHINE:THUMB from linker command options. I still got the same CPU type as THUMB. Does the linker considers default CPU type as THUMB for any WM 5.0 application created What changes do I need to make if I want CPU type to be ARM for WM5.0 applications -Seemit   ...Show All

• Windows Forms DataTable Expression Column

  My DataGrid is bound to a DataSet, with following columns: Description, CashExp, CreditExp,Frequency  On run time, I am adding two new DataColumn “AnnualCash” and “AnnualCredit” and defining Expression property to give product of two columns, as follows  Dim dc&nb ...Show All

• Software Development for Windows Vista Dynamic Changes: Add a new State to a State Machine Workflow

  I am playing around with the OrderingStateMachine sample and I am trying to add a new state to a running instance of the wf. However, it returns me an exception saying that it has compilation errors. This is the simple AddNewState code: Try 'Get a reference to the WorkflowInstance for the selected workflow Dim instance As WorkflowInstance = _ Me.workflowRuntime.GetWorkflow(wfInstanceID) '(wfInstanceID) (New Guid(Me.lstWorkFlowIns ...Show All

• SQL Server JDBC API - fetching only user tables

  Hi, I am using JDBC DatabaseMetaData's getColumns() to get the table names, column names and datatype of the columns. As a result, I am getting user tables as well as the system tables. How to fetch only the user tables excluding the system tables like sysindexes, etc. I know this is possible by executing a select query (using SYSOBJECTS and xtype = 'U'). But, is there anyway to fetch only the user tables using the databasemetadata AP ...Show All

• Microsoft ISV Community Center Forums Help with using Outlook from Access

  I am openning Outlook by calling createobject, which I expected to open a new instance of the application. However it appears to use the one open on my desktop. This means that my quit statement closes my e-mail. How should I amend the below to leave my original e-mail session open Also I will be replacing the debug.print statement with code to work with the attachment to copy data into my database. I am intending to save the file to a tempor ...Show All

• Visual Studio Team System Process Templates

  The only process template I can access in the Beta 2 is the MSF Agile, am I missing something or is this all that is currenlty available in Beta 2 I was primarly interested in the XP process template, or I guess I can design my own if I need to. Cheers Tim Seaward I've made a first attempt at a XP Methodology Template which can be downloaded from http://workspaces.gotdotnet.com/bsdagile your feedback would be ap ...Show All

• Windows Forms Expanding a datagrid

  Simple question, Does anyone know how to expand a data grid with out the user pressing or doing anything, such as when a form is opened with a datagrid on it, the datagrid is already displaying the rows and columns. Thanks,  Simple ...Show All

• Visual Basic InvalidOperationException

  Hi , I know I am missing the obvious , but why am I getting an InvalidOperationException ,when I try and run this code (vs 2005) , further comment to exception " Collection was modified; enumeration operation might not execute." Any Solution with examples will be greatly appreciated ! Dim row As HidWkFlwDataSet.tblPodRow For Each row In Me .HidWkFlwDataSet.tblPod.Rows If row.Verified = False Then ...Show All

• .NET Development How do I control modal dialog window.

  Hi,        This is the problem regarding modal dialog window.  I'm opening aspx web page normally and while clicking on the button of the page it is opening another aspx web page in modal dialog.  Initially the modal dialog appears in the center of the screen.  If I move the modal dialog window from center to any corner of the screen and if I did any server side action in that page, the page rendering ...Show All

• Visual C# iteration through copying files

  How would you go about iterating through a directory...and copying all those files to a new directory   string dirpath = "**"; Directoryinfo di = new DirectoryInfo (@"H:\\"); DirectoryInfo [ ] dirs = di.GetDirectories( dirpath ); foreach ( FileInfo files in di.GetFiles( ) ) {   try   {      files.CopyTo( )   }    catch{ } }   ...Show All

• Visual Studio Basics

  Hi, I'm relatively new to VB.net and VSS and I'm writing a little ap which will copy a load of files across from a network share using xcopy, in vb.net, everything fine there. But in order to make the app being copied work on the enviroment being copied to I need to extract a particular file from source safe. I'm haivng problems using the vss API to extract the file and I don't seem to be able to find any source code or tutorials on how to do th ...Show All

• Software Development for Windows Vista Bug Report(blue screen/can't install netfx 2.0)

  1. I'd installed a Virtual CD tool named daemon-tools(version 3.47), it'll cause blue screen in either vista beta1 or beta2 5270, either in safe mode or vga mode. I had to re-install vista again and again... 2.I can't install vs2005 in vista beta1(shipped in 2005.7.31), so I want to install the " problem-reporting tool ", but it prompt me to download and install .net framework 2.0. I download the nf 2.0, unfortunately, error occured:Er ...Show All