jturpin's Q&A profile

• SQL Server Get last record in a SQL database

  Don't know if this is the right SQL section, but... using VBE, how do you SQL for the last record in the database Thanks. the LAST record entered in the database.... if for example if you entered 10 records in a new database, how do you fetch #10 - or the LAST recorded entered (without indicating 'get the 10th record')   ...Show All

• SQL Server trigger question

  I have the need to use triggers in my database, but am a little foggy on something that reading the official msdn help did not quite clarify. If for example there is a trigger which is triggered when a certain record is updated (DDL ) Is it possible to see what the values were before and after the update I need to create a trail of updates such that the information can be rolled back if need be. Any help with this would be greatly appreciated. Thank you :) Thank you robert :) Someone else gave me a bit of sample code, but their explanation was not as fleshed out as yours. So between the two I understand what I need to. Thank you for your help :) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. HLSL Procedural Textures

  I am currently trying to implement HLSL procedural texture support in XNA. After I have defined the sampler and associated it with a function to generate my procedural texture in HLSL, I would usually call D3DXFillTextureTX in DirectX9.0c to fill a texture using the compiled shader. Is there an equivalent set of operations in XNA I dont think that the texture shader functionality is directly available in XNA, or at least, not in the same way as DirectX. From what I can see you basically have 2 options - generate your procedural data in c# and then just call SetData to put it into a texture object, or alternatively create a rendertarget, render your procedural data to that and get the texture back. Heres ...Show All

• Visual Studio Express Editions Help with "Concentration" Game

  I am a student studying VB for the first time and I've run into a snag programming as assignment. It's a matching game consisting of 8 pairs of matching words randomly assigned to 16 labels. When a label is clicked, the word currently assigned to it will display. If two labels are clicked and the words match, the labels are disabled and change their color. This is done until all 8 pairs of words are found, after which a message box is displayed indicating the game is over. I am confused as to how I can randomize the list of words and assign them to the labels, as well as how to check for matching. Any help would be appreciated. Right. I just thought it might simplify the code to have them all under one sub. ...Show All

• Visual Studio Team System Is there any “forbidden code patterns” example anywhere on the internet ?

  Again, a new cool tool by Microsoft that has simply no use, the “forbidden code patterns”, is there any practical sample of how to write a single useful C# “forbidden code pattern” I can defiantly tell the tools not to accept any code that has the word “Hello World” in it, but that’s about it, ok, maybe a bit more. I want any useful example, anything :-) I want to see the example so I can write my own custom code patterns, I have a long list, and I still can’t implement it. Maybe the tool is ok, maybe I am missing something or don’t have the experience, who know, let us see a sample, I am sure you tested that tool with something :-) See my other response - yes, it uses the .NET Regex class, a ...Show All

• Visual Studio Express Editions Upgrade app over the net - versioning

  Please can someone point me to some samples of auto-updating one's C# app over the net by checking current version no off the website. Thanks for any help. Well the way I have done it is to create a webservice which your application calls, sending it information about itself, then the webservice would detect on the server if there is a newer version and if so, it will take the bytes[] of the new version and send it across to the client (your "old" application) I dont think there is a way of doing it "over the net" like Windows Update for example.   in order to create a webservice, I am unsure if the WebDeveloper Express edition of VS2005 has this option, but it is available in the full ve ...Show All

• Windows Forms Data binding and Checkbox values

  Ok... I have a value in my Sql table called "Disconnected" is a bit type....0 for not being disconnected 1 for being disconnected, Now i have a checkbox in my windows form that will submit information on a product....if the Disconnected checkbox is checked how do i send that value to the sql db...I know the checkbox is a bool value so if its checked it returns true if not it returns 0 for false.......I know i can type cast a bool to a bit, so should i do that within a property or something anyhelp or any links on how to get this done will be most helpful!!! it should be: if (Convert.ToBoolean(IsDe) == true) { ... } ok, well since you are using a DataReader, what I suggested won't work. You will have to in this case ...Show All

• Gadgets Gadget post info to new web form

  I've created a gadget which is a simple HTML form with 2 text boxes and a button. When you click the button it should open a new IE window and send the information to the target URL as a post. The problem is when installed as a sidebar, although the IE window is opening with the correct page, the information in the 2 textboxes does not seem to be transferred. I have tested the simple HTML form by opening it in IE and all functionlity works fine, but not when I install it as a sidebar. Is there something obvious that I am missing Any help would be appreciated. Thank you Hi, I thought I would just respond to a couple of people's question if the issue has been resolved. Unfortunately it hasn't f ...Show All

