Steve_B's Q&A profile

• SQL Server Multiple column update statement

  Hi, I'm new to SQL Server but not new to SQL because I used it with Oracle. I wonder if it is possible to do this kind of statement on SQL Server: UPDATE TableX M SET (M.column1, M.column2, M.column3)= (SELECT T.column1, T.column2, G.column3) FROM Table_Y T, Table_Z G WHERE join condition)) WHERE EXISTS (join condition for TableX) Basically, I'd like to update multiple columns in one statement but for some reason I can not get it to work. What would be the equivalent on SQL Server Thanks for the help, Laszlo M Hi Laszlo, UPDATE TableX SET column1 = T.column1, column2 = T.column2, column3 = G.column3 FROM TableX M INNER JOIN (TableY T INNER JOIN TableZ G ON T.column4 = G.column1) ON M.c ...Show All

• SQL Server .NET Framwork error when starting SQL Server Profiler

  Greetings, I have been having a problem when I try starting the SQL Profiler. I am running the SQL Server 2005 - Developer edition. I get a message box from Microsoft .NET Framework saying: Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue. Could not load file or assembly 'ConnectionDlg, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its The details listed under the Details button are: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.IO.FileNotFoundException: Could not load file or assembly 'Con ...Show All

• Visual Basic out keyword

  alternative of out keyword in vb.net Out Keyword, con you give more information such as out keyword in which language or what your trying to achieve. ...Show All

• Visual Studio Custom Tool in VS2005

  Hi, have some troubles creating a "Custom Tool" like "MSDataGenerator": I read the article found at: http://msdn.microsoft.com/msdnmag/issues/06/02/CuttingEdge/   and some of the linked articles too. So here are the steps i made in hardly 15 mins: 1. Create new VS2005 C# ClassLibraryProject called "MyGenerator" 2. Add reference to Microsoft.VisualStudio.BaseCodeGeneratorWithSite.dll 3. Implemented: "MyGenerator.cs": using System; using System.Runtime.InteropServices; using Microsoft.CustomTool; namespace MyGenerator {    [ComVisible(true)]    [Guid("d1815bb9-ecce-4dbc-9b73-ce4ff234af7d")]    public class MyGenerator : BaseCodeGeneratorWithSite    {    &n ...Show All

• Windows Forms How to add duplicate datacolumn to datatable

  Hi All, How can we add a duplicate column to datatable. I already had a column named "Action" in my datatable, and i want a duplicate column to "Action". Note: Actually the datatable is being filled from dataset. I cannot change the Sql Query because those are predefined by analysts. Thanks in advance. You can not have 2 columns named action in your data table. You can add a datacolumn that uses an expression to copy the data to the new column. DataColumn dc = new DataColumn ( "Action2" ); dc.Expression = "Action" ; dt.Columns.Add(dc); ...Show All

• Visual Basic Page SIZE. See the PageSetupDialog.

  THis is my Custom page size W= 21.59 cm H= 13.97cm Dim pkCustomSize1 As New PaperSize( "Custom Paper Size" , 21.59, 13.97) ptr.PrinterSettings.DefaultPageSettings.PaperSize = pkCustomSize1 and it did not do it properly!!!! Hi, See the PageSetupDialog. For details click this link.>> http://msdn2.microsoft.com/en-us/library/6ctbkskc.aspx Regards, S_DS ...Show All

• Visual Studio 2008 (Pre-release) Duplex Communication Architecture

  Hi, I'm having the following problem: 1. I have a duplex service running. 2. One of the operations on the service is not marked as IsOneWay=ture, so the client calling the code is expecting a return message. 3. The operation itself will raise an event that the Callback will bubble-up back to the client. A deadlock is happening because the Callback message cannot be processed until the original operation message completes, in which the operation is waiting for the event raiser to finish. I'm trying to find out the best way to accomodate this scenario. Anyone have a suggestion from an architectural point-of-view I am currently considering marking the operation as IsOneWay for a quick solution. P.S.: I can post a sampl ...Show All

