Alastair Q's Q&A profile

• .NET Development How do you open an ADODB.recordset using a ADODB.Command on stored procedure in ASP.NET???

  I'm updating my 'classic' asp to aspx (what fun ) Perfectly good code doesn't work now e.g. Dim cmd cmd = Server.CreateObject( "ADODB.Command" ) Dim RS RS = Server.CreateObject( "ADODB.Recordset" ) With cmd .ActiveConnection = Con .CommandText = "sp_CategoryTreeClimb" .CommandType = 4 .Parameters.Append.CreateParameter( "@ID" , adInteger, adParamInput, , ID) RS = .Execute End With If Not RS.EOF And Not RS.BOF Then etc.... I get the cryptic 'System.Reflection.TargetParameterCountException: Number of parameters specified does not match the expected number' error They bloody did! They Bloody do! What new wrinkle do I need to m ...Show All

• Visual Studio Debugger starts and stops without running application

  If I create a new project (i.e. Windows Application), put a button on the form and then try to start the debugger, it will "start" and "stop" within a second or two. No form is displayed. If I run it outside the debugger, no form is displayed. If I add code behind the button and try to set a breakpoint, it is ignored. This occurs for both Visual Basic 2005 Express and Visual C# 2005 Express. Any ideas The exit code is -1073741819. In the knowledge base, the error code exists for other applications, but not for Visual Studio. ...Show All

• Visual Studio Team System Removing 'invalid rows' from query-result list

  I'm using the following code to get the number "developer hours by week" (slightly modified version of http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=326021&SiteID=1 ) . WITH SET [ValidRows] AS ' { FILTER ( NONEMPTY ( ( [Assigned To].[Person].[Person], [Work Item].[System_Id].[System_Id], [Work Item].[System_WorkItemType].[System_WorkItemType], [ Work Item].[System_Title].[System_Title] ), {[Measures].[Current Work Item Count]} ), [Measures].[Completed_Work] <> 0 ) }' MEMBER [Measures].[Completed Work On Period Start] AS ( (STRTOMember(@prmStartDate)), [Measures].[Company_Common_ActualTime] ) MEMBER [Measur ...Show All

• Windows Forms Encrypted .msi file results in installation failure

  Why is this Is it a bug If I unencrypt the .msi file, the installation proceeds normally, otherwise I get failure message 2755. Looking in the installation log, I was able to find a "failed to open stream" error which may be at the root of this. Thank you, Stefan. However, this raises another issue: When I search on msdn using the keywords "installer encrypted msi", as I did when trying to research this problem, the kb page you reference does not come up as a hit. Is the KB excluded from searches by default ...Show All

• SQL Server SQL Server 2005, replication and websync setup problem

  Not sure if this is the right place, but ill give it a try.. Everytime i try to make a websync for my replications i get this error and then it rolls back everything: =================================== The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib) ------------------------------ Program Location: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at Microsoft.Win32.Security.Win32Helpers.UnsafeSetNamedSecurityInfo(String objectName, SE_OBJECT_TYPE objectType, SECURITY_INFORMATION securityInfo, Sid sidOwner, Sid sidGroup, Dacl dacl, Sacl sacl) at Microsoft.Win32.Security.Win32Helpers.AddEveryoneToShare(String share) at Microsoft. ...Show All

• Visual C# foreach in C#

  Hi, I use C# in ASP.NET . 1. What is "foreach" and how can I use it 2.How can I have a collection of controls that are in a web page and use it bye Matthew Watson wrote: RizwanSharp wrote: foreach is not as good as other loops in its efficiency. That is completely untrue! In fact, the performance of foreach is usually as good as or better than other loops! This is because the compiler understands intimately the mechanics of foreach, and it is therefore often able to apply optimizations that are not possible for "hand rolled" loops. Here's some sample code: private void button1_Click_1( object sender, Ev ...Show All

• Visual Studio Team System Is anyone answering?

  Hi, Just wondering if anyone is actively answering questions on this forum That isn't meant to be rude or rhetoric, I genuinely want to know. Because if no-one is then I shant post any more questions. If the people that normally answer questions are currently too busy then that's fair enough! I know that nobody is required to answer questions. -Jamie Hi Jamie, Absolutely we are actively trying to answer questions on this forum. There is an email every morning that tells us what questions are new and what questions are still unanswered on the forum. Right now the product team is heads down working to get the next CTP and the V1 of the product out by the end of the year. There has recently been a big push to ...Show All

