Charlotte Adam's Q&A profile

• SQL Server how to loop through several excel sheets in a file in integration services

  Hello, I'm new at Integration services and I have an excel file with information in several worksheets. I want to loop through some specific sheets to retrieve the data and save it in a database table. I know how to retrieve the data from one sheet, but I don't know how to do it for several sheets. Any ideas ...I would appreciate any help. The last bit of pre-processing I want to do in Excel, I know how to do in an Excel macro, but not in SSIS. Can anyone adapt this into an SSIS Script task Here is the macro code snippet: Sub ClearWorksheets() With Application .Calculation = xlManual .EnableEvents = False Worksheets("MyData").Range("A:H").Clear .EnableEvents = ...Show All

• Visual Basic Problem with encoding between vb.net and a unmanaged DLL in C

  Hi! I have a DLL(made in C) which I want to communicate with, and I get the communication to work but the string which get sent becomes wrongly encoded. I have tried to declare the dll in the vb.net code like this: Public Declare Function Write Lib "test.dll" (<MarshalAs(UnmanagedType.LPArray)> ByVal Data() As Byte , ByVal DataLen As Integer , ByVal Id As Integer ) As Integer and also like this: < DllImport( " FG197038d.dll" , bestfitmapping:= True , CallingConvention:=CallingConvention.Cdecl, CharSet:=CharSet.Ansi, throwonunmappablechar:= True )> _ Public Shared Function Write( ByVal Data() As Byte , ByVal DataLen As Integer , ByVal Id A ...Show All

• SQL Server The cursor does not include the table being modified or the table is not updatable through the cursor

  I am getting the error "The cursor does not include the table being modified or the table is not updatable through the cursor" when i try to execute some statements using cursors. I am using SQL Server 2005 Enterprise Edition Can any one suggest the solution or is there any alternative to avoid this error. ...Show All

• .NET Development Seperating DataSets,DataAdapters stuff from Applications

  Hi, This is probably for most of you a very basic question. My goal is to define in a seperate instance from application all infos related to DataSets and DataAdapters that are needed when connecting to a specific database. Why First, I would like to be able to have in a single instance everything needed when hooking to a SQL Server Express database and in an other everything needed when hooking to a SQL Server CE database. Then, from application, I would like to be able following a few basic configuration steps to choose from one or the other, or even both in specific cases. Second, I want to be able to seperate Database related stuff from application so that I can re-use everything from any other application when needed. ...Show All

• Visual Studio Tools for Office Client Machine minimum requirements for web based excel office VSTO Solution using asp.net?

  I have to generate interactive excel reports(interactive only to get excel features of formulas , charts etc) having multiple worksheets with graph using asp.net . Currently we have Office 2000 installed on all client machines . 1) If I develop an office excel solution using VSTO in Vs.net 2003 having excel 2003 insatlled iapghn web server , Does it open the excel files on excel 2000 client machines for the asp.net web application 2) Does client machine needs .net framework installed to display excel reports for the asp.net web application Hi, To run VSTO applications you will need - a version of Excel that supports Visual Studio Tools for Office. -.NET framework 2.0 - VSTO runtime - ...Show All

• Visual Studio Team System Create work items using TFS API?

  Hi, I'm trying to import all of our bugs from Bugzilla to TFS. I'm able to pull the data out of Bugzilla's MySQL DB just fine using C#, but how do I use the TFS API to import these bugs I downloaded the TFS SDK and read through some samples, but they seem overly complicated. Can someone please post a very simple example in C# on how to create one work item Bug in TFS I can then take it from there. I need to be referencing Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client correct Thanks, Ethan Thanks. Now I am getting this exception on the workItem.Save() line: TF26201: This work item has unsupported fields, or user does not have permissions. I am assuming that this h ...Show All

• .NET Development compressing binary files with GZIP

  I have been attempting to use C#'s GZipStream to compress binary files (JPG, PDF) files and the resultant file is always larger than the original file. The compression methods work fine on text files. What am I not understanding about this compression approach I have rewritten the compression methods using a variety of approaches and the results have always been the same... thanx for any pointers/advice/kick in the head... Kick: JPEGs and PDFs are already compressed so will just get larger when you try to compress them again. ...Show All