• SQL Server forms in reporting services

  Is there a way to insert forms in reporting services. If so, how would this be done> Are you using Sharepoint or Report Manager You will probably have to write a custom web app or web part to enter data into a sql database, or use the sql web data administrator tool. There is no facility for creating a data entry form in reporting services. regards, Andrew ...Show All

• SQL Server Subquery Question

  I'm trying to write a very specific subquery. My table data looks like this. jobname1 complete destinationA jobname1 complete destinationB jobname1 not-complete destinationC jobname2 complete destinationA jobname2 complete destinationB jobname2 complete destinationC jobname3 complete destinationA jobname3 complete destinationB jobname3 complete destinationC The result I need is the job name of all unique job names whose records are ALL complete. So, in the case above, I need the names of jobname2 and jobname3. Here's what I have so far, but itt is so far returning no results: Select jobname from table where NOT EXISTS (Select * from table where table.job_status != 'complete' ...Show All

• Internet Explorer Development Detecting that a "File Download" Window popup is open and if possible close it through scripting

  Hi, When a user clicks a link that opens up the "File Download" window, is it possible to detect if such a window is currently open If it is possible, are there any way to close this window through scripting I want to call window.close() and have the browser close regardless if the "File Download" window is currently open or not. Thank you for the help in advance. Hello, I just wanted to give additional details about the IE7 issue I am encountering. The reason I asked about the "File Download" question above is that it appears in IE7, when a "File Download" window is open, it appears scripting routine stops executing in the main browser window. ...Show All

• Visual Studio Tools for Office Action Pane is disabled when I save the document and reopen.

  Hi, Please any one can let me know what is the problem with Action pane when I save and reopen the Excel document. Action pane and its controls get disabled when I perform following steps. 1) Open Excel document,Populate some data and save to hard disk. 2) When I reopen and click on Action pane controls, all the controls gets disabled and no events are fired. Do I have to do some reinitialization for the action Pane Regards, Uma Kadagi. Alex, Yes, I am taking the original VSTO document form the web server and binding the dlls to the document. I got the reason why it was disabled. Since I was not using the Sheet2 and Sheet3 in my project and was deleting those two on workbook open event.Now I am just ...Show All

• Windows Forms Adding new column to an Access database

  My application works with an Access database that contains valuable production data. I need to add a couple of new columns to one of the tables, but don't want to trash the user's data. At startup, I would like to check the existing database for whether or not it has been modified and, if not, add the new columns. What is the best way to do this Good answer, and it does work! Now the question is how to tell whether or not the field is already in the table. ...Show All

• Visual Studio Set an "Overview" HTML page to the Guidance Package

  How do we set the "Overview" page to the guidance package so that it appears in the Guidance Navigator Can't find it anywhere... Stole from Microsoft.Practices.RecipeFramework.MetaGuidancePackage.xml < GuidancePackage xmlns = " http://schemas.microsoft.com/pag/gax-core " xmlns:xi = http://www.w3.org/2001/XInclude aption = " Guidance Package Development " Guid = " 23FC29C9-FAFE-47f1-B633-B548E788DDDF " TraceLevel = " Info " Name = " MetaGuidancePackage " SortPriority = " 200 " BindingRecipe = " BindRegistrationRecipes " SchemaVersion = " 1.0 " > < Overview Url = " Templates\Overview\intro.htm " /> < Recipes > Have tested this in my own GP and it works great ... yay!  Note .. ...Show All

• SharePoint Products and Technologies Trouble with Content Management Server (MCMS) Migration Profile

  Hi, all. We're trying to use the Content Management Server Migration in SharePoint 2007. We have successfully created a (copy of a production) CMS installation on our test server, running on a VMWare Windows 2003 Instance. We set up a new Migration Profile in SharePoint Central Administration, and then run it. But after an hour or so, it reports that is has failed. The last error messages in the log are: 1/30/2007 2:25 PM Import error /Norsk/Helse miljo og sikkerhet/Tilsyn og raadgivning/Samtykker/Pages/7_samtykke_leteboring_6507_11-8.aspx 1/30/2007 2:25 PM Import error 1/30/2007 2:25 PM Exception The page that it references in the first line above, is available ...Show All