xzhang9's Q&A profile

• SQL Server Sum on conditional Values

  Hi I have a table with Records for employees and evry record has a record type now i need to have a sum in the table footer or in a group for all employees of Amount Column when Record type is "E" and the conditions is if this employee by RecordType "D" the amount column is not 0 else then shuld be 0 is it posible with SSRS Thanks Jhknys Thanks all for the reply but what i am trying to do is get sum amount form records that have RecordType "E" but i want to check if thay have a amount in Record by Record Type D so i can just check the sum with this record is it posible Thanks Jhknys ...Show All

• Visual FoxPro Replace character in a field

  I need to perform an update on a table, replacing a charcter (+) with another one (x) In SQL Server I Write Update <Table> Set Field = Replace(Field, '+'. 'x') With a dbf table it doesn't wotk and I couldn't find out how to do this. To be more specific, my table has a field (named flags), and it can be filled like this: i + xx i++ x+ +++ i+ I have to replace all '+' with 'x' to heve this result: i x xx ixx xx xxx ix Can anyone help me, please Easy to do in XBASE on a DBF:  REPLACE [ALL] field WITH STRTRAN(field, "+", "x") [FOR {condition}] * note that ALL and FOR clauses are optional   If you prefer SQL syntax UPDATE field ; SET field=STRTRAN(field, "+", "x") ; WHERE {condition} ...Show All

• SQL Server Report Builder

  I am attempting to create a report using the report builder. I can see the button for the report builder on my report server but nothing happens when you click it. I also attempted to go directly to the url but once again nothing. Finally, I attempted to run the application directly from the file structure and in doing so there I got the following errors. Could not find file 'reportbuilder.chm.deploy'. I created a junk text file with the same file name and attemted to run the app again and this time I got a error that said: Could not find file 'reportbuilder.exe.deploy'. After that I created another junk text file and named it the same as that. This is part of the errors that I recieved. This doesn't suprise me based on the hack I di ...Show All

• Visual Studio 2008 (Pre-release) Test WCF Services using Team Test

  Hi, Anyone knows how to use team test to create tests for WCF services thanks a lot oaix I did what i was meant to right clicked on the method, told it to generate tests. And it creates a new project, auto generates unit test code. But it fails when it tries to run, as it starts up a new webserver, but then fails to call it.... ...Show All

• Visual Studio Express Editions Microsoft Visual Basic 2005 Express Edition Problem!!

  I was making a new project, so then i press "Windows Application", then i name it, then i press ok. But then This Errors Pops UP! So anyone can solve this problem for me pl0x i think i know where is the prob, i think its my username's prob,. But when i try to change the folder's username, it said i cant change it. ( I changed Windows Username already) ...Show All

• SQL Server query

  hi, i want to achive the IIF functionality. example select iff(employee.empid is not null,'sdfsdf',iif(employee.deptid is not null,'dssdf','sdfsd')) as 'sdsd' from employee how to solve this. thank you You can use an IF in SQL. Its normally shown as IF EXISTS (SELECT * FROM Orders WHERE OrderNo = @OrderNo) THEN ...Show All

• Smart Device Development How to Merge *.reg File From Code

  Hello, Reg files usually are merged automatically during Cold Boot. Is there a way of merging a reg file from code (Something different than reading the file, parsing it and manually calling Reg functions from API.) The only thing I was able to find out about the issue was information about existance of RegMerge.dll. Thanks, Artur Ilya, It is enough to put a *.reg file (registry editor file:)) in /Application folder and perform Cold Boot to have all registry entries merged. Unless this is something specific to my device, your statement "there's nothing to process or parse them files on device" is not true. Also, I didn't use "merger" term in my post, therefore I don't get y ...Show All

• Visual Studio Express Editions Problem applying a filter to binding source

  Upon updateing a combobox to select the sex of a farm animal I am attempting to filter out the opposite sex in the next ID box.Can anyone see where my issue is here. I have rewritten this many time to no avail. I have read through the msdn help on this and all appears to be done correctly. Also... How would I use one of these filters to show only discrete items http://imkaudio.com/error/ nocolumnerror.bmp And here is the code Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'TODO: This line of code loads data into the 'Ct10DataSet.animal' table. You can move, or remove it, as needed. Me .AnimalTableAdapter.Fill( Me .Ct10D ...Show All

