Örs's Q&A profile

• SQL Server Recordset destination used in a FOREACH?

  Hi all, Can a Recordset destination be used as source for a ForEach loop. Correct me if i'm wrong but the Recordset is stored in a variable of type Object So what stops my ForEach loop from itterating Regards, Pieter Well, there are about 70-80 examples of using a recordset as a foreach enumerator (source) between BOL, google groups, and this MSDN forum.  Shorter answer, yes. Here's a good example from Jamie Thompson, http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx , which not only has verbiage, but a .dtsx file as well. ...Show All

• SQL Server Noob Question: How to get Reporting Services

  I'm evaluating using SQL for running the back end of a medium sized business. We're looking at using reporting services to cull information from several dbs, some of which are owned by partner companies who may or may not be running SQL 2005. What I'm trying to figure out is; can I just go online and download reporting services somewhere for pre 2005 sql installations Does it cost anything Browsing the MS download pages has given me no results thus far. Thanks much I found my own answer - I can get the functionality I need through the redistributable here: http://www.microsoft.com/downloads/details.aspx familyid=8A166CAC-758D-45C8-B637-DD7726E61367&displaylang=en#Overview Thanks ...Show All

• Visual C++ I want to add/remove ES_PASSWORD(CEdit) style, dynamically.

  Hi all, How can I change style ES_PASSWORD of CEdit, dynamically ModifyStyle() didn't work. I just want to add/remove this style dynamically. Thanks. :) Purusothaman A Hi, We can use SetPasswordChar function to change the password style dynamically. m_EditBox.SetPasswordChar(_T('$')); - will set '$' as password char and m_EditBox.SetPasswordChar(0) ; - will remove the password style. The above function works fine with both VS2003 and VS2005. Thanx & Regards, Ch.T.Gopi Kumar. ...Show All

• SQL Server How to suppress result sets returned from a stored procedure?

  I have a novice question. How does one suppress result sets returned from a stored procedure I have created a procedure which makes use of multiple stored procedures . The purpose of this procedure (lets call it procA), is to count the rows returned from other procedures. The “Other” procedures will return rows having an unknown number of columns. I would like to limit any changes which may be needed to be made to the “Other” procs. Once procA has collected all of the information (@@rowcount) from the inner procedures, then it will return a result set having several columns – mainly the subProcedure name and number of rows returned. The purpose of procA is to query several subsystems and identify which one ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Matrix.Scaling Problem

  Hi I write a simple game with C# 2005 and Directx9. I load a mesh from file in my application, and then use Matrix .Scaling () method to scale up my model like below: device.Transform.World = Matrix .Scaling(10,10,10) I turn on lighting in my application. When I scale up my model, the model become darker. If I scale mesh more, the mesh become darker and darker. What can I do about this problem I don’t want that my mesh become dark when I scale it up. Regards… Hey again, I didn't mention that approach because this is too costy since you are using managed code. If you used C++ you could write an assembly part to do that job so it could be very nice. If you don' ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using the framework with WinForm controls

  Anyone have any idea on how to redirect the rendering output to something like a winform Panel control, so that I could use the framework for traditional applications If you don’t need the GraphicsComponent you can easily create your own GraphicsDevice for a Window Forms control. You have to provide the window handle to the DeviceWindowHandle property in the PresentationParameters structure. I am not sure about the GraphicsComponent but overloading the FindBestDevice method seems a good starting point. ...Show All

• SQL Server Replicating Schema Changes

  Hi there, I'm using Sql 2005 merge replication and I have noticed something, I'm not sure if this is true or not:... My publication is set to replicate schema changes (replicate_ddl = 1). Now, I have noticed that schema changes are only replicated if the current snapshot is valid. Is this right If so why My next question carries on from the first. If I'm about to run a TSQL script on my publisher that will add a column or two to a published table, how do I ensure my snapshot is valid inorder for the ddl changes to be replcated Should I be using: EXEC sp_mergearticlecolumn @publication = <publicationname> , @article = <article name> , @force_invalidate_snapshot = 1 , @force_reinit_subscriptio ...Show All

