bigluzer's Q&A profile

• .NET Development A Question on GC

  I have a MDI program in which user can open different document and edit it. After several user use it, they report that it becomes more and more slow. So I watch the memory usage of it carefully and found a problem : it seems the memory is never released after a document is closed. I watch the memory cost in Tesk Manager, and found that whenever a document is opened, the memory cost increases. However, after the document is closed, the memory cost does not drop. When another document is opened, it cost more memory. I later realize that since the document is opened for a while, the objects it allocated have been moved to Generation 2. So ...Show All

• SQL Server semicolon terminator

  Can someone define for me what is a statement when it comes to having to use semicolon statement terminator This is absolutely undocumented in BOL. Googling only finds this incoherent article which is far from official documentation. TIA Hi Chad Boyd, This is Bhanu Prakash and i am going to be the new administrator for MSDN Forums. You are amongst top 200 answerers in Forums and we identified you as potential moderator.Please reply back to my email ( a-bhanun@microsoft.com ) with your email address so that we can give you moderator rights. We appreciate your continued support for the Forums. Cong ...Show All

• SQL Server FailParentOnFailure not working?

  I have a script task inside a sequence container with the FailParentOnFailure = 'false' and the FailPackageOnFailure = 'false'.  However, when I deliberately fail the task ("Dts.TaskResult = Dts.Results.Failure") the sequence container and the package still report failure.  Any thoughts Thanks Yeah, but shouldn't the 'FailParentOnFailure' override the failure result returned by the child regardless of the MaxErrorCount   What if I have a task that could generate 1 to N errors ...Show All

• Windows Forms Editing ToolStrip screws up auto generated code

  Hi, I have noticed a few times that editing the contents of a ToolStrip can*space space*the auto generated code. I haven't pinned down exact details as I have not had the time, but the subsequent build errors relate to the fact that the variable "resources" is no longer defined. Has anybody seen this, or is it just me Regards Allen Jones ...Show All

• SQL Server SSIS package execution question in SQL agent

  Hi there, I have been trying to schedule a package I design to run off hour, but unable to do so. Here is a strange issue: 1. I was able to fully run and complete the package through VSS. My package has three steps and I have on complete arrows from one step to the next... When I run it, it does what I expected in SSIS designer. 2. I was able to deploy and run the actual package by double click on the file system and it runs successfully through Execute Package Utility. So my package does loop through a file folder and insert records from within the folder through execute SQL task to a SQL table...etc. Typically it takes a while ...Show All

• Visual C# Problem using EntLib DAAB for .NET 2.0

  I created a windows form in VS2005 that uses Enterprise Library - DAAB - version Jan 2006 to access the DB in its constructor. Everything works fine; however, when I created a UserControl that attempts to store that form as a variable, the VS 2005 designer will not let me drag that UserControl onto a new form. It gives me the following error: “Failed to create component ‘UserControl’. The error message follows: ‘System.NullReferenceException: Object reference not set to an instance of object. At Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.get_DefaultName(), at Microsoft.Practices.EnterpriseLibrary.Data ...Show All

• .NET Development Accessing sharepoint data

  Hi. How do I launch a document in the associated editor (Word/Excel or whatever) Any added difficulities if the document is in Sharepoint Best regards, Throstur The easiest way to do this is just use ShellExecute feature of Windows. In .NET you do it like this: System.Diagnostics. ProcessStartInfo psi = new System.Diagnostics. ProcessStartInfo (); psi.FileName = @ "c:\MetaData.doc" ; psi.UseShellExecute = true ; System.Diagnostics. Process .Start(psi); You can use a URL with this as well, so it would work with SharePoint. ...Show All

• SQL Server Feedback Requested - What Content Do You Want to see for SQL Server Express?

  We’re in the process of assessing the content that exists to help people learn and use SQL Server Express.  This includes demos, tutorials, whitepapers, Webcasts, Starter Kits, and any other type of content you could imagine.  So this is a great chance to TELL US WHAT YOU WANT!  We’ll integrate your feedback and make sure that we try and address the most requested areas of content.  Please be as specific as you can. Hi Mark, I would like to have a demo that shows me how make a diagram from that data in a SQL Server table. Greetings from Germany,   VBFan ...Show All

