Darren_Yu's Q&A profile

• SQL Server "distinct" in select query

  when i use select : select flattened (select productid, $support from [model name].[table] )...... i have result with many record same. so i write : select flattened (select distinct productid, $support from [model name].[table] )...... but when i run, it's error. ( don't know what error). how can i do to get table record with not same record (loop) note : it write in DTS and i use sql 2000 I assume you mean an Analysis Services query. Try: SELECT DISTINCT [model name].[table].[productid] FROM [model name] This should return the distinct list of products ...Show All

• Visual Basic Referencing a Form on a Seperate Thread...?

  I converted my code from VS2003 to VS2005 and came across Cross-Threading problem, which previously did not occur in VS2003. I am developing a Client/Server style application where a great deal of computations takes place in either application. I designed a "Progress Form" that is used to, well you guess it, display the progress of some work. In an attempt to create code that could be universal used by any application, I decided to create a Class. I have a "Thermometer Class" that manages all the interaction of a "Thermometer Form". There is a reason why I used this duel object method of creating my "Progress Form". I want my progress form, when displayed, to lock the GUI but not to block the thre ...Show All

• Visual C# dynamic asp button click doesn't work first time

  Hi all, I'm creating some asp buttons dynamicly and I associated them an event handler btnDel.Click += new EventHandler (btnDel_Click); but the first time I click on the button goes to the Page_load but the btnDel_Click is not fired. Somebody knows the reason Thanks in advance. P.D.: Sorry for my english. Hi Nikunj, Thanks for you answer, but I have an asp table where I'm adding these asp buttons, so I think it's no neccesary to add them to the page (this). The question is that the event isn't firing the first time I click on the button, if I click twice it's goes ok. ...Show All

• Visual Studio Team System Just to clarify TeamSystem license - TFS

  I have been reading a lot of different information about TFS x TeamSystem license model, concerning Cals etc One thing I am almost sure is when we sign for MSDN Premium TeamSystem (whether Suite, Dev, Tester or Arch), we do have rights for 5 CALs to access TFS. Another issue has to do with using this package after expiration. I have posted previously about the possibility of signing for MSDN Premium TeamSystetm Suite, and when renewing, choosing a lower package (tester for instance). In this case, I would not receive any other new features on the other versions (in this case Dev and Arch), but I would be fully license covered to continue using the whole package I had up to that moment. Could anyone from Microsoft confirm this 2 in ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Power of XBOX360 - raw triangle power

  Hi, I was wondering if it was possible to compare the graphics power of XBOX360 to any of current gfx cards. Say, if it`s capable of rendering same amount of triangles as e.g. GF6800 does. The old XBOX was usually compared to GF3 in terms of graphics performance. The reason I ask is, that I would like to know the general boundaries of the raw gfx power, since I`m planning on converting some of my current games to XNA (and later to XBOX360) as soon as it becomes available. Currently I`m pushing the GF6800 card to its limits, which means I`m rendering a range of 0.5M-1.0M triangles (all unique, non-instanced) per frame and it seems that GF6800 starts to slow down when it crosses 1M barrier. No pixel shaders there, just Vertex Shader ...Show All

• SQL Server Transactional Replication : Deleting replicated rows

  I have 1 sql server 2005 database in Server A that is publishing a table to another database in Server B using the transactional method. It is possible for me to delete all the rows in the database located at the publisher at the same time the subscriber pulls them Thanks. If you delete the rows in the published table on server A, the delete transactions will remove them from the table on server B. However, if you delete the rows from the table on server B first, you'll stop the flow of replication transactions from server A. Alternatively, right click Replication on server A, select distributor properties, click the profile defaults button, and check the "Continue on data consistency errors" profile and click the ...Show All

• Visual C# Capture Key Presses in Windows

  Hello, I would like to build an app that acts similar to ALT+TAB (a key combination causes a form to pop up, hide the form when the keys arent held down anymore) and I'm just wondering what I would need to do to capture keys in Windows Will I need to access the Windows API directly to accomplish this Are there any examples that somebody could point me to that show how to do something in C# based on a KeyDown in Windows Thanks! It's not recommended that system-wide hooks, shared extensions, or system-wide extensions be written in a managed language like C# or VB.NET. For details see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=125283&SiteID=1 and http://blogs.msdn.com/oldnewthing/archive/200 ...Show All

