Yogesh Kumar's Q&A profile

• Visual C# check valid path

  Is there away to check a valid DOS path in c# ex: if the user types zzz:\test.txt and the path is invalid, return error message.   using VS2003 .NET1.1   Thank you, Thank you, I will check it out. I found something, would like to share. another way can be checked if the path is valid or not, using try and catch: try { } catch (COMException cex){ Response.Write(cex.ErrorCode); if ( cex.ErrorCode == -2147166139 ) { //invalid path format. } } ...Show All

• Windows Forms Alter the Close_button event on form

  Hi, I want when the user clicks on the Closing button(red cross) of my form, that my Form isn't closed but made unvisible(frm.visible=false). Is this possible and how would this be done Grtz Annihil8 you can set e.Cancel = false then make the form not visible: //FormClosing event e.Cancel = false; this.visible = false; does this help ...Show All

• Visual Studio 2008 (Pre-release) Stretching Frame Content

  I have a <Frame> within a page that I am loading external XAML files into at runtime. What I cannot figure out is how to force the content of the pages being loaded to stretch to fill the area of the frame. The frame has its VerticalContentAlignment and HorizontalContentAlignment properties both set to Stretch, but the page content still does not strech to fill the frame when it gets loaded. I have not set any size or alignment properties in the page being loaded, so bedefault everything should stretch. Devin ...Show All

• SQL Server How to manage all the SqlNK versions at the same time?

  Hi everyone, Nowadays, we've got four sql versions running around: 6.5, 7.0, 2000 and 2005. If you try attach from Enterprise Manager 2005 servers it doesn't allow you because of 2005 uses SMO instead of DMO. If you try attach from Management Studio 6.5 or 7.0 servers it doesn't allow you too. We'd like to have from the same place a tool for all of them. Is it possible Thanks in advance, I have client tools installed for SQL 6.5, 2000 & 2005 in order to manage our environment that is a mixture of SQL 6.5 to 2005 versions, I have no problem in having 3 of them and using at same time. Could you please explain what you mean by 'if you try to attach....'. ...Show All

• Visual Basic Coding MS Project 2003 VBA for multiple Languages?

  I have been coding some macros to run in MS Project 2003 that works fine when run under English language version but when used by a user in say France using the French MUI option fails miserably. I have a work around for: ViewApply Name:="Resource Table", singlepane:=True By seraching for a view with right screen attribute eg ' Get first resource table view For Each viewObject In myproj.ViewsSingle If viewObject.Screen = pjResourceSheet Then ResViewName = viewObject.Name Debug.Print "ResTab", ResViewName Exit For End If Next viewObject ViewApply Name:=ResViewName, singlepane:=True But now have run into the problem of: projapp.SelectTaskField Row:=1, Column:="Unique ID" ...Show All

• Architecture Any good Ntier real world (architecture)examples available for download?

  Hi all, Everybody talks about designing a good architecture Talking between tiers in stateless manner avoid chatty objects use interfaces Use factory patterns etc etccc But no one has published or uploaded some generic examples of different architectures so that you can see how things really work.(A complete solution)with different projects in it. Just tired of reading theory and not seeing any examples. Am I wrong Could anybody point me in the right direction or do i have to reinvent the wheel If I have to it will probably be a square one Thanks and apologies for moaning. hi Thanks for your time and links. I will have a go at this one.If you know of any other links ...Show All

• SQL Server Moving Table to another SQL server using Linked Server

  Hi, I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server. How is this done Thanks in advance. If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server). That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table on ...Show All

• Visual Basic strip leading zeros

  I have a field in my application where the user enters a number. My problem is that sometimes the number may have leading zeros which I would like to omit. For example the number may be 00108883, I would like to automatically strip the number down to 108883. I am searching for this value (108883) in an access database so the leading zeros would stop the value from being found. Is this possible Thanks in advance! Dim aString As String = "00108883".TrimStart("0".ToCharArray) ...Show All

• SQL Server Create database

  Hi! Is it possible to set the database owner using the "create database" command Thank you! Hi Ana, No, the CREATE DATABASE statement does not have a "owner = <name>" clause. The owner is the user that creates the database. The database owner can be changed by using sp_changedbowner. See this Books Online topic for details: http://msdn2.microsoft.com/en-us/library/ms178630.aspx . Regards, Gail ...Show All

