simon.bruynsteen's Q&A profile

• SQL Server How to delete or drop a cursor?

  Could anybody please tell me how to detete or drop a cursor Thanks, -RL Also, be sure to declare the cursor as LOCAL, or use a cursor variable declare @cursor cursor set @cursor = cursor for... These are much safer to use, and will deallocate themselves if you don't. ...Show All

• Windows Forms ClickOnce deployment problem

  Hello, I am having a problem and would be much grateful for any information/tips anyone can give me. After updating a program at work, i rebuilt it, and then published it to a server where people in my company can download it. When you click the setup.exe from the publish page, it downloads setup.exe all right. The program is that once you run that it pops up a dialog that says 'Cannot download the application. The application is missing required files. Contact application venfor for assistance.' Then it closes. Here is the detail file that came with it: Please, if anyone has any clue as to what or where i can check next, id be really really grateful. I am fairly new to programming, and would welcome any theories. T ...Show All

• SQL Server script in text in 2005 EM?

  Hi, In 2000 you could script out a file (tables SP's etc.) as text by going under Options -> File Options and choosing the MS-DOS text (OEM) format. I'm wondering where/if this same capability is in 2005. Right now, it looks like the default is binary. Can anybody share some information on this Thanks, Phil That's only how to script an object. My question is how to script an object as text. If you notice when you script an object like the way you are suggesting, it will by a binary file (atleast when I check it into sourcesafe). This was an issue I had before in SQL 2000, but atleast it gave the option to script the file out to MS DOS (text). Does anyone else know what I'm referring to ...Show All

• Visual Studio 2008 (Pre-release) Dynamically configured Client

  I want to be able to create a client endpoint in code (not in the config file) The closest thing to this that I have found is to dynamically update the config as follows: Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); ServiceModelSectionGroup sg = ServiceModelSectionGroup.GetSectionGroup(config); ChannelEndpointElement ce = new ChannelEndpointElement(); ce.Address = new Uri("net.tcp://localhost:47552/myService"); ce.Binding = "netTcpBinding"; ce.BindingConfiguration = "netTcpBinding"; ce.Contract = "ImyService"; ce.Name = "myTCPEndpoint"; sg.Client.Endpoints.Add(ce); // This writes it to the config file config.Save(); // this does not appea ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to flip a 2D texture

  Hi Microsoft, First, thank you very much for the XNA Platform. I do recognize the titanic effort to deliver this platform. I do have a small suggestion that will help the development of 2D games, specially for us newbies. In a nutshell, I've been looking for a direct way to horizontally flip an image, mostly because I don't want to put two ".png" files when one single file might be enough. I think this operation would be quite common, specially since a sprite that goes to the left will eventially go to the right. I look everywhere in the documentation, and I was not able to find such procedure. I did find some stuff about DirectX, but I didn't understand a byte of it. After half a jar of coffee, I read something ...Show All

• Visual Studio Team System How to start using TFS?

  Our team have just installed TFS on one of the servers. But problem is, none of us in the agile XP team knows how to use it! Can someone give links to tutorials or any help files that we can use to learn on it We dont even know the very basic of connecting a project to a agile project in VS2005... Thanks in advance. I think these two articles will give a nice overview and "how to use" for each discipline: Overview: http://msdn.microsoft.com/msdnmag/issues/06/00/TeamSystem/ more details: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/witinvs05tmsys.asp After that you can start using TFS. To learn extensibility, I suggest downloading SDK from http://msdn.mi ...Show All

• Visual Studio Team System Feature Requests: Database subset, Multiple Databases, and Linked Servers

  Database Subset This feature request is from a Software Developer's point of view who has to manage his own database tables where there are no Database Professionals to help them with schema changes. The database design at my work groups serveral different "subset" databases into one database. For example, Application #1 uses Tables with "App1_" prefix. Application #2 uses Tables with "App2_" prefix. However, all those tables are inside under "MyDB_1" database. I can't help but I have to work with it. Possibility #1 Since Application #1 is the one I mantain, I want the Visual Studio to only store a subset of the database schema for each individual project. Possibility #2 Or, I want to b ...Show All

• Visual Basic GetChange problem

  Hello. A question please. I have a dataset. I inserted a new row. Then I show the data on screen. The user does his changes. Now I'd want to insert that row in the database. I do a getchanges on a dataset but I get a rowstate=added with the data that I create in the first time, not with the changes made by the user. What happens.... Thanks... I only retrieve 1 change with the getchange. Hi,  I think you would need to refresh the view of the datagrid after the user has done His / Her changes too. That is show the data on the screen again. Try putting in a line similiar to.>> DataGrid1.Refresh() as the data is written to the database 1st ( not to the screen view ), it sound ...Show All