• Visual Studio Express Editions I need to know registry information for the internet explorer temporary internet files?

  I need its location in the registry and which key it is under. Thank You!!! P.S. I need this information for my visual basic troubleshooting application. Hi, Believe ot not I have some of my old C++ code and I found the answer where I had written an app to fix an IE bug. What I say is true for XP. (HKEY_USERS, _T( "S-1-5-21-1606980848-1957994488-1801674531-1003\\Software\\Microsoft\\Internet Explorer\\Main" The key will be HKEY_USERS The next portion will be your account SID - in this case mine was: S-1-5-21-1606980848-1957994488-1801674531-1003 The rest will be: Software\\Microsoft\\Internet Explorer\\Main" ...Show All

• Visual Studio Express Editions change the origin.

  could someone please tell me how to change the origin from the top left corner to the center of the screen when using the Win32 API I am trying to make a character go where you click, but I can't seem to figure out how, for DX uses the center as the origin and Win32 uses the top left corner as the origin. Thanks for all your help. Hello Re: change the origin. This forum is for “Questions about Visual C++ Express Edition and getting started with C++.” For questions such as yours please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Microsoft ISV Community Center Forums Emails via Excel

  Hey Ladies and Gents, I am a bit new to the world of visual basic so please be kind. I have been set a mini-project here at work and need some assistance. What i am trying to achieve is for a user to click a command button in excel, opening up a new mail message in outlook. This new mail message will include filled areas in to, subject and main body with a hyperlink to the document in which they have just updated. I have managed to produce the following code so far: Sub Button1_Click() Dim theApp, theNameSpace, theMailItem, myAttachment, MessageBody, subject 'create a new Outlook Application Object, 'direct it to the proper NameSpace, 'create a new Mail Item and set the attachments collection Set theApp = CreateObject( ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Limits of DrawPrimitive / VertexBuffer size

  Hi, The code I've been working on for the last few hours is a 360 version of some terrain code I had written for the PC. A huge gridmap of squares (each square is 4 triangles, not 2) drawn in a single call. Although I know this doesn't leave me many options for culling, I'll get onto that sometime this week. My question is about the limits imposed on the Draw call and VertexBuffer size. GraphicsDeviceCapabilities exposts a property called MaxPrimitiveCount, which for the 360 appears to be 1,048,575. Yet I've been drawing a grid of 1000x1000 squares (1 million squares, 4 polys each) which is over 4 million in a single call and as far as I can see it appears to be drawing all of them. What (if anything) does this MaxPrimitiveCount repr ...Show All

• Visual C# to run this application, you must first install the following version of the .net framework...

  I wrote an application using studio 2005 professional edition, and then I burn it to a CD, but when other people put the cd into their machine, I got this msg: "to run this application, you must first install the following versions of the .net framework v2.o.50727... how can I make the cd be used in any machine should I put some .net evironment software in the cd to go with my application this seems very un-convinient to use.... There is a very good article on MSDN which will walk you through deploying .NET 2.0 along with your application: Using Visual Studio 2005 to Redistribute the .NET Framework 2.0 http://msdn2.microsoft.com/en-us/library/aa480239.aspx ...Show All

• Visual Basic mscomm32.ocx : file is missing or invalid

  Hi when installing a visual basic 6 project in Vista 32/64, the process completes fine but when i try to execute the file after i get the error: "component 'mscomm32.ocx' or one of its dependencies not correctly registered: a file is missing or invalid". I have made sure i have the control in the correct place and that it is registered fine aswell. Any ideas Chris, I'm trying to help someone with this problem, but I'm doing it blind because I have never seen Vista Home Premium. Can you please give me more detail on this process He's trying to install a program from CD. Thanks, Patricia P ...Show All

• Windows Forms Deployment of a .NET C# windows service using a setup package

  Hello I have completed some code changes to a windows service. This application was originally not created by me, but I am maintaining the application. I have noticed that the application is packaged with a set-up application that was create in VS 2003. Basically when the project is built it creates a setup.exe file. When I double click on this file it presents me with several dialog boxes that allow me to install the service. The problem is that when I go through the setup dialog boxes, I am eventually presented with a messagebox telling me that "The specified service already exists". As far as I can tell the new version of the service is not installed. So what do I need to do Do I somehow need to un-install the older ...Show All

• SQL Server Report Viewer Output pdf to shared file folder

  Hello, I've developed an application in Visual Web Developer 2005 Express using a sqlserver 2005 express database. The application accepts user input via a number of wizard steps and in the final step renders a report of the final output in the report viewer control within the application. Is there a way to have the rendered document automatically saved to a fixed shared directory (in pdf format) without the user needing to export it manually Thanks there is a render control to get the report in three formats 1. Image 2. Excel 3. Pdf I hope this command helpful for u dim getbyte() as byte=rptviewer.LocalReport.Render("Pdf",Nothing,Nothing,Nothing,Nothing,Nothing,Nothing ...Show All