Symtex's Q&A profile

• SQL Server insert a new record

  Hi, I would like to know is it possible to combine these 2 statements into 1, as I want to insert a single record set in tblRefLockers. statement 1: INSERT INTO tblRefLockers (Locker_No) SELECT Locker_No from tblLockersInfo WHERE MemberNo = 1234 statment 2: UPDATE tblRefLockers SET Locker_Condition = 'BAD' WHERE MemberNo = 1234 Can I do that Thanks, KNVB Hi, In Oracle this would be simple since they have a MERGE method but in SQL Server this does not exists. So it is not possible in SQL Server. You can add and change rows at the same time in SQL Server. Greetz, Geert   Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Smart Device Development problems getting online with wireless laptop

  can some one please help i have been trying to connect a wireless laptop to the internet but it seems to have a problem downloading any form of webpage, the wireless connection icon in the system tray indicates to be connected to the internet and i can still go online with skype but thats about it.my download speed is just 54kbps, not really sure about how the wireless router is configured but dont think that the problem since my house mate has no porblem going on-line himself. This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. Please post to relevant forum or news group: http://support.microsoft.com/newsgro ...Show All

• Microsoft ISV Community Center Forums Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger I tried the code and all I get is a run-time err ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Working with buffers in 2D

  Hello all, I've been trying to figure out how the system with backbuffers work. In all examples I have found people are clearing the buffer before they draw something new. graphics.GraphicsDevice.Clear(Color.Black); ...draw some sprites... graphics.GraphicsDevice.Present(); I guess that when you enter the Draw method you are working with the backbuffer, so the clear() and the sprite draw() will affect the backbuffer. After that you call the Present() to draw the recently made backbuffer on the screen. My problem is that this is not how I would like to do it in my case. Everytime I enter the Draw() method I would only like to add some new things, and not clear anything. The easiest way to do this is to not have any backbuffer at all, but I ...Show All

• SQL Server Question on Flat File Import

  I have a flat file that uses tabs as the column delimiters and cr-lf as row delimiters. The first portion of the file consists of only two columns for approximately 10 rows and then the file changes to 4 columns for the balance of the file, about 21 rows. The column names are in the first column and the data of interest is in the second column for the first 10 rows and then in the third column for the last 21 rows. Is it possible to set up something like this for parsing in SSIS I've tried using two columns in the data flow task but then I get columns 1 and 2 through the whole file. If I tell it there are 4 columns in the file, it appends rows to each other so that there is a total of 4 columns in the first 10 rows. This reduces the row c ...Show All

• Visual Studio Documentation Compiler - Sandcastle

  We did code complete of documentation compiler ( code named "Sandcastle") on June 15th and currently we are testing the tool building our .NetFramework documentation. We would like to release the CTP version of Sandcastle in Microsoft download center by next week. The perf in our testing has been great as we are able to build the entire framework content in less than 1 hour. I am in the process of going through final check and code signing required to post this in our download center. Please expect the CTP in the next week or so and I will provide an update here as soon I post the CTP. Anand.. I think we all are. Don't forget that a Program Managers "desire" to release something is not always met. I think we ...Show All

• Windows Forms Reusing Pen with DashStyle set to other than Solid sometimes results in OutOfMemoryException when Graphics is rotated

  We are currently developing an application for shape manipulation on a canvas, where objects are drawn on the surface of Control in OnPaint method. At the beginning we didn't include shape rotating possibilities and all was working well when drawing any amount of objects at any locations. Then we added rotation possibilities by using Graphics.RotateTransform and Graphics.TranslateTransform. All of a sudden, in some wierd cases that have no obvious incommon properties except that there were multiple shapes that were rotated and that used a Pen which had DashStyle set to Dashed (for object outlining). After lots of testing (monkey method - drag&rotate a lot, drag&rotate a lot, etc.) and using Visual Studio 2005 debugger, we got ...Show All