• Visual C++ LoadLibrary fails only in Windows Server 2003

  Hi, I wrote a DLL to be called from a program that was written by somebody else. It works fine on Windows XP but not in Windows Server 2003 Enterprise Edition. I wrote another program that does nothing else than open the DLL with LoadLibrary() and then free it again. Works fine on XP, returns NULL in Server 2003 even if the DLL is in the same directory as the program calling it. I assume there is some security measure that stops the DLL from being accessed but some hours of searching in the internets about such measures didn't help. There are no software restriction policies defined and permissions are set for every group to be able to read and execute the DLL. Thanks for your help Paschalis E ...Show All

• Visual Basic Delay of 1 sec in code

  Hi In my application , I want to execute a code then wait for 1 sec then again execute with some changes and again wait and so on I used Sleep API but i am unable a print a status that loop is running even if i had written before the loop could execute. is there any other way to have a delay of 1 sec other than what i had used Help Hi Thank u for your concerned reply We are working on MsComm Control of VB. We actually want to have delay in reading the transmitt buffer by the device . Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Sub Command2_Click() For i = 2 To 900 y = "Command to be executed on the devi ...Show All

• SQL Server Union all does not union all rows

  Hi all, I have a Union All transformation with 4 inputs and one output when I debug the package the sum of the different inputs rows does not match the row count in output. I don't understand, I've used the Union All transform many times and I've never seen this. Any idea why this could happen OK, here is the description of my Data Flow: 1. OleDbSource 2. Conditional Split with 3 outputs. 3. The first output goes directly to the Union All which cause the problem. 4. The second output goes to a Derived Column transform and then goes to the Union All 5. The third output goes to a Lookup trnasform and then goes to the Union All. Let's say I have 500 rows coming out of the OleDbSou ...Show All

• Windows Live Developer Forums VEMap.GetMapView Method

  Hi, I'm trying to maintain the state of the map during postback and found a nice thing: VEMap.GetMapView() This could be an easy way to do it, but I cannot find any detailed documentation, about the object that is returned... ! The only sentence I found is: "Returns: An object that represents the current map view. " (http://dev.live.com/virtualearth/sdk/Ref/HTML/M_Namespace_VEMap_GetMapView.htm). Maybe someone can help me to get a few infos ! ! - thx cheers hafi23 How would you go about doing this with a BirdseyeScene Is there a way to determine the LatLong's of the top left and bottom right of the scene, similar to what you can do with the normal map I've tried using something like this, but it doesn't seem to be wor ...Show All

• Visual Studio Can not deploy VS 2005/CR .Net web site

  I am having a hard time deploying an intranet web site using the version of Crystal Reports that is bundled with Visual Studio 2005. I have created a deployment project, and added the reference to CrystalReportsRedist2005_x86.msm. I then ran the Setup.exe on my server. This would not allow me to view the Crystal Report. I found information that I need to make sure that IIS had a Virtual Directory called CrystalReportWebFormViewer3, and this is where the images need to be housed. I created this Virtual Directory, and moved over all of the files that were on my development machine in the same file. I even made sure that the ASP User had rights to the folder. My reports seem to run, but I can not see any images that CR places on ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Convert PC Game To 360 Game

  if anyone knows what kind of changes will need to be made, i would appreciate it. heres my Premise, its set in the year 2020 and i want to make a sort of perfect dark sequel, not perfect dark zero. joanna ends up getting into another fight with another corporation. i havent devised any weapons, or characters yet.           please help PLEASE REPLY!!! hey thanks man, some other people had told me the same thing, i just wanted to confirm. \ Thanks Again ...Show All

• Windows Forms Listbox refresh threading issue

  Hello, I've got a bit of a problem with refreshing the listbox. I may be making this too complicated, but here's what I have: the program itself is designed to check an array. When that array changes, the listbox is to be repopulated with the new items in that array. So the user clicks "go" and the event fires and causes the listbox to rapidly refresh until a) the procedure changing the array finishes. or b) the user kills it. The only problem is, the user can't kill it because control never returns to the windows form. The click event is still running. I thought I could solve this problem by creating a new thread to refresh the listbox, but it doesn't work because I discovered that I can't really manipulate the l ...Show All