Chris Aus's Q&A profile

• SQL Server Reporting Services XML documents - no default namespace prefix - sp_xml_preparedocument requires one

  We have a process to verify Reporting Services report content: Run report and create an XML output file Import XML into SQL Server 2005 via OPENROWSET function Parse XML content using sp_xml_preparedocument and OPENXML to allow values to be inserted into corresponding tables The sp_xml_preparedocument function requires a prefix to exist for each namespace. However, XML files created via Reporting Services export option do not give a prefix for the default namespace. This prevents the data from being parsed. Does anyone know of a way around this For the time being we are manually inserting a prefix for the default namespace into the XML files. Thanks Neil Thanks for the suggestion ...Show All

• Visual C# Why can't an interface method be internal?

  When I try to make a method in an interface internal I get a compile error.  Why is this   Thanks in advance, Per Rasmussen. A interface is an outward presentation of a particular implementation. If you want to mandate a particular implementation abstract classes are a means of doing this. An internal, private, or protected class can still implement an interface and while the implementation of those interface members must be public, use of the class would be restricted to internal, private or protected usage (where private and protected apply only to nested classes). ...Show All

• Visual Basic Inserting Text into PictureBox Control at Run Time

  Is it possible to programmatically insert text into a PictureBox control in VB 2005 In VB 6 the Print method was available but it is not available in VB 2005. I suspect there is some way to do it but I don't know how. Of course I would also like to be able to set the coordinates of where the text starts and set the font/size/color of the text. Thanks for any help. In the PicturesBoxes' paint event do this, note below used a panel... Dim text As String = "abc" Dim layoutRect As RectangleF = New RectangleF(0, 0, Panel1.ClientRectangle.Width, Panel1.ClientRectangle.Height) ' Turn off auto wrapping Using sFormat As New StringFormat(StringFormatFlags.NoWrap)     e.Graphics.DrawStr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed DirectX Deployment issues.

  What is the correct procedure for deploying a .NET 2.0 application using Managed DX 1.1 I'm having trouble running my application on another computer, using MDX. I found this about the boot strapper. It looks interesting, but the link is to the Visual Studio 2003 bootstrapper, even though the page title is Visual Studio 2005. http://msdn.microsoft.com/vstudio/downloads/tools/bootstrapper/ Does this exist somewhere It sounds like a useful tool. I have installed .NET 2.0, DirectX 9.0c, and (what I think are) the required redistributable files as described in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=440279&SiteID=1 However, the application gives an exception when it starts up. The dialog box does not provide a ...Show All

• Customer Care Framework 2 Compatibility Questions

  Can we install all CCF compnents on one machine including the domain controller Do we have any compaitibilty problems if we apply the above scenarion using Windows Server 2003 R2 Standard Edition ...Show All

• Visual Studio 2008 (Pre-release) How can I bind to member classes of a class

  I want to encapsulate all the data binding, validation, conversion, etc. objects for a piece of data under a single class, then reference these child objects as needed in XAML. For Example: I can implement a collection like this *** public class MyModes : ObservableCollection<string> { public MyModes() { Add("Mode One"); Add("Mode Two"); } } And bind it to a combo box, like this <Grid.Resources> <ObjectDataProvider x:Key="Modes" ObjectType="{x:Type src:MyModes}"/> </Grid.Resources> .... ItemsSource="{Binding Source={StaticResource Modes}}" IsSynchronizedWithCurrentItem="true"> *** ...Show All

• Visual Basic VB.net how to do a dowhile loop for datatable

  Dim dRow As DataRow For Each dRow In Employee.Rows If (dRow("NumberKey") = "1756") Then "blahblahblahblah" End If Next the point is that i have to scan through all the rows in the Employee datatable to look for one numberkey. It is not very effecient I want do to do a loop that will stop right after i am able to match the numberkey with the number i m trying to find. can someone help me.. it is sorta of like a do while loop in C++, but this is for a datatable Sounds like you need to do a little reading on SQL. The SQL Statement is probably going to look something like. SELECT ID, NameField FROM Table1 INNER JOIN Table ...Show All