• Visual C# I have this application in my head..........

  I am in the process of trying to leave healthcare after a twenty year run at it. No I'm not a nurse or a doctor, I work in the Lab, to be more specific I'm the guy that comes and wakes you up at 2 a.m. so that I can draw your blood. I have seen alot of stuff come and go, and none of it actually does what we need it to do, so being someone that knows what we actually need to make things alot better in the laboratory medicine arena I have been learning C# as fast as I can, and found that I have picked it up quite nicely. Question will C# allow me to create a "grand" program in segments, meaning start with creating an application for one department, release it, and move on to another department release that one, but "linking&qu ...Show All

• Windows Search Technologies Can Not Check Indexing Status

  Right clicking on the indexing icon (magnifying glass) does not display Indexing Status-as is should per the Help File. I just see the Tool bar menu, with Close Toolbar, etc. using Windows XP with WDS 3.1. Any ideas on how I can fix Thanks Dean I clicked the magnifying glass immediately to the right side of the text entry box that contains Search Desktop ...Show All

• Gadgets Launching a page in the default browser

  window.open() opens IE, how do I open the default browser (ie opera or firefox) Do I need to use an ActiveX control Thanks for your help Andy sorry try this var shell = new ActiveXObject("WScript.Shell"); shell.Run(" http://www.google.com "); ...Show All

• Visual Studio Team System Custom Rules Not Listed in VSTS 'Code Analysis' Tab...

  When I put my custom rule assembly into studio, it works fine, everything’s cool, except I can't uncheck it in the project properties | Code Analysis tab It shows up in the top level list, however my rules node has no children... when I click on the + there are no rules in the list... when I uncheck the whole category, it just comes back checked when you close and reopen the properties window... all of the default rules work just fine What gives From resource: < xml version="1.0" encoding="utf-8" > <Rules FriendlyName="Imagine Solutions Rules"> <Rule TypeName="PrivateFieldsShouldHaveCorrectPrefixAndCasing" Category="ImagineSolutions.Nami ...Show All

• Smart Device Development wsdl and the compact framwork

  I am sorry if this is the wrong forum for this but if any one has any ideas thanks. I have the following problem run the wsdl.exe program to get the cs file with the definitions in works fine when run in a windows app with the full framwork. But if I try to move it over to the compact framework I get an error with the " AsyncCompletedEventArgs " in the file as this is not part of the compact framwork. Is there a way to get round this. Many thanks Slim I don't see how server type is relevant. Click add web reference in VS and navigate to your Delphi based WS as usual. If you want to use wsdl.exe, you can fix the code manually as needed. You would have to do it each ...Show All

• SQL Server dll in c# sql 2005

  I wrote a class in C# with one method that returns a string. I built the dll and deployed it into sql 2005 and everything works just fine. I am now in a situation where I need to use this function in SQL 2000. Is there any way that I can use the existing dll and create a sql 2000 function, and if so how do I go about doing this Here is the c# code from the deployed dll. using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using System.Text.RegularExpressions; public partial class GECBI { [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic = true , IsPrecise = true )] ...Show All

• Visual Studio Team System TFS Project Structure creation

  HI Can any one tell me how to create a team project for the above secenrio we are in product development, so we have a product at top level and which in turn has n sub modules projects.The Structure is like this Product Module1-Team A (10 persons are working) Module 2-Team B(20 persons are working) Module 3 -Team C(10 persons are working) ......................................................... .......................................................... Module n-Team N( 10 persons are working) Based up on this scenerio, i want to create a team project where in ,project Lead of a particular Module should have access to his module relating information (it may in the Team expolrer,share point site ...Show All

• Windows Live Developer Forums custom error message for findlocation

  Is there a way I could display a custom error message when no matching location is found instead of: "Virtual Earth could not find a match for the location. Please check your spelling, enter the complete address including country name and commas, and try again." OR is there a way I can stop that message from being displayed Same for the message displayed when a close match is found. Is there a way to not display that popup message just a note that it is a hack and therefore may not work in future versions etc. Really we need a way to be able to set a callback event and handle the error ourselves. In 3D mode the iframe "shim" still appears - you get a white box where the message ...Show All