sjb's Q&A profile

• SQL Server Not sure how to form select with checks

  I only want to insert an extra data record for each corresponding m.number if and only if there isn't an existing record in extradata for that specific m.number where extradata.extracode = 'UU'. The requirement is that this is a nightly run. It searches for any recors in the phones table for m.number where p.good is null or =1. If found, then insert a record into extradata with an extracode of 'UU' if and only if one doesn't exist for each m. ...Show All

• Visual Studio 2008 (Pre-release) xbap (Web Browser Application) cache - how to delete?

  I Accidently clicked the *.xbap in the Debug/bin folder so I think its been deployed into some cache somewhere e.g. if I use Visual Studios to run it it'll pick up changes but running the *.xbap file runs the old version ..........anyone know how to get rid of this cache cheers ...Show All

• Visual Studio Tools for Office Opening an existing Word doc via a Word addin

  I've got a Word addin coded in VS 2k5 beta 2. I want load an existing Word document from within the same instance my addin is running. How can I do this Example: Dim test As Word.Document = ThisDocument.ThisApplication.D ocuments.Open(strFile) With the code above Word creates a new instance of itself and loads the document. I am confused with the scenario. Can you clarify what is you are trying to do Do y ...Show All

• Visual Basic Traversing all subdirectories and all files in those subdirectories

  Hello all, I know in .NET 2.0 there's a flag that you can set for your .GetDirectories(somePath) method, but in .NET 1.1, is there a clean way of traversing all subdirectories without using whiles, and for each's and what not Props to the hardcore programmers going at it on a Sat night haha Thanks. N. Farr That's what I ended up doing, it doesn't seem that 1.1 has a function that would one-line it f ...Show All

• .NET Development Automatic form in vs 2005, searching record

  Hello, I am using the wizard to create a new database connection and create fields from the table “customers” in the northwind database by drag and drop to a new windows form (vb 2005). Now I want to create a kind of search dialog where the user can insert the name of the customer and clicks “search”. If a record was found the navigator should jump to this position and display the data in the textboxes. I have no idea how to realize it, ...Show All

• Visual Studio Team System Buying TFS in the UK

  Can anyone tell me where I can buy Team Foundation Server in the UK. We are a certified partner but I need to know how much we would have to pay in order to get from the workgroup edition in MSDN to the full edition. I have tried the partners listed on the MSDN page, but non of them seem to be selling TFS!! Regards Graham I'm wondering the same thing. Perhaps its just too early. If it's any help, it loo ...Show All

• Visual C# Where to Find Good Tutorials / Overviews for DataGridView ??

  Hi There I'm getting a bit lost in the MSDN documentation for the DataGridView in .NET 2.0, could anyone please direct me to some good overviews/tutorials TIA Bill Hi Bill, The following link gives a good overview of all the features with snapshots: http://www.windowsforms.net/WhidbeyFeatures/default.aspx PageID=2&ItemID=13&Cat=Controls&tabindex=5 Regards, Vikram ...Show All

• Visual Studio Team System Migrating code analysis policies...

  I do not know if this has been posted as a bug or not yet; but if you have a solution with a solution folder and a project under that folder migrating code analysis settings does nothing to the project. EG: Solution 1:  \Components\ (solution folder)     ComponentProject1.csproj If you right click and hit migrate code analysis settings nothing happens. The project has to be moved to being in the root of the solution, migrate ...Show All

• Smart Device Development Add Column to DG

  How do I add a column to a datagrid - one that is not bound to the datasource - say I want to add a col with "X" as the first col and then the rest I have assigned via the datamap You can not do that with NETCF grid, you have to add column with "X" to data source. ...Show All

• .NET Development SslStream and SSL protocol not recognized (i think)

  i wrote this simple apps to connect to an IRC server but it doesn't work :( using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Net.Security; using System.Net.Sockets; using System.Security.Cryptography.X509Certificates; namespace provaSSL { class Program { static void Main( string [] args) { try { string certName = "" ; TcpCl ...Show All

• Visual C++ Documentation for struct RUNTIME_FUNCTION

  I have read the documentation in Visual Studio 2005 Beta 2 for this structure but have noticed that it is not complete.  While it points out that the unwind info address must be a 32-bit offset, it doesn't say what it means when the offset is not to a 32-bit value.  That is, if I run dumpbin /unwindinfo on C:/windows/system32/kernel32.dll, there are many entries that are not 32-bit aligned.  So my question is, what do non-32-bit a ...Show All

• Visual Studio 2008 (Pre-release) RichTextBox How To!

  Hi, I have searched the net and the documentation that shipped with Beta 2 and have not found any results or information that was able to aid me.  Hopefully there are some RichTextBox experts that could please help me with the following things: How can I make the RichTextBox single line   (this was possible in Win32, and no, changing the control template to a textbox does not work!  Because then it essentially is a t ...Show All

• Windows Forms Bold and Ubold

  Hi i have created a simple  editor  and i have a  text which is bold and underline i want to remove the bold but keep the underline the question is how to remove a style and keep the other You need to set t ...Show All

• Visual C++ Compiling FilmBox SDK Under VC6

  Hi, I am trying to compile Filmbox's SDK using VC6.  I can compile under VC7, but I only have a temp version, and do not want to port over to VC7.  The problem I am getting is on the following section of code: /***********************************************************************  CLASS KStaticArray ************************************************************************/ template< class Type > class KBaseStaticArray { & ...Show All

• Windows Forms DataGridViewComboBoxColumn Losing Values

  I have a ComboBox column in my DataGridView that is giving me some problems.  I have enabled AutoComplete and set the ComboBox to DropDown.  If the users starts typing a valid value and tabs, the value shows in the column properly.  If the user drops down the list and clicks on a value, the value shows in the column properly.  However, if the users starts typing a valid value and then drops down the list and tabs aw ...Show All