Dreifinger's Q&A profile

• Visual C# Error on a 'Add' in a Pivotcache in Excel

  I make an Pivotcache in C# and later want to connect an Access-database to this pivotcache, but i get an error on the 'Add'. The 'old' code in VB looks like this (and did work): With WbkXL_Workbook.PivotCaches.Add(SourceType:=Excel.XlPivotTableSourceType.xlExternal) .Connection = strConnection .CommandType = Excel.XlCmdType.xlCmdSql .CommandText = strCommand .CreatePivotTable(TableDestination:=WstXL_Worksheet_Bst.Range( &quo ...Show All

• SQL Server Run Time Error While Execute Sql Server 2005 Integration Services package from C#

  Hi I am trying to Execute an SSIS Package from C# Dot Net. Below the code i am using. try { Application app = new Application(); Package package = app.LoadPackage("DTSPackage/WinServeMonitoring.dtsx", null); DTSExecResult result = package.Execute(); label1.Text = "Package Execution " + result.ToString(); } catch (Exception exp) { label1.Text = exp ...Show All

• SQL Server Creating a package with data flow task programmatically

  I have created a simple package with 1 data flow task: Source: data reader (to sql mobile) Destination: oledb (to sql server) And the aim is to do a "Select * from table_name" from source and move everything to destination database. I have followed the steps in documentation, but the package fails! An exception is thrown with message: "Exception from HRESULT: 0xC0202072" Since its the basic functionality of SSIS that I am implementing, it ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX 10 issues

  Hi, Im having some problems running DirectX 10 samples. I just installed vista 5270, Visual Studio Pro and DirectX SDK feb 2006. Now i want to take a look at the DirectX 10 samples but they aint working :( First time i started a sample i got a popup saying it would run in references mode ... so i clicked no. now when i want to start a sample from directx 10, it shows the executable in the processes but nothing happens. Alt ...Show All

• SQL Server Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Ora ...Show All

• SQL Server DataBase Connection

  hi everybody; my questions about when database connection : i am when connecting database latter receiveing exception error.Error is : An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll codes : SqlCeConnection cnn=new SqlCeConnection("Datasource=\\My Documents\\Business\\LOREAL.sdf"); cnn.Open(); // Exception is here help me.. ca ...Show All

• Software Development for Windows Vista Compilation Failed error...very generic...

  Anyone know what this error means: Error 1 Compilation failed. Exception has been thrown by the target of an invocation. C:\Jons Documents\Visual Studio 2005\Projects\WorkflowConsoleApplication1\WorkflowConsoleApplication1 0 0  This means that a method has been invoked using reflection and an exception occured during its execution. Can you share more details of what you are trying to ...Show All

• Software Development for Windows Vista What if an activity is not the atomic unit of execution?

  Hello, This is a hypothetical question that I hope someone (or multiple people) can shed some light on.  As I understand it, the activity is the atomic unit of execution in WWF.  It's conceivable that I could create my own custom activity type that runs a series of steps, or commands, that are not embedded activities but resolve down to code statements.  What would I lose in terms of WWF support   I'm thinking in ter ...Show All

• Windows Forms DataGridView - How do I STOP sorting it?

  Hi, I have a DataGridView that I sort using the DataGridView.Sort(myColumn, ListSortDirection.Ascending) method. How do I tell the DataGridView to STOP sorting I'm trying to stop it from automatically sorting (moving) new rows as they are added. I want new rows to stay at the bottom of the DataGridView until the user has finished editing, then I want the DataGridView to sort again. I'm using VS2005 Beta 2. Many thanks. ...Show All

• .NET Development Best database choice?

  I am wondering what the consensus is on choosing a database solution for a windows forms application when developing for the following criteria: 1. For applications that need to be deployed with their database on target computers (nothing complicated like oracle or ms SQL). 2. small amounts of data...( say...less than 500 mb of data [basically only need to persist small amounts of data between application executions ]) What kinds of ...Show All

• SQL Server Invoice Pagination - How do I start next costomer on new sheet when needed?

  Someone has to have asked this question before but I could not find the answer.  I did find some places, not on this site, with the question. Basically like the title says, I'm just doing for a different purpose but figured invoicing would be the most popular reason.  If the last page of a group prints on the front of the sheet then I need to advance past the back of the sheet and onto a new sheet to start the next group.  ...Show All

• Smart Device Development Custom Platform woes...

  Hello all, I'm using a custom SDK built from PB 5.0 to create a native app.  The project is an MFC Smart Device app, and I'm getting some strange results.  If I build a plain jane Dialog based app, I get many of the following warnings: C:\Program Files\Microsoft Visual Studio 8\VC\ce\include\sal.h(527) : warning C4005: '__in' : macro redefinition C:\Program Files\Windows CE Tools\wce500\FormaxCE_500\Include\X86\specstrings.h(48) : s ...Show All

• Visual Studio Express Editions RSS Screen Saver

  Hi, I have created a project using the RSS Screen Saver project template. In this I want the background image to be retrived from the RSS feed and cached in the local system. I need assistance on how to do this modifications. I will be greatful if someone inthe lists point me to an url or code which will help me solve the above. Thanks in advance Venki ...Show All

• SQL Server Expression Problem - GrandTotal

  In my SSRS 2005 report I have a column in my table that I cannot get a SUM in my table footer (I'm not referring to report footer!!) due to the way it is calculated.  Here's the low down: I will focus just on the columns in my table unique to this problem.  Remember, I'm using a Table Control in SSRS 2005, not just a Body section!!! In my table I have: Commission %          &nb ...Show All

• Visual Studio .NET 2.0 Install Hang

  Can someone please help me with this hanging install. I attempted to install Visual Studio 2005 with .NET 2.0 and it failed because it was a new Windows XP SP1 install.   I used windows update to install SP2.   Now when I attempt to install Visual Studio 2005 it starts installing .NET 2.0 but then it hangs (no hard drive activity for 30 min and no movement on the progress bar).   I then tried to run windows update again to inst ...Show All