Terence Curd's Q&A profile

• SQL Server Problem with reportfooter and header

  Dear sir, i am developing reports in sql server businessintelligence development studio...i deployed the reports in reportserver and i was able to see it..but my requirement is all my reports should have the same header and footer as of all other pages must uses custom footers and headers....hw to use thatcustom footer and header in my reports Regards, Pradeep dear , other than reports pages i have some other pages in that footer and headers(company logo and the project name like that)...i want o use the same thing in my reports ...Show All

• SQL Server Cumulative aggregation over time

  I want to do cumulative aggregation similar to "period to date", but not to a specific period in the past, but to the earliest record in the fact table. The problem is that I have 20 million accounts that I want to follow up on a daily basis, but they change rarely. After a year, perhaps half a million have changed. What I have done is to create a fact table that stores the balance when the account is opened, then only keeps track of the changes, so that when anyone deposits money a row is added with the increment. After a year that would give me about 20.5 million rows in the table. As an analyst I would like to enter a specific date, say 2005-08-20 and see the balance of all the accounts at that time. To do so, I simply need to ...Show All

• .NET Development SerialPort ObjectDisposedException

  I use serialport on a form to communicate with serial port scanner. Sometimes(not always) I get this error: System.ObjectDisposedException was unhandled Message="Safe handle has been closed" Source="System" ObjectName="" StackTrace: at Microsoft.Win32.UnsafeNativeMethods.GetOverlappedResult(SafeFileHandle hFile, NativeOverlapped* lpOverlapped, Int32& lpNumberOfBytesTransferred, Boolean bWait) at System.IO.Ports.SerialStream.EventLoopRunner.WaitForCommEvent() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Seriaport ope ...Show All

• Visual Studio Reacting to Tools->Options changes in custom project

  Here is my scenario, I have a custom project and have also implemented some custom Tools->Options pages. Some of those options in the pages I created can deal with how the project is to be displayed. What I am having a hard time finding a way to do, is react when the Tools->Options page is closed. I've tried looking for a command that may come into the projectNode from one of the Exec() statements with no avail. I also tried going through the DTE.Solution.Projects list on save of my options to see if any of my projects are in the solution. The issue here is that all of my projects come back as ComObjects that I can't cast into my project type to call a method on my project to refresh its view. I'm assuming there is a way ...Show All

• .NET Development Uninstalled IIS due to corruption then reinstalled IIS - What issues may I encounter Please Help!

  I have Uninstalled IIS due to corruption then reinstalled IIS. Currently I have Microsoft.Net FrameWork 1 + 2 installed on my system, as well as Visual Studio 2005 Pro and SQL Server 2005 Express Edition. Also I have Borland Delphi 7 and Coldfusion MX 7. Coldfusion has already problems, and wont load the .cfm extensions so I have had to Uninstall and reInstall this to get it to work correctly. I have noticed that some of the Quickstart pages associated with .Net Framework 2.0 and ASP.net wont load - when their web address points to my localhost already. Is there a way to repair these installations. Can I expect more troubles with my other Microsoft Installations because Of the uninstallation, Reinstallation of IIS . Please any ...Show All

• Visual Studio Tools for Office Best Practice for XML Schema Library?

  Hi, I have developed a VSTO Word solution. The solution is a proof-of-concept to check how things work with VSTO. That is, validate that the way we would like to do things, actually works. The document includes XML fields, which VSTO uses to insert data into the document, and to receive some events from. But, when i get some other users to test the document, they (of course) does not have the schema in their schema library, and thus i receive some "XML element cannot be applied here" errors, and some validation errors. My question is - what is best practice here 1. Is it to get my VSTO code to add the schema to the library, if not present 2. Is it to get the IT department to push registry settings to a ...Show All

• SQL Server CLR integration - Could not find Type '??' in assembly '??'.

  Hi, I'm new to Integration services and .Net programming but am trying to create a dll that I can access from Sql server 2005. The dll read's an xml file and carries out some processing. I've run the code as an console app and it works fine. I have created the assembly in sqlserver thus: create assembly PinCodeLoader from 'C:\PinCodeLoader\PinCodeLoader\PinCodeLoader\bin\Debug\PinCodeLoader.dll' with permission_set = external_access But when I try to reference the assembly from a stored proc create procedure dbo.interface_processPinCodefile(@filename nvarchar(1024)) as EXTERNAL name PinCodeLoader.PinCodeloader.Main I get the following error: Msg 6505, Level 16, State 1, Procedure interface_processPinCodefile, Line ...Show All