• Visual Studio Team System Source control Plug-in "Visual Studio Team Foundation Server" is not showing in VS 2005 Team Edition for Software Developers

  I have installed Visual Studio 2005 Team Edition for Software Developers on top of VS 2005 Professional. I have read from here ( http://msdn2.microsoft.com/en-us/library/ms316479.aspx ) that Team Explorer functionality is part of any Team Edition. But still I don't see "Visual Studio Team Foundation Server" as a Source control Plug-in under Tools->Options. Do I need to install Team Explorer to get this plug-in or am I missing something Any pointer is greatly appreciated. -- Thanks Hi, You need to install the Team Foundation Server client. This is available on the Team Foundation Server installation CD. Instructions for downloading it seperately (if you can get hold of the TFS installation disk from your administrat ...Show All

• Visual Studio 2008 (Pre-release) MouseOver on border problem

  I want my border to be set to white when the mouseover event is fired any idea why this is not working <Window xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xml:lang="en-US" x:Class="UntitledProject1.Window1" x:Name="Window" Title="Window" Width="640" Height="480" Background="#FF040404"> <Window.Resources> <Style TargetType="{x:Type Border}" x:Key="BorderStyle1"> <Style.Triggers> <Trigger Property="IsMouseOver" Value="True"> <Setter Property="BorderBrush" Value="White"/ ...Show All

• SQL Server Issue with float data type

  Hi, I have a table with float data type. When we insert or update data with some math(1+1.01) it converts the decimal value to approximate value. Example: Create a table say "Table1" with field "Field1" of data type float Now insert a record with value 1.01 Select * from Table1 would give me out put at 1.01 Update Table1 set Field1 = 1.01+1 Now Select * from Table1 Instead of returning me 2.01, it returns 2.0099999999999998. Same thing happens if I insert record with following statement insert into Table1(Field1) values (1+1.01) Any idea why its doing this way I know float is approximate data type, but shouldn't it be giving me correct value for what I am doing Is there any server setting t ...Show All

• Visual Studio Team System Customize MSF Process template

  Does anyone know where to download the MSF customization tool The tool has GUI that allow you to customize the MSF, instead of you edit the XML files one by one. I think you refer to the MSF Process Guidance tool, you have two options for editing: AS you say, edit the Xml files one by one. Open template2.xsn with infopath and edit it and at last you will need MSFWinBuild http://www.gotdotnet.com/Workspaces/Workspace.aspx id=c0ce8992-2955-4371-904b-1f93a9efffe6 to render the HTML files for the Process Guidance If you refer to the workitem types and so on, then download what Sagar says, and also I would recommend you download Visual Studio 2005 SDK to have more documentation about this. ...Show All

• Windows Forms Adding a custom icon to a form, next to minimize, maximize and close in top right

  Hi My design calls for a custom 'pin' icon to be added to forms next to the existing minimize, maximize and close in the top right corner. Any suggestions as to how this could be done Jim Beware of WM_NCPAINT, it will wipe out your hard work when Windows redraws the caption bar. The GetWindowDC API function returns a DC for the entire window, including the caption bar. I've never done this but it sound technically feasible. Make sure you pay attention to the window metrics, the sizes of the standard buttons and the height of the caption are configurable. I'm not seeing this done in other apps though so there must be some catch... ...Show All

• Visual C# How to have multiple sets of application settings?

  Hi, I'm using the standard mechanism to set and retrieve application settings (using app.config, Settings.settings and Settings.Designer.cs). I can set the application settings using the Visual Studio IDE and retrieve them like this: string title = Properties. Settings .Default.WindowTitle; This works fine - for a single set of settings. But now I'd like to run multiple instances of my application, pass them an argument that makes them unique (1, 2, 3, or "master", "slave"), and use that argument to access a specific set of settings. Preferable something like: string title = Properties. Settings .Master.WindowTitle; or string title = Properties. Settings["Master"] .WindowTitle; Is thi ...Show All

• SQL Server Foreach endless loop

  I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It acts like it is stuck on the second record (tuple) and never goes on. I'm using an ForEach ADO Enumerator in the foreach. I've even set a breakpoint on each iteration and no task fails in side the foreach loop. I'm completely perplexed why it will iterate to the 2nd record but get stuck there in an endless loop. I've tried this on 2 different compu ...Show All

• Visual Basic Access server file from client

  hi all, i having a problem to access server folder. i got one folder inside server, which i already shared. but when i access that folder fail. dim host as string = "\\serverId\folder\file.xml" doc.Load(host) ..... error :System.IO.IOException = {"Logon failure: unknown user name or bad password. how i pass the user name and password any one help please......... hi bruno, idon know why u give me this code but thanks anywhere. i found that: Dim impContext As WindowsImpersonationContext = Nothing Try impContext = NetworkSecurity.ImpersonateUser("mydomain", "bala", "password", LogonType.LOGON32_LOGON_NETWORK, LogonProvider.LOGON32_PROVIDER_DEFAULT) Catch ...Show All