Mike Prilliman's Q&A profile

• SQL Server Documented t-sql for file space ?

  Hi There I would like to write sql to check that space used by any given data file in SS2000. sp_spaceused only returns the total space used by the DB or object in the DB, not for a specific data file. DBCC SHOWFILESTATS does give me this information , but it is not documented in BOL, i would prefer not to use an undocumented command to ensure future use in later versions. Is DBCC SHOWFILESTATS an undocumented T-SQL command If so what documented t-sql command will provide me with this information I could query system table's and work this out , but as mentioned this may not not work in future versions of SS. Thanx ...Show All

• Visual Studio 2008 (Pre-release) XAML Custom Classes & Collection Properties

  I am trying to define a custom class (hierarchy) to be used in XAML. I've just started with the root of my class hiearchy, and I'm running into problems. I'm not sure if I'm doing this the right away, so let me provide a bit of context. My root class inherits from ModelVisual3D (as well as my own interfaces), since it is meant to be inserted under a Viewport3D in a XAML file. I do nothing with UserControl. That didn't seem to accomplish what I wanted (i.e., add my root object in various place in a XAML 3D scene hiearchy), but I may be wrong. Anyway, I ran into problems when trying to add a collection property. My collection is based on KeyedCollection<>. It's exposed as a read-only property of my root object. However, the ...Show All

• Visual Studio 2008 (Pre-release) Gnarly design problem - how to identify all controls in an application (typically before they are ever loaded/displayed)

  So theys wants me to design and implement and application wide validation system for a rather complex set of interdependent properties. Obviously this will be easier in WPF than in Win32, but still rather complicated. The why is too much to get into here, but basically I need to be able to predetermine all of the data bound UI controls in an applicaiton. Even those that have not yet been displayed. Do I have the ability (at run time - app load) to extract all the UI pages and parse them to figure out what controls exist in the app I also need to identify the containing UI element (as perceived by the user). For what its worth, all the controls that I am interested in will be mapped to ObjectDataProviders that I implement. Howe ...Show All

