Paul.Brown's Q&A profile

• SQL Server Report/Query Parameters

  Hi Group, I'm getting a bit confused as to how Reporting Services work with parameters. I've got a query that uses 8 parameters 4 are optional(i.e is not required). I've applied all the necessary settings and am able to run the report via the Report Designer without inputting the optional parameters and the correct results are returned. However when I deploy the report and try running the report without the optional parameters I get a mess ...Show All

• SQL Server Top 5 with Union.

  I want to know the top 5 patterns in sales, the report will like this: Month Top1 Top2 Top3 Top4 Top5 2005-06 A1 A2 A3 A4 A5 2005-07 B1 B2 B3 B4 B5 2005-08 C1 C2 C3 C4 C5 --- --- --- What I did is: declare @StartDate and @EndDate, set @StartDate and @EndDate Delete AAAA (AAAA is a table) Begin While (@EndDate< somedate ) Insert into AAAA(sales, Month, Pattern) Select TOP 5 ...Show All

• SQL Server creating tables

  I am trying to go through an arraylist and create some database tables for each entry in the array. what I have is Dim ques As String For Each ques In questions query = "create Table " + ques + " (plantid nvarchar(100), Answer nvarchar(100))" cmd = New SqlCeCommand(query, con) cmd.ExecuteNonQuery() Next I am wanting to use the item in the arraylist as the name of the db. I am getting an error saying ...Show All

• Visual Studio how do i reference topic in different help file

  i have two separate CHM help files that I have created using NDOC. I want to be able to jump to a topic in one from the other. Is this possible As it is created with NDOC, I don't know the name of the relevant page but I think NDOC should be able to work this out. However I get "page not found" - does anyone know how to do this Incidently, building the help files as HTML 2 still has the problem. Thanks Jason ...Show All

• Software Development for Windows Vista DelayActivity dynamic update

  Hello, I would like to ask you if it is possible to update DelayActivity.TimeDuration value when DelayActivity is executing I want to achieve scenario like this: workflow is configured to simulate delay specified in the DelayActivity. After DelayActivity starts waiting, user wants to change delay value for the running instance (increase or decrease the delay value). Applying WorkflowChanges to the running workflow instance with dif ...Show All

• .NET Development Problem with custom binding

  I have a UserControl which have many instances of another UserControl as a child controls. I am trying to databind Properties in the child controls to a dataview. The problem is i get the same data in the all the child controls even though i am iterating using currency manager. here is what i am doing. Can someone help public void AddJobDataView( DataView dv) { int Y = this .Header.Height; this .Header.Size = new Size ...Show All

• .NET Development How .net obfuscators work

  Are there any articles on this I know about ildasm, and I'm interested in how the standard PE files are built, where the certain information is stored (meta-deta, IL, etc), how an application starts up for the first time (prior and after being jitted and stored in the gac). etc, etc. Basically, everything about how .net works :) Can I read up about this anywhere, or do I have to create my own sample .net executables, and guess/reverse engineer ...Show All

• Windows Forms Divide a form

  Hi, how can I divide a form into upper part and lower part (or eliminate the frame borders) Let say I have the following code and it open a new frame named "ActiveMovie Window". Now, under the video. I have to have a scrolling text area. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ve As Video ve = New Video("movie.wmv") ve.Play() End Sub ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Alpha blend working fine, but never writing value to color buffer

  I have alpha blending working as I want it to... except for the odd error that my rendered 32 bit colors always have alpha set to zero. It looks like (from my searching) that I am the only person in the world who cares about the final alpha value. Aparently eveyone else are happy if the colored pixels blend right. I have tried all sorts of combinations and the result is always the same: alpha is zero. How do i setup the device to blend ...Show All

• Visual Studio 2008 (Pre-release) Back to the 2-tier?

  It seems to me that Dlinq with this nice new feature of Entity = Class is good for a Client/Server scenario only. How would it worlk in a SOA at all I admit this code looks very efficient, but only in a C/S scenario. How would delayed execution work if you're not in C/S scenario, but need to call a webservice for retrieving your data, and also a webservice for updating your data ...Show All

• Visual Basic array equals method

  I'm trying to determine if a value in an array element is equal to another value. I have the following code set up, but it's not working as expected (unless I'm using it incorrectly): <code> If Convert.ToUInt64(CDRElements(1)).Equals(objSrchMaster.objSrchObj(i).Pos) Then blnCondition = True Else blnCondition = False End If </code> While debuggi ...Show All

• Windows Forms Custom controls(user control project)

  Hey all, I'm in the process of working through some examples in a book and had a couple of questions that I am having a little bit of a problem with. So hopefully, with your help they can be cleared up. I am creating a control that consists of several other controls 1) My control is completely cosmetic. It doesn’t really need to have any function but custom property setting. Is there any way to block all the stuff that comes with the control ...Show All

• Visual C++ Does methods of "std::fstream" set "errno" appropriately?

  Hi, Does methods of "std::fstream" set "errno" appropriately Does the mentioned anywhere in docuemnts of Visual C++ Best regards, HouZhenYu Hi, I don't see a reason for it not setting that "errno" correctly (unless it has some bug). Check this page for information of what error flags are set when using fstream members: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vclang98/html/ ...Show All

• Visual Studio Express Editions Integrate PSDK documentation into VC 2005 Express?

  I downloaded and installed Visual C++ 2005 Express and Platform SDK. I integrated PSDK directories into Visual Studio. However, I haven't found a way to integrate PSDK Documentation into Visual Studio help. When I press F1, only MSDN Express opens, without PSDK documentation. I can open PSDK documenation as a separate tool, but there is no way to search for highlighted text automatically (or is there a switch to dexplore.exe ). So, my question: ...Show All

• Visual Studio Express Editions Starting Over?

  Ok. I have had VB express for about 3 weeks now. I have 0 experience with programing. Sorry, all you techy people. But I have learned some cool things. But as I tried to jump into the fire ( and its hot ) i found nothing but frustration. Hence, I have improved on my "google" searching abilites and might add found "never before patience." Says my wife. Any way. Too bad for all of the very nice people that have put up with my & ...Show All