Saitham8's Q&A profile

• SQL Server Convert columnar data into rows

  I have a table of data that needs to be converted to rows but with a way to identify for each row the column the row value came from. Here's an example table: Employee FED MEDI SOCSEC 123 $100 $25 $70 234 $242 $54 $90 345 $75 $10 $55 Here's the format the data needs to be in after it's converted. Employee CodeType Code Amount 123 T FED $ 100 123 T MEDI $ 25 123 T SOCSEC $ 70 234 T FED $ 242 234 T MEDI $ 54 234 T SOCSEC $ 90 3 ...Show All

• Microsoft ISV Community Center Forums Office 97 / Windows 2000 Compatability

  Im having trouble referencing Office 97 objects in Windows 2000. I'm in Word 97 and trying to set my object appWord to equal a new word application. My code is: Dim appWord As Word.Application Dim docCP As Word.Document Set appWord = New Word.Application Set docCP = appWord.Documents.Open(OutputDirectory & FileName, False, False, False) However on running I get a prompt telling me the document can not be found. This code errors on the line Set appWord = New Word.Application not where the application sets the filepath and name. I get a similar problem when using he same method for Excel only the message I get is around a missing DLL but its doesn't tell me which one. If anyone could shed any light on this id ...Show All

• Visual Studio Express Editions DHTML controls

  how do i get the copy, cut and paste controls to work with the DHTML box I really recommend against using that control as it has been deprecated. In no longer supported. The control you want to use us the current Webbrowser control. The old DHTML control had an SDK as of a year ago it was available on the net and you have no documentation and you will be able to find very few people to help you with it. If you use the current WebBrowser control, there are LOTS of people that can help you with it here and there is lots of documentation and abundant examples in all of the VB fora. If you weigh all of those factors, I think it very clear that the webbrowser control is the very best way for you to pr ...Show All

• Visual C# File.Move works but can't open the file

  Hi i have an application that i listen file system with file system watcher and then i am able to move any file to another folder. When i use File.Copy method it always works fine but sometimes(not everytime) after that i can not open file with the code below FileStream fs = File .Open(path, FileMode .Open, FileAccess .Read); fs.Close(); it gives error just as "File already in use", and this situation continues forever(till i close application). But if i try to open the file manually from its new folder, its okey i open it. Where am i wrong and why does it sometimes work and sometimes not Anyone any idea Thanks a lot ! that's definitely points to my mistake, i must be careful while ...Show All

• Microsoft ISV Community Center Forums Access Security Warnings

  Because of the changes with Access 2003, i have had to buy a digital signature to sign my projects, this has cost many hundreds of dollars. My problem is that if i sign the project, computers with Scandinavian regional settings are unable to read the digital signature, when the file is opened the message comes up saying that it cannot be opened because it is not digitally signed. I have tried code signing certificates with both Thawte and Verisign, the same happens with both of them and have spoken to their support teams who are at a loss as what to do. I know there are several workrounds, but i dont want to leave my customers potentially exposed If anyone has any ideas it would be great Regards Steve ...Show All

• Visual Studio Tools for Office Right Click Menu for Contact in OutLook 20003

  I wanna add one extra action once I Right Click on any Contact under outlook.... is there any hint Hi There is no support in Outlook 2003 through the Object Model to add a context menu on an explorer window. It is possible to try and do this through API calls but this is not supported and is full of potential issues. Regards ...Show All

• Visual Studio Team System NUnitASP Style Tests

    How do I write NUnitAsp style unit tests with the UnitTesting framework   There was an answer posted here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=10378&SiteID=1 but the code no longer seems to work.  Or I can't find the namespace that these attributes are in <WebServerType(WebServerType.WebDev)> _ <WebApplicationRoot("/WebSite")> _ <PathToWeb(@"C:\WebSite")> _ Thanks Aeden Yes I do. I know because I wouldn't have access to HostType() & UrlToTest ( ) & AspNetDevelopmentServerHost ( ) and all that good stuff. Thanks for the quick reply. Cheers, Aeden ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with the default Windows Game in XNA

  When I go in debug mode, what happens is that it fails, and the problem is caused by this: this.GameComponents.Add(this.graphics); If I remove, however, the program does not work as it should, as all it does is display a grey screen that doesn't refresh itself. What's wrong with it For hardware info, I'm using an Inspiron 1000 laptop, with a SiS M650 graphics card. I know it's not because I'm missing a file, because I have downloaded Visual C# and the XNA Game Studio Express. I'd be willing to bet that your graphics hardware doesn't meet the minimum: Q: Will the XNA Framework require D3D9 hardware A: A Direct3D 9.0 card, capable of supporting Shader Model 1.1, is the minimum. The recommended l ...Show All

