GoldRunner's Q&A profile

• .NET Development XSLT Irregular child order xslt:foreach

  I have a question. I have an XML file which is actually an XML representation of Excel VBA code (but don’t let that out you off!). I am commissioning a program to parse the code into three types of XML element which will be styled in three different colors. If you look at an Excel VBA environment you will see keywords in blue, comments in green and other text in black. I have a fragment of XML thus < xml version = " 1.0 " encoding = " utf-8 " > < vbacodemodule > < line > < keywords > Option Explicit </ keywords > < br /> </ line > < line > < br /> </ line > < line > < ...Show All

• Windows Forms Hide caption bar without empty form text?

  I'm creating a login screen for my application, and I want to hide the caption bar of a form, but I don't want to set empty string for the form text, because it will be strange to customer that a task in the taskbar without a name. Does anyone have ideas about it Thank you very much! As Dave said, set the FormBorderStyle to None and it's ok. For more info, check the msdn: http://msdn2.microsoft.com/en-US/library/system.windows.forms.formborderstyle.aspx ...Show All

• Visual Studio 2008 (Pre-release) MenuItem Click event. Which menu was clicked?

  I'm using a single MenuItem click event for all of my menu items. In this event I want to use a switch to determine which MenuItem was clicked and then call the appropriate method. How can I identify which MenuItem was clicked I add a value to the Name property of the MenuItems, but the MenuItem variable is null below. private void MenuItem_On_Click ( object sender , RoutedEventArgs e ) { MenuItem mnu = ( MenuItem ) sender ; switch ( mnu . Name ) { case "mnuAddSeg" : AddLineSegment ( thm ); break ; case "mnuRemoveSeg" : RemoveLineSegment ( thm ); break ; } } ...Show All

• Visual Studio Getting an XMLException running Sandcastle

  I'm getting the following error when trying to use Sandcastle on my web site. It's just a test project and I've isolated my error to two files. The chm builds fine when these two files are excluded from the project. The two files are custom providers with nothing remarkable about them. C:\Documents and Settings\sageruss\Desktop\test>if not exist output mkdir output C:\Documents and Settings\sageruss\Desktop\test>cd output C:\Documents and Settings\sageruss\Desktop\test\output>MRefBuilder "C:\Documents and Settings\sageruss\My Documents\Visual Studio 2005\Projects\TestProj\TestPro j\bin\TestProj.dll" /out:reflection.org MRefBuilderStatic (v2.0.2397.42473) Copyright Microsoft Corp. 2005 ...Show All

