Anderss22's Q&A profile

• SQL Server Gap filling in a time series

  Hello, I am new to SQL Server and learning lots very quickly! I am experienced at building databases in Access and using VBA in Access and Excel. I have a time series of 1440 records that may have some gaps in it. I need to check the time series for gaps and then fill these or reject the time series. The criteria for accepting and rejecting is a user defined number of time steps from 1 to 10. For example, if the user sets the maximum gap as 5 time steps and a gap has 5 or less then I simply want to lineraly interpolate betwen the two timesteps bounding the gap. If the gap is 6 time steps then I will reject the timeseries. I have searched the BOL and MSDN for SQL Server and think there must be a solution using the PredictTimeSer ...Show All

• Visual Basic Grabbing file name and path of open files

  Is there a way to write a list of all paths and file names of currently open files. The best I can do is use the System.Diagnostics.Process class to grab the processes of the applications in which I am interested and then get the file name from the main window title for each process. There is no way to get the path for these files, however, with this approach. Thanks for the help!! Process . MainModule . FileName ()'returns full path and name of main module in the process...usually the executable... Process . StartInfo . FileName () Process . StartInfo . WorkingDirectory () ...Show All

• Software Development for Windows Vista "unidentified publisher" problem

  OK, using the final release of Vista, we decided it was time to test our software running on it. We noticed something strange and can not figure out why it’s happening. Some of the executables prompt the user with the "unidentified publisher" screen, which our users would prefer not to see every single time you run that application. That aside, some of the executables don’t ask if they are allowed to run, the screen just pops up. Great, we would like all of them to behave like that. So why do some executables prompt the user for permission and other don’t (None of our executables are signed) I did get the ones that prompted for permission, to stop prompting. I recompiled the app with a smaller file name. Eac ...Show All

• Visual Studio Express Editions commands

  where do i go to learn about all the vb commands, as i read these posts i am learning about commands that m books dont tell me about. how can do somethhing if i dont know the commands. things like accept and so on   SJWhiteley wrote: These aren't commands but methods of an object (presumably). You need to understand the Object Oriented structure of the language and, indeed, how windows works. There is no such place which simply 'lists' all these 'commands' (except the documentation). [ /quote]   ...And I gave you the links to the documetation!!! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I restructure the default directories to allow for easy distribution?

  First off, let me just say "good job, well done" to the people responsible for getting XNA up and running. It's incredibly easy to get a project started and working with MSVC# 2005 express, however, I think the directory structure could be improved to allow easy distribution of files. The way I see it a project consists of three types of files, and at the moment the default behaviour of MSVC# is to mix them up, making it difficult for hobbyists to work and share with other hobbyists and the XNA community. If the directory structure was changed slightly, then it would allow bulk copying a viable distribution solution. The three types of files are... Source Files: These are the files that are required to build the project, they inc ...Show All

• SQL Server ws_ftp 2007 pro corrupting downloaded files

  Am running ipwsitch's ws_ftp 2007 pro software on windows 2000 platform on a network. . Trying to download a 17.4mb zipped file via FTP. File comes across to my environment but is corrupt - when attempting to unzip it. Transfer mode being used is BIN and not TXT. Any suggestions This is a Microsoft SQL Server Integration Services forum. What does your issue have to do with SSIS Please ask in a more appropriate forum somewhere on Ipswitch's website or on the Internet. ...Show All

• SQL Server Set QUOTED_IDENTIFIER and ANSI_NULLS on all objects...

  Is there any way via T-SQL to run through a database and ensure that QUOTED_IDENTIFIER and ANSI_NULLS is set for all stored procs and functions etc on a database without having to recreate every proc / fn The reason this is an issue is I'm trying to take advantage of indexed views to get a performance increase in an application - but not all of the procs/fn's have historically been created with ANSI_NULLS and QUOTED_IDENTIFIER set - so any proc that's not set correctly will fail once the indexed view has been created. I could I suppose, script out all the procs / functions and do a bit of search and replace to ensure that these are set correctly by recreating all procs and functions - but I'm trying to avoid doing that as I've over 500 da ...Show All

• Visual Studio [Add-in using VC/ATL] How to Get Notified by "Build Begin" Event?

  I'd like to be notified when the build begin event is triggered. There are samples for such kind topic, but they are written in C#, VB... Could you tell me how to do it in unmanaged C++ (Add-in using VC/ATL) It seems that unmanaged C++ for Add-in has been forgotten by MSDN... I've studied it for some time, the following seems to be the solution, but still it doesn't work (the function OnBuildBegin & OnBuildDone are not triggered), could any one help me finish it class ATL_NO_VTABLE CConnect: public IDispatchImpl<EnvDTE::_dispBuildEvents, &EnvDTE::DIID__dispBuildEvents, &LIBID_EnvDTE, 7, 0>, ... { BEGIN_COM_MAP(CConnect)  COM_INTERFACE_ENTRY(EnvDTE::_dispBuildEvents) ...Show All

