keithpsft's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. XNA doomed?

  XNA may be the greatest thing since sliced bread, but I don't see it getting a lot of support until you make a simple web page that explains what features the XNA framework supports and why I would want to use it. I'm not going to download the thing just to figure out what it is. You might also check the FAQ . I've seen videos of XNA being talked about on major news networks, there's an XNA GSE ad in one of my son's issues of Boy's Life, it's been talked about in gaming magazines... It's far from doomed. Once the Dream-Build-Play competition gets into swing (hint, hint guys! ) it's going to explode I think. ...Show All

• .NET Development VB OdbcCommand.ExecuteNonQuery not returning -1 for DDL SQL stmts

  I am trying to use the OdbcCommand.ExecuteNonQuery method to execute DDLs and DMLs. The documentation says that -1 should be returned for DDL SQL stmts, but it returns 0 for DDL stmsts like CREATE/DROP TABLE. Is this a bug or am I doing something wrong gReadLine = txtSQL.Text cmd = New Odbc.OdbcCommand(gReadLine, cnx) cmd.CommandType = CommandType.Text gNumRows = cmd.ExecuteNonQuery() If gNumRows >= 0 Then lbOutput.Items.Add( "Number of Rows Affected : " & gNumRows) Else lbOutput.Items.Add( "SQL Operation Succeeded" ) End If Thanks in advance. ...Show All

• SQL Server One to Many Cube Relationship

  Hello everyone, I'm new to the cube environment and I would appreciate some guidance. My data structure has 2 fact tables, account and household, where one household can have one or many accounts. Each fact table has 3 or 4 dimensions attached. I need to create a cube that contains information from both cubes. For example, a count of households, a count of accounts, a total balance of households, and a total balance of accounts. I tried using linked measures and dimensions but they don't seem to be behaving the way I'd like. When I slice the data by an account related dimension, the account balance and count is correct, but the household balance and count is the same for all cells, and visa versa. How can I get this running correctly ...Show All

• Visual C++ C++ console app: best approach to sql two different dbs?

  Hello, Type of project: Database Support Separate from the User Interface An application that processes data without user intervention, such as an application that moves data from one database format to another, or one that does calculations and performs batch updates. Environment MSCV++ 6.0 console modules We are implementing selects, deletes and updates using DSN + CDatabase Class, and ExecuteSQL, like this: CDatabase db; LPCTSTR pszConnectString = _T("DSN=PDOX10;AUT=1;CT=7;DQ=0;FOC=0;IS=1;PW=myPassword;USF=1;ULQ=1"); if(!db.OpenEx(pszConnectString)) { AfxMessageBox(_T("Could not open database")); return 2; }//............................ //DELETE TRY { sql[0]=NULL; strcat(sq ...Show All

• Windows Forms Use Same DataSet and Connection Across Forms

  I know this is an obvious and dumb question but I can't seem to locate the answer elsewhere. How can I call and utilize the same .xsd and database connection across multiple forms Is there an article on this I've tried creating a data access layer and using the app.config with no success. Thanks, cj ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2D Movement based on Rotation

  Hi I'm looking for a simple way to do X, Y movement based on the angle of rotation. So if my object is facing the north-east, pressing up will move the object along the X/Y axis in that direction. Thanks x += Math.Cos(angle) * speed; y += Math.Sin(angle) * speed; where angle is in radians (1 lap = 2*PI). Regret sleeping through trig :) ...Show All

• Visual C++ Porting from 2005 Express Edition Beta 2 to Professional Edition

  I am using Visual C++ 2005 Express Edition Beta 2. What should I do to port my code to Visual C++ 2005 Professional Edition Hello, I'm having issues porting a C++ express beta project to Visual Studio 2005 standard edition. I haven't seen a guide to porting from the Beta - Is there one Here are just a couple of the first errors encountered: using namespace stdcli::language; Error 1 error C2653: 'stdcli' : is not a class or namespace name void Dispose(Boolean disposing) (This is generated code form a form class - public ref class Form1 : public System::Windows::Forms::Form ) Error 7 error C2605: 'Dispose' : this method is reserved within a managed class And the list goes on ... Any help is ap ...Show All

