Hans L's Q&A profile

• Windows Forms Reading datareader using a for loop.

  Dear All, I am reading through a datareader using a while loop. But in the loop in need to do some data processing. So the best is using a for loop. So can anybody suggest to me how to loop through my datareader using a for loop where i=0;i<datareaderlength;i++. I am quite lost thx. You would have to fill a datatable with a data adapter. The datareader does not support what you want to do. String strConn = "Server = .\\SQLEXPRESS;Database = Pubs;Integrated Security = SSPI;"; SqlConnection conn = new SqlConnection(strConn); SqlDataAdapter da = new SqlDataAdapter("Select * from titles", conn); da.Fill(dt); for ( int x = 0; x < dt.Rows.Count; x++ ) { System.D ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Generate random numbers for every class instance

  I'm trying out some AI techniques but I'm having a problem generating a TRULY random number. I create 20 instances of an ant class that should move and change directions on a random basis. They are doing that, but all in unison instead of each changing directions at different times. Its like synchronized ants. Anyone know how to create a truly random number each time the ants use this method Random r = new Random (); if (r.Next(100) < 5) ant.Speed = new Microsoft.Xna.Framework. Vector3 (-ant.Speed.X, ant.Speed.Y, ant.Speed.Z); if (r.Next(500) < 2) ant.Speed = new Microsoft.Xna.Framework. Vector3 (ant.Speed.X, -ant.Speed.Y, ant.Speed.Z); Thanks kindly, George. I don't wan ...Show All

• SQL Server Different results for MDX queries when using Attribute Hierarchies

  We receive different results for the follow 2 MDX expressions. The only difference is that the second parameter in the Where clause uses a separate dimension called Asset Class in the first query, whereas in the first it uses an Attribute Hierarchy dimension on the Asset dimension. The first provides the expected results which is the top 10 Equity assets, whereas the second returns just 3 Equity assets which belong to the top 10 assets overall. Can anyone explain this Using a cross join in the Topcount function works, but unfortunately ProClarity which we are using does not deal with this properly. Query 1 SELECT NON EMPTY { [Measures].[Value Base] } ON COLUMNS , NON EMPTY { TOPCOUNT( { [Asset].[Ass ...Show All

• Visual C++ cant' compile my code on visual C++ express edition

  I have been trying to cpmpile a simple code on the visual c++ express edition but the compiler tells me "cannot open include file: 'iostream.h': No such file or directory" I need some help Use <iostream>, not <iostream.h>. See this faq http://www.codeguru.com/forum/showthread.php t=344569 , for additional information. ...Show All

• Microsoft ISV Community Center Forums ado recordset problem

  i am using the following code and am getting the structure of customers structure returned to my application recordset rs - but there are no records being produced >>> what am i missing (the access table set is not empty) cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;Persist Security Info=False" cn.Open rs.Open "select * from customers", cn Hi, The following works for me in Excel. Include a reference to the ADO library if using early binding. Sub xx() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New Connection cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;Per ...Show All

• Visual Studio Tools for Office Can you wrap a ChartObject in a Tools.Excel.Chart ?

  Hi, I setup my chart (embedded on a Worksheet, not a Chart Sheet) using one added at design time, using SetSourceData and so on.  However I may have to add the chart at runtime so that I can delete the chart because I was having issues. The issue was I set the chart up in a specific way, setting the source data, max scales on the axes etc.  But when I try and change the max scale after the chart is set up (to accomodate new data) I get a "Unable to set the MaximumScale property of the Axis class" error. Anyways, unless I can overcome this I was going to simply delete the chart and create a new one.  However using (Excel.Chart)((Excel.ChartObjects)this.ChartObjects(missing)).Add(0, 0, 500, 500); I get a Ch ...Show All

• Visual Studio Team System CA2102:CatchNonClsCompliantExceptionsInGeneralHandlers

  I get the above FxCop warning on the following C++/CLI code: VersionInfo GetImplementationVersion() { unsigned char major; unsigned char minor; unsigned char revisionHigh; unsigned char revisionLow; try { // actual code omitted } catch (Exception^ e) { throw gcnew DeviceException(-1, this, "Unknown error", e); } catch (...) { throw gcnew DeviceException(-1, this, "Unknown error"); } return VersionInfo(major, minor, revisionHigh, revisionLow); } Is this a spurious warning, or am I missing something here Thanks for your patience, Simon. We've opened a bug regarding yo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question about Transfering the game.

  I am totally new at XNA and pretty new at programming in C, and i was wondering; How do you transfer the game over to the 360 Do you upload to the internet, or do you just transfer over an ethernet cable Thanks. ...Show All

• SQL Server Variable Value: How do I set it from value in flat file at runtime

  I have a number of DTS packages I am trying to convert and am totally new to Integration Services. I have a flat file that I reference to get a date that I use in some SQL statements in the package. It seems like the best way to do this would be to create a variable to hold the date and set it at run time from the flat file. I've been searching the documentation and the forum and can't figure out how to do this. This is so basic that I feel like an idiot putting it on the forum but I need some help. This whole Integration Services thing is a big shift from DTS (which I eventually became pretty good at) Now I'm back to ground zero. Any help would be appreciated. If you can direct me to any basic training resources that would be cool t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cannot run XNA projects

  I have directx sdk august 2006 release and .net 2.0 framework, c# 2005 express, & xna express Creating a new project, without adding any additional code, the project will not run under start with/ or without debugging. I have tried the multiswap fix in other posts. I am having the same problem, but I'm have a homework assignment due in a week or so. I also have ATI Mobility Radeon 9000 IGP, Windows Professional Service Pack 2, I can run games on my laptop that require DirectX9.c. I went to the ATI website but I couldn't find out if my graphics set-up handles Shader 2.0. I found this code snippet in C#- but I haven't run it yet - I guess I'd have to change the "v1_1" to "v2_ ...Show All

• Windows Search Technologies WDS 3.0 Beta 2:Scanning network drives

  Hi, In WDS 2.6.5 it was possible to scan network drives. In WDS 3.0 Beta 2 this is not possible. When will this feature be returning. As it stands, due to My Documents being redirected and other files being stored on network locations WDS 3.0 isn't much use in a corporate environment. Cheers Janson Wow Tim, You managed to hit this thread about 2 hours after our add-in to allow WDS 3.0 to index network shares went on the download center (the KB article isn't even up yet) :-) You can find this add-in here: http://www.microsoft.com/downloads/details.aspx FamilyID=f7e981d9-5a3b-4872-a07e-220761e27283&displaylang=en Paul Nystrom - MSFT ...Show All

• Visual Studio Team System Installation of RTM destroys my Visual Studio installation

  I am using Vistual Studio Team Suite english version on on german Windows XP Proffessional. I installed the trial of Datadude, which would as Gerd Drapers posted in hit blog would be a full version if I had the Team Suite (which I have). Now since Visual Studio and DataDude are both english versions, I would expect an english Visual Studio after the install. But instead I now got half the menus in german and the other half in english. This really can't be. It did not happen with the CTPs and now that. It is simply bad. What must I do to get my english Visual Studio again Hallo, I can not confirm your findings. See my thread RTM Download for Team Suite Subscribers All menus, submenus, etc. are in e ...Show All

• SQL Server auditing no of connections made to the database

  Hi My application connects to 3 databases . I need to know how many connections are made by my application to each database There are two applications servers. Basically what i need is to know how many connection to each database from each application server. (that is how many connections from application server 1 to database 1,2 &3 and how many connections from applications server 2 to database 1 ,2 & 3) Can this be done .. How to do it Please help me in regard to this Thanks in advance. In SQL Server 2000, query sysprocesses (e.g., select * from sysprocesses). Use loginname or nt_username to specify the login the app uses. You may want to translate dbid to the da ...Show All

• Gadgets C# DLL

  Hi, Is it possible to call methods stored inside a C# dll from a gadget If so please could someone show me an example of how to make the method call I have seen code for how to register/unregister the dll in the gadget code, but thats all i know. Thanks, Jason you can find solution here http://www.codeproject.com/gadgets/GadgetInterop.asp ...Show All

• Software Development for Windows Vista 2 workflows in 1 program?

  Hi all, I am new to Workflow Foundation. Recently I am about to start to write a POS system, but I am wondering if I need to seperate the following procedures into 2 workflows  in order to show the workflow outputs on a window form, such as the total sales price: 1. show the sales item details thourgh reading the item barcodes into window form 2. calculate the total price of all sales items, then shows it on the form 3. input the customer's payment amount, then press the payment button and the window formshows the amount to change  Since I don't know when or how I should obtain the total sales price within the procedures, I am confused if I need to seperate the above into fol ...Show All