web_monkey2k's Q&A profile

• SQL Server CTE in a DSV named query

  Hello, I have a CTE that I want to put into a DSV named query. here is the CTE (which anyone can run): WITH mycte AS (SELECT TOP (200) object_id, name, column_id, system_type_id FROM sys.columns) SELECT object_id, name, column_id, system_type_id FROM mycte AS mycte_1 I can put that into the named query editor and run it, no problems. Upon clicking "OK" I get: Incorrect syntax near ')' Incorrect syntax near the keyword 'with'/ If this statement is a common table expression or an xmlnamespaces clause the previous statement must be terminated with a semicolon. So, I put a semicolon i ...Show All

• Smart Device Development how to use library?

  i use below code to check my external storage. maybe this is not the correct way but this is work! if who have any better solution please tell me. for my system almost every form using this code, so i hope can use library to write this code, it is easy for me if next time i want modify the code. but i never use library before so i hope someone else can help me or give me some example to refer. Private Shared Dir As IO.Directory Private Shared myStr1 As String = "Directory, Temporary" Private Shared Directories() As String = Dir.GetDirectories("\") Private Shared i As Long Private Shared ...Show All

• Windows Forms DataAdapter Update runs with no errors, but database is not updated

  Following code executes without err, but when database is checked the update was not applied. This code retrieves a single row from the database containing columns/fields "Nickname" and "Pswd". ' create database connection using code Dim myDbConnection As New SqlClient.SqlConnection() With myDbConnection .ConnectionString = sMyDBConnectionString End With 'Create a database command object using code Dim sSearchNickName As String = Trim(txbUserId.Text.ToString.ToLower) ' below generates the following sql statement ' "Select Nickname, Pswd from [dbo].[Nicknames] WHERE ...Show All

• Visual Studio Express Editions How do I pass return codes on exit?

  I would like to call a program using Call Shell(), wait for it to finish, then (if possible), collect the data it returns (as if it were a function). My question is, how do I make a program that sends data back when it exits, and how do I make another program that calls this program, then gets the data Environment . ExitCode = MyExitStatus ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiple configs & EULA

  Hiya, I just had a quick look at XNA Build in between waiting for builds. :) It certainly looks nice and I'm encouraged by what I've seen. I do have some questions though: I can't figure out how to handle multiple configs such as a sku or a platform, is this possible in the Designer window Assuming the above, can I specify what to include/exclude for each config Is it possible to specify what to build E.g.: a particular entity Can I use parts of XNA Build rather than all of it In particular I've identified Tracker.exe as something I can use standalone. What is the license agreement Thanks! Ling ...Show All

• SQL Server Changing Ordering of a Dimension Attribute

  I have a dimension attribute called Month.  It is sorting alphabetically instead of based on it's underlying key value.  How do I change this Thanks, Chris If you choose attribute name, you can define the order by another field. I have in each dimension an order field and I have configured each dimension to sort by this field. By default I fill in this field with name. But if a user request another order I can change values in this field without changing dimension structure. ...Show All

• .NET Development How to share a variable among multiple consumers of a web service

  Problem1. Need to share an int variable among multiple clients of a web service.Clients can read and write the value of the variable.declaring variable as static doesnt seem to work.How can i use the Application class in web serivce Problem2. I have created a class in Web service solution.And sending the arraylist of that class to client.Now need to cast this object[] (since arraylist is returned to client as object[] array) to that class,how can i do this Problem 1: You can't. Web Services are stateless, which means once it's done with the request, that data is no longer available. It's like a SingleCall in .NET Remoting... ...Show All

• Windows Forms List of Generic Collections? Trees?

  Where is there a published list of generic collection classes available in Whidbey If there's no list available, are there any Tree classes such as red-black, AVL or b-trees I realize this is an old post, not sure if anyone is still monitoring it anymore or not but I wrote a generic implementation of an AVL tree that you are welcome ...Show All

• Visual Studio How to add Intellisense to a New Project Type

  Hi. I am new to the forums and extending Visual Studio 2005. I am working on creating a new project type for Visual Studio 2005 using C# and the Managed Package Framework (MPF). I used the examples provided by the SDK and the SDK Help to create a new project type. The new project type is working quite well, but Intellisense on any variables or classes within the project fail to be utilized by Intellisense. Intellisense is still functional on built-in C# objects and responds to the normal methods for invoking it. I have found the same occurs in the Project sample in the SDK. Now, I need to enable Intellisense functionality on the variab ...Show All

• Visual Studio Team System Team Build Failure on Tests

  When running a team build we are failing out when the process goes to run the tests we have associated with our components. The only output we are getting for this is in the BuildLog.txt and it is only "MSBUILD: warning : Specified cast is not valid" We can determine that the testing process has started due to the tests we have set with the Ignore attribute. Let me know what additional information may be required to help track this down. We are using VS.NET RC (clients and server), Team Foundation Beta 3, .NET Framework 2.0.50727.26. Sorry Winnie Time passes and you tend to forget the trails you leave behind (luckily :-). We don't ...Show All

• Windows Forms Form to/from Form variable updates?

  Situation: MDI form for entering report parameters (frmReportParms) reportParms has a button which opens another form (frmOptions). frmOptions allows the user to drag and drop values from lbxAvailableFields to lbxSortBy and lbxGroupBy. The problem: How do I get the values from lbxSortBy and lbxGroupBy in frmOptions back to the current instance of classReportParms instantiated in frmReportParms  I ...Show All

• Visual Studio Express Editions How to config Team foundation server?

  I'm a beginer in .Net 2005. I can't config source safe 8.0 of .Net 2005 I don't know how to config a Team foundation server. Pls help me. thks. Hi, Upon installing SourceSafe or TFS you can configure on what source control to use on the tools menu options. Select the Source Control node and choose the appropriate source control (either sourcesafe or tfs) that your going to use. Ipon setting that up you can login to the source control through File->Open. In TFS choose Team Project, in SourceSafe just select Project and on the open dialog there is a Visual Source Safe button on your left, that's where you'll find the source safe data ...Show All

• Visual Studio client-side debugging in IE 7

  I am trying to debug an asp.net program in Visual Web Developer 2005 Express Edition, and I have errors in my client-side javascript. When it breaks out into the debugger, I only see the original aspx file, without the javascript. The yellow arrow points to the last line of the html, indicating that's where the error is. It breaks when I click an image. I have an "onclick" event handler, and I assume the code is breaking there. I just installed Internet Explorer 7 Beta 2. Is that related to my problem of not being able to debug ...Show All

• Smart Device Development Deploy Failed

  Hi Developers, I am trying to deploy my sms application on the phone , but cant do so . I get a error saying deploy failed . It was working fine for few runs before . I am building this in VC for smartphone 2003 Can any one help me with it 1>------ Deploy started: Project: SMS, Configuration: Debug Smartphone 2003 (ARMV4) ------ 1>Deployment and/or registration failed with error: 0x80070020. The process cannot access the file because it is being used by another process. 1> ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Thanks , Parag Which version of Visual Studio ...Show All

• Smart Device Development Thread Priority

  Hi, Can I know if it is possible to change the thread priority while it has been started If yes, how I did try to change the priority...but it gaves me Exception (InvalidOperation). Talking about game programming, for example, I have one thread as main while another one to load the file. What I would like to do with that "another one" is...while the player is idle...I would like to make that loading thread priority as highest, therefore...I assume it should load faster. Thank you in advance for the answer.  You can have some boolean flag inside your thread that will indicate that a thread ...Show All