curt2go's Q&A profile

• Visual Basic Simple question - help please and thank you.

  Hey, I am calculating simple monthly returns on a series of daily asset prices for a number of years worth of data. The problem is I am not sure how to indentify the end of a month, and the start of the next in a column of 05/01/2006 format sequential dates. I could just add another column and use the "month" function in excel (what I have done thus far),  but I have to do the whole operation in VBA. What I have now is: If ActiveSheet.Cells(dayofmonth, 1) = ActiveSheet.Cells(dayofmonth - 1, 1) Then day +1  and continue till they are different etc...... The first column is a single number derived from a = month(date column) formula This unfortunately will not cut it. I want to be able to do the same o ...Show All

• Visual C# Converting a string to a datetime

  Here is what I'm trying to do: ----------------------------------------------------- string strTime = "20060801" ; DateTime dt = Convert .ToDateTime(strTime); ----------------------------------------------------- This of course gives me the following error: String was not recognized as a valid DateTime. What is the best way to take a custom string like that mentioned above and convert it a datetime so I can use c#'s built in datetime functionality try using tryParse to see if it can be parsed into Datetime:   string strTime = "20060801"; DateTime result; if (DateTime.TryParse(strTime, result)) {    //we have our result stored in result varia ...Show All

• SQL Server custom code in report

  hi friends i wrote following custom code in report to hide/unhide a textbox in report Public Function CheckVisibility(ByVal value As String) As Boolean If value.tostring().length > 0 Return False Else Return True End if End Function but i dont see this function when type in "code." in expression box am using VS2005 standard edition, is it a restriction for this version Functionality is the same for custom code in local mode as it is in server mode (disregarding the different environments); it will just not show up in intellisense, since the designer does not parse the code. ...Show All

• SQL Server Vista IIS7 and asp.net reporting services wont deploy

  I am using vista, iis7 sql server 2005 sp2, vs 2005. i first noticed that i could not deploy to the localhost server after upgrading to vista. i installed sql server sp2 and configured the iis7 using the control panel. Everything i needed to check off got loaded exept the asp.net check box in the ApplicationDevelopmentFeatures subcategory under the iis configuration section. It errored out when i clicked apply. there was no specific error just that it did not get added. Controlpanel> Programs>T urnWindowsFeaturesOnAndOff> InternetInformationServices> WorldWideWebServices> ApplicationDevelopmentFeatures> Asp.net (check box) When i click OK, afte a few minutes, i get a message: "An error has occur ...Show All

• SQL Server Show only the five first...

  Hi!! I have a bar chart and the data are agrupped by Folders (Category groups) and by FileType (Series Groups)... I want to show only the 5 folders with the biggest amount of files... how i could do it All suggestions will be wellcome... Thx!! Sorry Ian... i mean, which is the purpose of the operator "Top N" in the filter of a chart if I can’t use it to show the five first elements Sergio ...Show All

• Visual C# Problem with winspool OpenPrinter DllImport in 2005

  Hi, i have a component which scans the spooler of a printer. in Framework 1.1 it works fine but in 2.0 i got the following exception when i open the printer: PInvokeStackImbalance was detected Message: A call to PInvoke function 'Dornbracht.Odis.Server.PdfPrinter!Dornbracht.Odis.Server.PdfPrinter.Spooler.PrinterSpooler::OpenPrinter' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature. My import looks like that: [ DllImport ( "winspool.drv" , CharSet= CharSet .Auto, SetLastError= true )] static extern int OpenPrinter( string pPrinterName, ...Show All

• .NET Development Multithreading problem for multiple methods (Semaphore)

  Hello I have this problem. I use a class that has some methods in it that runs concurrently (Another object manages many instances of this class). Here is the constraint:- method1() can run up to 10 threads at a time method2() can run up to 5 threads at a time if there is method1 running (even only 1 thread), method2 cannot run. if there is method2 running (even only 1 thread), method1 cannot run. Anyone has a solution to this problem for method1 and method2 themselves to run up to 10 and 5 threads, I can control using semaphore but how to do mutual exclusion between method1 and method2 Thank you Pi. But if so (using mutex to block inside method1 so another thread cannot call method2), another thread can ...Show All

• Visual Studio 2008 (Pre-release) Suggestion: Can TextSearch be improved to support to search string of other language?

  Chinese seems not to be supported currently. Hope so. I tried the Chinese version of Markup below, and it works fine. If you still have problem, could you post the markup Thanks. <Canvas xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:sys="clr-namespace:System;assembly=mscorlib" xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " > <ComboBox IsEditable="true" Width="100"> <ComboBoxItem>二中 一</ComboBoxItem> <ComboBoxItem>不幸</ComboBoxItem> <ComboBoxItem>一段情 </ComboBoxItem> <ComboBoxItem> 特的</ComboBoxItem> <ComboBoxItem>明白的</ComboBoxItem> </ComboBox> & ...Show All

• SQL Server Calculated Measure does not appear in all the drilldowns

  Hello, I created a hierarchy [Time].[Year-Month] that has the following -Year --Period ---English Month I want to return the headcount from the 1 st Period only. This works fine. I did it by making a new measurement called LastActive by using the LastNonEmpty aggregate function. I then made a calculated measure called BeginHeadCount as the following: ([Measures].[LastActive], [Time].[Period].&[1]). This works OK, sort of. When I browse the cube, and I put the [Time].[Year-Month] hierarchy on the columns I don’t see the BeginHeadCount for each English Month, but I do see it for the totals. For example, I see the BeginHeadCount for the Year, then I hit the + and drill-down to the Period, I see it ...Show All

• .NET Development Marshalling structures with variable-length inline strings

  Greetings, I'm having trouble solving a pinvoke marshalling challenge in C#. I need to call an unmanaged API function which expects a structure containing a variable length inline string. Here's the unmanaged function prototype (from MSDN): BOOL SetupDiGetDeviceInterfaceDetail ( HDEVINFO DeviceInfoSet, PSP_DEVICE_INTERFACE_DATA DetailInterfaceData, PSP_DEVICE_INTERFACE_DETAIL_DATA DeviceInterfaceDetailData, DWORD DeviceInterfaceDetailDataSize, PDWORD RequiredSize, PSP_DEVINFO_DATA DeviceInfoData); The troublesome guy is the third argument, DeviceInterfaceDetailData . Here's its definition (again from MSDN): typedef struct _SP_DEVICE_INTERFACE_DETAIL_DATA { DWORD cbSize; TCHAR DevicePath[ANYSIZE_ARRAY]; } SP_D ...Show All

• Visual Studio 2008 (Pre-release) ClickOnce Installation

  How to create a Click-Once Installation for a WPF Project and Including all the application folders and Dependencies like dlls of other projects If you have a WPF browser app, this is done for you by the project system in VS. So those apps are ClickOnce-deployed apps out of the box. If you have a standalone app, you need to set <GenerateManifests>true</GenerateManifests> in the project file, or alternately, do this via the VS project properties UI. When you include files into your project and declare them as Content or Resource, you don't need to worry about handling the deployment aspect for these files. That's taken care of for you by the WPF build system. ...Show All

• SQL Server replication hangs on one table

  publisher - sql2000 sp4 distributor - sql 2005 sp1 subscribers - mix of sql2005 sp1 and sql 2000 sp4 we have a database with around 300 tables and replicate it to around 10 different subscribers. some in the same datacenter and others in different offices. We have around 50-60 different publications for this. Some have 20 or so tables others have only one table if they are large tables. Tables range in size from a few hundred rows to over 20 million. Some tables replicate a few commands, others 100000 or more commands on a daily basis. Around 6 weeks ago we started having problems with one table. It's 1.4 million rows and replicates around a few thousand commands on a daily basis. We saw a backlog of around 150000 to 400000 commands. We ha ...Show All

• Visual Basic Progress Bar/Loading Bar To Perform gif Update

  Hi all, I am just a new member here. Hope that my English will not give you an uncomfortable feeling ^^|| Actually, a month before, I was trying to implement a progress bar( some may call it loading bar) form so that when the Main Form/Main Thread is doing a Time-consuming tasks or thread-blocking tasks, it can display to the user and asking them to wait for a while. The problem was that I put a gif file into the picture box and the gif was an animation, the gif was not "animated" until the Main Form/Main Thread finished the tasks. Here is just a little code: Private Sub StartTasks() ' Create And Show Loading Bar Dim frmLoading as new LoadingBar frmLoading.Show() ' Start To Do Time Consuming Tasks ...Show All

• SQL Server Force to complete query, ignore errors

  Hi, I have a big table and want to make a plausibility check of it’s data. Problem is, that my query stops, if there is an unexpected datatype in one of the rows. But that is it, what i want to filter out of my table with that query and save the result as new correct table. How can i write a parameter to my query SQL Code, that if a error occurs, the querry resumes and the error line will not displayed in my final querry overview In my books and on the net, i don’t found something to this theme ;-(. Thx in advance. - how is the table outline The table has 30 columns with differnt data's in there. The datatyps are all nvarchar(50) after the flatfile txt Import. But there are some date, text, int ...Show All

• Visual Studio How Can I generate the Help file for Dependency DLLs. ?

  I have all the assemblies in one bin folder. now I want to generate the common .chm files for all the assemblies as well as thier dependencies. I got lot of reference which generates the standalone .chm file and I am able to do so successfully but not found any source which helps to generate help file for dependencies and link it to common .chm files and give us only one .chm file. Regards, alok Hey Anand, Good news. I am able to generate the .chm file with respective <summary>. I realized that we have to change the .xml file name in sandcastle.config file in <!-- Copy in comments --> <component type="Microsoft.Ddue.Tools.CopyFromIndexComponent" assembly="ProductionTool ...Show All