Graham Hay's Q&A profile

• SQL Server After an insert, how do I get the primary key of the new row?

  I am using C# and ADO.NET After executing an INSERT, I would like to retrieve the primary key of the last row inserted. I've tried running SELECT @@IDENTITY in a query, but I get an OleDbException with the message: {"Syntax error. in query expression 'SELECT @@IDENTITY'."}. does anyone know what to do Someone asked me the same thing today and after a couple of hours I've came up with this (the code is in VB but I will try to explain the concept as well as I can): I'll use a sample table from a SQL Server (I work with an SQL 2000 right now). The table is called _FluxModels and has two fields FluxModelID (an identity field) and FluxModel (a varchar (50) field). In order to update the ta ...Show All

• Software Development for Windows Vista VNC and Session 0 Isolation

  Hello, I am the author of Bozteck VNCScan Enterprise Network Manager . I am a bit concerned about the new session 0 isolation in Vista. When VNC is installed to a Vista computer as a service, it is locked into running at only session 0 and that is pretty much useless for what it is designed to accomplish. In session 0, you can not remote control the computer or even get a remote screen shot of it. Our software is relied upon by over 100,000 Network Administrators across the globe and I have heard many of them voice deep concern about moving to the new Vista platform if VNC will no longer work properly. RDP is not an option because it does not allow the end user to interact with or view what the remote administrator is doing on their PC ...Show All

• Visual Studio 2008 (Pre-release) constants in query

  This relates to the http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=523328&SiteID=1&mode=1 How can I create a query like: select 1 as Number union select 2 as Number union select 3 as Number Have you tried using the ToQueryable() operator in System.Query.Queryable int[] ia = new int[] {1, 2, 3}; IQueryable iq = System.Query.Queryable.ToQueryable(ia); foreach(int i in iq) { Console.WriteLine(i) } ...Show All

• Audio and Video Development HDi and animations

  Does the HDiSimulator support things like: <animate calcMode="linear" style:backgroundFrame="0;1" /> I cannot get it to work - no animation occurs. I was just trying to use a different method for changed say a button from normal to highlight. I'll try it with more images/frames. The thing is, I'm not even seeing the second frame. ...Show All

• Visual Studio Express Editions Save collection into a file, then read back

  Hi folks, I have been doing some searching here about how to store the data in a collection into a file, to be able to read it back in later. I could save every data item one by one into a file, and then read it back one by one, but this is a painstaking and errorprone process. I found some articles about serialization/deserialization into an XML-file, but I cannot quite grasp it (yet). I am not sure if the serialization works with collections. Simply put this is what I want: (<<< is what I need to know>>>>) 1- create a (public) collection and fill it with all kinds of data 2- invoke a Save command, and obtain the filename and path to save to 3- <<< store entire collection into said file >> ...Show All

• SQL Server Scheduled Subscriptions, ScheduleRecurrence and the ICalender Recurrence Rule

  I am working on getting a subscription management interface put together for my product's implimentation of Notification Services. I have a question about the capabilities of the Scheduled Subscriptions, specificaly about the flexibility of the ScheduleRecurrence property. below is a copy of recurrence options from books online... ICalendar Recurrence Options FREQ=DAILY; FREQ=WEEKLY;BYDAY= DaysOfWeekList ;[BYMONTH= MonthsOfYearList ;] FREQ=MONTHLY;BYMONTHDAY= DaysOfMonthList ;[BYMONTH= MonthsOfYearList ;] FREQ=YEARLY;BYMONTHDAY= DayOfMonth ;BYMONTH= MonthOfYear ; It would apear that Daily is the smallest unit of recurrence supported, but we would like to have a recurrence option in a period o ...Show All

• Software Development for Windows Vista trouble installing Windows Workflow Foundation, to be used for SharePoint 2007

  I am wanting to set up SharePoint 2007 on a test server in my office. One of the pre-req's is Windows Workflow Foundation. I have gone to MS WWF page ( http://msdn2.microsoft.com/en-us/netframework/aa663328.aspx ) and downloaded the components listed there Runtime Components WIndows VIsta SDK Visual Studio 2005 Extensions for WWF And have installed them.. When I try to install the Visual Studio 2005 Extensions, I get a message saying that I need to have Windows Workflow Foundation installed first..... Anyone able to tell me what I am leaving out... This is being installed on Windows 2003 Server. Dave Since you appear to have the release version of WF i ...Show All