• Visual FoxPro Sub Total and Grand Total in Table

  Dear Experts Following are tow columns in Table1, Field1 has products and Fileld2 has quantity A-----------60 A-----------45 A-----------20 B-----------40 B-----------35 B-----------85 B-----------15 C-----------12 C-----------18 In table I want to get sub totals of every category and then Grand Total at the end of the Table as below A-----------60 A-----------45 A-----------20 sub total--125 B-----------40 B-----------35 B-----------85 B-----------15 sub total--175 C-----------12 C-----------18 sub total---30 Grand total-330 Tariq, Those types of data are almost always needed for reporting. What are you trying to do Report supports it. If you need it as a cursor/table then create a cursor/table with appropriate structure and fill ...Show All

• Visual C++ Reverse Engineering with Visual C++ 2005

  Hi there, I've installed VS2005 Professional and Visio Professional 2003 SP2. According to MSDN there should be a way to reverse engineer an existing C++ project: ' From the Project menu point to Visio UML, and then click Reverse Engineer. ' Unfortunately, there is no corresponding menue item at all in VS. Do I have to configure this first Thanks for any advice Artschi This sounds like something you will only be able to do for managed projects. Properly unwinding native source code isn't quite as simple as it is with reflection :) That's also why there are so few good refactoring and intellisense tools for native C++. ...Show All

• Visual Studio Team System How do I view all Pending Changes for other users

  1. How do I view all Pending Changes for other users within the studio (equivalent to status search in SourceSafe) i.e. i want to see which files are checked out to someone else (   I have deployed and am working with the RC version of Team Foundation Server and latest client)   2. How do I undo pending changes without causing a get latest and overwiting my local copy !   Cheers Yoni Sorry, missed question #2. Undo does not Get Latest -- it downloads the version you had before you checked out the file. Of course, this does overwrite whatever changes you've made. That's by design. I can't think of any situation when I'd want to undo the pending change without also undoing the file contents. ...Show All

• Visual Studio 2008 (Pre-release) Question about WPF concerning 3D and controls

  Hi! I'd like to do the following: I want to create a UserControl containing TextBoxes, Buttons etc. that on a 3D plane. That 3D plane is to be swung away, just like a door swinging open (to make it slimmer when docked e.g. to the right edge of a window). But, the controls should still be working, i.e., I can still click the buttons, enter text in the text boxes, ... How can I achieve this The only thing I have found up to now is the VisualBrush, which simple uses the image created by a control to paint on a surface - please help! A simple cooking recipe would be greatly appreciated! Thanks Q In between shipping Vista and planning the next version of WPF, we realized that with a clever implementation it w ...Show All

• Visual Basic Missing flash.ocx file

  I am using windows 98 se, and for some reason I am now getting an error message "cannot find flash.ocx file" , can any help , where do I get a copy, what is it, it keeps going on and on, when the computer is left unattended . Its very annoying, any help is greatly appreciated. Using on a home computer.     actually, looking at that page again, probably the best thing to do is to use the flash uninstaller ( http://download.macromedia.com/pub/flash/ts/flash7/updated/uninstall_flash_player.exe ), which will remove the flash player from your machine. You can then either use the flash installer, or else simply visit a flash site in your browser and allow your browser to do the detect and install, to end up with a c ...Show All

• SQL Server Help with Join Syntax

  I have a query where I need to join a table to multiple tables and alias a field from those tables on each join. I tried the syntax below but received a error. Please assist, first time trying to do this. JOIN dbo . AbsenceReason ar ON ar . AbsenceReasonID = sda . AbsenceReasonID WHERE ar . [Name] = 'DailyReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = spa . AbsenceReasonID WHERE ar . [Name] = 'PeriodReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = cio . AbsenceReasonID WHERE ar . [Name] = 'CheckInOutReason' error I receive is : Msg 156, Level 15, State 1, Procedure p_000001_GetAttendanceProfileData, Line 45 Incorrect syntax near the keyword 'LEFT'. Msg ...Show All