WinFormsUser13232's Q&A profile

• SQL Server problem with sql query.

  Hi ya, I have two tables. One is the temporary table called tbl_temp and the other is called tbl_empDetails. I want to run a query that would bring me the records of tbl_temp where there is no corresponding ID present in tbl_empDetails, meaning it shud bring only records where a corresponding records is not available in tbl_empDetails. I tried it but this query doesn't work, it is bringing me the records which are there in tbl_empdetails. How can i do it SELECT DISTINCT tbl_temp . SID , tbl_temp . fname , tbl_temp . lname , tbl_temp . mail , tbl_temp . tel , tbl_temp . mobile , tbl_temp . office FROM tbl_temp , tbl_empDetails where tbl_empDetails . adSID != tbl_temp . SID ORDER BY tbl_temp . lname Try th ...Show All

• Visual Studio Team System Intercepting WorkItem Changes from Excel

  hi all, i'm working on VSIP package in order to do some custom validation on workitem save and its working fine.. but still there are other ways people can by pass validation like from Excel etc. I'v never worked on excel customization etc.. so can somebody give any ideas how to approach it.. regards faraz Hi, Can you provide some more details on what kind of validations are you planning to add to Excel Excel Add-in in TFS V1 does not support any customization mechanism. You may have to implement your own COM Add-in and capture Excel events like SheetChangeEventHandler and implement your customizations in that Add-in Following MSDN article talks about how To Build an Office COM Add-in by Usin ...Show All

• Visual Studio Express Editions Does C# have any problems with SQL Express!

  Hi, I am planning on converting a program that I was writing in VB to C#.  Mainly because I was having a problem with my main form, it would not let me edit it because of an error that occured with an auto-named database that had the same name or something.  It is to my understanding that this is a common problem in VB.  So my question is: Does C# have the same problem with SQL Express as VB   Also, I was told that C# is a faster language, is this true exactly, Glenn hit the spot - I always say that - the language is down to user preference, at the end of the day, its using the same framework/clr so it doesnt matter what you use, you are still using the same framework/resources - it gets compiled to the ...Show All

• Visual Studio Express Editions Stupid SQL Question

  I am trying to learn the C# and SQL, and it looks like to run a program using an SQL Database that the user needs to also install a fairly large SQL program. Is this true, or will the compiled program be all that they will need I'm curious, as if this is the case I may need to look into using MS Access or something instead. Any help would be greatly appreciated. Thanks, -Matt Hello All. Matt: Well, I'm not positive because I've never tried it (since I prefer SQL Server), but I'm thinking that if you use a MS Access database, the machine will still need the MS Jet database engine. If you don't want your users to have to install something themselves, then it's no problem, because when you build yo ...Show All

• Visual FoxPro application and webdata interacting.

  ok first off here is some info about my webserver: i dont no if you needed the information but maybe you do General server information: Operating system Linux Kernel version 2.6.17.11-grsechg Machine Type i686 Apache version 1.3.37 (Unix) PERL version 5.8.7 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.21-standard cPanel Build 10.9.0-CURRENT 117 Theme cPanel X v2.6 ...Show All