• Visual Studio Catastrophic failure with Add new item

  Hi All, I've created a custom project type using the MPF. The probem that I am running into is that after I create a new project of my type and try to add an item to it via the project item context menu, I get the below exeption. I've verified the project items template folder matches the [ ProvideProjectItem ] attribute that I set on the package. Any ideas on what could be the cause of the problem Or how I can solve it Thanks Drew The exception is caught in: HierarchyNode. AddItemToHierarchy ... ErrorHandler .ThrowOnFailure(addItemDialog.AddProjectItemDlg( this .hierarchyId, ref projectGuid, project, uiFlags, null , null , ref strBrowseLocations, ref strFilter, out iDontShowAgain)); /*&fDontShowAgain*/ ...Show All

• .NET Development Searching table

  Hi there, I am new to .net and VB, but have been doing some development. I have a simple question I am using a select statement to retrive some ID's from a table stored in access 2003, and record them in a dataset & display them using datagrid now i want to search all of those IDs recorded , one by one and retrive some more records from that same table in access using select statement with that ID...any idea how this can be possible, best reguards sl5 And what's the problem What do you want to know How to create an SQL query with "where ID=@ID" clause How to enumerate your records Please explain a bit more and we will try to help you. ...Show All

• Windows Forms How to create a Custom Form that appears in the Toolbox and is droppable on the Design Surface?

  I like to create a dll with a custom form that contains other controls (buttons, check boxes, etc). I am using vb.net or c#.net (2005). I like the form to appear in the Toolbox and be able to drop it on the design surface. This behavior is the same as the provided dialogs such as FontDialog. Searching the web showed that I need to add a designer attribute of ComponentDesigner: "Set the Designer attribute for your custom dialog to be ComponentDesigner (instead of the default ControlDesigner). That should make it droppable in the design surface as a component." But I have not been able to make this work. Can someone help Thanks, Rene Rene, Are you planning on the users of your desi ...Show All

• Visual Studio 2008 (Pre-release) Change rectangle property from code

  Hi guys, i've got a rectangle i've drawn in a grid, how can i change its propertys from code, i think i need to build once or something, should i be using X:name or something...FindName, i'm a bit lost, thanks guys si in that code sample you are missing the KeyDown event KeyDown = " OnKeyDownHandler " ...Show All

• .NET Development Coding a for loop for multiple threading and automatically timing out long running threads.

  I know most programmers including me could work out a solution for this, but I was thinking that there may be features built into .net2005 which cover this functionality in a neat way. I haven't done much threading before but have a serious timescale pressure so any help you can give with this would be appreciated... I need the following pseudo code: dim th(10) as threading.thread for each obj in collection ' collection has perhaps 5000 elements ' terminate any threads that have been running longer than their timeout - say 60 seconds ' pick up the first available thread, or sleep if there are no available threads. ' execute that thread to process obj t.Execute(normal, AddressOf mysub, obj) next I was w ...Show All

• .NET Development finding out if the computer has an active working Internet connection

  I need help with writing code that finds out if the computer has an active working internet connection so that my program does not throw errors and exceptions when it cant find the internet. My problem is that i do not know where to start. FLAMETHROWER It's good to do it on a separate thread: ThreadStart threadStart = new ThreadStart (VerifyInternet); Thread InternetCheck = new Thread (threadStart); InternetCheck.Start(); if (InternetCheck.IsAlive) { pbNetworking.Image = Image .FromFile( Application .StartupPath + @"\yellow.ico" ); lblWWW_Status.Text = "Verifying connection..." ; if (lblWWW_Status.Text != "Verifying connection..." ) ...Show All

• Visual Studio 2008 (Pre-release) Using command line arguments in a WinFX Window application

  Hi, I'm trying to use command line arguments in a WinFX Window application. I figured out the "real" entry point of the program was located in the App.g.cs file. There I can add argument String[] args to the main method. However, the header states that modification to this file will be lost when it is regenerated, making me expect that there's another way to use arguments which would be cleaner. Any ideas of a better way to do it Thanks in advance Here is the code of App.g.cs, where I manually added the String[] args argument to main method: <CODE> //------------------------------------------------------------------------------ // <auto-generated> // This code was generated by a tool. // Runtime Version:2.0.50 ...Show All