Adam Tyler's Q&A profile

• Visual Studio Express Editions VB 2005 Express installation hangs

  After having (succesfully) installed SQL Server 2005 and SQL Server Management Study Express CTP, I have tried to install Visual Basic 2005 Express (Italian), but the installation hanged. I tried again and the installation hanged at the same point (19 green blocks on the advancement bar - 4/5 completion), without any error message. How can I solve, please My PC runs Windowx XP Pro, completely updated. Regards, Giovanni As a workaround you could do a manual installation and see if that works. http://msdn.microsoft.com/vstudio/express/support/install/default.aspx I don't have many more su ...Show All

• Visual Studio Tools for Office Determining where I am in ThisDocument_SelectionChange

  Hi, I'm trying to determine where I am in the document within the ThisDocument_SelectionChange event. I have a document with XML tags in it, and would like to select which ActionPane Control I show based on which XML tag I am in. I thought that e.Selection.Range.XMLNodes(0) or something might do the trick, but it appears that the e.Selection.Range.XMLNodes collection is empty. Anyone know what I am doing wrong, or if there is another way to achieve this Thanks. Aaron. Misha, Just had a nosey at the site. Looks pretty good. Will have to spend some time going through the webcast. Strangely enough, there is one there that answered my que ...Show All

• SQL Server SSIS Designer freezes/hangs in debug mode

  My control flow consists of 1 task - A data flow task. The data flow task consists of: 1. OleDbCommand Source - reads from table A 2. Conditional split task - splits on one column (say col1) of table A. Condition is: FINDSTRING(col1,"UUU",1) != 0 FINDSTRING(col1,"VVV",1) != 0 FINDSTRING(col1,"WWW",1) != 0 FINDSTRING(col1,"XXX",1) != 0 FINDSTRING(col1,"YYY",1) != 0 FINDSTRING(col1,"ZZZ",1) != 0  where  col1 is guaranteed to have one of the values UUU, VVV... ZZZ. 3. The six cases go to 6 OleDb Destination tasks (and therefore to 6 different tables). This whole thing was working fine. Only significant change I could think o ...Show All

• .NET Development Instantiating SqlParameterCollection

    SqlParameterCollection ' s constructor is private, so it’s obvious that one cannot create it’s instance with using - Dim objSqlParameterCollection as New SqlParameterCollection I get it’s object with SqlCommand’s Parameters( ) method. I’m curious about – how SqlCommand creates object of SqlParameterCollection Without using SqlCommand class, can I instantiate SqlParameterCollection Chris, it's actually quite possible to do what you suggested - just create a List<SqlCommandParameter> and pass it. What you can't do (and I bet this is what you ...Show All

• SQL Server Logical functions in SELECT clause

  Hi, this ought to be elementary: I want to select the logical inverse of a bit type column. The online help tells me Syntax [ NOT ] boolean_expression Arguments boolean_expression Is any valid MicrosoftR SQL Server Boolean expression. Result Value NOT reverses the value of any Boolean expression. The way I read this I should be able to then simply SELECT NOT bit_col, yet I get a syntax error when I try to do simply SELECT (NOT CAST(1 AS BIT)) Arrrrgh! I've tried some syntactical variations on the theme, but it seems the not function just doesn't work in the SELECT clause, only in the WHERE clause. Of c ...Show All

• Visual Studio Express Editions CDate function returns 'IndexOutOfRange' error - also in VB.Net 2005 Beta2

  Hi folks, I have already reported this error in the VS 2005 Beta2 forum, but was told that it was not reproducible (VbCity and VBug, and your UK Launch team were also unable to reproduce the problem). I think I now have a lead on the issue! It also looks similar to a problem reported yesterday on the VB Express forum - 'I keep getting the out of range exception'. I have condensed the problem to two lines of code:       Dim myDate as DateTime       myDate = CDate("01/01/2005") The above error is reported on execution of the second line. This has now occurred on 6 different ...Show All

• SQL Server PIVOT statement whitout knowing values

  Just a small issue... I'm trying the new SQL 2005 (Express) because the PIVOT function was finally added. I've a table with three columns ID, Height and Width Now I'd like to have a table with for each height the number of ID for each Width The easiest way is to use the PIVOT statement.....but..... to use it in SQL2005 I should use:   SELECT Height, [100] AS Width01, [200] AS Width02 FROM ( SELECT ID, Height, Width FROM TestTable) p PIVOT ( COUNT (ID) FOR Width IN([100], [200]) ) AS pvt This kind of querry works perfectly in a static situation, but if I add new record in the table referencing the "300" Wi ...Show All

