Andre Odendaal's Q&A profile

• SQL Server Show dimension members only if there is data associated with them

  Hello, Is it possible to set-up dimensions to contain only members that have a match in the fact table I would like the dimensions pull-downs to show only members with data. Thanks, Philippe Nice that you have found a solution but I think that you have only manage to do what a normal TSQL-query can do. Never build a cube when you only want show related records. I have done this for sales staff that would like to see what their customers have bought. Build this directly in Reporting Services and query the datamart with TSQL. Regards Thomas Ivarsson ...Show All

• Windows Forms BindingSource , DataBindings and my own private hell!

  Hi All, Ok so I have finally decided to stop chasing my tail and ask for help! There seems to be a very big gap in my understanding of databinding and the binding source component. For the sake of brevity I will simplify the code I am using merely to get my point across : I have a master-details Dataset exposed to my UI as an object datasource ( the dataset is compiled in a separate assembly ) , I have set up a bindingsource component for each of the tables in the dataset in the form of : Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load ' InvDs is the datset containing the master and detail datatable. iDAdapter.Fill(InvDs.InvoiceDetails) iHAdapter.Fill(InvDs.InvoiceHeader) ...Show All

• Visual Studio Express Editions Best way to write video player

  I need advice on the above matter. 1. DirectX.AudioVideoPlayback The library didn't provide a function/method to clean up the screen. 2. Media Control Interface (MCI): if I set a playlist with 10 video files, when the player play the last video i notice the first image repeat twice. 3. Windows Media Player control I didn't try out this component as most of the forum suggest that the component is not stable when import into program. For my case, the player is most probably play more than 1 video so is not user friendly each time the user need to click the open button to select video files. The video will clean up the screen each time it finish the video. Do anyone know any other best way to solve the above matter. Please advice. Thank ...Show All

• Visual Basic DataTable or DataSet

  I'm trying to create an SQL statement that will return duplicate fields from a Text file that I imported. The imported file is NOT in a Database, but rather in memory. What should I query against, the DataSet or the DataTable Also, how do you create a complex SQL statement and use it against the DataSet/DataTable Looking for something like this: SELECT * FROM myTable WHERE ssn IN(SELECT ssn FROM mytable GROUP BY ssn HAVING COUNT(*) > 1; Any sugguestions would be great!!! I would say a dataset(if this is a window based application, else if its web based, then use datatable). Datasets more flexable, well from my experience at least. Also you can use the select method from a dataset and dataview. Also I believe you can use the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. RAKNET-Converting C++ to C#

  I am in desperate need of networking code, and I found RAKNET. Now RAKNET is built in C++. How can I convert it to C# Any help would be awesome. -Xythe Well you convert code by looking at the C++ version and writing something equivalent in c#. Yes I know thats not a useful response but your question is very high level and vague. Have you even tried to convert it yourself Why convert It won't run on the xbox anyway so why not just make a wrapper and use the code as is. Rewriting that much code will take a long time and you will lose all of the years of testing that went into the native version. ...Show All

• Community Chat MS Dos prompt

  The appearance of my MS Dos prompt has changed normally the cursor flashes at the top left hand corner of the screen but mine has moved to the bottom left corner and slightly off the screen particularly when I select full screen I have looked at the properties and compared with another PC and can't see anything different I would like to revert back to the old way any suggestions would be very much appreciated ReneeC wrote: YaaaaaaaaaaaaaaaY!!!!!!!!! Questions like these are not what these fora are for. ...Show All

• Visual Studio Express Editions Install VB Express application to All Users under Windows XP

  Is there a way to cause an application developed under Visual Basic Express to install for all users on an XP system I am logging onto an XP system, which many people use, as Administrator. I install my application, but when other users logon under their own ID they don't have it available. I also moved the Start Menu folder from my Documents and Settings folder to "All Users," which causes the program group to appear under all user's Start menu; however, the program itself isn't there if they try to use it (program group is empty). The Installer does not appear to have an option to install the program only for you or install for everyone. Any way to force the application to install for all users Thanks ...Show All

• .NET Development App config setting to force 32 bit execution for .Net 2.0 apps

  Hi All, We are using some legacy third party components which only have 32 bit versions of it. We need to force our .Net application to run in 32 bit on x64 environement. We do not want to make changes to build process and we are building as "Any CPU" options. Is there any configuration level setting (Similar to forceRuntime setting) that forces application to run in 32 bit mode Thanks for Help Salim You can run all the applications on an IIS 6.0 server in 32-bit mode. See this URL: http://support.microsoft.com/ id=894435 no need to change anything in your build process but this forces all the applications on your server to run in 32-bit mode. The only side-effect that I have foun ...Show All