• Windows Live Developer Forums Adding Layers to the Map

  Hi, I am in a process of developing a website using virtual earth that displays data from my database on Virtual earth Map. From the VE SDK i learnt that this can be achieved by Layers. But didnt not really understand how to implement it. Could some one help me in doing the same or provide a sample code that will help me. Email: madhu.gandhi@patni.com . Thanks and regards, Madhu. I copied the sample RSS available in the SDK ( http://dev.live.com/virtualearth/sdk/GeoRssTest.xml ) onto my local machine. Kept it on a server and gave the path of the xml in the layer source. But it didnot work. i got an error saying "Unable to load the file". Am i doing anything wrong However if i change the source to http://dev ...Show All

• SQL Server Understanding Estimated Execution Plan

  When I generate an estimated execution plan from Management Studio, one of the things I often see in the execution plan generated is an 'Index Scan'. When I put my mouse over the 'Index Scan' graphic, I will see a window display with something called 'Output List' at the bottom of the window. Do I understand correctly that SQL Server will scan my index looking for values in each of the fields included in this output list Thanks, Amos. Output list is nothing but the list of columns that will be projected from the operator (scan or seek). So this will relate to say the column(s) that are required for the join and/or referenced in the SELECT list of the query for example. There is a parent topic in the lin ...Show All

• Visual C# How to use the custom assembly deployed it in the GAC

  Sorry to ask a very basic question here. I have created an assebly and deployed it in the GAC. Now how can I use that assembly I deployed in any type projects, I mean how to add reference to that assmbly just like we add reference to System.Windows.Forms.dll. How can I do that Given below are the steps I done to deploy an assembly 1. Created an SN Key . sn -k "c:\Keys\ver1.snk" 2. Create a dll, and in the assemblyinfo.cs, I have given [assembly: AssemblyKeyFile("c:\Keys\ver1.snk")] 3. Deployed the assembly using gacutil -i <Mylocalpath of assembly> . I checked for this assebly name in c:\windows\assembly, its present there, so the deployment is successful oops !! I am sorry. Please give rep ...Show All

• SQL Server How to specify config file for package within a package

  I have a situation where I have Package A, which is called from Package B. Both packages have been designed to use config files for their connections, etc. The issues arises when executing Package B. I can specify a config for Package B to use, but how do I tell the embedded package to use its correct config file By default, Package A has its config file pointed to development, but I would rather not have to save a special version of Package A that points to production. I dont see any option within the execute package task. Any ideas Each package has to have the name of the config file specified (unless you are using indirect configurations ). Are you telling PackageB which config file to use via the command-line If s ...Show All

• SQL Server Mailing Label

  When I develop a 1" x 3" mailing label - line one of each label is 1" apart. When I move to the server and run - it wants to add about .1 of a line between each label causing the print not to match to the label paper. To help in alignment I have a verticle bar 1" in height. On the client there is no gap. On the server I get a .1 gap between lines. Anybody have any idea(s) about what is happening and why ...Show All

• Visual Studio 2008 (Pre-release) Using Microsoft.Expression.DesignSurface.dll

  Hi. Am I allowed to reference Microsoft.Expression.DesignSurface.dll in my project I'm trying to create some PowerPoint like application. The end-user should be able to place and drag elemets on a canvas. I found the framework Adorner implementation problematic for such uses (mouse and performace issues), and I'd like to use the Blend implementation, which includes rich model for it.   Thanks. ...Show All

• Smart Device Development Retrieving all device icons

  Hi, I need your help. I have developed sample application for listing files and directories like File Explorer. Files and Directories are displayed in the ListView control. For that application, I need all device icons (gif icons, jpeg icon, exe icons, dll icon...) to display in the ListView for files. I think all icons are in dlls like windows (Shell32.dll). How do i get that icons Please send your suggestion or links. Thanx. M. GANESAN Ok. Leave it. Now i have a doubt about getting icon from exe. How to extract icon from the exe file or dll file. for eg. extract icon from the iexplore.exe file I could get the icon handle from that exe by using ExtractIconEx() API. But How can i display that icon in a control Please se ...Show All

• Visual Basic insert snippet with a shortcut key

  I write in VB.Net with VS2005. I would like to insert my code snippet with a single shortcut key. It's so inconvenient for me to insert a code snippet every time according to the following steps: 1. right click on my VB codes 2. click the "Insert Snippet..." menu item from the context menu 3. find and select the folder of the snippet I would like to use 4. find the snippet I would like to use from the selected folder The above 4 steps is too long to me. What I want is a single shortcut key for each insertion action. I considered to record a macro for this. However, I found out that I could not pop up the context menu for the "Insert Snippet..." menu item once I have started marco recording. How can I insert my code snippet in a faster way ...Show All

• Windows Forms Automatic shift of ScrollableControl contents

  Hello, I'm creating a custom control whose client area is painted by DirectX (it uses the Application.Idle event, and the "AppStillIdle" check as described in this blog ). Now, I need this control to be scrollable. DirectX still paints the same area, but the scrollbar positions control some internal vitual offset which affects what's being drawn. The problem is, the scrollable controls seem to actually automatically shift the content of the client area when the scrollbars are dragged, probably to optimize user's experience. Unfortunately in this case it's not desirable, because the content gets partially shifted by the control and partially repainted by the idle processing, which looks quite ugly. So my question is, is there a ...Show All

• Visual C++ Add a final "\n" to a buffer

  Hi, I am writing a file with text from a TextEdit control. I have a buffer with the text I got with GetWindowText and I want to put a new line character to the end of the buffer. I reserved this extra character space in the buffer but I do not know how to assign the "\n" to the last position of the buffer. Can anybody tell me how to do it You can use _tcscat_s to concatenate characters at the end of an existing string. Use \r\n for newlines on Windows controls. Brian ...Show All