• SQL Server Complex Transformations (SSIS components vs TSQL)

  Greetings SSIS friends, I have been attempting to implement one of our numerous ETL processes in SSIS but hit a brick wall when I tried replacing a complex stored procedure with a series of Merge Join components. In the end, I had to settle with using a SQL task which merely calls the stored procedure and this proved to be the better option as the other version where I used SSIS components only took forever to run. How do people cope with complex transformations ! Do you guys opt for pure TSQL to perform complex transformations and use SSIS components for control flow+simple(ish) data flow tasks I am confused. dreameR.78 wrote: Yes it has speeded up considerably although I still think I can shave a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mathematics for Game Programmers Book

  I've been developing games for a few years now but I've always been aware that my maths skills are less than I would like. So, I'm wanting to buy a mathematics for game programmers book and was wondering if anyone could recommend a decent one I'm not a maths whizz by any means. In fact, I used to have a fair bit of trouble with maths at school so I'm not looking for anything too hardcore. Just something to start with :) Mathworld is a great resource, but it's no help in actually learning what you need to know for game development. These books cover relevant topics and at minimum explain how these maths are applicable to games and graphics, often times demonstrating with an implementation. Mathworld is fa ...Show All

• Visual Studio Reporting Services - dynamically resize a chart

  I am doing a report in SQL Server Reporting Services 2k5 , the report has a chart that displays data from a query. The question is: Is possible to dynamically resize the area occupied by the chart depending on the amount of information (variations of a category) to be displayed on it Hi, Questions about specific products are best posted to the product forums so they can be answered by the product teams. For Reporting Services, if you are using the ReportViewer controls, use this one: http://forums.microsoft.com/msdn/showforum.aspx forumid=75&siteid=1 For the SQL Server Reporting Services, use this one: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=82&SiteID=1 T ...Show All

• Visual Studio 2008 (Pre-release) Kevin moore OneMonthCalendar

  hi there, I'm trying to use the OneMonthCalendar example from Kevin Moore - "Kevin's Bag-O-Tricks " at http://wpf.netfx3.com/files/folders/controls/entry7094.aspx. There is an example under the OneMonthCalendar Folder, but I just can't manage to make it work.. did any1 try it / thank you ...Show All

• .NET Development "Not enough storage to complete operation" Exception

  Hi, I am using the Excel object from Microsoft Excel 11.0 Object Library version 1.5 to export data to Excel. I received the error "Not enough storage to complete operation". Below is my source code. The error is thrown by the line "excel.Cells[rowIndex + 1, ColumnIndex] = row[col.ColumnName].ToString();" Does anyone know the potential causes and possible fixes Thanks Excel.ApplicationClass excel = new Excel.ApplicationClass(); excel.Application.Workbooks.Add(true); Excel.Worksheet ws = (Excel.Worksheet)excel.ActiveSheet; ws.Activate(); int ColumnIndex = 0; foreach (DataColumn col in data.Columns) { ColumnIndex++; excel.Cells[1, ColumnIndex] = col.ColumnName; } int rowIndex = 0; foreach (DataRow row in data.Rows) { row ...Show All

• Visual FoxPro Syntax Difference

  can some one please tell me the difference between accessing a tables info by using these two different approaches Table.Field or Table->Field thanks in advance They're same. Table->field style is less known (maybe only by those who are coming from foxbase days) and not used. It is dereferencing pointer coming from C (old fox was using Watcom C as I remember.) ...Show All

• Visual Studio 2008 (Pre-release) Selection_Moved Event of InkCanvas

  hi friends, I am storing the Strokes selected by the user in the SelectionChanged event of Inkcanvas. I am storing another stroke collection to store the strokes of the selected object in the SelectionMoving event of the InkCanvas. But what I observe is that stroke stored in the SelectionChanged have been changed. The X and Y cordinates of the stroke have been changed. I am posting the code :   void inkcanvas1_SelectionMoved(object sender, EventArgs e)         {             newCollection = inkcanvas1.GetSelectedStrokes();         }   void inkcanvas1_SelectionChanged(object sender, EventArgs e)   & ...Show All

• Software Development for Windows Vista Extracting ISO from CD-ROM

  Hello All, Is extracting an ISO image from a data CD-ROM within the scope of the IMAPI APIs If so, where can I obtain the applicable documentation If not, can anyone offer some advice as to which direction I should go next Thanks, - Scott Hello Scott! Extracting an ISO image is not specifically within the scope of the IMAPIv2 API, meaning we do not provide a high level function call that wraps some method and provides this functionality.  However, our interface is very open-ended and the IDiscRecorder2Ex's SendCommand* APIs allow you to send arbitrary MMC commands (CDBs) down to the device.  You could use IDiscRecorder2Ex::SendCommandGetDataFromDevice to send READ10 CDBs to the de ...Show All