• SQL Server Export to XML

  Hi, I have been researching the new features of Server 2005 and its handling of XML; there are some impressive features. I am hoping to design a reusable process for extracting data as XML and am having trouble, I am hoping that someone can help me brainstorm some of my ideas. Conceptually I would like a procedure or service that I can pass a Stored Procedure and any necessary information needed to execute it as well as an XML Schema and have returned an XML stream containing the results of executing the Stored Procedure formatted according to the provided schema. The closest feature to this type of functionality that I have found is the HTML/SOAP Endpoints. But with these I see no way to format the out put to a provided schema ...Show All

• Smart Device Development MD3DM mesh.Intersect

  Hi I am currently developing a project in c# and my focus is on manipulating a mesh of a human body, I need to get the point of intersection on the mesh from a ray using MD3DM. What I will eventually get it to do is highlight the selected area with a colour or image of some sort. From what I understand Mesh.Intersect() would allow this to be possible but this is not available in MD3DM. How do you suggest I go about getting the point of intersection on the mesh using MD3DM I am already using a bounding box, but this is just allowing the user to differentiate between the mesh and other areas of the screen and is not detailed enough for what I am trying to achieve. What would be the best approach I am doing this for my ...Show All

• SQL Server Creating a double entry book keeping system

  Can anyone please tell me how to create a basic double entry book keeping system database using SQL Server or Access. I need to know what tables amd fields I need to create, and what relationships need to be defined. I just need to know the db structure here. Also how should I go about designing the forms ( I use visual Basic 2005 Express and SQL Server 2005 Express, and Access 2002 ), the front end user interface for creating journal entries, how should I display the ledgers, and how do I calculate the totals for the ledgers, because we also need to take into consideration the opening and closing balances as well. I tried a lot using Access, but I could not get a satisfactory result. I first created a account base type table which has ...Show All

• SQL Server Indexes & Statistics

  1) We have SQL Server 2005 database on windows 2003 server. 2) We have CREATE INDEX & CREATE STATISTICS. 3) For indexes, we can query sysindexes. What about statistics Are these objects since there is a CREATE & corresponding DROP. 4) Does creating indexes also create statistics & if so do we have to drop both of them. If we just drop index, will the corresponding left over statistic will have any effect. 5) How do indexes on individual PK, FK & other columns based on observation compare against indexes and statistics suggested by index tuning advisor K. Murli Krishna wrote: 3) For indexes, we can query sysindexes. What about statistics Are these objects since there is a CREATE & ...Show All

• SQL Server Missing SQL Server Management Studio

  Hi, I am a novice at SQl Server, so apologise in advance if you think this is a really stupid question. I have a windows XP laptop with Visual Studio 2005. I installed SQl Server 2005 Developer Edition but do not see the SQl Server Management Studio anywhere. The only thing in Programs/ SQL Server 2005 is SQL Server Configuration Manager. I then uninstalled it & installed SQL Server Express but encountered the same issue. I would like to install the Developer Edition if possible. I have tried uninstalling & reinstalling a few times but it does not work. Could someone please help in resolving this. Appreciate it! If you are still missing the management tools after your new attempt, when you post again, can you be s ...Show All

• SQL Server Unable to connect SSRS to other SQL2000 & SQL2005 servers

  I'm able to build data sources and models through the reporting services web site for the local server that SSRS is installed. When I try to create data sources and models to other SQL Server installations (both 2000 & 2005) I recieve the following error message when trying to create the model: Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get Online Help Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. My connection string reads: Data Source=server01;Initial Catalog=OLTPDatabase I left the connection type as 'Microsoft SQL Server' and I'm using 'Windows Integrated Security'. I'm logged in as domain administrator. Thanks, Doug ...Show All

• Visual Basic Error updating Exchange via web dav from vb

  I am trying to run some VB.net code to update our public contacts folder. I can manually update the contact folder from Outlook or OWA without any problems. However, when I use the same username/password from VB.net to try to update a contact I get an "Access Denied" error. However, I can view the contacts without any problems. Any suggestions would be greatly appreciated. thanks, Luis ...Show All