• .NET Development using sax to parse large xml files

  I am trying to use SAX for the first time. I got as far as this: this .fileStm = new FileStream(path, FileMode.Open, FileAccess.Read); reader = SaxReaderFactory.CreateReader( null ); reader.Parse( new StreamInputSource(fileStm)); and i have no idea how to actually get the data from the reader... If anybody has a sample code to parse the document and put data into some kind of a structure like hashtable or an arraylist - I would really appreciate it ! Thanks! Forcing XmlReader through a SAX layer is possible but adds overhead that makes the comparison somewhat unfair.  You should be comparing real customer code - one writ ...Show All

• .NET Development How to:using TCP/IP and SSL in .NET?

  Hi, All I am developing some custom Point-of-sale system, that requires handling the payments by credit/debit cards. The company provider of the payment services says that to process the credit cards we need to do the following: 1. DNS lookup and locate the gateway IPs. 2. Communicate to the gateway via TCP/IP/SSL (request/response). I actually came across this issue at first time in my programming life, never had to work on such low level before :))) They are suggesting using OpenSSL, but as long as i know this library is for Unix. Is there a simple (as simple as possible) way to setup TCP/IP connection with SSL in .net Framewor ...Show All

• Visual Studio Visual Studio Beta 2 fails with error

  Hi I had earlier tried to install VS 2005 Beta 2 and it had failed due to some unknown reason. While trying to repair the VS 2005 Beta 2 Architect Edition, i can successfully install the .NET Framework 2.0 and restart. However, while installing MSXML 6.0 Parser in the next step, the setup stops and asks for locating the CD that contains runmsi.exe. The DVD doesn't seem to have the file and hence I have to abort the installation. A search on my local machine did not yield any such file on my hard disks. i have already run the clean install tool mentioned earlier on this forum at: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=17416 I ...Show All

• Microsoft ISV Community Center Forums Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified module could not be found. Here is the VBA code in the Excel Macro.  The error happens when it reaches the line that reads: Set theApp = CreateObject("Outlook.Application") .  I tried to ...Show All

• Windows Forms RemovePreviousVersions doesn't seem to work?

  In my deployment project in VS2005 I have set the RemovePreviousVersions property to true, but do not get the desired effect. After changing the Version property from 0.0.1 to 0.0.2 as well as the ProductCode property when prompted by VS (leaving UpgradeCode as-is), I expected a following install to remove the version 0.0.1 from the target computer before installing the version 0.0.2. This does not seem to happen. After the install I have the 2 versions simultaneously visible in Add/Remove Programs. This seems like a trivial problem so I must do something fundamentally wrong or missing some other property somewhere. But what Any ...Show All

• Visual C# ExecuteScalar erro

  { SqlConnection conn = new SqlConnection (); conn.ConnectionString = "Data Source=(local);" + "Initial Catalog=bd;" + "Integrated Security=SSPI;" ; SqlCommand sqlComm = new SqlCommand ( "SELECT * FROM utilizador WHERE user=@user;" , conn); sqlComm.Parameters.Add( "@user" , SqlDbType .VarChar); sqlComm.Parameters[ "@user" ].Value = user.Text; conn.Open(); Int32 teste = 0; teste = (( Int32 ) sqlComm.ExecuteScalar()); --> ERROR {"Object reference not set to an instance of an object."} conn.Close(); } wha ...Show All

• Visual Studio Express Editions How Export table as .csv file

  I need export the data. Please help-me. Thank's This task will probably required the bcp utility or DTS (Data Transformation Services) if you want to export directly. I've done this with SQL, but it requires an ODBC connection and AFAIK SQL Server Express doesn't support it. ...Show All