vdv_phuong's Q&A profile

• Visual Studio Express Editions newbie qn - VB vs VBA processing speed

  Hi guys, please excuse me if this is a dumb question. I've written a programme in VBA in Excel, a Sudoku solver. The program runs entirely within a user form, doesn't use any worksheetfunctions and only uses the excel interface for the button to press to launch the userform - the calculations are all done in an array variable, and the results copied to a microsoft office owc11 spreadsheet control embedded in the userform. I've now written the same programme using virtually the same code, in VB Express. With a bit of tweaking, the programme is now running as a stand-alone application and works properly. However the VB version is more than 7 times slower than the VBA version (the programme has a timer in it, so I can tell). How c ...Show All

• SQL Server using Dts.LOG within event handler

  Hi, I am trying to Log my activities when OnError event handler fires I have defined few tasks in OnError event handler section so when there is a failer on the main package my OnError task runs ( which it work fine) now I am trying to add Dts.LOG from inside OnError evend handler task, and it seems like SSIS doens't give that function. I can use dts.log outside on the main package but not inside OnError section! any ideas Thanks Kolf wrote: Hi, I am trying to Log my activities when OnError event handler fires I have defined few tasks in OnError event handler section so when there is a failer on the main package my OnError task runs ( which it work fine) now I am trying to add Dts.LOG from inside OnE ...Show All

• Software Development for Windows Vista Where is WinFx in Visual Studio 2005 July CTP

  How do I build a WCF project when the extensions are not there to create the project in Visual Studio I have Vista July CTP, Windows Vista SDK (July), and VS 2005 full. So where do I get the Visual Studio extensions to create projects Larry Aultman ...Show All

• Visual Studio Team System What permissions determine who can be assigned work items?

  Good afternoon.. I see a highly configurable permission set. I have a contributer role at the project level with no members. (None have been added since I created the project) However, when I go to create a task, I see all users, including the service account.  There is a global service account group, with quite a few permissions.  Why is the service accounts group even there to begin with Also, I see direct way to set users or roles to "be assigned work items".. Any ideas Cheers! -Sean Sean, The assign to is determined by the definition of the type of workitem. For a task, this is set to the group <Validusers/> this is every user found in the group "Team Foundation Valid users" I pe ...Show All

• Visual Studio Visual Studio 2005 SDK - April 2006 V2 RTM Download Problem

  Hi everyone, I want to download the Visual Studio 2005 SDK - April 2006 V2 RTM from http://affiliate.vsipmembers.com/affiliate/downloadFiles.aspx  but the download process is always failed. I try to download the file directly via IE and not via download manager. My questions are, is it because the cookies or session time has expired If is the problem, is there any way to change the expired time out from the client And why don't Microsoft use the Microsoft File Transfer Manager for downloading every files from their sites Thanks in advance. dcoder_85. dcoder_85, Are you still having problems downloading I just tried this and it is working fine for me. Let me know if you are still running into problems. ...Show All

• SQL Server Rollback in a trigger??? (explicit/autocommit transactions)

  I’m using triggers for some more advanced integrity check. The problems is that the same trigger can be run from explicit transaction (this is when I start transaction from .NET) and as autocommit transaction ( very rare, only when we do some maintenance directly with SQL statements). Currently if I want to rollback transaction from trigger I only issue RAISERROR statements, then .NET application catches this error and generates rollback. But the problem is if trigger is raised from some SQL statements outside .NET application (normally some maintenance work direct from SQL manager ) in that case error is generated but there is no rollback. Is there any way to distinguish if transaction in trigger is explicit or autocommi ...Show All

• Visual Basic Timed Forms

  When a typical application starts it usually has a main form that shows, right How can I use VB 2005 close the main form after certain period of time and at the same time opens another form Please help me Are you trying to create a regular splash screen that appears for a certain time on startup, or will this form be opened later while the app is running If you're trying to create a standard splash screen, you can designate a form as the splash screen in the project properties for a VB 2005 project. There is even a way to change the amount of time that the splash screen will appear if you need to do that. ...Show All

