Sneak's Q&A profile

• SQL Server Error when attempting to upgrade MSDE to Express using command line /UPGRADE

  When attemping to install SQL 2005 Express using the following command line arguments /qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE or /qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD the following error occurs. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. The follow ...Show All

• SQL Server Table cells...accessing a value

  hello All, I am trying to now access the data (if any) in the current cell of a table. I want to know if this cell has been populated, and if so to move on...if not then I want to populate with a zero. I am using the following: ReportItems!textbox9.Value inside of an if statement but it tells me that I am unable to do so as, and I quote: "The Value expression for the textbox 'textbox 9' contains a direct or indirect reference to itself. Loops in expressions are not allowed." Any ideas guys Where are you populating the textbox9 from Are you trying to manipulate another textbox (not textbox9) based on what textbox9 has in it Try this: =Switch(ReportItems!textbox9.Value = 'x', Fields!Col23.Val ...Show All

• Visual Basic How to handle US and international phone numbers?

  Hi all, I have a Visual Basic Windows application done in Visual Studio 2005. My users need to be able to enter phone numbers, US and international. If it was US phone numbers only it would be easy, I can just use MaskedTextBox. But handling international phone numbers is a different story for the following reasons: -country codes can be anywhere from 1 to 7 characters long -some countries have area codes and some do not. And for the ones that do, an area code can be anywhere from 1 to 7 digits long. -phone numbers vary. For example some countries have 3 digit phone numbers, some have anywhere from 5 to 12 digits long phones. So what I need is a way to handle all possible phone number formats in one. What would be the best w ...Show All

• Visual Basic File Attributes

  Hi. Im writing a program that is searches all the files in the Hard Drive. All files are listed in a listbox. But i DON'T want to list the system files. I tried to do : If File.Attributes = FileAttributes.System Then..... but it didn't work! And the reason is that for example the file "A" is a system file but it is also hidden! If it weren't hidden it would work! To be specific: FileAttributes.System = 4 and FileAttributes.Hidden = 2 That's make us 6. The program won't list files that it's attributes = 4. That goes for any other combination. Is there a way to NOT list the file if it is a system file but is is hidden, or compressed etc Or the only way would be something like this If File.Attributes = FileAttributes.System AND Fi ...Show All

• .NET Development Where to put cleanup code for after a WebMethod ??

  I have an ASMX web service that implements a whole lot of WebMethods (300+). These WebMethods call out to various other components and objects to perform their work. Usually that work will involve multiple different objects/components which will be making updates to the database. All the database updates are made through a DatabaseLayer component which is implemented as a Singleton (so even if there are multiple components firing off database updates, they all go through the same instance of DatabaseLayer). I wish to ensure that all the database updates made as the result of a call to a WebMethod are executed as an atomic transaction. Since I have all the database calls going through a Singleton object I have implemented a BeginTransact ...Show All

• Visual Basic Using Excel worksheet functions in IWorksheetFunction in VB.Net

  I have been asked to convert a Excel/VBA application into a VB .Net application. The existing code uses a lot of application.WorksheetFunction and I tried to use those functions exposed by IWorksheetFunction and unfortunately no joy at all. I wonder if anyone can help me on this. Thanks in advance. skbNo5 Thanks very much spotty. All works well now. Thanks again ...Show All

• SQL Server Remove "All" and Keep "select All" from parameters

  I know that when you select Multi from the parameter report properties, that it automatically makes "Select All" Available. So how would i take off the "All Value". My users dont want to see All, if Select ALL is available. How do i exclude from "All" from my report parameter/dataset ...Show All

• Windows Forms Add Multiple controls to a datagridview

  Hi Is it possible to add multiple controls to a cell of a DataGridView Or a single control that spans across multiple cells I'm trying to develop a scheduler application and when the user clicks the cell content it creates an appointment. They can have 1-4 appointments within a cell and I want to display those four appointments as four separate labels within one cell. It is something similar to OutLook Calendar. Can this be done using a DataGridView. Or do I have to use some other control I will appreciate your help. Thanks Check out this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=47169&SiteID=1 ...Show All

• Visual FoxPro Still imestatus() problem in vfp9

  According to the vfp help index. imestatus(0) ---- Turn the ime window off imestatus(1) ---- Turn the ime window on So, I use the following code to activate Chinese input or English input. imestatus(0) ---- Activate English input imestatus(1) ---- Activate Chinese input It works fine in vfp6. But it doesn't work now in vfp9. When I use imestatus(0) in my form controls. It activates Chinese input and display 1 if I use imestatus(). imestatus(1) does not work too. Can anybody help me ...Show All

• .NET Development XML for ASP.net

  Hi, I need to render the XML document in a ASPX page, using XSLT. I am not able to handle multiple if conditions in the xslt file. I have rendered the choice as a dropdown in the XSLT. But I should place a condition, on the value 'Yes' in the dropdown, the checkbox and the label should appear.. This is my XSLT file. <xsl:choose> <xsl:when test="$choice='Yes'"> <xsl:for-each select="question/choice/question"> <xsl:if test="@type='lbl'"> <asp:Label Cssclass="styletextsublabel1" runat="server"><xsl:value-of select="@value"></xsl:value-of></asp:Label> </xsl:if> </xsl:for-each> <xsl:if test="@type='checkbox'"> <asp:Checkbox runat="server" Cssclass="stylepadding"> <x ...Show All

• Visual Studio 2008 (Pre-release) Peer to Peer channel in WCF

  hi friends, I want to establish a peer to peer channel to communicate between two applications. Can anyone guide me or give me a live example how to create a peer to peer channel between the two applications. Thanks, Abhas. please check this SDK sample(we have more p2p SDK samples,please check all samples) http://msdn2.microsoft.com/en-us/library/ms751502.aspx I like Justin artcle on p2p also,This may be helpful http://msdn.microsoft.com/msdnmag/issues/06/10/PeerToPeer/default.aspx ...Show All

• Visual C++ Collecting external dependencies

  Hi everyone I have a couple of projects that I move around different computers and that others also need to work with from time to time. It depends on a few external pieces of software, e.g. python. What I would like is a simple way of packaging up the locations of these software packages, so that I can use $(PYTHON_HOME)\include, $(PYTHON_HOME)\Libs and the occasional $(PYTHON_SRC)\PCBuild8 and have them all change magically. I don't want to define environment variables and since these are not the only projects I nor my colleagues work on I don't want to add these paths into the global IDE settings. Ideally I'd like a file simply defining these variables, but I just can't find a way to do so. I thought I had a workaround using ...Show All

• Visual Studio Team System Binding workitemcollection from Query to datagrid control

  We are working on a simple website that allows our -non-tech people to execute WIQ strings. Getting the correct stored WIQ isn't that hard, getting the results from executing it neither. Problems kick in when we try to bind the 'workitemcollection' to a datagrid and we only want to display the columns that were actually requested. Problem when doing this is that the individual workitems contain a fields collection that actually hold the values we want to display (among those some custom fields). So far no luck, any help would be appreciated. Current code: items = tfsData.Store.Query(query.QueryText, parameters); //// Build list DataGrid dataGrid = new DataGrid (); dataGrid.Width = Unit .Percentage(100); dataGri ...Show All

• Software Development for Windows Vista Problem in executing codeactivity inside a WhileActivity

  Hi, I am writing a simple workflow which has a whileactivity which contains a codeactivity as its child activity. When i execute the workflow it throws an exception Exception has been thrown by the target of an invocation. with inner exception Could not load file or assembly 'codetest, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. and stack trace at System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringTypeSig, SerializationInfo info, StreamingContext context) at System.RuntimeMethodHandle.SerializationInvoke(Object target, SignatureStruct declaringTypeSig, SerializationInfo info, StreamingContext cont ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rants on XNA 1.0

  This is my first reaction when I installed and tried the 1.0 of XNA. To summarize my feeling: it's still 95% for XBox and no nearer to replace the old MDX 1.0. So I decided not to migrate from MDX to XNA though I want to do that very much. I feel like MDX 2 more; amen to MDX 2. The hardest issue for me is the content pipeline, which is very necessary, but the workflow is fixed and it assumes the contents are only built before the program runs. The helper functions wrapping D3DX can only be used with types in the content pipeline. I have to utilize the full content pipeline just for generating something dynamically, of course with significant performance cost. Or I have to write those D3DX utilities my self. Currently I don't have a good id ...Show All