DQM's Q&A profile

• Windows Forms Combo box autocompletemode

  I have a databound combo box with its autocompletemode property set to "suggest" and its autocompletesource property set to "ListItems". When the user closes the form the following exception is thrown: Cannot bind to the property or column LastName on the DataSource. Parameter name: dataMember Any suggestions as to how I can work around this exception Thanks for your help. Ken McLean ...Show All

• Windows Live Developer Forums System.Data.DataTable 2 GeoRSS

  Hello out there... I’m developing a VE Server Control for ASP.NET 1.1 and have a question related pretty much to ASP.NET and XML, but somehow should fit also in this forum here. I have lots of contacts (with LatLong information) stored in my database and would like to add them via a GeoRSS layer to my map. Nothing special! My question is: How to best transform a DataTable (the result of my db query) to a GeoRSS conformant XML file Right now I’m trying to use the DataSet.WriteXml() function. Is it possible to combine this with the DataSet.ReadXmlSchema() function Or is it really necessary to build the XML-tree element by element from each row of the DataTable ! Appreciate any help or suggestion!! Cheers hafi Hi Mediaguy700, of course ...Show All

• SQL Server SSIS package

  Guys I've migrated a SQL Server 2000 DTS package over to SSIS (which seems to have worked), its a really simple package with just one item, it first checks for a tables existance and deletes if necessary, then recreates the table and then inserts data from a selection of other tables, except its only creating the table no data is being inserted, yet the script to insert data works as I've tried it in a query. Any ideas Thanks inadvance Duncan-Countrywide wrote: Hi Thanks for the swift reply, I'm using the control flows and an execute sql task, as is it was imported, the only change I've made is the server names, as I said it does work no errors are generated, just when I check the tabl ...Show All

• Visual Basic Locking the transcation

  HI May i know how to lock the table when the transaction is make( not just 1 but many transaction) so i can unlock the table after all the transaction has make or error occur. Thanks Why do you want to lock the entire table - you should design an application which will lock as few records for as little duration as possible to avoid locking performance issues. Would you want to lock all the records in the table (say all orders for all customers) when only 1 record (1 order for 1 customer) has chnaged an needs to be updated. ...Show All

• Windows Forms Strange Toolbar Error

  I'm building a simple C# WinForms app and am getting a strange error. Upon starting the application I check whether certain key registry values have been set. If not, then I display a little "Options" dialog box to collect them. Prior to doing this I display the regular main form in the background to give a more pleasing aesthetic feel to the user. Both of these forms are launched from "Main". Here's the strange thing though: When the app is run the first time as described, the toolbar buttons refuse to fire an event.. The menu events work fine but not the toolbar ones. So I guess the toolbar's event handler isn't getting activated but why wouldn't it Is this a known bug with the toolbar or I have done something wrong ...Show All

• .NET Development Transact SQL Query to return Sequence Number

  I want to display the sequence number Column for the Row Returned, row wise. i.e. select empname,emp_age from [table Name] sl_no empname empage 1 Adams 45 2 Borris 55 3 Cathy 33 how should we include this 'sl_no' column within a select query Please Help ! I wrote an article on how to find the identity value of a row during an insert: Retrieve Identity Column Value After Inserting Record in Database Table - SQL Server - Free ADO.NET Tutorials Hope this helps. Regards, Dave ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Microsoft.Xna.Framework.Input.Keyboard

  Hiya Everyone, Any advice on the following would be greatly appreciated. I’ve developed a very basic static KeyboardHandler class, for the sole purpose of generating OnKeyDown events whenever some keys are being pressed. The class has a member function called Update, which is called each time the Game.Update() member function is called i.e. it is called each time the game components are being updated. The KeyboardHandler.Update() queries the KeyboardState to determine which keys have been pressed, and raises an event for each of the keys returned by the GetPressedKeys() method I’ve noticed though that the following occurs: 1) The Keyboard.GetState().GetPressedKeys() is returning mouse ...Show All

• Visual Studio VB.NET 2005 / Sandcastle treatment of <see cref=""/>

  I created identical test projects in C# and VB.NET 2005, and it seems that the two compilers treat <see cref=""/> tags differently. Given this <summary> comment text in the source code: An example comment that references the <see cref="ID"/> and <see cref="Name"/> properties and also some base class library stuff like <see cref="Environment"/> and <see cref="DateTime"/>. The C# compiler produces this text in the XML comment file, which is correctly interpreted by Sandcastle: An example comment that references the <see cref="P:SandcastleTest.Program.ID"/> and <see cref="P:SandcastleTest.Program.Name"/> properties and als ...Show All

