YoK's Q&A profile

• .NET Development TableAdapter InsertQuery and query builder unhelpful

  Alright well I could write out some code create a generic Sqlconnection and command and execute an insert with execute scalar to return my identity or that returns my identity as an output parameter but why should I have to do that.. I'm using ADO.NET 2.0.. I want my table adapter to be smart in some way and give me the identity. I want to be able to do this using the built in tools like query builder. Should be easy right I'll specify an output parameter in my query with the nice query builder tool. And tell it to give me scope_identity(). No, there's no way to do that in the query builder.. it cannot parse any command like that. Hey maybe I'll add a new query to insert a row... and look at the code it generat ...Show All

• Visual Studio Referencing custom environment variables in MSBuild.

  Hello, Ultimately all I want to do is set an environment variable with a value, so it can be referenced within my Build script. Sounds easy I know, but I can’t find an answer anywhere to this problem. Summarised below are the steps which I am currently taking to achieve my goal: Set environment variable in DOS (i.e. SET TEST=TEST1). Type SET to ensure the variable had been created, which it has. In my build script write a target to reference the newly created environment variable. < Target Name = " ReferenceEnvironmentVariable " > < Message Text = " TEST1= $(TEST1) " /> </ Target > I invoke the above target by ...Show All

• Visual C++ Help, I need to implement IOleCommandTarget using ATL CAxWindow

  I need to know how to implement IOleCommandTarget using the ATL CAxWindow class that is hosting a WebBrowser control. Thanks in advance! For such issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups . For more details on the scope of these forums, please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All

• Visual Studio Team System Problem with [DeploymentItem]

  I'm running into a problem with the DeploymentItemAttribute in my unit tests. Some specified items get copied over, while others do not. For example, I have these three items: [ DeploymentItem ( @".\test.config" )] [ DeploymentItem ( @".\DB1.mdf" )] [ DeploymentItem ( @".\DB2.mdf" )] The MDF files get deployed, while the test.config file doesn't. Yet all of them exist in the same test project directory. Anyone have any clues about this Thanks, - Dave Good question. My guess is the test.config is not set to be copied over with the build outputs like the .mdf files are, so when deploy goes to copy it from the build o ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XInput wrapper

  How are people wrapping up XInput Many games only care when the player starts or stops pressing a button. State changes. Edges. XInput lets you check if the button is currently down or not, but leaves the rest to be handled at a higher level. Is XNA Framework planning to handle any of this I wrote a quick wrapper that just checks for state changes and fires off events using delegates. This is a good start, but requires an update from the game loop to check for those changes. Even at 60Hz, I imagine it's easy to drop edges, and god forbid the game hitches due to some nifty effect. Losing an input would be pretty annoying for a fighting game. Lacking interrupts, it seems the best solution might be to dedicate a thread to monitoring control ...Show All

