Albel's Q&A profile

• SQL Server Doing a SELECT on a different field than the field in the GROUP BY

  I'm using SQL Server 2005. I've got table tblSaleAddresses which looks something like this: AddressID   SaleID   Address1                  Address2                .....    DateEffective ------------   -------   -------------------       ---------------------             --------------- 1                 100      Unit 20                     100 Easy St         &n ...Show All

• SQL Server How to delete a group of stored procedures

  For reasons I won't go into I have a need to delete over a 100 stored procedures from a database.  The stored procedures have a common prefix such as dbo.aspnet_createUser. I'm trying to come up with something that will allow me to delete all procedures that contain aspnet in their name. The only thing close I've found is CONTAINS but I get an error I can use it against sysobjects because it isn't indexed. Any ideas of how I can go about doing this other than deleting each one by hand Thanks Execute this in query analyzer or management studio, copy the output, paste to the top pane, and run again: SELECT 'DROP PROCEDURE dbo.' ...Show All

• Software Development for Windows Vista Force workflow unload

  Hi Is there any way to make an activity force the Unload method on the workflow instance Thanks. Hi, perhaps a question, without knowing all about XAML, but nevertheless: If I have the activities/workflow defined in XAML (.xoml), how can I add attributes to them (in this case the [PersistOnCloseAttribute]) NRN ...Show All

• Windows Forms How can I add mainmenu items on Treeview control?

  Hi friends I want draw my mainmenu items on Treeview. How can I do that Thanks I have a sample code for VB.Net it is : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As  System.EventArgs) Handles Button1.Click         Dim mnu As New MainMenu         Dim tn As TreeNode         Dim&n ...Show All

• Windows Forms Design vs. Runtime

  Can anyone tell me if there is an advantage to creating a ListView control (details view) during runtime vs. creating it in the design view   If you need the context, I have an app that does the following: *Parse a txt file and populate a ListView control *Perform a Search of the ListView for records matching a string, clone those ListView items, and&n ...Show All

• Visual Basic Restrict '\' character in textbox

  Hi everybody, How do restrict entering these characters <>\"%';()& and telling user these caharcters are not allowed to be enter in the textbox field using RegularExpression Validator I put in the Validation Expression property [^<>\"'%;()&]. It restrict every character execpt 0 to 9. How to fixed this I used [^<>\"'%;()&]+ in validation Expression property of Regular Expression Validator Control. All are working except when entering the character \, which suppose to restrict it. How to restrict '\' character Thanks. den2005 Try doubling the \ so that the ex ...Show All

• Windows Forms Misbehavior From a ListBox

  I have a version 1.1 Windows ListBox in MultiExtended mode using C# (I tried it in VB.NET as well) which is performing badly.  I need to be able to hide and show the bad boy and when I set it to Visible = false it throws away all but the first selected item. I also tried putting it on a panel, and on a custom control...  Same result. I was able to simulate proper behaviour by saving the selected items before setting visible to false and then resetting them after setting visible back to true. I don't say this very often, but this must be a bug in the control.  Does anyone have a better work around ...Show All

• Visual Studio Extreme slow binary file check-in

  I'm using VSS2005, when I check in a binary file (6MB), it consumed over 5 minutes to check in the file, and VSS Explorer consume 100% cpu usage. However, it only consumed around 1 second when I check in the same file to VSS6. What's wrong with VSS2005 We have discovered a regression in the way VSS2005 checks in certain binary files. The fix will appear in the service pack for VSS2005. Unfortunately there is no workaround for it. Just to make sure it addresses your problem, too, could you mail us one of the binaries that caused problems f ...Show All

• Smart Device Development compatible with ppc 2003

  I developped my application with windows mobile 5 sdk. Is it possible to install compact framework 2 on pocket pc 2003(the previous os) -> Yes thus I'll be able to run my program on 2003 thus, programs written for windows mobile 5, run also on 2003 or... ...Show All

• SQL Server SQLServer2005_SSMSEE_x64

  Pls i have a problem with the installation of this product. Each time i try to run the set up, it gives me a message that "This installation package is not surported by this type of processor" Please what type of processor do i need to run this set up. There are two versions of the installation package: SQLServer2005_SSMSEE.msi: can be installed only on x86 machines SQLServer2005_SSMSEE_x64.msi: can be installed only on x64 machines You should download the package that corresponds to your processor type. ...Show All

• Windows Forms msgboxstyle icons

  Is there anyway of accessing the icons that are used with the msgbox I am wanted to set a picture box or some control (that would work) to have the image of the critical icon in the msgboxstyle object is this even possible Theresa The Icon object should have it's own "Size" value (as well as Height and Width broken out). ...Show All

• .NET Development Is there XML editor, organized like form view, according DTD ?

  Is there XML editor, organized like form view, according DTD (or else XML scheme) I want to enter XML data, but not in pure XML, or in arbitrary  XML in form view like in Microsoft XML notepad, but to enter data by form fields according DTD. Is there such a good thing thanks. Yes, it looks what is need, with only collection of nodes must be kept. As well as collection of collections i.e. using some tree-view instead of list -view. ...Show All

• SQL Server Returning top 2 results from each different data in a row and inserting into new table

  Hi All, I'd much appreciate any help with the following problem.  I need a statement, cursor, anything.... I have a table in MS SQL Server containing the following (simplified version of course :)): PID      DATE              OTHER INFO aaa      31/05/2005   blah blah blah aaa      06/06/2004   moo moo moo aaa      17/05/2005   baa baa baa baa bbb      31/04/2004    ...Show All

• Windows Forms How to automate the process of creating MSI

  Hi all, I am trying to automate the process of creating an MSI file for an vb.net web application. Can any one suggest me the way of doing the same Thanks, Sridhar Greetings, What do you mean by 'automation' Best regards, Mike. ...Show All

• Visual Studio Express Editions control.visible

  can someone give me an example program for using the control.visible property While it is not a full program, take a look at the example code found on the MSDN page about Control.Visible . Hopefully not much more is needed as it is really a simple property as when it is set to true the control/form is visible and when it is set to false it is hidden. Is there a specific question or problem that you have with it ...Show All