yaotong's Q&A profile

• SQL Server How to execute multiple stored procedures from a report and return the sum of the values returned from the sp's

  Hi, I am writing a ver complex and highly critical report and since the report is complex, I have created a bunch of stored procedures to handle this. I then created a text dataset to call the sps. In the dataset I have a dynamic sql query that executes those sps and get the values returned from them in a variable. I then add those values together and store them in another declared variable. I want to return this variable from the report so that it shows in the fields list. For this I am writing a single select query for eg: 'Select @amount as Total' But when I click refresh fields, I just get a single column with the name ID and it is not set to any value from the dataset when I go the the fields tab in the dataset. This has b ...Show All

• Visual Studio Team System The internal state of the database project is inconsistent

  I got this error Error: The internal state of the database project is inconsistent Unload the project and then reload it to resolve the issue. i already Unload and reload the project but not solved any help Yes, it is unclear as to what is causing this to happen. We had a database project as part of our solution for about a week and then suddenly this started happening for all the developers on the project. At this point we have to unload the database project whenever we want to do a build. -- Bryant ...Show All

• Software Development for Windows Vista New Vista Home Premium PC will not reconize old XP based "NAS" PC

  The title says it all. I am trying to gain access to my home XP based "NAS" with my new Vista based PC. My old XP PC is set up and ready to go as a "NAS" however when I try to map a network drive from my Vista PC I get nothing it wont even acknowledge its existence on the network. PLEASE HELP All wires connected...check On old XP based PC: Run network setup wizard (through a residential conection/turned on file and printer sharing)...check Create a shared folder (share folder on network/allow network users to change this file)...check On new Vista based PC: Map a network drive...Failed see above To get more complete faster service I recommend that you try the link ...Show All

