Khin's Q&A profile

• SQL Server select query based upon results of another select query??

  Hi, not exactly too sure if this can be done but I have a need to run a query which will return a list of values from 1 column. Then I need to iterate this list to produce the resultset for return. This is implemented as a stored procedure declare @OwnerIdent varchar(7) set @OwnerIdent='A12345B' SELECT table1.val1 FROM table1 INNER JOIN table2 ON table1. Ident = table2.Ident WHERE table2.Ident = @OwnerIdent 'Now for each result of the above I need to run the below query SELECT Clients.Name , Clients.Address1 , Clients.BPhone, Clients.email FROM Clients INNER JOIN Growers ON Clients.ClientKey = Growers.ClientKey WHERE Growers.PIN = @newpin) '@newpin being the result from first query Any help appreciated ...Show All

• Visual Studio Express Editions How can i Do transaction while using a dataset?

  hi guys.. im Doing a Simple Inventory Application Which Data entry might be handle by quite a few people so there will be error in database. i used dataset. i initialise my dataset on my main form Public Sub LoadData() connInventory = New Odbc.OdbcConnection(constr) DaLogin = New Odbc.OdbcDataAdapter( "Select * From Login" , connInventory) CbLogin = New Odbc.OdbcCommandBuilder(DaLogin) daWareHouseTable = New Odbc.OdbcDataAdapter( "Select * From WareHouseTable Order by WareHouseID" , connInventory) cbWareHouseTable = New Odbc.OdbcCommandBuilder(daWareHouseTable) dalocationMaster = New Odbc.OdbcDataAdapter( "Select * From locationMaster Order by LocationID&quo ...Show All

• SQL Server ---Problem of realization replication through WEB---

  Hello There is a following mistake at replication through WEB A security error occurred I try to go through IE which user has specified in the master of creation of the subscriber, in a diagnostic mode https://Servak/Replication/replisapi.dll diag And all works, all certificates fulfil correctly who did not collide{face} in what business WHERE TO DIG No. The problem is! Load a file, I there on steps have described and have drawn a problem. Thanks big that help me!!! http://www.replication2006.narod.ru/Problem.rar ...Show All

• Visual Studio Cannot load class diagram

  Have a problem with loading a class diagram and would like some pointers as to how to track down the problem. I have created a class diagram within which I created several classes. I then decided to start again and deleted all the source files. The Class diagram duly updated itself and removed all the classes. I closed the class diagram. When I tried to reopen it I received the error message Cannot load D:….. Parameter cannot be null. Parameter : key. I tried delete and create of the diagram – still no joy. Reduced the project to just the class diagram. This would now display but when I attempted to add an interface from the popup menu I received the error dialog “Parameter cannot be null Parameter: key”. Using the toolbox ...Show All

• .NET Development sent byte array shifted

  hi, I have a case whereby when i try to send an byte[], the receiver receive it as its has been shifted. When i tried to debug: sender byte[] before socket.BeginSend() consist of: [1] 60 [2] 63 [3] 120 [4] 109 [5] 108 32 [7] 118 101 ... receiver byte[] after socket.Receive() consist of: [1] 0 [2] 0 [3] 0 [4] 0 [5] 60 63 [7] 120 109 ... The size of the byte[] is sent beforehead, and both sender and receiver has same number. The filestream is created afterwards, and the receiver file has 4 spaces at the front file and 4 character truncated at the rear of the file as it follows the size of the byte[]. What is exactly happening... Anyone can solve my problem Thanks in advance You are being bitten by network byte ord ...Show All

• .NET Development Multithreading problem for multiple methods (Semaphore)

  Hello I have this problem. I use a class that has some methods in it that runs concurrently (Another object manages many instances of this class). Here is the constraint:- method1() can run up to 10 threads at a time method2() can run up to 5 threads at a time if there is method1 running (even only 1 thread), method2 cannot run. if there is method2 running (even only 1 thread), method1 cannot run. Anyone has a solution to this problem for method1 and method2 themselves to run up to 10 and 5 threads, I can control using semaphore but how to do mutual exclusion between method1 and method2 Thank you Pi. But if so (using mutex to block inside method1 so another thread cannot call method2), another thread can ...Show All

• .NET Development Generated TableAdapter does not create methods for manualy entered commands

  If I create a tableadapter from a simple query, the corresponding Insert/Update/Delete commands are created, and the generated underlying class has matching methods created also.  That's fine. However, I am creating a TableAdapter from a query using joins from multiple tables.  In order to update the primary table, I have then manually written the Insert/Update/Delete SQL and set the appropriate paramerers. In this latter version, the generated TableAdapter class does NOT get the corresponding insert() & delete() methods created. Is there some way of forcing these to be generated, or some guidelines on when methods will and will not be generated Thanks in advance Tim If t ...Show All

• Visual Studio Team System Problem with witimport

  All, I've just made a change to a work item definition, and imported it as usual using witimport. On the last couple of occasions i've done this the changes don't seem to be reflected in the form layout presented to the users. witimport validated the changes ok, and didn't report an error during the import I've tried exporting the new definition, and my changes are present. I've cleared the cache (once using teamplain and once using witfields rebuildcache). I've turned tracing on, on the web service, and there are no exceptions Nothing that appears relevant in the event log* * except TFS Services restarting every hour. Very strange. I'll investigate separately. How do I go about solving this one The last time I had to reboot the machine ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D racer problem (collisions)

  Hi im trying to make a very very basic 3d racing game. Basically, ive spent hours trying to work out how to detect whether my rocket (the car) has left the side of the track or not. I cant work out how to properly use bounding boxes/bounding spheres in 3D and i dont understand how that would even work with a track with bends etc. Here is my source code for you to download and try and understand what I mean. Any help is really appreciated. EDIT - http://www.sendspace.com/file/6pcunk http://www.megaupload.com/ d=G6CLZF70 Or if someone could just explain how to go about working out whether the car has left the track or not What fuctions you should use or whatever. Music - aren't this worms Hmm even by loo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNADominos - Initial release

  Just thought I'd post my first release of XNADominos. Its a port of a DX app I wrote a while back mainly as a learning experience. Next release will include source and an editor. Anyway, binaries and screenshots can be found here: http://andyq.no-ip.com/blog/ cat=4 Andy I am willing to share it on a need to have / want to have basis right now because it is still in its VERY early stages. The code is uncommented, very "dirty" and the engine as a whole still needs to get more functionality before I can even consider it to be releasable. I am willing to let people have it on a more one to one basis so I can get feedback from those I give it to. ...Show All

• .NET Development Role based security

  Hi All, I understand that Principal namespace is to implement Role based security. Questions i am going to ask might be silly one but they haunts me whenever i start looking into security aspect. 1. Msdn quote following in one of its article on PrincipalPolicy. " For performance reasons, the default principal and identity objects are not created until they are needed. If a principal is explicitly added to the current thread, a default principal is not created and the principal policy setting is ignored. " Can somebody please explain what exactly is meant by this and what all should be done to implement role based security without affecting performance. 2. One more query: Principal namespace contains both Genericident ...Show All

• .NET Development finding out if the computer has an active working Internet connection

  I need help with writing code that finds out if the computer has an active working internet connection so that my program does not throw errors and exceptions when it cant find the internet. My problem is that i do not know where to start. FLAMETHROWER you should never use the Abort() method on a thread and also there is no need to start a new thread just for this, its expensive. the code also loads a file from the local computer itself :-) ...Show All