• Visual Basic Program to execute on one machine only

  Hello, My problem is that I want to deploy my program onto a 'thumb drive' and sell it that way and I need the program to only run off that drive. It is a small program that can easily be copied and run by anyone so I thought that if I could somehow 'lock' it to the small USB drive then that would solve my problem. Because some games require a CD to be in a drive before they will run I figured that that would be something that I could do, my problem is finding any help in how that might be accomplished. Can anyone point me in the right direction Thank you very much Bill Langston Hmm, now this is interesting. I don't want to clutter this forum up with usless posts with this one being premature but it will take me a b ...Show All

• SQL Server Parameters in data flow task with Oracle database source

  In many DTS packages I have used parameterised queries for incremental loads from Oracle database sources using the Microsoft ODBC Driver for Oracle. Now I want to migrate these packages to SSIS, but the OLE DB connection for Oracle does not support parameters. I cannot use the "SQL command from variable" data access mode because of the 4000 character limitation on the length of string variables and expressions. Am I missing an obvious workaround Thanks Donald That sounds like a good option. I understand that you mean we should use a Script Component as the Source in the Data Flow. The script will make the connection and build and run the required query. Nice!   ...Show All

• Windows Forms Automatic scrolling in Datagrid view

  Hi I'm developing application in windows forms . and I'm using a datagridview control in my form. I'm filling it with data. I'm running a thread in the application which will modify the content (ex Status) of the Grid. I want to scroll the datagrid automatically, depends upon updation. Thank u Thanks Gavin But I'm not adding at run time I'm modifying already filled rows. while modifying in other thread, it should automatically scrollled. Thanks in advance ...Show All

• SQL Server Export an already rendered report with webservice not using reportviewer

  How do I export a rendered html report using webservice to other formats If I render the report again to other formats, the data in the report might have changed since the first execution. Hi, I don’t know if I got you right at this point, so just for clarification: You already rendered a report and it is present as HTML files and images on your disk. Now you want to take this HTML file and put it in a rendering machine to get something else than HTML, like pdf, etc Not his is not possible, what you can do is to import the data in an Excel file (if the data is structured like in a table) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Architecture Question regarding the CSLA framework

  I'm currently in the beggining stages of designing an application around the CLSA framework. Before i go too far i would like to know if anyone has used this framework successfully in any mid to large size applications If not, what went wrong I like the way the framework is layed out but its a big investment in time and money (work hours). Any help would be appreciated. I had Rocky's book (highly recommended) and have reviewed the CLSA.NET framework, but I have never used it in a production environment. I have used a custom port of the CSTemplates ( http://cstemplates.sourceforge.net ) framework for the past year or two. It has worked extremely well in both very large and small systems. The good thing about working with a framewo ...Show All

• .NET Development Is there a way to redirect assembly version for individual servicedcomponents?

  hi, Can I redirect to different assembly versions of an assembly for individual .NET servicedcomponents I have few com+ services running but each service should bind to a different version of same assembly at run time. how can i achieve this I see, I can specify application specific configuration at only "dllhost.exe.config" which will apply to all the Enterprise services. can anyone help me here Similar questions have been answered before. For example http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=741214&SiteID=1 ...Show All

• Visual C# How to catch Exception that throw by timer

  I have a WinForm application and a timer inside. The timer will throw an Exception while event Elapsed. How can I catch this Exception in WinForm Umm, I don't get it; that try is never going to catch anything. You need try/catch in the Timer_Elapsed() code... ...Show All

• Visual FoxPro SQL Server Express & Foxpro-populating SS from Foxpro

  I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastname) values ("Kareen","Abdul-Jabar")'. If I use: lcStr = ['INSERT INTO SAUTHORS (firstname,lastname) values ("] + m.firstname + [","] + m.lastname + [")'] lnResult= SQLEXEC (m.lnConn, m.lcStr) I get an error that says Invalid Syntax. Can someone steer me in the right direction I want ...Show All