• Visual Studio Express Editions Populating a Dataset from an SQL Database

  I am using VB 2005 Express Edition! Also - this is my first attempty at accessing an SQL database, so I acknowledge that I have probably done something very silly but at this stage I am stumped and need some help. As a reference on how to do this, I used KB Article 301216. I have basically copied exactly what was shown in the article changing names to suit my requirements and have come up with the following code :- Dim connection As New SqlConnection(ConnectionString) connection.Open() Dim adapter As New SqlDataAdapter ReadString = "SELECT * FROM configuration" adapter.SelectCommand = New SqlCommand(ReadString, connection) Dim DSetCONFIGURATION As New DataSet( "CONFIGURATION&qu ...Show All

• Visual C++ Need help compiling 64-bit C++ Code in VS2005...

  Hello generous helper! I am trying to figure out how to port my code from 32-bit VC++ 6.0 to unmanaged C++ 64-bit VS2005. I have found the preprocessor definition changes and the linker changes, but I get errors compiling, like: error C2371: 'size_t' : redefinition; different basic types I get the feeling that I am doing something horribly wrong, even when I try to make a "Hello World" program, its not working out for me in 64-bit... Does anyone have an unmanaged C++ VS2005 Project in 64-bit that does "Hello World" just so I can see how it is done Thanks! - John Aha! I reinstalled and saw those options... Now it compiles !!!! Woohoo! Linking is another problem, but thanks for getting me this far! Much ...Show All

• SQL Server Backup the Transmission queue

  My normal scenario is tills sending live slaes to head office via service Broker queue.  Sales are sent as soon as sale is made(normally tills on adsl lines), a loss of a Link to head office will still allow a sale to be made with  the sale sitting in the transmission queue on the till but has not been commited at HO to adjust stock etc, until the link is back up. My worry is link goes down with several sales siting in the queue and then hardware failure. Is their a mechanism to backup the Transmission queue in the case of no link If you could back up the transmission queue at a till could i then take those messages and copy them into head offices queue for processing, this is in the case of ...Show All

• Visual Studio Express Editions loading large pictures in picturebox

  Hello. I'm working with large pictures (one of them is 4021x3123) and I want to load them inside o PictureBox so the user interacts with it (draws on it). The problem is after I load the picture, when I use the scroolbar to move around it, it has that flicker effect and also the interaction with my application has a delay (it takes about 1 sec for the other controls to react). I'm guessing my problem appers because of the large picture I'm loading, so is there a way not to load the entire picture inside the PictureBox and only load that portion of the picture that is currently dispayed by the PictureBox Is there a better solution to that Thanks. Yes, I'm using double buffer and it doesn't help. ...Show All

• SQL Server Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

  Hello all, I just want to make a quick post on the “Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.” I am working on a small system at the moment and I have a CODES table with columns CODE and DESC. When I first set up the database I set CODE to varchar(MAX) and same with DESC, Then when I put all the codes and descriptions in and tried to run fill I got the error. Now weather this will help anyone I don’t know, I found out that it was the Colum DESC in the DataSet that was causing the problem, if you enter your dataset designer and select one of your columns, Right click, properties, there is a field called MAXLENGTH, When I checked it was set to 50 ev ...Show All

• .NET Development proxy error when consuming internal web service

  I've pulled out much hair over this, so I hope a guru out there can quickly see the err of my ways. I have created (with the help of some code from articles) a web service that accesses an external web site (outside of our company firewall). I have coded the web proxy and credentials into the web service. In testing via a browser, the web service performs correctly, in that it authenticates thru the firewall and returns data to the browser in XML format. Now I need to consume that web service in an ASP.NET application. However, it fails with the error : The request failed with HTTP status 502: Bad Gateway. The client code is pretty darn simple, so I'm embarrassed that it's not easily working. The sanitized code is below (client and web ...Show All

• Visual Studio Team System a

  When i build a WebApplication and runs them on the CPU its usage goes through 100 % and the computer goes down. Everytime i must kill the aspnet_wp.exe process. Why please provide the resolution Please help me on this its urgent thanks in advance regards sridhar Have you tried debugging your application Walk through your application, because from your description it sounds like there may simply be a programming error where you are inadvertently using all of the available cycles. Good luck, Dave Lubash Visual Studio Team Developer ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Simple BreakOut Demo (Source included)

  Well there it is, my first ever C# and XNA program I hope it'll help some of you. Download BreakOutDemo.zip v0.31 Thank you MS for that wonderful gift that is the XNA. Thanks for the comments guys, I appreciate it! :) I will make some improvements (ball effect, maybe item drops) and upload an updated version later today. And sorry about the question/comment thing Glenn, I will make sure to set it correctly next time. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Custom Vertex and Transformed vertices.

  Hello all, This is my first post so sorry if I did something wrong ;) I have a little problem with porting my "framework" that used mdx1.1 to xna (I am still using Windows.Forms). The problem is that i didn't do a lot shaders in a past and now things are more difficult to me. I had a lot of objects like gui parts and splashscreens which used my "quad" (2 triangles with texture in screenspace). And that is the problem. I used transformed vertex so i could give screen coords and now I can see only positioned. Is it possible to use screen coordinates somehow I know this thread is a bit old but I am also going to be using screen coordinates to put up colored triangles (GUI, like in F ...Show All

• Visual C# Is possible to optmize a access database by code?

  Hi ! Well, i have a access simple access database and always i need to optmize manually... Can i do by code Thanks ...Show All

• Software Development for Windows Vista How to generate workflow code file

  Hi all,     I'm developping workflow designer.I have found System.Workflow.ComponentModel.Serialization.ActivityCodeDomSerializer  class can get CodeDom object,how but am I not too clear generate workflow code file(.cs and .designer.cs and .vb and .designer.vb file).Who can give me the detailed explanation how to make or  provide some sample code     thanks. there is a nice article about designer rehosting at ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnlong/html/WFDsgnRehst.asp ) that should have that working. take a look at MemberCreationService and EventBindingService services for more details. Sergey ...Show All

• Visual Studio Team System How do you find what process template is in use?

  How do you find what process template is in use for a Team Project after it has been created The code snippet I posted above should work fine. I was running the above sample against a private build that is why it was returning -1 for templateId. When I ran it against a TFS Layout setup it worked fine. See whether the above code snippet will work for you ...Show All