• Visual C# Does anyone know how to use Validation Summary Control with Custom Validator ?

  I am trying to use Custom Validator which causes server validation and Client validation for the FileUpload Control. But if i put Validation Summary Control to show the error message then the message is not showing up in MessageBox. All other Client Side validations messages are showing up in the Validation Summary Message Box except the message of Custom validator. Anyone has idea on how to do this -Thanks Satya Hi Satyavani, You should setup in ClientValidationFunction property to your CustomValidator: IsAgree, for example. Later, you put is code snippet in your script section HTML. function IsAgree( val, args ) { var done = false; // your custom valitation result. In true ...Show All

• Visual C# How to read the Return Value from any Stored Procedure.

  I'm using .Net 2005 I want to access the Return Value sent by any Stored Procedure, I'm executing sp using SQLCommand's ExecuteReader and it seems that we need to close the DataReader before we want to read the Return Value. But, I want to read the Return Value before I read any data from the DataReader. Please help me out. Best Regards Trinadh P. Add a parameter to the parameter collection in the command with direction ReturnValue. SqlCommand cmd = new SqlCommand(theSQL); SqlParameter param = cmd.Parameters.Add("@returnval", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; SqlDataReader dr = cmd.ExecuteReader(); int nReturnValue = (int)cmd.Parameters("@returnval").Value ...Show All

• SQL Server Group Update of Prices

  I am trying to write a SP that will update the price of products that are in a particular category. I have 3 tables; PRODUCT - productID, price CATEGORY - categoryID, categoryName, parentID PRODUCT_CATEGORY_MAP - productID, categoryID What I want to do, is allow admin to pass is a new price and categoryID, and it will update all the products that are within the supplied category. I will start with: UPDATE PRODUCT SET price = @price WHERE categoryID = @categoryID however I do not have categoryID within the PRODUCT table Do I place a SELECT statement after the WHERE DECLARE @productID int UPDATE PRODUCT SET price = @price WHERE (SELECT @productID = productID FROM PRODUCT_CATEGORY_MAP WHERE categoryID=@categoryID ) Not sure if that ...Show All

• SQL Server New version of MSSQL CE RC1

  I noticed the new date on the download page for RC1 of MSSQL CE. I downloaded it and compared it to the last one (I think it was maybe dated 11/17/06 ) and found there are differences between the 2 msi files. That leads me to some questions: 1. What has changed with this latest RC1 release Any fixes that would make this a "required" download 2. Can I get away with just uninstalling the old MSSQL CE RC1 and reinstalling the new one i.e. without having to go through all of the other prerequisite, exacting steps required to get MSSQL CE working with VS.NET. 3. Why wouldn't this new file be named RC2 Slipstream releases are never a good idea, as they just add confusion. Thanks for any input. Dan ...Show All

• Visual Studio Express Editions Visual Basic Express for the web?

  Hello This is my first post to this forum so to start with I want to say hello to everyone. I live in Sweden so hopefully my English is good enough for you to understand. My main question is: Should I / can I use Visual studio express for my application This is my vision: I want to build a program that my users download from my site. The program will send data and receive data from a database on my server. The windows based app will show result from matches and tournament that has been played and also users will add results to the database, which means that it could be many connections open to the database at the same time. As I said can I use VB Express for this And as you have noticed I’m a beginner when it comes to VB so ...Show All

• Visual Studio Tools for Office Find and replace for Strings over 255 charaters in Word

  I'm trying todo a find and replace in Word 2003, replacing a found item with a string that is greater than 255 characters in length (believed to be the limitation due to the find and replace in word). My plan was todo a find to highlight what i wanted to replace, then just inserting text over that highlighted area, unless there is a better solution. If this is the best solution how do I go about setting the range values required to insert over the already highlighted text Any help would be greatly appreciated :) Hi Edward OK, you know you're supposed to ask general automation questions here : http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en& ...Show All

• Architecture abstract vs interface

  hi everybody, In my current application,ther is a common fucntionality(method) which can change frequently. Should i use the abstract class or the interface to put the signature of the method (no body )inside. The answer which comes in my mind is interface but then why can't we use abstract instead by just giving the signature of method in the abstract class. Do interfaces or abstract differ in how much memory they consume and also in the performance of the application. Please elaborate on what is to be used prefably in which scenarios as i read many articles but none of them gives indepth knowledge. Regards In my example shown in O/R Mapping thread ( http://forums.microsoft.com/MSDN/Sho ...Show All

• Windows Forms Error Code: 0x80070643

  I have tried to install Windows and Office updates utilizing the Automatic installation tool; but, the initialization takes place and none of the updates are intalled. I ran WinDoctor and I am told that I am missing file "ORUN32.exe" and it cannot access "learn32.dll" and "pctree32.dll". I have searched my computer and found the orun32 and pctree32 files but not the learn32 file. I don't know how it got deleted and not sure how to get it back in place to use the automatic update. What do I do to get my Automatic updates to run again Please help me! Office Source Engine bull *** solution does not work...no matter how many times you restart this service. This problem was most likely created ...Show All

• Visual FoxPro Aha, found. To be able to reply first cause an error:)

  Hi everyone. I have noticed a rather serious incompatibility between VFP9 and older Foxpro versions. In the following code, when the field valid is fired, the related table record is not seeked and not found. In older Foxpro, the related table record is already seeked in the valid clause. This happens only for the first entry in the 'TmpProd' table but subsequent entries are seeked and fine. Is there a solution for this aside from seeking within the field validation code SELECT 2 USE prod order ProdId &&Index is on ProdId SELECT 1 USE TmpProd EXCLUSIVE SET RELATION TO ProdId INTO prod zap APPEND BLANK BROWSE FIELDS ProdId:v=showinf(),design=Prod.design RETURN FUNCTION showinf ...Show All