• Visual Studio how can I disable the debugger?

  Every time a program crashes or do something wrong it pops up a window that ask me what debugger I want to use. Its annoying... I causes me to exit from this game I'm playing - "Titan Quest" and I don't want it to pop up anymore... I have the same problem!!! I have to have VS 2005 installed for a class im takeing, but it is destroying my windows experance! Please help us, I dont want my computer to crash every time windows hic-ups. Where is the Never debug option ...Show All

• Visual Studio Express Editions mfc library

  can any one tell me how i can get the mfc header files (assuming they are header files) so that i can use them with visual express thanks Let me just add that there's a common misconception amongst new developers that when they need to include a header to make something work, they seem to assume they just need to find that single file. A header is often an entry point into a library, which will include many other headers. In addition, headers are useless without .cpp files or .lib files ( which are precompiled .cpp files for your code to link to ). So, MFC requires a lot of files above and beyond the headers that the help tells you to include, and as Jonathan has stated, the Express Edition does not support MFC. ...Show All

• SQL Server T-SQL Date Format question

  I have a small problem (creating big issues) in T-SQL. I have a sql query that gets some date data from SQL Server 2000 and displays the result in a grid. This grid is a custom sortable grid. The problem is that the result returned from the server is in American format and I want to display the dates in UK format. I tried using Convert but Convert seems to be converting dates into character strings and hence creates problems while sorting the grid. I tried finding other functions but could not find any. Mind you that this is just a sql query and hece cannot do something like SET DateFormat = some value. If you could guide me to the right direction and help me get rid of this problem then it would be really greatful. ...Show All

• Windows Forms ClickOnce - .chm file is not available

  Hi, I have a C# application that I publish with ClickOnce. I want to include a .chm help file in it. However, the file is not found after deployment. I tried setting it as Content file with different copy options. I added it as existing file and tried setting it as a data file in the publish option as well. I also tried showing it through the text file. I have gone through the posts: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=199239&SiteID=1 and a few others. It still does not work. Is there anything else I am missing Thanks, Avanti ...Show All

• Smart Device Development Accessing A Windows Shared Folder

  This question has previously been posted in the network and communications forum. Using a windows CE device, I am trying to access a regular shared documents folder on another computer. The folder has full permissions for all users. However, the first time that my program (written in VB.NET) tries to access a file in the remote folder (using IO.File) a login screen opens. Nothing has to be entered in the screen and all that is required is to click the Ok button. The problem is that the CE device is physically inaccessible with no user interface so it effectively freezes the machine. “Logging on” to the shared folder only has to be done once ever time the device restarts. Is there any way to automatically logon to the folder ...Show All

• SQL Server Eternal 'Enable Pending' on SQL2005

  Hi! I have this problem... im kinda new to sql2005, and im responsible for creating some notification services. Ive done a lot of tutorials, books and samples and every time, when i reach the step of enabling the instance, i get this... Generator-Enable Pending Distributor-Enable Pending Even doing the Microsoft's Notification Services Tutorial. Ive tried everything I could figure, registering the instance with a user with every permission there could be... doing this local or on a client... and ive been 2 weeks stuck here... Any tip or clue will be thankfull. M.Eng.Leandro Melendez Ive tried to give the user the permissions that the tutorial says, also ive tried to give the user every permission i could imagi ...Show All

• Visual Studio 2008 (Pre-release) ClipToBounds property on Ellipse, Rectangle and Path

  Hi all I am hoping that someone can help me out. I am wondering if WPF has the capability of successfully applying ClipToBounds (or a property that achieves the same affect) to anything else besides form elements or Panels. This is because I need to apply this same property to objects like Ellipse, Rectangle (when the RadiusX and RadiusY have set values other than 0) and/or any other shape that can be created with Path. Now I know that the three mentioned elements have the ClipToBounds property but none of these elements allow you to add content of type object, thus the property in this context seems a but superfluous. In essence this is what I would like to be able to do: <Rectangle Fill="{x:Nu ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All