• Visual Studio 2008 (Pre-release) MouseOver on child, but not parent?

  Is it possible to apply an event to a child UI element, but not the parent I have a panel that contains a couple textblocks, and rectangles as well as a child panel. I want to use the MouseOver on the child, without triggering a MouseOver on the parent panel. (Unless I'm over one of the textblocks or rectangles..) thanks! ok, it was recommended by a co-worker to use a multi-condition trigger. He is correct that it will work in my simple case given. Any other suggestions though ...Show All

• Visual Studio 2008 (Pre-release) Serialization

  I have a service for which I get an exception thrown by the proxy on the client side (server stack trace below) on a server InvalidOperationException. My data contract is marked up with [XmlElement] in places because I deserialize some XML content returned from a database call to SQL Server with FOR XML... Are there known issues with using [DataMember] and [XmlElement] on the same properties Unfortunately, it seems to work some of the time, and not others... Thanks! Error message: Test method MyMethod threw an exception: System.InvalidOperationException: The operation is not valid due to the current state of the object.. ---- at System.Xml.XmlBaseReader.ReadEndElement() at System.ServiceModel.Disp ...Show All

• SQL Server about connections and Login

  Hey guys, I have created dtsx packages and i have one master package which would run couple of child packages. 1. I have all on my local machine.I want others who r working with me access these.So what do i need to do for them to access... 2.what would be the best way in executing these packages. the way it is set now is i had 3 connections set for each package. a.Source connection b.Destination Connection. c.One more connection(which is used with in the process of execution) Can i set connections in common for all the packages in one location. 3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done. H ...Show All

• Visual Studio How to make such kind of Crystal Report

  Hi All, I require Cross-Bar Crystal Report in the Following Format Total Column1 Column2 Column3 Total Row1 Column1 Column2 SummaryData SummaryData SummaryData Row2 Column1 Column2 SummaryData SummaryData SummaryData . . . The Row Field of Cross-Tab contains more than one field and if possible may allow to format. Thanks in advance. ...Show All

• SQL Server how to assign the view to a user?

  im using the Northwind database, i use T-SQL commands to create a view that restricts users from seeing the address, city for all employees. i dont know how to assign the view to a user in the database using Enterprise manager. pls help me, im really needing a answer. thanks! But you should be aware that sp_changeobjectowner is for SQL 2000 only. It is still existing for SQL 2k5 but should not be used anymore in SQL2k5. Use the other options mentioned in the BOL (look in the entry sp_changeobjectowner) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic Printing an rtf file with printform

  Hi I love the idea of the printform, it was one of my favourites in the vb6 code. Although in vb6 it was possible to print a flexgrid (or even a textbox i think) which i used frequently. Is the same things possible with the printform, or would i have to make the controls the exact size of the window and then use the printform I would like to print an rft file and what would be the easy way of doing this Getting WYSIWYG results from a .Net Rich Text Box control. ...Show All

• SQL Server URGENT PLZ: random but unique

  Hi, Can you please help with this query.. I want to extract the following columns from the database: start_date_time serial_number pin_number account_group substring(ani, 9, 8) as mobile what i want to get is a random 50 records from the database with the above columns but it MUSR have a unique mobile number (above : no. 5).. I tried this in the stored procedure: SELECT DISTINCT TOP 50 ani , substring ( ani , 9 , 8 ) as Mobile , start_date_time as ' Date ' , account_group as Card FROM billing Where start_date_time between @start_date and @end_date and account_group in( '2Connect (0506)' , 'India (0506)' ) and substring ( ani , 9 , 2 ) in ( '36' , '39' ) ...Show All

• Smart Device Development Draw nice line Compact Framework

  I want to draw some lines and basic shapes on screen in Compact Framework. I've used the Graphics class and a bitmap, and then added the bitmap to a picturebox. The problem is the lines look like *** when they are not going straight up or to the side, and by *** I mean that it looks like stairs. Anyone know how I can fix this problem My screen is 640*480 pixels, and that's what I use for my bitmap. I tried to set the bitmap to 6400*4800 and then set the sizemode property for the picturebox to stretch, but the result was the same, the line is like a stair. I guess I might have to use some visual "cheat" or something, but don't know where to start. Anyone got any tips ...Show All

• SQL Server Excel pivot table

  Hi, I have several pivot tables in Excel that access data to a SQL 2000. We install SQL 2005, we change the ODBC from the 2000 server to the 2005 server. Now when we try to run the pivot tables I've got the following message: "User 'public' does not have permission to run DBCC TRACEON" Any idea on how to fix this problem Thanks, Arty When I trace with the SQL Profiler as Laurentiu suggested in both SQL 2000 and 2005, the statement that run is: dbcc traceon(208). I have no clue what the 208 means. The difference between the SQL 2000 and 2005 is that in the 2000 I have no errors and the pivot tables runs ok, however in the 2005 I have the error previously mentioned. Arty ...Show All

• SQL Server How to pass results of a SQL FOR XML query to an XML Task?

  How do I pass the results of a sql 'FOR XML' query to an XML Task I tried using a user variable of type string. In my Exec SQL Task on the General tab I set the ResultType to XML. Then on the Result Set tab I map it (Result 0) to my user variable (string). Then in the XML Task I use that variable as the Source. However, it fails in the Exec Sql Task with error "End tag 'CustomJob Field' does not match the start tag 'CustomJobField' It looks like some extraneous chars are getting inserted into my tags   I also tried setting the ResultType to SingleRow but that failed with error: "The type of the value being assigned to variable "User::ForXmlResult" differs from the current variable type. Variables may not change type during ex ...Show All

• SQL Server Getting list of subscribed reports from the ReportServer database

  I need to replace all instances of 1 e-mail address with another, this address is subscribed to multiple reports, and many of those subscriptions are set up to be sent to lots of e-mail addresses so the description field in the subscription table is not returning the full list (the description field is truncated after 55 characters so I can only see the first couple of e-mail addresses that are subscribed). Where in the ReportServer database can I find a list of e-mail addresses subscribed to a report I have had a look around and can't seem to find where the information in the "To:" and "Cc:" and "Bcc:" fields are stored Thanks, Paul. Thats in the Subscriptions tab ...Show All