• SQL Server Using Except function without aggregation (ssas 2005)

  Hello, I recently got help in getting the except function to work... Here is the solution provided by Deepak. (The requirement is to calcuate active head count of employees excluding two departments) SUM( Except([dimensionEmployee].[Employee Department].[All].Children, { [dimensionEmployee].[Employee Department].&[Services], [dimensionEmployee].[Employee Department].&[Leadership] }), [Measures].[Active Employee Head Count]) Now, how do I get the except function to work "without" the aggregation Any help is greatly appreciated.. Thanks, Ganesh PS: here's another version of the Adventure Works sample, which excludes 2 specific members: Accessories and Clothing, without using Vis ...Show All

• Visual C# save datagridview contents to access database

  Can someone please show me how to dump the contents of a datagridview into a programmatically created access database When I click a save button, an access database is created to hold the contents of datagridview1, with fields named according to datagridview1's column headers.. Thanks for any help Hi, You have to bind the dataset's content to a dataset through the binding source object and call the table adapter's Update method. If you also want to know how to create a new access db on the fly look into ADOX: http://www.4guysfromrolla.com/webtech/013101-1.shtml A whole bunch of good resources, including numerous books, that could really help you out: ASP.NET 2.0: http://quickstarts.asp.net/Q ...Show All

• SQL Server configuration manager Build property

  Our SSIS project's Configuration manager "Build" property gets mysteriouly check marked to true - even though we checkin with false into TFS. We tried repeatedly but most of the time it gets checked. Why is this happening ...Show All

• Visual Studio Sandcastle - Links to inherited framework members not working on my system.

  Hello All, I would appreciate some feedback on the following issue I am having with the latest version of Sandcastle. I am either doing something wrong or there would appear to be an issue with the latest sandcastle release. When I use sandcastle ( latest release ) to generate a help 2.0 .HXS file I have noticed that when I integrate it into Visual Studio 2005 - using the help integration wizard supplied in the SDK - I seem unable to get to inherited members from the Framework when I click on them. When I look at my classes they contain inherited members like GetType(), Equals(Object) which are all inherited from the Object() class. When I click on them I get a page displayed saying "Information not found". I am sure on pre ...Show All

• SQL Server Page width and height setting problem

  We have a problem in page layout. From the report properties, we set the page width and length. But previewing the page finds the page is much longer than setting in the properties. Exporting the page to PDF gets different page size. That totally messes up our page number. Anyone had this problem before and knows why. I appreciate it if anybody can help. Thanks. The pagination system is different between the different renderers. HTML is a "soft" page layout -- in other words, it will try to use the interactive page size, but will expand as needed to accomodate objects on that page and to avoid splitting objects. PDF is a physical page layout; the page size is fixed and we cannot expand it, s ...Show All

• Visual Studio 2008 (Pre-release) Does vNext support nested typed queries?

  I was playing with vNext trying to figure out how does it handle object identity and found out that following construction always throws exception ("invalid command format" on the second foreach) var query1 = <select> var query2 = <select> (exactly the same as query1) foreach (QueryObject object1 in query1) foreach (QueryObject object2 in query2) { if (object1 == object2) Console.WriteLine( "tada" ); } Hello, What are you running your query against Is the db.Shipment an Entity Model, or a dataset Thanks, Erick ...Show All

• SQL Server components Design state or Running state

  Hi, I am doing a custom destination transformation, How would I know wether the Destination component is in Design state (getting edited by BIDS) or wether the component is getting executed(by BIDS or DTEXEC) Is there any property or ENUM by name DesignState. Thanks Dharmbir ...Show All

• SharePoint Products and Technologies Lookup fields in asp:wizard control

  I'm using SharePoint Designer 2007 and am trying to create an custom "insert.aspx" page where the user will enter data and then save it to a SharePoint list. I'd need to provide some lookups (from existing SharePoint lists) for the user to make the UI more user-friendly. Since SparePoint Designer doesn't support lookup lists (joined tables) for insert forms, I decided to use the asp:wizard control. So I've tried two things unsuccessfully and am looking for help. 1. I inserted a data view outside the asp:wizard control and configured it to grab my lookup data and display it in a dropdown. However, when I view the page in design, I get the following error: Type 'Microsoft.SharePoint.ProxySupport.C___165' does not have a ...Show All