gafferuk's Q&A profile

• Visual C# annoyances

  Is there some way I can stop windows "parked" in the left and right tool strips jumping out when they see the mouse coming (ie it hovers momentarily in their vicinity). Or even worse jumping out when they are minded to do so - especially the Properties window which seems to jump out on any pretext.. What I'd like is that they only appear when I click on them or "context click" the toolstrip and select them - ie I want to control the screen real estate without prejudice;-) I finally solved this problem, I bought a new computer. It has a faster processor and more RAM, the parked windows still jump out (actually they now slip out), but they are no longer sticky, ie I don't have to clos ...Show All

• SQL Server Understanding the Algorithms used by SQL Server

  I have been a DBA for three years. Over the past three years, I've been rapidly increasing my skill set in standard administration and programming. However, I know that there is a huge gap in my understanding of SQL Server and how it really works. I'm in graduate school right now and I'm taking a course in Algorithm and Design. I have to write a research paper on some topic that deals with Algorithm and Design and I figured this is as good of time as any to really understand the Algorithms that SQL Server uses to make the decision on how to retrieve data, store data and etc. Before I go off on this journey, I would like to know if I am going to be able to find out how SQL Server really works Does microsoft actually discuss the algo ...Show All

• SQL Server No rows were deleted

  My SQL 2005 table has 7 exact redundant records. I opened it in a data sheet view and selected these rows and tried to delete them. No keys are defined and null values are allowed. Error says: The rows values updated or deleted either do not make the row unique or they alter multiple rows (7 rows) Help: Why error message and How to delete these 7 rows Hi, that is related to the fact that the SSMS will compose a query behind the scenes which takes the values as parameters for the DML statement. If the query does not precise define the row (in case of two exact same rows the parameters will be the same) SQL SMS won’t know which row to be deleted. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2 ...Show All

• Visual Studio Example of how to exclude class members?

  It is not clear how the examples in mrefbuilder.config apply to class members. Help is appreciated. Thanks Henrik Hi Henrik, I've been playing around with the namespace ripping feature and here's what I've found. The config file should look like this: <configuration> <dduetools> <platform version="2.0" path="%SystemRoot%\Microsoft.NET\Framework\v2.0.50727\" /> <apiFilters> <!-- API filters go here --> </apiFilters> <attributeFilters> <!-- Attribute filters go here --> </attributeFilters> </dduetools> </configuration> Attribute filters are the easiest. If you want to include all attribute information on the typ ...Show All

• Visual Basic Capitalize a string

  I want to ask if is there any way to capitalize an entire string, so that a string looking like QweRtY can be automatically changed into QWERTY Thanks a lot!! Actually, what i need now is a function that can change characters like a e i o u into a e i o u Thanks and sorry for posting so many replyes :P ...Show All

• SQL Server Unable to install SQl Server 2005 SP2 - Unexpected error

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• Visual Studio Express Editions How to save as HTML and more

  I have a couple of questions I hope someone can help me with. First, I made a program that generates a complete HTML page. That page is displayed in a text box and I just tell the user to copy and paste the contents into Notepad and save as .html Obviously this isn't the best way to do that. I want to upgrade that by simply having a button on the program that they click to automatically save and save it as an .html file so all they have to do is find the location they are to save it at. How do I do this What code do I put in the sub class for that "save" button Also, I have another program that generates some text in a textbox. Right now I just have the text box's visibility false until the user hits submit in wh ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. USing VB and C++.. 2 programs, accessing 1 anothers var's

  Hey guys, Quick question. I have a school project that i have to do. We are required to use visual basic 6.0. I dont like using direct input because i like the other values that xinput outputs. I found out, after hours of searching online that directx 9 can not! be used in VB.. because no one can do it.... so ill just use C++..... now this is my question, Can i have a created C++ programm running in the background and have a VB program running, which access's the C++ var's .. is this possible.... please let me noe Questions: Do you have to use DirectX If so, do you have to use DX9 If no to the first question, can you use the GDI for whatever graphics you have to do How complicated is the pr ...Show All