• SQL Server Installing Report Service in Window XP - Report Builder and other option are not displaying

  hi I have installed SQL Server Reporting Service on window xp. everything working fine except one thing. I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights. I have checked with local administrator login also but same problem. what additional setting are require for admin rights Dinesh Patel No, unfortunately no idea. But I'm having the same problem. A user with Administrator's rights on the Reporting Services server gets the "Report Builder" link, but another with all task assignments (Content Manager, Report Buil ...Show All

• Software Development for Windows Vista Some sample about AcivityBind and WorkflowParameterBinding

  Can u give me some sample about the usage of WorkflowParameterBinding and ActivityBind I can't any theme about this A WorkflowParameterBinding is used to bind to named parameters like the properties of an invoked workflow. ActivityBind is used to bind an Activity’s property to a variable or another activity’s property. For examples of both do the following: · Create a new workflow library project. · Right click on the default workflow and choose View Code. · Add a property to the workflow like below: string paramOne = string .Empty; public string ParameterOne { get { return this .paramOne; } set { this .paramOne = value ; } } · Add a ...Show All

• Smart Device Development how to programatically install CF2 with my C# program using CEAppMgr

  Hi, does anyone know how can i utilized CEAppMgr to install both CF2 and my C# program I can manually install both by using cab file or used CEAppMgr to install one file at a time but i would like to install both CAB files using CEAppMgr. It's possible Thank you in advance. You can register as many INI files with CeAppMgr as you need and then install them in one step. Of course device can only install one CAB at a time anyway, but at least you won’t get several CeAppMgr pop ups. Please see MSDN for details. ...Show All