Chris M Turner's Q&A profile

• SQL Server Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All

• Visual Studio invalid table number

  Hi, I developed my apps in vs 2003 . my apps utilizes crystal report. In my PC it's working well. I've SQL 2000 database. Now i'm facing problem when i deploy the apps in client PC. It has SQL express 2005. When i open crystal report from client machine, it gives me invalid table number. how to solve this I just attached the same database (from my machine) into the client machine . Kindly guide me. Thank You Hi, Have you already updated the location of your database in your crystal reports Coz maybe this would be caused when the database location of your database has changed. So you need to also change the location in your crystal reports file. cheers, Paul June A. Domag ...Show All

• SQL Server IIS

  Hi, A few of the machines have not got IIS installed (business related). Is there a way to install sql server 2005 without having IIS on the machine Thanks From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install. ...Show All

• Visual Studio Express Editions Computed Column

  I am having trouble finding the correct sytax for formulae in creating computed columns. I would like to create three computed columns in my table in my database. The first is an average of the last 20 prices, the second is the average plus one standard deviation and the third is the average minus one standard deviation. I would appreciate any help. I have tried even simple formula but nothing seems to work, i keep getting error messages. Markw2004, Check out this link: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1279113&SiteID=1 This will show you how to aquire spreadsheet gear for free. (legally). I use it for something similar to what you want. I also have my reports generating as data is being input with b ...Show All

• Visual Studio Express Editions How to create a Inheritable user control...

  Hello everybody, I'm trying to create a User Control that inherits from another User Control, but under the Add --> User Control command I don't see nothing that permit to choose some inheritable options... Can you help me Thank you very much! igorbaITALY, Take the DataBoundControl an example. The following code example demonstrates how to derive a class from the DataBoundControl class to create a custom data-bound control. The TextBoxSet control creates a TextBox control for each data item retrieved from its associated data source control, and binds to the value of the data item at run time. The current implementation of the Render method renders the TextBox controls as an unordered list. Imports System Imports ...Show All

• SQL Server Query syntax

  Hi all! I am new here and I'm also new to SQL.. I hope somebody could help me regarding my problem. I don't know if this is possible but I would like to have a code that can integrate data from 3 tables. The names of my tables are Savings, Loans and Insurances. Their common field is the MemberID. One member could have zero or more Savings Accounts. At the same time, a member could also have one or more accounts on Loans or Insurances. How can I get the data that would appear like this: MemberID - Savings Account - Loan Account - Insurance Account 0001 - S0001 - L0002 - I0001 - S0003 - L0005 - 0002 - S0012 - - 0003 - S000 ...Show All

• Visual C++ Using zlib within a managed MS Visual C++ 2005 Express project

  [FYI, I'm somewhat new to the latest Visual Studio incarnations and am coming up to speed as quickly as possible. ] Has anyone managed to get zlib 1.2.3 to work within a managed MS Visual C++ 2005 Express project (using /clr:safe) I have gone so far as to successfully rebuild the zlib DLL and lib within the same IDE (different project) successfully using the original sources (though the project had to be converted automatically from the older version first). However, zlib is not in C++ .Net (it's pretty much standard C++) and so I cannot simply reference its DLL as part of the project (it's not clear to me how you'd make that call). I'm in need of some direction, i.e., how to load the DLL and how to reference some part of it. I'm get ...Show All

• Visual C# Converting a string to int

  I'am building a console program and need to convert a string that the user types to an int. If I use convert.ToInt32 a get the ascii code for the number but not the number it self. can anyone help me find a easy way to do this, if there is one :) I fixed the problem by doing it this way for ( int i = 0; i < str1.Length; i++) { if ( Char .IsDigit(str1,i)) { number = Convert .ToString(str1 ); if ( int .TryParse(number, out theResult)) { Console .WriteLine( "input string successfully parsed to Int: " + theResult.ToString()); } } } Thanks agin for your help Damon ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Use XNA to make a map maker?

  How can I incorporate XNA into a Form so that I can make a map builder rather then make the whole interface inside XNA , I would like to be able to use windows controls. Thank you A quick an easy way to use forms with XNA, is to simply new up a form prior to Game.Run. Add a form, "MyForm" to your project Then, within the program.cs file in the "Main()" method just before Game.Run(), do this: MyForm myForm = new MyForm(). myForm.Show() Game.Run() .... When you run the app, your form will show and from this form, you can write code that interacts with your game. You can also add as many other forms as you want... -jeff ...Show All

• .NET Development How to get versions of services/programs running on another system?

  Hi, I want to get the versions of the services/programs running on another system. Does any body have any idea as to how it can be done.I thought of using SNMP.However I am not sure of how to use it thanks in advance, nhd WMI or System Management objects work here. Works in .Net too. Base query is "Select * From Win32_Process" ...Show All

• Visual C# Windows Unzip and Download

  Hi, I have an application that download it's new version from the internet in a zip file. But I'm having problens to unzip and replace the files... Is there a way to make the application unzip the downloaded file automatically to the folder that it's running Thanks Obviously... What class do I use to call command line Is there some internal in C#.net that I can use to unzip files...How can I do this process !!! ...Show All

• Audio and Video Development Chapter playlists

  Has anyone written any code to do chapter playlists yet Suppose I have one title/.MAP file with many chapters in it and I want to allow the viewer to pick a playlist that plays only a few of those chapters, automatically skipping over some chapters in between. Right now I'm catching the chapter system event, checking which chapter just finished, then jumping to the chapter that comes next in the playlist. Since script execution timing varies, I'm having a lot of problems with this method. I am going to experiment with Event s in the title's ScheduledControlList next, but I was wondering if anyone here has a better idea of how to implement this. That's good to know, but our eventual goal is to allow dynamic ...Show All

• .NET Development Circular reference

  Hi, I have a webmethod returning a "tree" but each node has a reference to its parent. But the XMLSerializer doesn't support circular references. Is it possible to return such circular reference types from webmerthods Thanks, Kostadin XML, with its parent-child structure format, doesn't support circular references. What you can do is use the <XMLIgnore> attribute to prevent the XMlSerializer from the serializing that field, then on the client re-build the circular reference. http://msdn2.microsoft.com/en-us/library/system.xml.serialization.xmlignoreattribute.aspx You could also use a dataset as it supports circular references, not through pointers (ByRef), but through PK/FK (int ...Show All

• Visual C# Add Comment to File

  Is it possible to add a comment header file to a file. Something in the form // filename.cs // Creation Date // Author // Copyright (C) ... The filename, date and author would be automatically inserted. I would like this inserted at the head of the file whenever I create the file. If this is not possible then if I could use some keyboard short cut toinsert it. Is this possible BTW I am using Visual Studio 2005   Yes, you can do this by using Macros, Check this link , http://www.codeproject.com/dotnet/VSNETBoilerplateMacro.asp ...Show All

• Visual Studio SubreportProcessing is not firing when the project output type is not executable

  I have raised this before but I didn't get any reply. So I am trying to rephrase the problem. To duplicate the problem please follow the following steps: Download this sample code from http://gotreportviewer.com/objectdatasources/AuthorBooks.zip Open the solution and add a new Windows Form project to the solution Make this newly added project as startup project In the newly added project add a reference to AuthorBooks project Put a button in a Form1 and onclick of the button try to open the AuthorBooks.Form1 Now I am getting Subreport could not be shown error. Is this a know issue Has anybody else experiencing same problem If this is a know issue, do I have any work around. I am appologizing for reraising this ...Show All