• SQL Server SessionTrace during XMLA execution?

  Hi all! I wrote a command line tool that processes a SSAS cube/dimension. At the moment the tool starts processing similar to: using Microsoft.AnalysisServices; olapsrv = new Server(); olapsrv.Connect(@"SERVER/DATABASE"); Database mydb = olapsrv.Databases["NAME"]; Cube mycube = mydb.Cubes.FindByName("CUBENAME"); mycube.Process(ProcessType.ProcessFull); it is possible to trace the server output with: olapsrv.SessionTrace.OnEvent += new TraceEventHandler(DefaultTrace_OnEvent); olapsrv.SessionTrace.Stopped += new TraceStoppedEventHandler(DefaultTrace_Stopped); olapsrv.SessionTrace.Start(); the two functions can write the "feedback" to a ...Show All

• Windows Forms How To Bind DataGridView

  Hi PPL, I want to Bind the DataGridView to DatSet. By :- DataGridView.DataSource = DataSet.Tables(0) i can display the record on DGV but i want to bind it to DataSet So i Change the possition on record pointer by clicking the buttons ei. [top] [next ] [prev] [bot] . plz give me code for this. ThnX in Adv. Regards HuNTeR ThnX Ken It Works Fine i did add some extra lines to ur code i got want i want. but let me know its right way for this or not. i want to create a search form DGV is used for dispaling the records. & TextBox is used for Enter ring the values filtering the records. by staying the control at text box user can move the record pointer up & down. by using the keu_Down method of text box. Private cmd As ...Show All

• Visual Studio Express Editions help splitting text

  I need some help splitting up some text that looks like this BOS DH 34 or other ways like (3 chars) *blank space* (2 chars) *blank space* (1+ chars) the last set can be a single digits or 2 digits. thanks for the advice Like so Dim s As String = "BOS DH 34" Dim textParts As String () = s.Split( New [Char]() { " " c}) -- SvenC ...Show All

• .NET Development event log messages mysteriously disappear ??

  i got a  problem which some of the event log message does not appear on the event viewer It could be due to server load or some message is dropped. Can this issue be solved Or is there a better way to do it. See the below source code.and comments. #region Method : LogEvent public static void LogEvent(string eventLogSource, string message, int eventID) {     try     {         System.Diagnostics.EventLog.WriteEntry(eventLogSource,             message,             System.Diagnostics.EventLogEntryType.SuccessAudit,       &nbs ...Show All

• SQL Server SQL Express and SQL 2005 developer edition on same machine

  Hello, I am wanting to setup both SQL Express and SQL 2005 developer edition with visual studio 2005 professional on the same machine and want to make SQL dev edition the default local accont to where I can set the sql connection to server=localhost. Is there a way to do this Thanks So, I then should proably install SQL 2005 dev as default instance, then go ahead with the visual studio 2005 pro with SQL express installation after, correct Also, I am seeing this in the IIS ASP.net configuration settings connection string data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true. I am assuming that sql express is the default server. ...Show All

• Visual Studio Team System Get latest version vs get specific version

  Im getting some feedback from users who have complained that they are not seeing the latest version of source files or in some cases if a person has created a new file and checked it in to source control it cannot be seen unless a Get Specific Version (force get) is issued. Im just wondering if this is how Get latest version and Get specific version are supposed to work and how should users approach bringing down files especially when they start their day in a shared environement. Thanks Aaron Thanks for the reply. I had a person create and add a file to source control and another user did not see this file when he did a get latest version only after doing a get specific did he see it. I was just t ...Show All

• Visual Studio Invalid DOS Path: T:\VSS\activity.log

  Hi all, I have Visual Source Safe 2005 installed locally on my PC and the srcsafe.ini and database (etc) are all located on a LAN server. I am attempting to add files by dragging and dropping from Windows Explorer into a folder in Source Safe. Every time I add a new file I get the error message "Invalid DOS Path: T:\VSS\activity.log". T:\VSS\activity.log is the server path to the srcsafe.ini file, the activity.log, and so on. I have read/write/access permissions to T:\VSS and I am able to actually get to T:\VSS via explorer and modify and save activity.log manually. This is driving me nuts, as I am trying to add a whole heap of files into Source Safe (its not connected to Visual Studio by the way) and having to click ...Show All

• Internet Explorer Development Is there a profiling tool for IE rendering times?

  Hi there, does anybody know about a tool which measures and lists the processing times of the Internet Explorer rendering engine for a HTML page I am interested in such a tool for doing a fine tuning analysis on my company's web applications. I don't know very much about the details of IE. But it is natural that there must be a library or "engine" responsible for parsing and rendering of the HTML code as part of the IE distribution. It would be a valuable tool if this library existed in a modified version, tracking one after another all the different tasks on a fine level. With such a tool, one could understand for each tag of the page: How much time does the rendering cost Does a page element force a re-rendering of the page o ...Show All