• Visual C# Save a radiobutton value in Settings?

  How can I save a radiobutton.Checked value in Settings Thanks, First you need to handle when radio button is checked. You need to handle ValueChanged event on every radio button, by seperate handler or what I prefer one handler for all radio buttons in a logical group. I also use a form property that is used to cover radio button selection. Then you need to decide how to represent that selection. It's easyer if you define enumeration for radio buttons group and value to be a of that enumeration type. Then you can store string representation of enumerated value in application settings and when you need that value you can just read, parse and based on that value, select (check) coresponding radio button. When you have a value you ca ...Show All

• Visual Studio 2008 (Pre-release) XmlDataProvider - Recommend when using large files

  Hello I really enjoy the binding features in WPF for the xmldataprovider, really useful. My only problem is further down the road there is no support in my mind for setting the XmlDataProvider with an XmlReader only an in-memory XmlDocument. After downloading the XPathReader from MSDN should there not by a XPathReader in V3 of the Framwork and an XmlDataProvider that streams data I can see my avalon app eating memory in occasions. What do you recommend. kind regards, Andrew XPathReader (which I believe is a wrapper around SAX) is really not suited for binding, especially two way binding. It is the same reason why XmlReader isn't supported. If you only have a reader, you cant write. That is why XmlDataProvider only supp ...Show All

• Visual Studio Express Editions VB Express Teaching Aids - Recommendations?

  I am looking for recommendations for any guidebooks for learning VB Express. Right now, I'm leaning towards "VB Express for Dummies", but if there's anything better that veteran members of the community know of, I'd be interested to know. Personal History: Long, long ago (in High School/University. About 15ish years ago) I took programming in school, almost exclusively Pascal/Turbo Pascal. I dabbled with it as a hobby for a couple years but gave it up to pursue other interests. I've recently discovered VB Express and have caught the programming bug again. However, I'm a little out of practice. Ok, a lot out of practice. I've gone through the first few tutorials, but I find I do much better having a lesson book to referen ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA 2D Collision Detection using Quadtrees

  I've seen a few posts on collision detection, and though I'd post an article on how to write a collision detection engine for your game. Take a look at: http://mbebenita.blogspot.com/ I'll follow it up with some source code as soon as I get a chance. Michael B. Ok, I understand that. But I meant using the screen to "cap" the area where you want to test collisions (like when using the frustrum area in Octress and BSP to select the 3D areas to render). Say, in a single player game, the dynamic objects that lay out of the screen could be frozen so as to avoid do some checking on them. And when the player moves so that the objects are back again on screen, these objects are reactivated. That ...Show All

• Visual C# Partial Specialization of Generics

  I want to do something like this: using StringDictionary<T> = System.Collections.Generic.SortedDictionary<System.String, T>; How do I accomplish that If C# 2.0 doesn't syntactically support the notion, what is the next best equivalent It looks like . Probably we should suggest to add some functionality to this forums like: if someone is editing a post and somebody else adds a post warn the person who is editing... ...Show All

• SQL Server pfpagealloc error

  I am running Sql Server 2005 SP 2 CTP and keep getting an error which says Internal Error pfpagealloc.cpp file is corrupt. This did not happen with SP1 and is very speradic. I get the problem when using both excel and the visual studio browser to manipulate an anylsis services database. I can then try again and everything works. I also get the same problem sometimes with my overnight rebuild of the cube. Paul Please, please. If you can catch the repro schenario, create a report with http://connect.microsoft.com/sql . Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Visual Studio Express Editions RaiseEvent, button1.click vs. textbox1.keydown

  I think this question has been asked before and the replys seem to miss the point of the question. (Or maybe I missed the right reply. ) So, here is how I will phrase the question. I often start out a program by adding a button on the form to do something. Then I put code in the button1.click event handler. (I let the IDE 'frame' the handler for me by double clicking the button in the designer view.) Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Blah, Blah, Blah .. lots of code pertaining to a textbox usually End Sub Then I decide that I would like the same code to execute if the user hits 'enter' in the textbox, as well as execute if the butto ...Show All