nutsboutdan's Q&A profile

• SQL Server temporary table and multi-part identifier

  Hi, I want to join a temporary table with a table in my stored procedure : CREATE PROCEDURE sp_DeltaabgleichDarlehen AS BEGIN SELECT Grundeinstellungen.Dat_Initialisierung, Grundeinstellungen.Dat_Jahresbeginn INTO #temp_IniDatum FROM Grundeinstellungen INSERT INTO DeltaDarlStammdaten (Datum, Vertragsnummer) SELECT ImpDarlStammdaten.Datum, ImpDarlStammdaten.Vertragsnummer FROM ImpDarlStammdaten WHERE ImpDarlStammdaten.Datum=#temp ...Show All

• Windows Forms Transparent Usercontrols

  Currently transparent background color is not supported in usercontrols with overlapping controls as it was supported within VB6 with the backstyle proeprty. In the transfer of our software from VB6 to VB.Net this lack of functionality is killing our applicat ...Show All

• Visual Basic Bound Form Dirty

  This should be fall off the log simple for a brand new development environment, but... In VS2005 b2 I have a bound windows form. How do I determine if the user has made changes to the data TIA It appears that the 'RowChanged' event only fires after the acceptchanges in invoked. This is well after any HasChanges flags have been set. And after any column data is assigned a 'proposed' version value. I myself ...Show All

• SQL Server Connection managers - OLE DB

  Hi There Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one. In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it ...Show All

• .NET Development Delete DataRow From Table

  Hellow How i can Delete DataRow From Datatable without remove it from the table or how can to know this row is deleted without deleted from table final decause i want this row for another thing thanks I think, you can do like this: Add one flag column(bool column) to indicate the DataRow is deleted, and not delete it actually until you will not use it. ...Show All

• SQL Server SSIS Package runs fine except as a scheduled job

  I have an SSIS package created from a SQL 2000 DTS using the Migration Wizard. The package imports data from a MySQL database to a SQL 2005 64-bit database running on 64-bit windows server 2003. The package runs fine when executed from SQL Server Management Studio but when I schedule it as a job it fails with: Executed as user: [the domain admin account]. The package execution failed. The step failed. I've tried a lot of different ways to ...Show All

• Windows Forms .Net 2005

  Has anyone be allowed to compile from Visual C# Express .Net 2005  I get an asembly validation error but with no description :/ I dont have the Framework directory in Microsoft.NET folder. ...Show All

• Visual Studio Tools for Office vbScript with .NET

  With Visual Studio 2005 and Framework 2.0 you discontinued the Microsoft.Vsa namespace. How do I execute vbScript in your latest framework without having to return back to your COM MSScriptControl (C:\WINDOWS\System32\msscript.ocx) I have not tried that yet, but I will. However, I did try running a simple test subroutine with no problems. Sub Test1 'Todo:... End Sub (It was actually passed in as a BSTR: & ...Show All

• Windows Forms DataGridView - Stop User From Sorting On Column

  Since I cannot do this: DataGridView1.AllowUserToSortColumns = False Is there a way to stop the user from clicking on the header and forcing the column to sort Have you checked out the docs or the DataGridView FAQ: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=152467&SiteID=1   -mark DataGridView Program Manager Microsoft This post is provided "as-is" &nbs ...Show All

• .NET Development Remoting socket address problem

  Hello to all reading this post, I have one remoting application with server and client parts. It seems to work just fine until I attempt to restart the server. If client applications have accessed the remote object and I attempt to restart the server, the server stops successfully, but I receive the following error when it's trying to start up again: " Only one usage of each socket address (protocol/network address/port) is n ...Show All

• Microsoft ISV Community Center Forums Visual Basic Editor scripts question

  I populate a Word merge letter from a Stored Procedure. I send the SP parameters via a form I created in a Word template. I want the form to autoload when someone opens the document and I cannot figure out how to make this happen. I can go into Tools-Macros-Visual Basic Editor, Open the frmPreview and run the macro there and it works fine, but I want it to load automatically. Please help. Jeff ...Show All

• Visual Studio Team System Logs

  I get this error while attempting to install TFS RC, anyone have any more information Thanks If you could provide the VSMsi*.txt logfile (in the %temp%) directory we can do a better job at understanding the problem. marc ...Show All

• Visual Studio How to view an XML file when connection is attached to a schema (XSD) file.

  I have a CrystalReport file connected to an XML schema file (XSD). I want to associate an XML data file to the report at runtime so I can select one of several XML files to a single RPT. Is this possible Thanks for your help Hello, Yes this is possible as long as your XML files use the same schema.   The Crystal Report runtime engine needs to have the schema of the report file and the XML fi ...Show All

• Visual Studio Express Editions Is The OOP Microsoft.VisualBasic.IIf Equivalent To the Procedural If Then?

  so I guess the thread was locked due to thinskinned vb'ers, unfortunately bronco has a fantastic question in his last post and it certainly warrants discussion. . . This Particular Microsoft.VisualBasic.IIf Is extremely important to me.... If Microsoft.VisualBasic.IIf is Equivalent to the Procedural "Classic" If then.... If it is Equivalent I can Transist to Pure OOP by using Descision Tables, Boolean Algebra and other CS tec ...Show All

• Visual Studio 2008 (Pre-release) Keeping base object in database across Page navigations

  I'm writing an application with a set of classes like so: Base class: List<Accounts> Account class: List<Transaction> Transaction class: Various properties Basically, I want one instance of the base class with instances of all it's subclasses. I really only want one copy for the entire application. Since my application uses a NavigationWindow this can become a problem. I've tried adding an ObjectDataSoruce to the Navig ...Show All