Mike Williams28205's Q&A profile

• SQL Server view executes too slow

  i have written a query and created it as a view when i run the query it takes less that 5 seconds to give results but when i run the view it takes about a minute can anyone help please, it keeps giving me time out errors here is the query. SELECT MAX(B.Code) AS Code, MAX( T.Description) AS Type, MAX( WH.Description) AS Warehouse, MAX(B.Barcode) AS Barcode, MAX(B.BatchNo) AS BatchNo, MAX(B.CustomField) AS CustomField, MAX(B.Colour) AS Colour, MAX(Q.Quality) AS Quality, MAX(round( M.ConvFactor, 2, 2)) AS ConvFactor, MAX( M.Multiply) AS Multiply, MAX(CONVERT(VARCHAR(20), round((B.BoughtQty + B.TransferQty + B.IssuedQty + B.Retu ...Show All

• .NET Development BUG: "Cannot Implicitly Convert Type 'System.Data.DataSet'" not fixed yet?

  The following is an old bug from 2003 (that's right, 2003) SYMPTOMS You have a Web Service that has a Web Service method that returns an instance of a custom class. The class that is returned by the Web Service method implements the IXmlSerializable interface. If you use this Web Service in an application, you may receive the following error message when you build the application: Cannot implicitly convert type 'System.Data.DataSet' to 'ClassLibrary.ClassName' I remember seeing online somewhere that this had been fixed, yet we're still getting this bug in .NET 2.0, We're developing new web service methods that return c ...Show All

• SQL Server order by in a view in sqlserver2005

  Hi, I've a problem with a created view in sqlserver2000 that I'm now using in sqlserver2005. This is the view : CREATE VIEW hsarti01_VD1 AS SELECT TOP 100 PERCENT * FROM hsarti01 WITH(index(hsarti01_PK)) ORDER BY 1,2 desc,3,4 When I do the "select * from hsarti01_VD1" in sql server 2000, I see in the result that the order by is been using. but in sql server 2005 it's just using the order of the primary key and not the order by ! Has anyone have a solution for it Thanks Hi I have found out that the percent directive gives this problem. I guess it is a bad solution but replac ...Show All

• Software Development for Windows Vista Windows SDK January missing Graphedit components?

  Previously when in DXSDK the graphedit has used proppage.dll that is used then viewing pin property pages etc for example. The latest Windows SDK does not have this and GraphEdit in it is giving "requested property page could not be displayed" in every turn... So should that proppage.dll still be included in the SDK or is this something that is being changed Can you, or someone else, please upload proppage.dll from the Windows Server 2003 R2 Platform SDK to an accessible location It feels like overkill to download the whole SDK just for this one missing file. ...Show All

• Visual Studio Express Editions MDI Taskbar?

  Does anyone have a mdi taskbar class or somthing. I cant find one good example anywhere :'( The MainMenu and MenuStrip classes can automatically display a list of open MDI child forms. Do you need more than that ...Show All

• Visual C# No password needed for webClient.UploadFile()??? :-/

  Hi there, I found this snippet on how to upload a file using the webclient-class on MSDN. Console.Write("\nPlease enter the URL to post data to : "); String uriString = Console.ReadLine(); // Create a new WebClient instance. WebClient myWebClient = new WebClient(); Console.WriteLine("\nPlease enter the fully qualified path of the file to be uploaded to the URL"); string fileName = Console.ReadLine(); Console.WriteLine("Uploading {0} to {1} ...",fileName,uriString); // Upload the file to the URL using the HTTP 1.0 POST. byte[] responseArray = myWebClient.UploadFile(uriString,"POST",fileName); // Decode and display the respo ...Show All

• Windows Forms DGV RowEnter event: How to determine if it's fired during initial load

  As described in documentation, the "RowEnter event occurs when the DataGridView is initially loaded, as well as when the user selects a row other than the current row". Since I just want to react to user changes, I need to determine if the event was fired because of user interaction or initial loading. Does anybody know how to reach this Thanks a lot! Thanks a lot. This was the missing data to determine the user interaction. I thought there might exist something more direct, like checking if the datagridview is in initialisation mode. But anyway - it works! ...Show All

• Windows Forms <object/> tag - standby and alternate text

  my tag is like this <OBJECT id="simpleObject" height="150" width="150" classid="./simpleControldll#tabletWdc.simpleControl" standby="loading" VIEWASTEXT> alternate text </OBJECT> the standby attribute doesnt show while its loading. nor does the alternate text, if it does not load. am i using the wrong syntax ... or do they just not work Thanks casey posted this  ...Show All

• Visual Studio 2008 (Pre-release) runtime compilation of Linq code

  Hello, Would you know of any ways to provide on-the-fly compilation of C# 3.0 code There must be some CSharpCodeProvider for it somewhere.. Thanks, NR I ended up trying both ways, as playing with compiler is I think the best thing in programming. After all, isn't giving meaning to abstraction the crux of programming So, bottom line is : If I use the natice csc Linq compiler (by an ugly process wrapping), it works but I loose the ability to feed my own namespace For instance, my business object that I want to query is a "Bench" that has products, portfolios, curre ...Show All

• .NET Development Help with detecting a barcode scanner event

  Hi, I am a .NET programming newbie. It is my first time posting here so i apologize in advance if i got the wrong forum. If it is the wrong forum, maybe you could point me in the right direction :) I am developing a desktop Windows inventory application using the .NET framework. The user will be scanning barcodes into a TextBox on a Windows form. The barcode scanners that are used in the company are not programmed to automatically send a carriage return at the end of the scan. (I checked this in Word/Notepad and there does not seem to be an end of line character in there). Is there any way to detect when the user has finishe ...Show All

• Visual Studio Team System Don't seem to have Web Test Recorder Toolbar

  I am trying to record a test script as shown in the demo's but after installing VS2005 and creating new web test project , when I press "Start Recording" IE starts up but there is no "Web Test Recorder" toolbar or view of the script in a left hand pane in IE. Have I missed a step Do I need to install a plugin in IE to make it able to record scripts. Is installed on XP Pro - SP2 - is browser security blocking something Thanks for any help or pointer to were to look. David, In Internet Explorer, look under the View -> Explorer Bars menu and see if Web Test Recorder is listed there. Also, make sure you reboo ...Show All

• Visual C++ Is the /GS switch working as expected in Beta 2?

  Something appears a little broken in VS 2005 Beta 2. The code below will produce the expected buffer overrun dialog box when compiled retail in VS 2003 but does not in VS 2005 unless I set optimization to /Od. void causeAnOverrun( _TCHAR *badName ) { _TCHAR myNameBuffer[5] = {0}; _tcscpy( myNameBuffer, badName ); } int _tmain( int argc, _TCHAR* argv[]) { _TCHAR *name = _T("Long Name"); causeAnOverrun( name ); _tprintf( _T("I got past the overflow!!\n") ); return 0; } Is this a known issue, or should I submit a bug George George: you should go ahead and file the code-generation bug so th ...Show All

• Windows Forms Max length of string

  What's the max length for the string datatype Thanks. .NET documentation says:: String  (variable-length)   System.String (class)   Depends on implementing platform  0 to approximately 2 billion Unicode characters.   ...Show All

• Visual Basic XML editing

  When i try to use any of the XML editing functions within the XPath class i always get a method is not supported error.  Why is this ' Load the document. Dim Doc As New XPathDocument( "Data.xml" ) ' Navigate the document with an XPathNavigator. Dim Navigator As XPathNavigator = Doc.CreateNavigator() ' Move to the root <Debts> element. Navigator.MoveToRoot() ' Move to the first contained <User > element. Navigator.MoveToFirstChild() ' Write a new Child Dim Writer As XmlWriter = Navigator.AppendChild() ' ERROR HERE!!!!!! ' And insert the tag navigator.AppendChild.WriteStartElement( "User" + NoO ...Show All

• Visual Studio Trapping the F5 menu command

  I'm having some difficulty in trapping the F5/Start Debugging command. I've tried adding the command like this: id = new CommandID(VsMenus.guidStandardCommandSet97, 295); command = new OleMenuCommand(new EventHandler(ShowConsole), id); mcs.AddCommand(command); but no luck. I've also added a section in the commands table like this: CMDUSED_SECTION guidVSStd97:295; CMDUSED_END My other user defined commands work ok - I can trap and handle them fine. Is there anything else I need to do Thanks Dermot I've figured out how to do this by overridding the ExecComm ...Show All