• SQL Server Alignments between tasks and constrains

  Hello What are your experiences with the alignment of constrains between tasks I find it hard to align two task in an exact same vertical or horizontal position. When you grab the green constrain lines with your mouse, you can see a soft pink dashed line which tels you which way to go with your mouse but it is so hard to get straight lines. Is there a auto align task feature or something else I don't know of How do you guys do it Regards, Worf Have you looked at the options in Format menu of BIDS I personally use it to align the tasks but I do pay too much attention to the arrows. Rafael Salas ...Show All

• SQL Server Annualizing Measures

  In the financial services world, a common requirement is to annualized a value. We've made several attempts at this. The challenge comes when using a standard Date hierarchy (Year, Quarter, Month, Date). We need to annualized a measure based on a running total of the last 6 months. We also need to take into account the early dates of the warehouse where X Months might not be available by multiplying the aggregate it by Y divided by the count of non-empty members. This seems to work for this part of the problem: Create Member CurrentCube.[Measures].[Rolling 6m Contribution] AS Case When COUNT(LASTPERIODS(6, [Date].[Month].CurrentMember), EXCLUDEEMPTY) + 1 < 6 Then Aggregate(LASTPERIODS ( 6, [Date].[Month].CurrentMember),[Me ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Meshes, Material and Light

  Hi guys, i'm currently trying to get started with my first serious approach in getting something to work in XNA ;) It will be a ball game and it is called xMinton for now. Many things are done, setting up many classes and the usual stuff. While i was working there were more and more questions coming up. I was able to solve some of them on my own, some of them are those i want to ask you genius folks now. dga wrote: Problems: First big problem is the lighting that takes place through the shader. It seems like the lighting is done for every "Mesh" (Net, Ads, Floor) again. Its hard to explain. But as you can see in this Screenshot the floor is lightened in the TopRight corner, but the ad there is very dark. Same for ...Show All

• Visual Studio Express Editions Webcasts?

  Just wanted to ask, I found a couple of webcasts i wanted to view but i see you need to enter your address! If this for like a bill (are webcasts free or do they cost money) Or is it for other reasons (if so what ) Thanks http://msevents.microsoft.com/cui/WebCastEventDetails.aspx EventID=1032294939&EventCategory=5&culture=en-US&CountryCode=US How do i watch this webcast Do i hit register on the web Then thats where it asks me for the address! What do i do ...Show All

• Windows Forms get the column header text of datagrid view

  hi i have binded the datagrid view control with dataset now when the user clicks on the datagrid column header, i want to retrieve the the column header text pls help me hi Andrej its giving ArguementOutOfRangeException Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index pls reply ...Show All

• Visual Studio Express Editions DataGridView cell input

  Hi, How can i directly get into the data input mode when i click on a DataGridView cell unit, not like at this moment showing the selection of the cell first then allows you to input the data ok try this, in the designer view of the form, select the datagridview, then in the properties scroll down to "EditMode" and selet "EditOnEnter" does this work for you ...Show All

• SQL Server How to subtract previous value of one column from current value of another column

  I have a table like this: Bottom Top 0 2 4 6.5 9 14 1 5 17 In Transact SQL I need to calculate the difference between the current bottom and the previous top. If there is no previous top, then the result would be the current bottom. So, the result would be 0, 2, 2.5, 1 I must return the value in a table. Thank you all for your help! Karen Karen, If you are using SQL Server 2005, you can take advantage of the new analytic functions more or less like this: create table T( primary_key int identity(1,1) primary key, bottom decimal(10,2), [top] decimal(10,2) ) create index T_bo ...Show All

• SQL Server Windows XP Pro x64 and Jet 4.0

  I am trying to work with my database driven .asp files and once I add a call to my asp files I get the following message:   ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /cedar-springs/admin/includes/inc.dbopen.asp , line 25 It seems that in Windows XP Pro x64 the Microsoft Jet 4.0 provider can not be registered.  I have installed the lastest version of .net frame that i can find and this still does not work.  Any help would be greatly appreciated. the code in the inc.dbopen.asp file is below: Dim conn Set Conn = Server.CreateObject("ADODB.Connection") Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" Conn.ConnectionString = Conn.ConnectionString ...Show All