MaggieChan's Q&A profile

• Windows Forms TabControl how to remove default tabPages

  Hi, when i add microsoft tabControl to the winform, then is created tabcontrol with two default tabPages (TabPage1, TabPage2).Is here anybody who knows how to remove these default tabPages from initializeComponent() method I have created own tabPages and tabControl. public class MFTabControl : System.Windows.Forms.TabControl public class MFTabPages : System.Windows.Forms.TabPage {..} This MFTabControl works with mfTabPages but still contains two default tabPages . Designer generates this in InitializeComponent() >> this.dTabControl1 = new GUIControlDataGrid.DTabControl(); this.tabPage1 = new System.Windows.Forms.TabPage(); this.tabPage2 = new System.Windows.Forms.TabPage(); ...Show All

• SQL Server SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog >>> This method does NOT require MSDTC. Now, the message got through. (The ears were listening but the mind was not .) Thanks, Barkingdog ...Show All

• Windows Forms Error Code: 0x80070643

  I have tried to install Windows and Office updates utilizing the Automatic installation tool; but, the initialization takes place and none of the updates are intalled. I ran WinDoctor and I am told that I am missing file "ORUN32.exe" and it cannot access "learn32.dll" and "pctree32.dll". I have searched my computer and found the orun32 and pctree32 files but not the learn32 file. I don't know how it got deleted and not sure how to get it back in place to use the automatic update. What do I do to get my Automatic updates to run again Please help me! In the toolbar Icons on the left you should have a small yellow sheild with an exclaimation mark in the middle. Jusk click on sheild icon in the ...Show All