• Visual Studio Express Editions Richtextbox: changing string(s) into pictures

  Hi Is it possible to change a word (string) into a picture (I know it's possible to change a certain string into another string with the replace command.) (for exemple: the use of emoticons. when entering a certain string that changes into the corresponding emoticon.) If this is possible, how do I need to do this. Thanks in advance. Shoot, didn't think that the forum bug was going to mess up my post. Giggle. The lamp icon in the post replaces "[ i ]" (without the spaces). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problems with Microsoft.DirectX SDK versions

  Hi, I'm trying to do the Coding4Fun Game Devlopment tutorial, but I can't seem to get it to work. I first tried it with the latest DirectX SDK (june 2006). But when I add the references to Mircosoft.DirectX and Microsoft.DirectX.Direct3D the Direct3D is version 1.0.2902.0 and the DirectX is version 2.0.0.0 This results in this error: The type 'Microsoft.DirectX.Direct3D.Device' exists in both 'c:\WINDOWS\Microsoft.NET\DirectX for Managed Code\1.0.2902.0\Microsoft.DirectX.Direct3D.dll' and 'c:\WINDOWS\Microsoft.NET\DirectX for Managed Code\2.0.0.0_x86\Microsoft.DirectX.dll Why is the Mircrosoft.DirectX.Direct3D dll a different version then the Microsoft.DirectX dll I would expect to get the latest version of both in the SDK... ...Show All

• Visual Studio Team System Extending Work Items - Bug Tracking

  One issue with the Team system bug tracking is that I cannot seem to see how testers, using Team Explorer, can simply paste screen shots into an issue. Instead they have to save the file manually and then add an attachment. Am I maybe missing something here Has anyone got a suggestion as to how I can get around this issue Thanks, There's nothing built into v1 that does this. James Manning has posted an add-in that does this. See http://blogs.msdn.com/jmanning/archive/2006/07/04/655757.aspx . Buck ...Show All

• Windows Forms Sort columns in datagridview

  Hi all. Does anyone know how to sort the order of columns in a datagridview. My datagridview is using a datatable as datasource. This datatable contains columns "A","B","C","D". I want my datagrid to display the columns in another order. I Want column1 = "B", column2 = "C", column3 = "A". Anyone Lars Same result if i specify displayindex or not. columnorder in the dataset/datatable is "cp-contr1,cp-contline,cp-proddesc,cp-prodid,cp-prodtype,cp-serialnr" Display when running the program is "cp-prodid,cp-serialnr,cp-proddesc,cp-prodtype". As you can see it's a mixture of both datatable column order and the build order. ...Show All

• Visual Basic Progressbar apperars so late in visual basic Activex...!

  Hi, I made an activex (with visual basic 6.0), that downloads a file to client..I converted cab file with package&deployment wizard, and signed it.. There is an progressbar on the usercontrol(activex control form).. and set the progressbar value appropriate value while downloading.. I use these lines: ------------------------------ Do DoEvents bData = InetDwn.GetChunk(CHUNK, icByteArray) DoEvents If i Mod (downloading_file_all_size / 10) = 0 Then ' I used this line to increase progressbar value every 10 percent 'downloaded DoEvents DoEvents ProgressBar1.Value = ProgressBar1.Value + 1 DoEvents DoEvents i = 0 DoEvents DoEvents End If DoEvents DoEvents Put #intfile, , bData i = i + 1 Loop While UBound(bData, 1) > 0 -------------------- ...Show All

• .NET Development Failed to get schema for this query

  Using Visual Studio 2005 c# I have made a small program that connects to one of my databases and is supposed to update 1 of the columns. I start to go through creating a query and can execute it in the query builder. Now when i click ok to make the query it gives me an error. "Failed to get schema for this query." At this point it wont let me go any further and cannot finish the query. Any help would be appreciated. Nick try manually creating the query instead of using the wizard...SOund like the wizard is having a problem with the column you changed...Just a WAG! ...Show All

• Visual Studio Express Editions Fatal error C1083: Cannot open include file: 'windows.h': No such file or directory

  When I try to compile a win32 sample program, I get the 'fatal error C1083: Cannot open include file: 'windows.h': No such file or directory' error. I have installed and configured (even the step not in video) the most recent Platform SDK, but I still get this error! What is happening Thanks! Sorry for the late reply. My install directory is: C:\Program Files\Microsoft Platform SDK These are the include setting of the IDE: $(VCInstallDir)include $(VCInstallDir)PlatformSDK\include $(FrameworkSDKDir)include I hope this helps. ...Show All

• Visual Studio 2008 (Pre-release) CanExecute handler is called, Executed handler is not called

  XAML: <MenuItem Header="Rotation">   <MenuItem Header="0°" Name="menuRotation0" IsCheckable="True" IsChecked="True" />   <MenuItem Header="90°" Name="menuRotation90" IsCheckable="True" />   <MenuItem Header="180°" Name="menuRotation180" IsCheckable="True" />   <MenuItem Header="270°" Name="menuRotation270" IsCheckable="True" /> </MenuItem> Code: // Class members: public static RoutedCommand CommandRotation0 = new RoutedCommand(); public static RoutedCommand CommandRotation90 = new RoutedCommand(); public static RoutedCommand CommandRotation180 = new RoutedCommand(); public static RoutedCommand CommandRotation270 = new RoutedCommand(); // Constructor: menuRotation0.Command = C ...Show All

• .NET Development the age old problem of "the root element is missing"

  I've done a lot of searching for how to fix this error, and I can't find what's different between everything else and my code. Basically what I'm doing is connecting to a bizTalk .asp service, and its being sent fine, and is recieved fine. It uses streams to get back and forth, and if I were to write it out to a string, it works fine. If I pass the same stream into the constructor of another class that parses the stream to xml, it gives the error. Heres the code: Encoding encoding = new UTF8Encoding (); byte [] data = encoding.GetBytes(request); // Prepare web request... HttpWebRequest myRequest = ( HttpWebRequest ) WebRequest .Create( this .path); // connect to mustang WebResponse response; // POSTed response myRequest.Me ...Show All

• Community Chat what ya think

  ok guys I have tried everything to publish my new web browser on to my site.... thanks spotty for all your help.... much appreciated.... I think my isp is not configured for click once.... I have clicked a thousand times to no avail....... so I am wondering if there is some other way to post my application... I would like to put my app on show and tell and get some feedback... any advice on how to do this thanks cheyenne Zip up your package and post the URL under the show and tell forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=991&SiteID=1 ...Show All

• Visual Studio Team System Versioning and multi-site deployments

  Hi, We have an asp.net web-based product which we will eventually be deploying to different web servers at our various client locations. Each of our clients eventually will need customizations\enhancements which will have to be developed, tested and deployed specifically to each client's webserver. My question is how do we handle versioning for this in TFS for our asp.net solution Scenario1: Split the source code out, with a separate branch for each client. This would be cumbersome from a maintenance point of view, due to extra effort of syncing common changes across all branches. Scenario2: Have a main branch which has the common source for all clients. Have client-specific folders where enhancements for each client are versi ...Show All

• SQL Server Loading data from xml

  I have an xml file I want to use as the source. It's not overly complicated, but not simple either. It has one hierachy, and one optional field and looks like this a 1 'text' 2 'text' b 1 'text' 2 'text' 'optional field' Ok, now I want the data to load like this: a,1,text a,2,text b,1,text b,2,text, optional field but when I try to use the xml source it won't create the xsd...anything I can do For some reason this post is currupt below the xml. The first column is missing it should read etc I want the database records to be: 1,1,1 1,2,alfretta 1,2,1.6 1,29,2.8-3.4 1,131,1-3-4-2,75175 ...Show All