Thomas Belser's Q&A profile

• SQL Server AdventureWorks\AdventureWorksDW question

  I thought that all data in AdventureWorksDW came from the OLTP AdventureWorks database. But....then I looked at DimTime table in "DW". I doubt that level of detail exists in the OLTP database. Is it common to add new data and fields to the OLAP side that didn't exist in the OLTP side Pup Dear barkingpup, Can you plz give more details about you question OLAP create time dimension based on the_date column of time dimension table, you have to select which time heirarchy you want. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Distorted texture after lost/reset device

  Hi, I'm drawing a textured mesh using DrawIndexedPrimitive, using an effect interface. After a windowed/full screen toggle the texture appears distorted. Interestingly when I draw another mesh in wireframe mode in the same render call the problem doesn't occur. Can somebody help Nico I just dumped the tex coords before rendering the mesh with the undistorted texture and than before rendering the distorted version. They are identical. But interesting is the result of your second suggestion: to use the tex coords as color values in the pixel shader reveals that the tex coords in the undistorted render cal ...Show All

• Visual Studio Team System Update Check In Comment

  I would like to update a check-in comment for a source code file that I checked into TFS version control. Is this supported If so, what tool should I use UI: rightclick the item, History. Doubleclick the relevant changeset in the History toolwindow Cmd line: tf changeset XXX brings up the same dialog. ...Show All

• Visual Studio Express Editions How to INSERT into a Access DB with C# 2005 Express edition?

  Now I've blowed all my fuses! For two days I've been looking for after information how to use the INSERT query in Visual C# 2005 Express (VC#05Expr) without actually finding it - not even at Microsoft's sites. I just want to see a simple code example, or a "How to do", to insert the data from two variables into one table Access database with two attributes (columns). I tried to write the code as I've been doing in VS.NET 2003, but that doesn't work in VC#05Expr, no former ADO seems to work in VC#05Exprs, instead there're lots of wizards for connecting the DB, Datasets, etc - but nothing how to get the data in two variables into the DB when ...Show All

• .NET Development Recursive searches with Regex Class.

  Hi! How can I do recursive searches with the Regex class. I know the Sample with the matching Parantheses ()*, but I need it with BEGIN/END blocks e.g. some text begin    more text    begin       even more text    end end second part begin    text end So the expression should match the outermost begin/end blocks. How can this be done *) \(     ( >         [^()]+         |    \( ( <number>)         |& ...Show All

• Windows Forms Error when trying to access Form components

  Hi, I am developing an windows application in C#. I have encountered problems when trying to access the form and the controls from the code. I get the error message: 'FactoryMethod.Form1.rtbCodeBody' denotes a 'field' where a 'class' was expected I don't know what I am doing wrong. Most of the code is created by Visual Studio.NET. The code from my Form1.cs  ...Show All

• SQL Server Selecting maximum from a varchar field in a data flow

  I have a problem selecting maximum values inside a data flow, when the field is varchar. For example, I could have an incoming text file with following rows (the real life problem is a bit more complicated, but the idea is the same) ID Desc 1 Car 1 Truck 1 Bicycle 2 Horse 2 Cow Now I would like to group by ID, and have the maximum value from the Desc field, resulting ID Desc 1 Truck 2 Horse I tried to sort the data flow first with ID ascending and Desc descending, followed by sort with ID ascending and "Remove duplicate sort values" turned on. However, the sort does not seem to select the first Desc value it ge ...Show All

• SQL Server SSRS on SQL Server 2005 Express

  Hi there, I'm working on a scenario where a number of smartclients at distributed locations will connect to a central reporting services server. We are replicating data onto a SQL Express machine (on Windows XP) at each distributed location, and are hoping to migrate some of the day-to-day reporting onto Express at a later stage when it supports SSRS. I have a number of questions requiring some clarification to make sure this will be feasible: Will the Express edition support personalized reports and the 'My Reports' folder in Report Manager per user Will users be able to upload reports onto the Express SSRS which they have desig ...Show All

• Windows Forms Binding DataGridView to XML node or document

  I've spent some time looking into this, but I cannot seem to find a way to bind a DataGridView (or a DataSet for that matter) to an XmlNode or XmlDocument. I don't have access to the xml file, I get the XML from another method call so DataSet.ReadXml() seems useless for me. It seems like there should be an easy way to do something this simple. Anyone know how to do this TIA,  DarrelC The DataGridView only support databinding to a flat structure such as a DataTable in a DataSet. I don't know enough about data tables and ADO stuff, but you should be able to read XML into a DataTable somehow. I've used ...Show All

• Visual Studio Express Editions Free Ebooks in Express Editions - How to get them?

  hello everyone, i just downloaded the ISO version of visual c# 2005 express edition and installed it on my workstation. is there any way for me to avail of the free visual c# ebooks that registered users of the online edition can get thanks and best regards, matt To register, click on "Help" and select "Register Product...".  Then just follow the instructions. Thanks, Scott Currie DDCPX Program Manager Microsoft ...Show All

• Visual Studio Team System Process Template Upload Error On SharePointPortal Task

  We have been modifying and uploading our own process template for three or four months. Today I wanted to make a change, but when I uploaded the template I received the following error when the SharePointPortal task in WssRasks.xml was processed: Exception Type: System.Web.Services.Protocols.SoapException Exception Message: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. SoapException Details: <detail><errorstring xmlns=" http://schemas.microsoft.com/sharepoint/soap/">The Web site that is referenced here is not in the configuration database.</errorstring></detail> Wh ...Show All

• Visual Studio Express Editions Database Creation thru C# IDE

  Why is it that when I right click Data Base Explorer from the C# IDE, the "Create New SQL Server Database" is greyed out I am logged in thru an account with administrative priveledges. I can create a database thru the command line utilities and then attach it via Database Explorer but I can't create the database directly thru the explorer. Go to the solution view and add a new item to the project, from there you should be able to add the new database file. ...Show All

• Visual Studio Team System How to skip a request in a Web test's GetRequestEnumerator method

  Given the style of yield return used in GetRequestEnumerator, can someone give me an example of how I could skip one or more requests if certain conditions are present For example, say I have request1, request2, ..., requestN. After request2 is executed, say there is a value of 2 in Context["skipValue"]. How would I then cause request3 and request4 to be skipped and execution of the iteration to resume with request5 Thanks. Regards, Mountain There are a few ways to do this.  You could just add if statements around the requests which may be skipped that check for the existence of the key ...Show All

• SQL Server Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path

  Hi, I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for m ...Show All

• .NET Development please help..iis 6

  hi everyone, please reply asap if you can help. i'm running windows server 2003 with iis 6.0.  i'm trying to start using asp throughout my website, so i made sure active server pages was allowed.  for testing purposes, i installed iis 6 on my windows xp 64-bit computer.  my pages worked fine.  when i upload them to my 2003 server i get a 500 error telling me there is a problem with the page. the only difference that i notice between my computer and my server is that my computer has an "application pool" folder available in the iis console-the server does not.  did i install something wrong   i'm going cra ...Show All