• SQL Server Connecting to Analysis Server 2005

  Does anybody knows if a 2000 analysis services client could connect to a 2005 Analysis Server Thanks If by "client" you mean "client components", i.e. PTS aka OLEDB driver msolap80.dll - then the answer is NO. There was a version of ADOMD.NET which shipped after AS2000 but before AS2005 - it can connect to AS2005. HTH, Mosha ( http://www.mosha.com/msolap ) ...Show All

• Visual C++ Visual C++ 2005 Precompiled Header Bug?

  Hello, I have converted a project from Visual Studio 2003 to Visual Studio 2005 and noticed the following problem: Changing a header file does not recompile all the required dependants. This happens only with precompiled headers on, when I turn them off, everything works. This did not happen in Visual Studio 2003. (Minimal / Incremental Build are OFF). It is most problemtic when what changed in the header are flags, since it links properly the project is built with some files not updated and creates the most obscure bugs. Example (just for problem illustration): Test.h: #define FLAG_ONE 1 #define FLAG_TWO 2 Files TestFile.c and TestFile2.c both use the header and flags, I edit Test.h and remove FLAG_ONE definition -> ...Show All

• SQL Server Native error messages in OLEDB destination (and hopefully forthing ADO.NET dest)

  For both OLEDB destiantions (and hopefully for the forthcoming ADO.NET destination adapter) it would be useful to have the following two output columns: NativeErrorCode and NativeErrorMessage. For SQL Server, this would allow you distiguish between multiple errors which all roll up to the SSIS error "the value violated the integrity constraints of the column", which is way too generic for proper decision making (via conditional split). For example, like SQL Server replication, you should be able to ignore duplicate key errors (error number 2627) indicating the record existed, but error out on nullability constraint errors (number 515) in which the record could not be inserted. If you had a native error code, you could make this ...Show All

• Visual Basic Can I set userscale of picbox, like possible in VB6?

  Dear all, it used to be possible in VB6 to define picboxes as carthusian axis crosses with user-defineable min and max for both X and Y direction. With the advantage that you can draw on them just as you would do in math. I am trying: Imports System.Drawing Public Class Form1 Dim g As Graphics Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load g = PicBox.CreateGraphics() End Sub Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim a(5000) As System.Drawing.Point 'points are paired numbers: a.X and a.Y Dim i As Integer For i = 0 To 5 ...Show All

• Windows Live Developer Forums Windows Live Contacts Gadget beta release!

  I'm pleased to announce that the Windows Live Contacts Gadget has been released to beta! The Contacts Gadget allows end users to access their Windows Live (Hotmail + Messenger) contacts in the context of third-party web sites, and use those contacts with the web site. It's easy to add the contacts gadget to your web sites - just reference the .js files on dev.live.com, copy one channel.htm file to your web server, and write a little code to construct the contact gadget and respond to its callback events. More details can be found here: http://dev.live.com/contactgadgets I'll be posting articles and code samples over the next few days on my blog . If you have any questions, feel free to ask! -Danny Hmm. Not sure w ...Show All

• Visual Studio 2008 (Pre-release) Help, why wcf become very slowly after I refresh some times.

  Hi, All: I need help now, thanks. we use wcf in our web project, yes, now it can work. But After we refresh web page some times, it will become very slowly and timeout at last. we do not kow the reason, and we want to know how we can fix this issue. Thanks. sample code: [DataContract(Namespace = "Company.Core.Services.Patient.PHR.Contracts")] public struct Allergy { private string _conceptCode; [DataMember] public string ConceptCode { get { return _conceptCode; } set { _conceptCode = value; } } ...... } [ServiceContract(Namespace = " http://Company.Core/Patient/PHR/Allergy ")] public interface IAllergy { [OperationContract] Allergies ListByEnvironmentFood(); ....... } ...Show All

• SQL Server Scrubbing data in a data flow task

  I can only assume that I either did something very stupid, the examples are completely wrong, or I don't have the slightest clue what it is that I'm doing. I'm trying to do one of those incredibly complicated things in SSIS that was a brain-dead, point click operation in DTS.  I want to strip characters out of an input stream from a flat file source before loading them into a table.  I've defined my data flow task.  I have my flat file source properly defined.  I have my SQL Server destination properly defined.  For the life of me, I can't figure out how to scrub the data that I want. My input is a csv file that has 22 columns of data.  Column 22 contains data and if data was not present, there is a - in ...Show All

• Visual Studio Textbox Format Missing

  I'm running out of ideas here... My reports are working perfectly in the ReportViewer control, except for textbox formatting. Despite the fact that standard format codes are specified in the designer, date and numeric values display exactly as they're returned from SQL Server. Am I missing something simple here The report language is set properly, is there something else I need to do to tell the viewer to use embedded formatting Any help is appreciated. I've found the solution: If you want Format a Textbox as Date : you have to insert into the Format field of the TextBox: d //very simple, or !! But it works! If you want Format a Textbox as Numeric with 2 Digits after komma : you ...Show All

• SQL Server sort_int in tempdb

  Hi: Can anyone explain why I am seeing the following in my tempdb db. This transaction has been open for 3 hours and it took my tempdb log space. I had to kill the spid to rollback the transaction but i was wondering if there is a worka round to solve this. A input buffer on this spid showed a sproc being called and I am wondering if my select statements in the sproc were not using correct indexes and thats what might be causing this. Can anyone from the community please confirm. Transaction information for database 'tempdb'. Oldest active transaction: SPID (server process ID) : 112 UID (user ID) : -1 Name : sort_init LSN : (128:150438:113) Start time : Jul 30 2006 9:50:55:503AM Thanks AK ...Show All

• SQL Server Error in SQL 2005 cluster installation

  I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:  ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: ...Show All

• Windows Live Developer Forums Is there a way to hide the earth base layer?

  Some of the custom tile layers I have created cover up the base earth layers completely. Since they are covered and can't be seen, I don't want the client to download them when the covering layer is active. Is there a way to turn the base earth layer off and then back on again when the covering layer is removed If you're using the page that MapCruncher generates, try remove the call to ActivateAlphaLayer('New Layer') and replace it with a call to SetMapStyle('New Layer'). ...Show All

• Visual Basic ar400 reader codes

  can i ask whether this codes start up the ar400 reader thanks. Private Sub testing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load                 OpenMsComm()         openbol = False         openbol2 = True         openbol3 = False         Dim commByte() As Byte         Dim commbyte2(5) As Byte         agent.Get_StopDevice_Command(commByte)         MSComm.Output = commByte    &n ...Show All