• Software Development for Windows Vista How to grab all desktop content , not using GDI GetDC(NULL) & BitBtl?

  Does anybody know, how to get all desktop (Screen) content - screen shot - without accessing GDI functions (like GetDC(NULL) & BitBtl), because know thay are having lack of perfomance, and not hardware accelerated. I wrote test application for comparsion - in WinXP, that grab screen via GetDC(NULL) & BitBlt for offscreen HDC, and have about ~400 per second grabbings with 1-2% CPU overload. And then try to run it on Vista. And how do you think Whay did I get About 7-9 grabbings and 80% CPU load. It's not the way I want to grab the screen anymore. I have tryed to know how do it with DirectX. But it seems there no way to get WDM's primary surface (Windows Desktop Manager), which do a lot of visual of Aero. I can get thumbnail ...Show All

• Windows Forms ListView problem : overlapping items (c#, .net 2.0)

  Hi everyone. I've encountered following problem with list view - i wrote user control that has listview and 2 buttons. ListView has next settings : this.listViewDocuments.Anchor = (System.Windows.Forms.AnchorStyles)(AnhorStyles.Top | AnchorStyles.Bottom | AnchorStyles.Left | AnchorStyles.Right); this.listViewDocuments.BorderStyle = System.Windows.Forms.BorderStyle.None; this.listViewDocuments.HideSelection = false; this.listViewDocuments.Location = new System.Drawing.Point(0, 0); this.listViewDocuments.MultiSelect = false; this.listViewDocuments.Name = "listViewDocuments"; this.listViewDocuments.Scrollable = false; this.listViewDocuments.ShowGroups = false; this.listViewDocuments.Size = new System.Drawing.Size(304, 88); this.listView ...Show All

• Smart Device Development How to use bluetooth on emulator??

  I want to develop a program with bluetooth communication, I have already installed the bluetooth usb dongle on my pc, and ActiveSync 4.2. But I don't know how to connect the vs2005 emulator to bluetooth or how to map serial ports. would anyone help me how to do that in detail Thanks a lot! XRobin Your options are limited and outlined here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=351399&SiteID=1 ...Show All

• Architecture Recurring Appointment Database Storage

  Hello, I am writing an application that handles scheduling of appointments. I will need to support recurring appointments and I anticipate performance problems should I go about this naively. I believe my task is pretty simple to explain. One query might be to retrieve all appointments within a week. Or, all appointments within a month. Of course, these queries should combine results for single and recurring appointments. Specifically, I think I should be trying to avoid calculations within my select statement when I retrieve information from the database. So, I'm wondering if anyone has suggestions on how/what data should be stored to ensure my queries are optimal. Thanks in advance for any helpful suggestions! Ya ...Show All

• Visual Studio Team System TFS Server SP1 Install failed, error code 1603

  I attempted to install the final version of the VS 2005 SP1 for Team Foundation Server. First I installed the quiescence patch that the installer required, rebooted the server, then restarted the SP1 installer. After ~3 minutes, it was saying "Please wait while Windows configures Microsoft Visual Studio 2005 Team Foundation Server - ENU" and indicated Time remaining as 0 seconds. About 9 minutes later, the progress bar shrank back to nothing, the progress dialog closed, and that was it. The Application log had an Error, Source:MsiInstaller, with a description that began, " Product: Microsoft Visual Studio 2005 Team Foundation Server - ENU - Update 'Microsoft Visual Studio 2005 Team Foundation Server (databases) - E ...Show All

• .NET Development InnerXml property generates blank namespaces

  Hi, I've got some problem while generating some Xml code with the InnerXml property. After doing "myNode.InnerXml = ..... ", my Xml code has som blank "xmlns" attributes in the node added by this way. Here's an example : XmlElement destNode = doc.CreateElement( "destination" , XPath .JOB_NAMESPACE); XmlAttribute typeAttr = doc.CreateAttribute( "xsi" , "type" , XPath .SCHEMA_NAMESPACE); typeAttr.Value = BROADCAST_OUTPUT_TYPE; destNode.Attributes.Append(typeAttr); destNode.InnerXml = "<listenAddress type=\"string\">Automatic</listenAddress>" + "<listenPort type=\"uint\">" + bOutput.Port ...Show All

• Visual Studio Express Editions When press Enter, how run function and focus next control?

  My aspx page as below: write code in C# ( in asp classic i do it easy). < tr > < td style ="width: 47px"> < asp : Label ID ="Label1" runat ="server" Text ="Tel 1"></ asp : Label ></ td > < td style ="width: 100px"> < asp : TextBox ID ="TextBox1" runat ="server"></ asp : TextBox ></ td > </ tr > < tr > < td style ="width: 47px"> < asp : Label ID ="Label3" runat ="server" Text ="Old Cus"></ asp : Label ></ td > < td style ="width: 100px">XXXXXXXXXXXXXXX ...Show All