John Doherty's Q&A profile

• SQL Server Programmability of parameter bar(layout/items)?

  Hi all, does anybody of you know how to code and customize the parameter bar of the SSRS reports I know about putting code behind expressions but how is it with parameters How is it possible to... 1. define the layout of the parameter bar and the positions of the parameter items 2. make the parameter items user-specific Is it possible to define a report with the report designer and hand over data (parameters) by code-behind or a referenced assembly Thanks a lot for any help Best Regards Marc Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer). If the parameter selection needs to be as dynamic as you describe, the best ...Show All

• SQL Server SQL Agent job fails running SSIS packages

  I need some help from you on a problem with SQL Server Agent that I believe many of you have experienced. When searching on the web I find some loose answers, but it would not solve my problems. So here is my story. 1. I have created two SSIS packages, package 1 and package 2. Both packages have a Execute SQL Task making a select sql statement to a table, say Customer in AdventureWorks DB. Package1 also makes a Execute Pacakge Task to Package 2. Both packages have protectionlevel property set to EncryptSensitiveWithUserKey 2. Then I created two package configuration files per package, one indirect xml configuration and one xml configuration file. The former I created an environment variable called pack1, which was specifying the path ...Show All

• Visual Basic adding buttons in collection that resize themselves smaller with each added button.

  The code below is working code for the Control Array class as per http://msdn.microsoft.com/library/en-us/dv_vstechart/html/vbtchCreatingControlArraysInVisualBasicNETVisualCNET.asp frame=true&_r=1 I would like this to have the ability to dynamically resize the buttons within a FlowLayoutPanel as more buttons are added. If there is only one button, the button would be the entire width of of the FlowLayoutPanel. 2 buttons would be 1/2 the size of the single button, 3 buttons 1/3, etc. Each time a button is added the flowlayout panel would have to be cleared of all the buttons previously displayed and recreate them. Thanks for letting me think through this.... -greg ******************************************************** ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Matrix.CreateBillboard

  I am trying to create a Sun textured quad billboard to rotate around my skydome. I came across the Matrix.CreateBillboard method, but I'm not sure how I am supposed to be using it. Here is my call: Matrix billboard = new Matrix (); billboard = Matrix .CreateBillboard(entity.Position, camera.Position, camera.Up, camera.Forward); Am I supposed to be using the resulting matrix as the quad's World when I pass it into my shader I tried that and multiplying it by the quad's world passing it into the shader, but in both instances I get nothing to show up. Any help appreciated! This is from a simple transform/texture fx file I'm using uniform extern float4x4 gWVP; ... Out.position = mul(float4(Pos, 1.0f), gW ...Show All

• SQL Server Excel task has no output columns

  I created an Excel Source and used a query to get the data,i.e SELECT F1,F2,F3,F4,F5,F6,F7 FROM [Fut Days$A20:G1480] The query works fine, the preview returns the rows, but SSIS will not generate output Columns nor will it let me manually add them Am I missing something Here is some information that may answer your question: 1. In the Excel Source Editor, navigate to the Columns page. You can modify the output column names that are listed in the External Column/Output Column table by clicking in the field and typing a new name. You can also remove output columns by clearing the checkbox next to column names in the Available External Columns table shown on this page. 2. Click Ok in the ...Show All

• .NET Development Shopping cart

  Does anyone know a “Shopping cart” and a “Classified Adds” asp.net c# web application I can download the source code This forum is for posting questions regarding .Net Developement..specifically Data access and storage. Your post is off topic for this forum.. In order to receive help with your question try posting on the asp forum: http://forums.asp.net/ ...Show All

• Architecture Documenting a web site

  I have been given the assignment of documenting the entire site's navigation. They also want to see how and for what reason we would go to each page. I.e.., I need to add an event to an order. So I need to somehow display the interactions of each page to go through a process. This could entail several pages. So I thought that I could do Use Cases for this. My thinking was with Use Cases and Sequence Diagrams I could show the thought patterns to get from point A to point B. My boss tells me today they want to the site map(pages) and then something else to dictate different scenarios. My company is not very good at reading UML. In fact one other person bought UML in 24 hours. I however have read the entire OMG specifications, ...Show All

• Visual Studio Express Editions editing a datagridview row!

  Wassup! I have a GUI with a datagridview . The user can select some data (out of an integrated table) and the selected data from this table will be automatically written into a row of the Datagridview. Now that the data has been entered in the datagridview row, i want to implement a feature in which the user can manually go to row( with a mouse click for example) and make some changes in the data (for example change age=23 to age =24) which was automatically transferred from the table based on user selection. so basically i want to implement edit functionality for a datagridview row on a mouse click event after some data has been entered in the row. Ho do i do it Cheers! Duplicated post with: ...Show All

• Windows Live Developer Forums Blocking registration in Windows Live for specific domains?

  Is there a way to block Windows Live from accepting registrations for specific domains that we own We have having a constant problem with people registering non-existant emails under own domains and then trying to trick others into thinking that they are affiliated with us. ...Show All

• Visual Studio 2008 (Pre-release) Performance when using with WCF

  When I use the entities within a WCF muti-tier service, the performance is terrible. I am guessing that it is trying to search for the WCF transaction I have not specified any WCF transactions, and am using basic http binding. The performance is so bad that the WCF service is timeouting even when i set the timeout to about 1 min. Has anyone out there used entities in a WCF service For a single entitiy this is relatively easy to do: find the CacheEntry for the entity (renamed to StateEntry in more recent versions which may or may not be in the build you are working with), call Delete on it, and then call AcceptChanges. This will cause it to be removed from the cache but that change to be marked as accep ...Show All

• SQL Server XML BULK LOAD very simple but I CANT UPLOAD THE DOCUMENT! HEEEEEEELP!!!!! PLS !!!!!!

  Hi I have been trying to upload an XML document for weeks... the document: <produkte> <produkt> <produktid value="2342" /> <langtext>klasd kdal aks<langtext> </produkt> <produkt> ........ </produkt> </produkte> My XSD: < xsd:schema xmlns:xsd= "http://www.w3.org/2001/XMLSchema" xmlns:sql= "urn:schemas-microsoft-com:mapping-schema" > < xsd:element name= "produkte" sql:is-constant= "1" > < xsd:complexType > < xsd:sequence > < xsd:element name= "produkt" sql:relation= "PRODS" > < xsd:complexType > < xsd:sequ ...Show All

• Visual Studio Express Editions Selecting the three largest variables from a group of ten

  I need to select the three largest variables from a group of ten, however I need to do it without a hundred ifs, also I need the variables, and not the values. Is there an easy way to do this that I am perhaps missing If so could someone please enlighten me Thanks. here's what i had in mind when i replied to this post... You must use an array or it won't work.  Place each value in the array in order of the item.  The item is the index.  You will not sort the array so the index will still correspond to the value. 1- Create 3 variables named high1, high2 and high3.  Initialize each one to 0. 2- Inside a For loop, compare the value of high1 with the value of each of the array values. 3- If the array val ...Show All

• Visual Studio Team System Error when opening "Performance Tools" Tools Options page

  I *suspect* this issue has occurred since I installed SP1. I had no errors installing SP1 and not noticed anything untoward (so much so that I was near on upgrading my other machine!). Whilst I was poking around the options I found out that my Tools Options page for 'Performance Tools' is broken - when I choose it I get "an error occurred loading this property page" instead. I do recall an error loading a package but I didn't note the GUID down and it's not prompted me since :( I'm not sure if it really was SP1 but if anyone could offer any advice on how to fix it I'd appreciate it! PC: Windows XP Sp2 + all updates, Pentium M-760, 2GB RAM Visual Studio version info: Microsoft Visual Studio 2005 Version 8.0.50727 ...Show All

• Smart Device Development Blocking Popups/Dialogs while receiving a file from Bluetooth

  Hello All, I`m using HTC. Whenever I receive a file from Bluetooth, 2 popups/dialogs come up. One is for the display and another is for permission for request to continue. I want to block these popups/dialogs. Is that possible With Regards, Manjunath. Thanks Peter. Since I`m a newbie, can you enlighten me more regarding this, what should I do What Should I download and how should I proceed with my bluelistener program Waiting for your reply, With regards, Manjunath ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can I play video files with XNA GSE?

  I'm not so much looking at writing a game as using this tool to develop some media applications, if possible. I've grabbed C# Express Edition and installed it, and I've watched a number of the C# tutorial videos. I'm going to have to learn C# - I've done Delphi, and Java, and some C ages ago - but I'm looking for something new, and this looked interesting. But I'm not sure I fully understand the limitations of this development tool/environment, particularly when it comes to multimedia capabilities. I like the idea of being able to target an application to a fairly well-known, easily available, consistent hardware platform. Having software that could run on an Xbox 360, with the option of using some of the Live facilities for information ...Show All