Ben Wolf's Q&A profile

• Windows Forms Can Crystal Report display multiple dataSets?

  I passed one dataSet into Crystal Report at run time using the following code and it works fine. myreport = new CrystalReport2(); caseTestSet11.Clear(); string buffer="SELECT * FROM casetbl WHERE c_id="+buf; odbcDataAdapter1.SelectCommand.CommandText=buffer; odbcDataAdapter1.SelectCommand.ExecuteNonQuery(); odbcDataAdapter1.Fill(caseTestSet11, "casetbl"); myreport.SetDataSource(caseTestSet11); crystalReportViewer1.ReportSource = myreport; My question is: Is it poss ...Show All

• .NET Development Memory Leak when used SmtpMail class

  I have the function which consists code below. Every 50 mails the memory of application raises up 100k. Sometimes is more. Does someone know why and what I have to do to solve this problem. for ( int emailNum = 0; emailNum < int .Parse(txtMailsAmount.Text); emailNum++) { MailMessage tmp = new MailMessage(); SmtpMail.SmtpServer = mail.SmtpServer; tmp.BodyFormat = mail.BodyFormat; tmp.Body = mail.Body; tmp.Subject = mail.Subject; tmp.From = mail.From; tmp.To = mail.To; tmp.Cc = mail.Cc; SmtpMail.Send(tmp); } See what happens when you call tmp.Dispose() afte ...Show All

• SQL Server Seems like permissions issue with OLE DB connections

  Hello, I've created quite few packages using OLE DB connections with dataflow destination as SQL Server Destination. The OLE DB connections using a windows login works fine when connecting to SQL Server Destination table(data flow destination) . The OLE DB connections using "sa" fails when connecting to the exact same table to "SQL Server Destination" but it works fine with "OLE DB Desination" even though it is the exact same underlining table. Why is the "sa" login not working with SQL Server Destination table (data flow destination) in my OLE DB connection Thank you ...Show All

• Software Development for Windows Vista General questions about WWF

  I've tried the Hand on Labs for the WWF Beta 2, even for Lab-01, not clear/simple enough for me to understand the logics behind as it uses too many external activities and applications (without description). I've a couple of questions in mind after the lab and hope any of you can help. After start a sequential workflow, how to: 1) Check the workflow status (completed or not) 2) How to get a return value from the workflow 3) Can we set use / load different workflow dynamically (determined by users, not at design time by developer) Thanks in advance Charles, Sorry to bother you again. I ...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 actually I think that is a very good article outlining the usage of GO and statement terminators. GO separates Script blocks ; defines the end of a statement within a script block. what is unclear ...Show All

• Visual C# Exception number

  is there a way to get the exception number thanks Yes, see the GetHRForException method in the Marshal class. regards, wcprog ...Show All

• .NET Development WinForms Vs WebForms

  Where can I get the list of pros & cons generally speaking WinForms are Richable but not reachable , on the contrary WebForms are Reachable (but not richable due to performance factors). so the question is : can we have a form that is both richable and reachable at the same time . the answer is simply , yes "Click-Once deployment ". there was an old article about hosting a windows form over IIS , and this would lead to the death of browsers we know today . http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnadvnet/html/vbnet10142001.asp so if we can really work this way by hosting winforms over IIS , why would we nee ...Show All

• Visual Studio Tools for Office Threading issues GUI updates in the Action Pane

  Using VST0 2005 with C#. I have an action pane that initiates a user request by creating a thread to query a web service. After the thread is created to do the work, the current (main) thread makes a progress bar visible and disables all action buttons and returns control to the excel application. The worker thread communicates with the main workbook via events. I have an event which signals the workbook that processing is done. At that time the workbook calls a method off of the action pane control to enable the buttons and make the progress bar invisible. While debugging, I get a message saying that I cannot perform the hiding of the progr ...Show All

• Visual Studio Express Editions Problems in Updating data

  Hi, I'm new to Visual Basic and SQL Server express editions and I've been following the beginners lesson from learnvisualstdio.net and also the How do I in the help of Visual Basic. The problem that I have is that I can't update my database after editing fields or ading new fields in datagrid view or details view. I followed step by step the How Do I on Data Access located in Visual Basic ' s Help. Here is the URL: ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vbcnexpress/html/a768c7f9-5d3b-4bf1-996b-64274d7e9ce6.htm Can anyone give me a hand Thanks This is a known issue and is covered in numerous threads ...Show All

• Visual Basic Error- Could not load file or assembly

  I have two projects in a solution. One is a class library with my FTP, GPG and some other classes that get compiled into a dll call CBI.Utilities. The other is my main app which in a few places call the ftp class. I added the reference to the main solution by browing to the project from references under the main solution and now I get this error when I try to instantiate the ftp class. "Could not load file or assembly 'CBI.Utilities, Version=1.0.2053.21021, Culture=neutral, PublicKeyToken=78bbe40a91a1660e' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: ...Show All

• SQL Server Error connecting to Reporting Services 2005 using SQL Server Management Studio

  I have configured my report server using Reporting Services Configuration Manager. I have green checks across the board. I can connect to the report server via the web to view reports and I can develop and publish reports, but I can not connect to Reporting Services using SQL Server Management Studio. I receive the error listed in plain text below. I've spent four hours trying to resolve this with no luck. OS: Windows 2003 SP1 Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) TITLE: ...Show All

• Visual C# Connecting Web Application to Database Wired/Wirelessly

  Hi good day too all. I am currently designing a program that should allow users to access to database wired/wirelessly on a different location from the web application. Compared to connecting a web application that has database on the same PC is a much difficult task. Can anyone kindly enlighten by giving some suggestions on coding or methods to solve this problem I need to sovle this problem asap as submission for my program will due in like 12hrs. Lastly i would like to thank a million in advance for any form of help i would receive! Wired vs. wireless won't matter as long as you know the DNS name ...Show All

• SQL Server Need Help creating a SSIS Package (Newbie)

  Following is what I would like to do, so I can keep updating my central SQL Server database with latest updates from the field. I like to use SSIS 2005 to create a package that could do this. Any help to get me started would be appreciated. I need some help soon, pls give me something to get started. APpreciate it. Thanks. Open connection and read client location table on the local SQL Server database called PODO For each location id in the table do the following: Store locationid/clientid in a variable called CLLOC_ID Construct file name with mdb extension and store in a variable MDB_FILE Establish connection to the data import fol ...Show All

• Visual C# Newbie: Two Questions on Generated Delegate Class

  Hi everyone, I'm new to C# 2.0 (moving over from Java) so these might be easy. I have two questions I'd like to ask regarding delegates. I know that when I declare a delegate the C# compiler automatically generates a class that extends MulticastDelegate . Here's a simple delegate declaration: delegate bool Charlie(bool b1); First Question When I use ildasm to view the generated class for Charlie I see there is a generated c'tor that takes two parameters: an object and a native int. Yet, when I instantiate a Charlie object, I only pass one parameter to the constructor. Here's an example: Charlie c = new Charlie(someMet ...Show All

• Windows Forms Microsoft Browser control

  Hey all, Using Microsoft Browser control is it possible to create a HTML Editor, if so can anyone suggest good reading, threads or samples to get me started.. Thanks   Take a look at HTMLEditor http://www.itwriting.com/htmleditor/index.php ...Show All