• Visual Studio Error with storttbls.nlp

  On the weekend (11-Nov-06) a .net framework update was automatically downloaded, installed and my computer was reset. Unfortunately this update failed As a result my Visual Studio 2005 completely stopped working. For anyone else you may encounter this, you simply have to re-install .NET 2.0 in add/remove programs, press the Change/Remove for .NET 2.0 Framework and select re-install. If the setup informs you about a current install, let it rollback the install. For anyone itnerested at MSFT: Microsoft Update Error Code: 0x80242007 EventType clr20r3, P1 regsvcs.exe, P2 2.0.50727.42, P3 4333ae62, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 a26, P8 0, P9 system.io.filenotfoundexception, P10 NIL. Not really enough information ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. main menu

  Will you be able to create a main menu and if you can how will it be done Jim Perry wrote: From the FAQ : Q: What’s the difference between XNA Game Studio Express, XNA Game Studio Pro and XNA Studio A: XNA Game Studio Express and XNA Game Studio Pro are related products targeting non-professional game developers and established professionals respectively. Both products integrate with Microsoft Visual Studio. XNA Game Studio Express is intended for the hobbyist/small development group and therefore designed to help create non-commercial games. XNA Game Studio Pro will include additional functionality such as libraries supporting Xbox Live (Achievements, Leaderboards, Multi-player) needed by prof ...Show All

• Visual C++ Writing Scalable IOCP Socket Apps

  Ok, so I have done a fair amount of research, and I dont "get it". I understand IOCP is a huge and powerful concept, and relatively new. Anyway, I am having a LOT of problems while setting it up, and not sure if what I'm doing is what its supposed to be doing. Before you direct me to a link just yet, I'll show you were I have looked: http://msdn.microsoft.com/msdnmag/issues/1000/winsock/ http://win32.mvps.org/network/sockhim.html And an ungodly amount of time in the MSDN winsock functions/structs/etc. The problem with the first 2, is they give a good dive into it, but the example source code doesnt really show the steps of doing it. The 1st link doesnt go a ...Show All

• Visual Basic Converting textbox's text into Decimal

  hi.. I am practicing a exercise from a book and when i type in this code Dim decPrincipal, decIntRate As Decimal decPrincipal = txtPrincipal.Text.todecmal for some reason i get a syntax error on this part can someone help me out i m using VB.net When converting user input text...like from a text box...you should use the "TryParse" method...that way if the text cannot be converted it returns zero instead of an error: Dim d As Decimal Decimal . TryParse ( Me . TextBox1 . Text , d ) ...Show All

• SQL Server The attribute key cannot be found - two cubes - different results

  I am working with a cube that was built by someone else.  I reverse engineered it to create a project and I am trying to re-deploy it in a development area.   I keep getting the ‘The attribute key cannot be found: …’ error on a fact table key.   When I use a SQL script to check if there are any missing keys in the dimension table they are all there.   I have tried dropping the dimension from the cube and adding it back and changing the DSV from table to Named Query.   Nothing fixes the problem.   As a test I created another project and included only the fact table and the ‘problem’ dimension and I was able to successfully process the cube ! !   I would rather not ‘ignore the errors’ ...Show All

• SQL Server connot connect to the repository with Analysis Service

  I have a problem with Analysis Services. When I open Analysis Manager and try to connect to the SQL server with Analysis Service, the following error message is displayed: "connot connect to the repository. Error:Could not use ''; file already in use." the server and my local machine all both using SQL server 2000 with SP4 any help will be appreciate, thanks in advance. Benjamin ...Show All

• Office Live Development Adding data to custom list

  We are building a custom application for office live. Here we are using a form web part that would accept data from the user in a wizard like format and would save that data into a custom list. We are trying to figure out how to store the data in the custom list, but have not received any success so far. I tried using the UpdateListItems method of the sharepoint web service Lists.asmx, but have been unable to do so. If I try to invoke the web service from a console application programatically, I get an 'Object moved to ' error referring to a login.live.com url. I am wondering if I am moving in the right direction. What I need to know is exactly how can we save data to a custom list, using the sharepoint web service or otherwise. T ...Show All