rottingorange's Q&A profile

• SQL Server Problems splitting name field

  I am reading in data from a legacy system where name data is in one field. The single field includes last name, first name, middle initial(sometimes), and suffix(sometimes). Due to the optional components it is a bear. I am using a fuzzy lookup on the suffix and derived columns for the first, last, and middle initial. The first name and suffix work, but I'm having trouble with the last and middle initial. The following is the formula I'm using for both. The first name formula is causing an error, and the middle initial is only populating if the suffix exists. If anyone has insight, it is appreciated. FirstName: TRIM(SUBSTRING([ARPNAME-T],FINDSTRING([ARPNAME-T]," ",1) + 1,FINDSTRING([ARPNAME-T]," ",2) - FINDSTRING( ...Show All

• Windows Forms Deploying to Program Files

  Hi, I am using C# 2005 Express edition and I cant select a directory I want my application to install into. I would like to deploy into program files. The Publish wizard works fine, and I can distribute my applicaiton, but I dont know where it installs into. I cant see an exe file anywhere on the computer I deployed on, yet my app works.. Is there more deployment options in the full version of C# 2005 that i need Frank Carr wrote: Here's another little quirk you may encounter related to this. My.Computer.FileSystem.SpecialDirectories.AllUsersApplicationData does not return the actual "All Users" data area but a data area in the cache. You'll need to use Environment.SpecialFolder.CommonApplicationData to g ...Show All

• Visual Basic Efficient method for writing to a text file real-time

  I am working with a stream of incoming text that must be captured and written to a text file real-time. The captured information is mission-critical, so I am currently writing each character directly to a text file on disk as soon as it is captured. If I buffered the input, some of the information might be lost if the computer crashed, there was power outage, communictions failed, etc. I'm currently using a StreamWriter to open the file in append mode, write the character to the file, then close the file again. This means that the file is potentially being opened and closed hundreds of times per second. Is StreamWriter the best method to use for this type of application (writing very small amounts of information to a disk file freque ...Show All

• .NET Development VB form get smaller with each click on form.

  Using VB 6.0. When using a normal screen (1024 by 728) the VB Form works fine. When using the new screens (1600 by 1024) the VB Form on Dell computers the parts of the VB Form starts to disapear with each key stroke. It disapears about 25% with each key Stroke. Talk with Dell computer tech group and they said that the problem was with the VB program. What can I do to fix this problem. ...Show All

• Software Development for Windows Vista Question for Volume Shadow Copy SDK

  After I saw the windows vista comparison table, some of editions are not support Volume Shadow Copy service, such as Windows Vista Home edition. Moreover, Microsoft also provides the Volume Shadow Copy Service (VSS) SDK for third-party developers. The developer can use the VSS API to create requestors, such as a backup application. My question is that is it possible running my application in Home basic edition of the Windows vista for supporting VSS service I think you'll have better luck getting this question answered in the General Windows Vista Development Forum. I'm going to move the post there. Good luck! ...Show All

• Visual Studio Tools for Office CommandBar Button Images when disabled...

  Hello All, I have an addin (Outlook specifically) that creates a command bar with buttons that have images. I am using VSTO 2005 in C# for this addin. The problem I have is that when I create these buttons and images, when the buttons are disabled, the mask looks pretty bad. I couldn't find a way when the buttons are disabled to show a better greyed out image than using the mask. How can I get my buttons to have a good disabled image (similar to the 'Reply', 'Reply All', 'Forward' buttons) when they are disabled Currently I set the buttons like the following: m_btnTBRefresh.Picture = ImageToPictureConverter .Convert( TeamlookRes .refresh_16); m_btnTBRefresh.Mask = ImageToPictureConverter .Convert( TeamlookRes .refresh_16ma ...Show All

• Visual Studio Team System Unable to undo pending changes due to domain migration

  Huge headache and long story, so please be patient :-P we are using tfs as the source control provider ten days ago, a user dm1\user1 at workstation machine1 checked out a file and didn't check in that same night, a db backup of the tfs server was made. that was the only backup available several days later, all the users in domain dm1 were migrated to another domain dm2. the migration went quite well and all the team members now access the tfs using the new domain name and the old user name. then this afternoon, the tfs db file corrupted, all we can do is to recover the db using the backup ten days ago now we have a problem, the checkout made ten days ago can not ...Show All

• Visual Basic LEFT string function

  This is how you would use the LEFT function in VB6 ... str1=LEFT("This is a typical string",4) Can you still use the LEFT string function in Visual Basic 2005 I can't seem to get it to work. Thanks, Mattthew. Actually I stumbled upon that myself. I tried adding "Imports Microsoft.VisualBasic" at the top of my code hoping that I could eliminate adding "Microsoft.VisualBasic" in front of the Left() all the time. But this approach did not work. Do you know of an Imports statement that could be used to eliminate adding "Microsoft.VisualBasic" in front of the Left() all the time Do you find the VB 2005 Help as useless as I do Thanks again for you p ...Show All

• Smart Device Development debug output message

  Hi... another newbie question. When iam debugging my product everything works like I want it to do but int the debug output i see exceptions like this: A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.IO.IOException' occurred in mscorlib.dll A first chance exception of type 'System.IO.IOException' occurred in mscorlib.dll 'Pelle.exe' (Managed): Loaded 'c:\documents and settings\administrator\my documents\pellets\pellets\obj\debug\af-za\Pelle.resources.dll', No symbols loaded. A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorli ...Show All

• Visual Studio 2008 (Pre-release) SecurityNegotiationException Issue accessing WCF service when Client is in different Machine

  Hi, I have created WCF service and Client. It is working fine, if both service and client are in same system, but if i place the client module in different system which under the same domain, i am getting the security negotiation exception The following is App.config configuration : < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < system.serviceModel > < bindings > < wsHttpBinding > < binding name = " WSHttpBinding_IMetaDataService " closeTimeout = " 00:01:00 " openTimeout = " 00:01:00 " receiveTimeout = " 00:10:00 " sendTimeout = " 00:01:00 " bypassProxyOnLocal = " ...Show All

• Visual Studio 2008 (Pre-release) Intellisense problem

  Hi! I installed Visual Studio to a clean installation of Windows Vista RC2. After installing Linq Preview, I have the known problem of intellisense completion. If I write: ArrayList list = new and then press space bar, intellisense doesn't give me suggestions. Same problem with the override keyword. I usually solved this problem by resetting the environment and by using the uninstall c# ide support script. The problem is that now, if I execute the script, I receive this error: Uninstall LINQ Enabled C# IDE Support was unsuccessful. Some files that need to be restored are currently in use. Is there any workaround I have VB installed and the smart tags functionalities work well. Thanks ...Show All

• SQL Server case statement using cast

  Hi guys, The value in the field ACCOUNTS.ACCOUNTKEY is something like: '3130005' I need to read the characters from position 4 to 6. If the value of that Substring is equal to the VALUE Zero then write "Zero". In the code below, the first "case" is working nice, but the second (red one) is getting ERROR. Please Help. "SELECT ACCOUNTS.ACCOUNTKEY," _ & " Case When SUBSTRING(ACCOUNTS.ACCOUNTKEY, 4, 3)= '000' then 'Zero'" _ & " Case When CAST(SUBSTRING(ACCOUNTS.ACCOUNTKEY, 4, 3) as int) =0 then 'Zero'" _ & " Else 'Unknown'" _ & " End " _ & "AS 'Finding Zero' " Thanks in advance, Aldo. the data in the field is a st ...Show All

• Visual Basic Running a DOS command from within a VB application

  Hi all. I am a newbie, and I am trying to develop a graphical interface to automate a task that I usually execute through a batch program. I have to execute an external command-line program that is not capable of accepting parameters. In my batch files I always solved the problem redirecting the input: my_command < input_file So I tried something like this (which works perfectly when the external program accepts parameters): procId = Process.Start("my_command", " < input_file") This doesn't work, and this is the reason why I am here to beg you help..... Can someone help this sad newbie ! Regards ___ Max To get redirection in a batch file to wo ...Show All

• Visual Basic Code to Flow Chart Diagram

  I'm looking for ideas... I have written an app to generate a logon script for my domain, and I'm pretty happy with it as long as I am willing to hack the vbscript, but I want to be able to generate the code based on objects in a diagram. Let me explain a bit... My app shows users, groups, OUs, printers, drives, etc. in listviews, and it's easy enough to drag a printer or a drive onto a group or a user, but suppose the printer is dependent on what workstation the user is logged onto. I think it would be do-able to display a picture box, parse the vbscript and draw lines and boxes, but that would only be an output - very useful, but that only makes a logon script viewer. I would have to be able to give the user buttons and whatnot to draw ...Show All

• Smart Device Development Picturebox resize scrollbars

  Hi. if I have an image showing in a picturebox, of course depending on the image size itself, if the image is larger than the screen, I have told it to resize the picturebox to the size of the image. This is all cool, and shows me the vertical and horizontal scroll bars. problem is, I am unable to scroll through the picturebox. How can I scroll through the picture box so I can view the image When in doubt, never fear, Anthony Wong is here! I believe Anthony has provided a great solution, many thanks to him! http://blogs.msdn.com/anthonywong/archive/2005/05/12/416907.aspx keep up the great work! :-) ...Show All