• Visual Studio 2008 (Pre-release) Is there a way to specify the namespace in the DLinq Designer?

  I am referring to the May 2006 CTP. Am I missing it Or is it not there If not, it seems like a necessary feature. Without it, some may be forced into editing the generated code. I see a setting for naming the DataContext. This seems like a natural place to be able to edit the namespace. Thanks. You guys got me on my birthday...I am not sure that one counts. ;-) I took the day off and slept all day. Been staying up way too late, far too many nights. And wouldn't you know that would be the day you guys would sneak out the release on me...and early to boot! The good news is that the March Orcas CTP and I have the same birthday. I don't suppose I could convince you guys to coordinate the RTM release for the same day in 2008, could I ...Show All

• Visual Studio Team System Project/TFS Integration issue - please help

  Ok, this is my last effort before opening a ticket with Microsoft and spending the rest of my life on the phone with them. I have Project Server setup, and I have it receiving its data from TFS. The data is replicating between the 2, etc. Here is the problem. When I click "Refresh" on the Team plugin for project a couple times, the data will change. Here is an example: I have a work item with Actual (Completed) Work set to 8 hours. This shows in TFS. Refreshing it in project shows the 8 hours fine. However, if I refresh again it changes it bakc to 0. Clicking refresh 2 more times sets it back to 8, hitting it again makes it go back. This happens with most of the work items, and I cant for the life of me figure out what it is. ...Show All

• SQL Server Need help sql server 2005 client Installation

  Hi , Iam a new bee to sql server.I have Installed sql server 2005 ( trail software ) in my Server.I like to install sql server 2005 clinet in another system. Where can i download sql server 2005 client My requirement is , i should access sql server database from my client... Regs, Priya Hi , I have downloaded sqleval.exe ,and installed the sql server.Can u tell me where can i find SQL-Server Mangagement Studio or can i use express edition of SQL-Server Management Studio But the trail software says its standard edition.Is it fine to use express edition for client software Regs, Priya ...Show All

• Software Development for Windows Vista Problem with Workflows and WebServices

  I am tying to use MSN search in a workflow. I have used invokeWebservice activity to invoke the MSN searh. This MSN search web service implementes SearchCompletedEventHandler. What I would like to achive is to implement, in the workflow, an activity that would write the searchResponse to a variable once the SeachCompletedEvent is fired. I tried to use the EventDriven Activity but I cannot add it to the workflow. Any ideas how I could solve this problem Thanks, M. Vuksanovic. Below is a simple example of how to use the MSN search web service with the InvokeWebserviceActivity: using System; using System.Collections.Generic; using System.Workflow.Activities; using WorkflowConso ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Create Flash Light or Car Headlight effect...

  Hi All, Where can I get information on creating a flash light/headlight lighting effect. When the light moves I would like it to light up objects in a scene. Thanks. http://www.riemers.net/eng/Tutorials/XNA/Csharp/series3.php ...Show All

• Windows Forms Need help changing AxWebBrowser (COM) code to .NET Web Browser!

  object obj = axWebBrowser1.GetOcx(); IOleObject oc = obj as IOleObject; oc.SetClientSite(this); How can I make this code work with the .NET 2.0 Web Browser Control Never mind - I figured it out - this is all part of a .NET Browser effort. Email if you want a copy of the latest beta - mateuszrajca{at}gmail.com ~Matt ...Show All

• Windows Forms hex display

  HI everyone, i have a value that i want to show in hex. I use : textbox1.Text = "0x"+value.ToString("x"); I get the results right, but if the value is 0x06, it only shows me 0x6, is there a format that i can use to get 0x06 Thank you OK, what about use: hexValue = value.ToString("x"); if (hexValue.Length < 2)        label1.Text = "0x0" + hexValue; else        label1.Text = "0x" + hexValue;   It seems to meet the need. ...Show All

• Visual Studio Tools for Office Question re Cypress

  Dan Fisherman originally posted this question when Cypress was announced and it was accidentally deleted from the Forum. Here's a respost of his question with response: ----------------------------------------- I currently have VS 2005 Standard, and want to be able to create .NET applications whose UIs are hosted in the Word 2007 task pane. Will I eventually have to buy a new version of VS to be able to use the functionality in VSTO v3, or will VSTO v3 be a free add-on to any VS 2005 product My understanding is that currently VSTO v2 is available only as a purchasable edition of VS 2005. Thanks for any info you can provide. Dan Fisherman ------------------------------------------ You are correct that VSTO shipped as a pur ...Show All