SPWilkinson's Q&A profile

• SQL Server can calculation be defined in SQL Server Management Studio?

  hi!can somenboby hlep me,i want to know that can calculations be defined in SQL Server Management Studio And how to do it Thank you very much! Calculations are added to a new or existing cube using "Business Intelligence Development Studion" (BIDS). You could generate the script for a cube and then add the calculation by hand, but it is much easier to do using BIDS. If you simply want to create and test a calculation using SQL Server Management Studio you can add a query scoped member using a WITH clause in the MDX editor. Here is a simple example that can be run against Adventure Works: WITH MEMBER Measures.[Internet Sales x 2] AS [Measures].[Internet Sales Amount] * 2 SELECT {[Measures].[Internet Sal ...Show All

• Visual Studio Express Editions media time calculation

  Hi need the maths calculation for this: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If OpenFileDialog1.ShowDialog Then mplayer1.URL = OpenFileDialog1.FileName Timer1.Enabled = True Private Sub Timer1_Tick( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Label1.Text = mplayer1.currentMedia.duration But It displays the length as 345.232 for example. how would I format this as 3:00 for example As has been suggested, using the durationString property would seem to be the easiest way to get duration in the form of a string representing hours, minu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed C# performance loss.

  I caught some people quoting managed performance loss at only 2% (over unmanaged). I am just curious how accurate that assessment is. Last time I was looking into it, DX programmers were quoting 90% of managed performance as a BEST case scenario. (usually much lower) If the margin has grown so low, is there any large scale games developed using C# Oh gosh!!! One more topic about the same thing. Guys please...don't give answers to someone who don't really want catch an answer. Managed code can be even faster... as framework is recompiling project at first run to meet the requirements. Don't really sure that. is working with our loved XNA. Zbuffer.com also already showed that managed code is the fut ...Show All

• Visual FoxPro Converting a DAT file into a BDF file

  Hello all I am trying to import a file into FoxPro, it has a DAT extension, is there any way I can convert this to a DBF file Thanks Hello My trouble is that I do not have a data layout of the file. It was a COBOL program that created the file. Thanks ...Show All

• Visual Basic Run-time error '53' : File not found

  Hello. I don't know if this is the right place to post this error but I really need help. When I run some games programmed with Visual Basic, I get the following error: Run-time error '53': File not found I am running Windows ME (I wonder if that can help). If anyone could help me, I would be really grateful. Thanks. Regards, PedroMCN If the error actually specifies the file, you can try looking for it on your instalation media. Otherwise, I'd try reinstalling the game, it sounds like something failed on setup. ...Show All

• .NET Development Null Values

  The following code executes a Select query almost flawlessly. There are some records in qrySecurityPricesWithSymbols where VixOpn, VixHigh, Vixlow, VixClse contain null values. When this query is executed, those records are excluded. How do I get them to be included strSqlRead = "SELECT Date, Opn, High, Low, Clse, VixOpn, VixHigh, VixLow, VixClse FROM qrySecurityPricesWithSymbols WHERE (((qrySecurityPricesWithSymbols.SecuritySymbol)=" & Chr(34) & txtSymbol.Text & Chr(34) & "))" objCommandRead.CommandText = strSqlRead objReader = objCommandRead.ExecuteReader() Is that your complete SQL I don't see anything in the statement that would exclude rows wh ...Show All

• Visual Studio Express Editions Deployment of windows application with Microsoft Visual Basic 2005 Express Edition

  Does Microsoft Visual Basic 2005 Express Edition provide Deployment of windows application using Setup Project If it doesn’t, then Please tell me whether we can create a deployment kit of a windows application using Microsoft Visual Basic 2005 Express Edition. Is there SDK available for this functionality which is available to the full version. Thanks, Nitin The Express editions provide ClickOnce installation, and don't come with Setup Projects. You can either: Use ClickOnce deployment (quick and easy, especially for simple applications) Upgrade to Visual Studio, which contain the setup projects Use a third-party installation tool (useul for complex installations, and ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Recommendations for physics

  Hi, I know XNA doesn't include physics. Does anyone know of a good C# physics engine If there isn't a C# one around, how about a C++ or Java open source one that can be ported... Thanks, T Thanks for the tip about TorqueX. I'm having a look at it at the moment. It seems ok, but is quite limited at the moment: no 3D. I still think a port of a good open source physics package would be of benefit to the XNA community. I'll look into it more in 2007. T ...Show All

• .NET Development Deleting file from fileserver

  I would like to be able to delete a file from a file server. I have code to do it for an ftp server, but u nfor tunately applying this code to files on a file server does not work since the following does not exist: FileWebRequest request = ( FileWebRequest ) WebRequest .Create(serverUri); request.Method = WebRequestMethods . File .DeleteFile; I also have a way to make a temporary z drive and work with code that basically inputs into a command window. The problem here is I am not sure what the command line is to delete a file. Also, the file server will be protected by a username and password, so I need to take that into account. Does anyone know the best way to go about deleting a file from a file server If you leave ...Show All

• Visual Studio 2008 (Pre-release) DataTemplate vs. ControlTemplate

  Hello, I'm not so sure that I understand the difference between a DataTemplate and ControlTemplate. I realize that the DataTemplate renders a 'type' of data. But then why is ColumnHeaderTemplate defined using a DataTemplate resource Thanks Houman here is one from the samples http://windowssdk.msdn.microsoft.com/en-us/library/ms771489.aspx ...Show All

• .NET Development Remoting sink configuration problems

  OK, I have a Remoting server/client program and I am porting the server side of the app to be a Windows service. Unfortunately, Visual Studio stubbornly refuses to ensure that the Remoting .config file ends up where it needs to be and the server fails. I need to move my Remoting configuration code back inside my program so that I am not dependent upon an external file but have been unable to get my sinks properly configured in code. Unfortunately, Rammer's Advanced .NET Remoting seems to be obsessed with using the .config files and I have been unable to find any good examples of how to hook up multiple channels in code. The commented line in my code below is where the error is coming from: Error 16 Cannot implicitly convert type 'Sys ...Show All

• Windows Forms docking problem in panels/split containers

  I have put a text box and a datagridview control in one panel of a split container. The text box is docked to the top, because it is the title bar for the datagridview. The datagridview is anchored to the bottom and right. The problem is when the form is resized, the top of the datagridview moves away from or into the text box (depending on the sizing direction. but if I set it to Fill, the label covers up the column headings of the datagrid. Is there a way to anchor the top of the datagridview control to the bottom of the text box If not, how to deal with this situation "The datagridview is anchored to the bottom and right" You need to anchor the data grid view from all sides, top ...Show All

• .NET Development Update without Parameter

  Hi, Is it possible to write an update in ADO.NET without deffining my update with parameters In ADO we use to be able to create a connection edit the field and called the the ado1.recordset.update function. It's a lot of codes to update a database. Thanks. Do you still have to use the update query with a SqlConnection like OledbConnection That's were I find that it's a lot of codes declaring fields, type, etc... Thanks again. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .X 3d Mesh Applications?

  I am looking for an application that I can used to create the 3d Mesh Files. Does anyone have anything they use Free is best, else low cost. Milkshape is excellent and cheap. http://www.swissquake.ch/chumbalum-soft/ We are using it for our game. ( http://www.robotechmmo.com ) We had to write our own tool to split the single track animations into multiple tracks, but that was pretty easy.   ...Show All

• .NET Development System.UnauthorizedAccessException when creating registry keys - Please help

  Hi, I am trying to write into the registry from my application and I get the below exception: System.UnauthorizedAccessException was unhandled Message="Cannot write to the registry key." Source="mscorlib" StackTrace: at System.ThrowHelper.ThrowUnauthorizedAccessException(ExceptionResource resource) at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity) at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey) at ReadFileNames.Form1.Form1_Load(Object sender, EventArgs e) in D:\Bancassurance\OFX Specs\OFX2.1.1\ReadFileNames\Form1.cs:line 35 at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms. ...Show All