• Visual C++ Problem migrating to Visual Studios 2005

  I'm trying to convert a project i've been working on from eVC++ to Visual Studios 2005. The header files are in the same folder as the source files but apparently they do not exist when i try to compile. gives me a problem with my include statements saying stuff like "cannot find include file "StdAfx.h" \n Does not exist. Any help on the matter would be much appreciated, thanks. Hello Re: Problem migrating to Visual Studios 2005 Sorry for the lack of replies to your question - is it still current. If so, have you made any progress or is the problem exactly the same today The reply above from einaros dealt with the fact that your error message said it was looking for stdafx.h, t ...Show All

• Windows Live Developer Forums Windows Live Messenger Add-in

  I have made an Add-In that catches all incoming and outgoing messages. Till now it is good with the following code. Imports Microsoft.Messenger Public Class MSNAdd Implements IMessengerAddIn Private WithEvents m_client As MessengerClient Public Sub Initialize(ByVal messenger As Microsoft.Messenger.MessengerClient) Implements Microsoft.Messenger.IMessengerAddIn.Initialize m_client = messenger m_client.AddInProperties.Creator = "MyName" m_client.AddInProperties.Description = "MyDescription" m_client.AddInProperties.FriendlyName = "MSNAddin" End Sub Private Sub m_client_IncomingTextMessage(ByVal sender As Object, ByVal e As Microsoft.Messenger.IncomingTextMessageEventArgs) Handles m_cli ...Show All

• Windows Live Developer Forums Pushpin z-Index

  I would like to be able to control which pushpins are ontop of each other. I have tried changing the z-Index on the stylesheet with no success. And after looking at the javascript, the map.AddPushpin function actually uses a global variable for the z-index when it adds the pushpin to the mapcontrol. this.vemapcontrol.AddPushpin(GA.ID,veLatLongDecoded.Latitude,veLatLongDecoded.Longitude,25,25,"VEAPI_Pushpin",GA.GetContent(),Msn.VE.API.Globals.vepushpinpanelzIndex-1); Has anyone else came across this problem and came up with a reasonable solution besides just overwriting the map.AddPushpin method I thought about that as well and it does work to some degree. Mainly the issue is when you a ...Show All

• Visual Studio Team System change table relationships in a CTP project?

  Is there a way to change table relationships within a CTP project Dakerson - If we don't hear from you by next week, we'll delete this thread so we can keep the forum focused on questions with answers for other customers to search. thanks, ...Show All

• Software Development for Windows Vista Rehosted designer Rule Condition error with June CTP and XOML only workflow

  If I attempt to create a rule condition in my rehosted designer for a XOML only workflow I get the following error displayed in a Properties Window dialog as soon as I type in the Rule Condition dialog index was outside the bounds of the array This is something that has been broken by moving to the June CTP, unfortunately. Any suggestions This doesn't help, unfortunately. The TypeProvider code above is already in Vihang's example, (appart from looping over the CurrentDomain assemblies which I added for good measure). Did you make the two small changes to Vihang's latest example, (as in the second post), and not get the runtime error ...Show All

• Visual Studio Team System Server not referred to by the FQDN

  I want the server to refer to itself ONLY by the FQDN. http://img116.imageshack.us/img116/2330/properties9sk.jpg if you have a look in the image - the server name is Fully Qualified, although the link that it will send the user to is not. how do i make them both be the same FQ thank you. The link that the server sends to the client is generally constructed based upon the prototocol and server name used to connect to the server. If you clear the TFS cache on the client and then reconnect using a FQDN, you should see that the client uses that FQDN. There are a few places where TFS uses "absolute" URLs, and if you want a complete FQDN solution, you will need to upda ...Show All

• Visual C++ Opening multiple files in a single program instance

  This is something that is done millions of times every day... Using Windows Explorer you double click a file to open it, the associated program starts up and the file is opened, if the associated program is already running, then the file is opened in that (already running) instance of the program. Simple... However, I'm having trouble finding how to do this simple feat with VC++ 2005, CLR, CLI, .NET. What is the simplest "supported" way to do this Seems you are looking for solution for making your program a single instance one. Please go through this article Run a Single Instance of a .NET Application ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX EULA for DirectSetup Requirements

  Hello All, I am having trouble pin pointing when it is required to display the DirectX End User EULA when using the DirectSetup library to install the directx 9.0c dlls. I will be requiring 9.0c to be previously installed and will be only installing the required dlls for my application. I cannot seem to find the truth behind whether or not I have to display the EULA for this process. The DirectX DXInstall example does not show a EULA. This page: http://msdn2.microsoft.com/en-us/library/bb174600.aspx which describes the process of using DirectSetup to install DirectX components does not explicitly state that you must show a EULA. It says follow the license agreements for redistributable code which only states t ...Show All