Mark Layne's Q&A profile

• .NET Development How to delay a Response.Redirect?

  Do you guys know how to put a 2-3 second delay in the response.redirect method   Or is there another function I should call which has a delay built into it   I'm using this command for an autoforward to another page. Any help would be appreciated. You should use the forums.asp.net site for ASP.NET related questions. I found this thread over there: http://forums.asp.net/448135/ShowPost.aspx ...Show All

• SQL Server How to calculate difference between totals of two group

  Hi I am new to SQL Server Reporting Services. I have a grouped report which has two groups in it. I want to calculate the difference of totals of the two groups. Can anyone tell me how we can do this e.g. Loan # Name Principal ...Show All

• .NET Development Stored Procedure

  Hi, I'm using ADO.net (1.1) and I'm trying to run a stored procedure like this: myCommand.CommandText = "MyStoredProcedure 1, 'teste', 14, 'Mary'" myCommand.CommandType = CommandType.StoredProcedure myCommand.ExecuteNonQuery() Why doesn't it work I'm keeping receiving a error message saying that It cannot find the stored procedure "." Do I have to run the stored procedures with parameters Or is it possible to do it like in ADO ("MyStoredProc ...Show All

• SQL Server KPI value expressions

  I'm trying to understand what forms the value expression of a KPI can take. All the sample I've seen so far have been very simple, like a simple measure expression, e.g. [Measures].[Internet Sales Amount] I've also had success specifying a simple tuple, e.g. ([Measures].[Internet Sales Amount], [Product].[Product Model Lines].[Model Name].&[Bike Wash]) But what if I want something more a little more sophisticated For example, what if I want ...Show All

• Visual C# SQL Server on C# question

  Hi, I want to be able to run, pause or stop a SQL Service (as in SQL Server Service Manager) from within a C# application. How can I do this The server I'm using is called DEANHPLAPTOP. I'm sure this can be done through the command line somehow in DOS but how can I do it in an application The end result I want is to have it so that the first form in the app (login form) starts the service if it's not already running and then stops it when t ...Show All

• Visual Studio Source control.... repository design

  How does your team go about designing your Source Safe trunks Personally, we're having issues figuring out how to properly model a project in VSS to allow for "snapshot" views yet allow us to continue building towards releases. For example, how would Microsoft setup a VSS design around a product like Windows I mean, you've got 5,000 developers all hitting the same repository in theory and all working in the same "version ...Show All

• SQL Server Sql date substract question

  Hi everyone, I need to substract one day from de system date(yesterday). example: execute spGetCustomers GetDate()-1,null,null --system date less one day(yesterday) Can someone tell what is the SQL sintax to do that. Thank's Hey, Your example itself is right !! you can use getdate(). anyways, this is the syntax. dateadd(dd, -1, getdate()) Amarnath ...Show All

• Windows Forms DataColumn.Expression IIF problem

  I am trying to create an expression column in a typed dataset as follows: dcC.expression = "IIF(dcA=0,0,dcB/dcA)" but when I do this I get a 'System.DivideByZeroException'.  Apparently, both the truepart and falsepart of the IIF are being evaluated for e ...Show All

• Visual Studio Team System Workitem to Workitem Transition

  I want to customize my Agile Workitem Types so I can be able to do workitem to workitem transition in such a manner: I have a "Customer Inquiry" type with the following states: Open Closed What I want to be able to do is create the following transitions: <empty> ==> Open (New) Open ==> Closed (Answered to the Customer) Open ==> Closed (Bug Detected) ==> New Bug Workitem with the information pro ...Show All

• SQL Server SQL Server 2005 SP1 Webchat on March 22nd 9:00 am PST

  We will be hosting a public web chat discussion: March 22 nd 9:00 – 10:00 am PST about the March CTP of SP1. It is the customers’ opportunity to engage with the dev team and provide feedback and ask questions. Strong participation from customers will act as a motivator for stronger participation by the dev team and will increase their interest in having these in the future, so we urge you to join and participate. For more information ...Show All

• .NET Development OleDbConnection Access 2003 Query Default Parameters?

  I am trying to construct an Insert query in Access 2003 which will be called using C# and an OleDbCommand object in stored procedure mode.  I am having trouble finding out how to set default parameters on the PARAMETERS line in order to allow a parameter to be optional. Also, will hitting the connection next with a "SELECT @@IDENTITY" return the new record ID of the inserted record   As I understand it this would need to be a separate ...Show All

• SQL Server ETL using SSIS

  Hi guys, I have been able to put together a simple SSIS package and familiarize with how it works. Now as I am trying to put together this ETL job I am stuck and am looking for some recos: I need the source system to be able to do a join on my Datawarehouse table and push thru only those rows which I am interested in. Can this be done using one of the Data flow task Presently we do it by using staging area, creating temp tables, doin ...Show All

• Architecture which politics do you prefer for exception and logging?

  Just for creating a little debate and learn a little. ...Show All

• Software Development for Windows Vista hiya my first post and just got invited to the beta from technet =)

  hiya I was wondering can I dual boot Windows Vista and Xp on a single hd cause I have a 1 year old hornet pro with a 250gb hd ATI Radeon X1600PRO 512mb agp version, 1gb of ram, ATI HDTV Tuner will that tuner work with vista as well with their tv software if the beta comes with it and my cpu is a p4 2.8ghz 800fsb and I did a beta scan and it says my system can run it =) please lemme know if I can dual boot without having to format the whole if I ...Show All

• Windows Forms Code Downloads? Animal Farm?

  I did some looking around and found out that alot of developers were going to release or have released their old source code   I read this from the old message boards for Terrarium   Did this happen or not yet   I'm wondering if  ...Show All