• Software Development for Windows Vista Blue Screen of Death

  I recently purchased a copy of Windows Vista Business addition. I currently own a copy of Windows XP home edition which is installed. I want to have dual booting operating systems, I have a 120GB SATA 7200 RPM hard drive and a 200GB IDE Maxtor 7200 RPM. XP is installed on the SATA and i want to put Vista on the empty 200GB hard drive. I insert the disk and reboot my computer. When it boots off the CD i enter my key and all that. Then it asks if i want to upgrade or fresh install. I choose fresh install. I click the empty 200GB hard drive and it copys the files finishes everything then reboots. When Vista tries to load up i get a blue screen of death and a system crash error, it will reboot its self and try to load it ag ...Show All

• Windows Forms Including non referenced dll in ClickOnce deployment

  I'm deploying an applikation using ClickOnce I need to include a dll from another project in the solution. This dll is not directly referenced in the project I'm trying to deploy, but is added as a Project dependency. This dll is not getting bublished alongside the rest of the project files and references. How do I get the ClickOnce deployment to include this dll file -- sparrez The thing is I really don't want a direct reference to the assembly in the project. We use Reflection to create objects from different assemblies dynamically and we don't have the possibilty to have all those referenced in the project as some are delivered by third party. But I think the MageUI approach is the way to go for now. ...Show All

• Software Development for Windows Vista Getting readonly data without locking the workflow instance in a WF runtime-multihosted environment

  Hi, Please, consider the following scenario: A web farm or web garden A common store for SqlTrackingService and SqlWorkflowPersistenceService with locking enabled An ASP.NET web service running in the web farm or garden that: Host the runtime Exposes custom message-based interface to clients (web or windows apps) and encapsulates workflow stuff Interact with the hosted workflows using the runtime Now, several persons using a web application are requesting read only data about the same state machine workflow instance at the same time. This data are the workflow state and allowed messages. I have seen the ordering state machine sample, and I have realized that it gets the allowed messages from the workfl ...Show All

• Visual Studio 2008 (Pre-release) SOA - availability vs. consistency

  Hello, Would someone please explain the trade off between availability and consistency in SOA I don't thinkg I'm 100% on that. And if/how WCF allow architect/designer to choose thier own availability & consistency threasholds Thanks in advance Houman ...Show All

• SQL Server UPDATE TABLE using ROW_NUMBER() OVER...

  Hi Champs, I am trying to either UPDATE or add a new column with ROWNUMBER() OVER an column on a table table: ID------Col2----Col3--- 1-------12---------1 1-------34---------2 2-------44---------1 2-------75---------2 2-------77---------3 3-------23---------1 3-------33---------2 4-------44---------1 4-------22---------2 I know I can get Col3 right with an SELECT and ROWNUMBER() OVER, but how can I UPDATE the table with the result /Many thanks You can use a CTE in any DML statement. So it is simpler to just do: with r_SomeTable as ( select * , row_number() over(partition by IDCol order by ValueCol) as rnk from SomeTable ) update r_SomeTable set RANKCol = rnk go ...Show All

• Visual Studio 2008 (Pre-release) Populating a VisualCollection from a background thread

  Hi all, I have a UIElement whose child VisualCollection I'd like to populate using a background worker thread. BackgroundWorker initially seemed like it would do the trick, but I haven't been able to get it to work correctly. What is the proper way for me to declare/scope/use my UIElement so that I can populate the VisualCollection in Thread "B" and when the work is complete, actually use said object in the rendering (UI) thread Right now I'm running into thread affinity issues. BackgroundWorker.RunWorkerCompleted allows me to return simple data back to the UI thread, however attempting to return my UIElement generates an exception when I try to access it's members, since it is 'owned' by the background thread. Is there ...Show All

• Visual Studio Team System Updating GlobalList contents

  I want to display a dropdown of project names in my customized workitem type. The list of project names will increase over time. We are using one Team Project to store all our projects. Currently I have dumped all our existing project names into a GlobalList. However, maintenance of this is going to be very unfriendly for admin users (who are not technical). Also, there is no provision to correct a project name if one is entered incorrectly. I think I have two options: create a custom control to pick up the relevant project names from a database and save the project id field to the workitem. All addition or editing of project names can be done via this table with a UI. create a UI that manipulates the TFSWorkItemTracking dat ...Show All