• Windows Forms Windows Server 2K3

  Hey all, I was wondering... I want to make a folder in my C:\Inetpub\wwwroot file so it will be available for internet access. BUT, i want it so when you try to access it, a password box appears. I got that far by adding permissions to the folder, but no password i enter ever works, is there a way to set actual folder permissions and make it so when you try to access the folder through a website, you need the password to continue Thanks! -Teenprogrammer This is a Windows Forms programming forum. These posts should contain only questions about programming with Windows Forms in the .NET framework. Try using the Micros ...Show All

• Windows Forms Can you run a seperate process as a child form?

  We'd like to write some functionality in a child MDI window that can be "plugged into" several different applications but we don't want to have to recompile those container apps when the child changes (nor vice-versa). Is there a way to run a different process (exe) as a child MDI window in other exes I would probably use a class library for a similar situation what you describe. You can distribute a compiled version that developers can use. You create a class library and add the classes to it that should be shared. Another developer will reference the compiled dll and can use the classes in ...Show All

• Visual Basic TimerControl_Interval Property

         The following code is a simple elapsed time counter.   I want to change the Timer_Control.Interval property during   run t ime during a Button_Click event handler.   Can this be done   I also would like to initialize the counter when the VB   program starts. I don't know where to put any initialization code.       Public Class Form1          Private MyStartTime As DateTime = Now()     Private MyEndTime As DateTime = Now()   &nbs ...Show All

• Visual Basic Problem while install VB .NET Standard 2003

  Hello, I'm trying to install Visual Basic .NET 2003 Standard on my Windows XP Home machine. Just after running the Setup.exe program, I get the following popup message: Command line parameters: /L language ID /S Hide initialization dialog. For silent mode use: /S /v/qn. /V parameters to MsiExec.exe /UA<url to InstMsiA.exe> /UW<url to InstMsiW.exe> /UM<url to msi package> The setup program then doesn't continue. How can I fix this problem Thanks in advance. You'll get that if you run setup with a / , or I believe if you run it with a command line parameter that it does not recognise. Chec ...Show All

• .NET Development very new and unexpected Error with database

  hi masters, i am using dot net 2005 C# with sqlexpress, i have made connection and start inserting values to the tabels and its working fine. BUT.. when i am close this application and restart again this application then there is no previous data i have checked using direct opening the tabels , no data found. please help me where data are going i like to know from you all is it happened... did u checked in the database where u inserted the values.... otherwise while inserting did u checked the int value return by executenonqueries is greater than zero.... check these two to make sure that it is inserted in to t ...Show All

• Windows Forms How to custom date format for datagrid datetimepicker

  Hi everyone, if anyone know to customize date format for datagrid datetimepicker. I have a datetimepicker in datagrid, I want to display format like this, yyyy.MM.dd how to do it thanks ...Show All

• Microsoft ISV Community Center Forums Passing arrays as parameters in VBA Excel

  Hello. This is my first post here. I have googled and rtfm'd the following to death to no avail. Excel VBA under WinXP Pro Problem: I have an array of variants declared thus - Dim avarMyArrray() as variant I have a subroutine into which I want to pass the array. I have attempted the suroutine call thus - Call myRoutine(avarMyArray()) Call myRoutine(avarMyArray) I have attempted to receive the call thus - Sub myRoutine(avarNewArray() as variant) Sub myRoutine(avarNewArray()) Sub myRoutine(avarNewArray) No matter what I try the array is not passed to the receiving routine. The VBA docs relative to thi ...Show All

• SQL Server temporary table not dropped after user disconnected (SQL2005)

  Hello all, We are developing some stored procedures on the SQL2005 server. All of them use local temporary tables to store temp data. Due to some errors in the procedures, run-time errors are produced and the procedure stopped. But after user disconnected, these temp tables are still exist in the tempdb and cannot be deleted. We can only view these objects using SA account in tempdb.sys.objects view. I would like to ask if there is any method we can delete those unused objects Thanks a lot! Bryan I would recommend that you look at the following KB, and post SP2 hotfix that was released by Microsof ...Show All