VSFW3's Q&A profile
SQL Server Conversion of "True" or "False" textfields to display "Yes" or "No"
Hi All, I've created a report that has some textfields containing "TRUE" or "FALSE" as data output when I run the report. How do I convert these textfields to display "YES" or "NO" in the output when I run my report. (bits) Please advise. Thanks for your time and help. Hi Check this link:http://www.sqljunkies.com/HowTo/0D746276-352D-42D9-A2BB-225C0B2A3AB5.scuk Hope this helps. ...Show All
Visual Studio Team System Saving attachments
To save an attachment you have to open it and then save it from within the application that has opened the attachment. In my experiences, IExplorer is always opening the attachments and sometimes failes to do so. For example: opening xml files for which the specified schema can not be found. Also for other file types like .jpg I rather want to save the files than open them in IE. I tried to change the file type associations as explained in http://support.microsoft.com/kb/905703/en-us , but no luck. (What's more, for file types for which I changed the default open-application, the Advanced button is missing in the 'Details for .. extension' dialog. Only after pressing the 'Restore' button I can select 'Advanced' and then check/uncheck 'Conf ...Show All
Visual Basic Graphing data?
Is there a way to take some data (say an array of integers) and display it in line graph form, defining the labels and axis manually Zedgraph also shows up here: http://www.codeproject.com/csharp/zedgraph.asp ...Show All
Visual Studio 2008 (Pre-release) Refresh ImageBox
hi, I am building an application which display images continually into imagebox. But when first image will display in imagebox, the same imagebox is not able to show another fetched image from file. I think the solution of this problem is to update or refresh the imagebox whenever it go to display another image. But I am not able to get such type of property for imagebox. Can anybody suggest me the solution of this problem And in WPF I am not able to add picture box control. ...Show All
Visual Studio Can you publish a web application using MSBuild on the command line?
Hi, I tried doing it like a website: <MSBuild Projects="C:\MyTempWebsite.sln" Targets="Publish" Properties="Configuration=Debug; Platform=AnyCPU; PublishDir=D:\todelete\FINAL\; ApplicationVersion=0.1.0.0; PublisherName=my site; PublishUrl=http://localhost/MyTempWebsite/; InstallUrl=http://localhost/MyTempWebsite/"> <Output ItemName="OutputFiles" TaskParameter="TargetOutputs"/> </MSBuild> But it tells me that its an unpublishable project... Thank you Hi Yoni, Sorry for the late reply but here's my class. Hope you will find it useful. Let me know if you have any questions. Its an MSBuild task: using System; using ...Show All
Windows Forms User Customizable Forms
We’re starting to write a new application that in part is very similar to Microsoft InfoPath. There will be a form designer module that will allow the user to create their own data capture forms. I’ve written a similar application before that just added controls to a form as it loaded. Unfortunately this time round that is going to be too slow. Can anyone think of a better way of doing this I’ve thought about possibly making the designer program create an assembly from the form somehow and then get the client to load that assembly. But I can’t find a way of saving a form to an assembly Any assistance would be appreciated ...Show All
Visual Basic 2 Instances of UserControl on Form Each In its own Thread?
I have a User control that does some heavy Database work, I have two of them on the form, (a source and destination) being that they pull from different servers, I wanted to beable to let each one load at the same time, I'm not new to threading, but I'm no Expert. I tried putting Attributes on the UserControl MTAThread() I tried changing the ApartmentState of the CurrentThread . I was hoping to find a more professional method, than putting a timer on the control and having the button enable the timer, which fires the Load method. (Load just fills a DataTable, but its Thousands to Millions of records) Any Guru's want to take a Stab at it -Thanks ThreadConfusion I'd like to hear those hundreds of re ...Show All
Visual Studio Team System about the method VisitCall
I found there is a visitcall method that can be overrided. but how to use it what are the parameters mean public override void VisitCall( Variable destination, Variable receiver, Method callee, ExpressionList arguments, bool isVirtualCall, IProgramContext programContext, IExecutionState stateBeforeInstruction, IExecutionState stateAfterInstruction) i found some code block example blew: IStronglyConnectedComponent component1 = programContext.get_ControlFlowGraph().get_StronglyConnectedComponents().SccForBlock(programContext.get_Block()); if (((component1.get_ContainsCycle() && callee.get_IsSpecialName()) && (callee.Name.get_Name().StartsWith( "get_" ) || (callee.Name.get_Name(). ...Show All
Visual C# SqlConnection.Open() OutOfRangeException - Need Help!
Hello! I am trying to open a connection between my programe and a mySQL server with the SqlConnection.Open() method. My connection string looks like this: " Data Source=tcp:myservername, 3306;User ID=****; Pwd=******;Pooling=false;" As soon as I call the SqlConnection.Open() command I get the following error message: "None-negative value needed. Parameter Name: count" (I have translated it from German into English so it can vary from the original message) I have no idea why this happens and as you see I have already disabled Pooling but no chance. Has anyone got any idea Thanks in advance! veryxRV Probably "tcp:" is the problem and should be re ...Show All
Visual Basic How to release an mdb file's file lock protection?
.NET 1.1 VB 2003 i have create a program where the program will dynamically create a mdb file, create a table, then populate the table via ADOX.dll using com interop. After populating the table i would like to FTP the said file to some FTP folder, to my dismay everytime i try to upload the mdb file i always get 0 kb, then i found out that the mdb file is "FILE-LOCKED" by some unknown process, but i dont know why because i have manually released all the resources that has been used, here is my code Private Sub GenerateMDB(ByVal strCompletePath As String) Try 'if file exists then delete mdb file If File.Exists(strCompletePath) Then File.Delete(strCompletePath) End If Dim objCatalog As New ...Show All
Windows Forms load an image from resx
I need to load an image from the resx that I added manually. I have found that when I add an image (.png) to the resx corresponding to my form, then the designer will remove them if it doesn't use them. I then tried to add my own resx file but don't know how to load from it. My own resx only contains the few images that I need and is not associated with a class. This is C++/CLI. So, if I were to want to use the same images many times through the life of my form, how should I pre-load them and store a reference to them System :: ComponentModel :: ComponentResourceManager ^ resources = ( gcnew System :: ComponentModel :: ComponentResourceManager ( /*something here*/ )); button_OK -> BackgroundImage = ( cli :: saf ...Show All
Visual Studio Team System Custom Test Install issues
Good Day, I am trying to build custom tests. I am a newbie to this so please bare with me. I have RTM VS TFS Test edition with the VSIP SDK loaded. When I attempt to build the MyTest Sample, I get the following Build error for the MyTestUI: Creating temporary file "c:\TestTemp\MyTestUI\Debug\BAT00000135402424.bat" with contents [ @echo off "C:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\tools\bin\ctc" -nologo .\PackageCmd.ctc pkgcmd.cto -Ccl "-IC:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\common\inc" "-IC:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\common\inc\office10" if errorlevel 1 got ...Show All
SQL Server waittype NETWORKIO blocking spid on SQLServer 2000
I have a series of processes being blocked - after running sp_blocker_pss80 I can see that the blocking spid is coming from a batch program that is issuing a 'sp_prepexec' event and has a waittype of NETWORKIO. It looks very like the problem fixed by hotfix: 884554 in SP4. The db is SQLServer 2000 and running the following command: SELECT SERVERPROPERTY('ProductLevel') GO Gives the result SP4 So I guess I have the hotfix but I'm still experiencing this problem. The event that is 'blocking' is a select statement on a large table. Running the same batch process on identical data in a test environment doesn't give the same problem. I'm not certain that other processing on the test environment is identical though so it is ...Show All
Smart Device Development Emulator 2.0 error opening images with mapped COM port
I am successully using the WM 5.0 MSF emulator to run TomTom5 (much larger picture than my PDA...). A bit slow and erratic to start (need 5 or 5 tries to start the image), but once started, it works. My question: since everyone says that 2.0 is faster and more stable, I installed it; problem is, it cannot open my images with the COM port once mapped (it opens fresh images with no mapped COM port) - same problem on my laptop, and 2 PCs. Problem both with bluetooth serial port and a wired GPS. Error #1: "Unable to open serial port "COM6" LastError=Access denied." Error #2: "The device emulator coud not start, possiblyif incorrect statup parameters" Any suggestion I would appreciate any help. ...Show All
Visual C++ Virtual Lock for memory to prevent being paging out
HI All, I am m using VirtualLock to lock the address space used by data structures in memory, so it won't get pagedout to disk by Windows. Now I want to make sure that my pages are locked out. How do i test this Thanks in advance. Shaan. Shaan007 wrote: I am m using VirtualLock to lock the address space used by data structures in memory, so it won't get pagedout to disk by Windows. What's your motivation for locking the memory Shaan007 wrote: Now I want to make sure that my pages are locked out. How do i test this I'd have to say "check the return value". Then write some benchmarks. ...Show All
