Andie Kurniawan's Q&A profile

• .NET Development Best way closing datareader

  He there, I hope someone can help me. I am having problems with the data reader. When an error occurs the datareader does not close eventhough i have this code in my error handling. Catch(Exception err){ dr.Close(); } is there any way to close the reader even when an error occurs Mail me @ vangelier@duoflex.nl Thanks guys! When dealing with disposable objects you really need to have good control over the lifetime of the object. Assuming that you create the data reader, use it and then want to get rid of it you should use the following code in C# using (DataReader dr = ... ) { }; ...Show All

• Visual Basic How to refresh a bindingsource

  I have an SQL Server database with a table I want to export to a comma separated text file. That table is created with a query which filters data from another table. I thought that by using a bindingsource, I could step thru each record and write them line by line to an ascii file. However, the bindingsource frequently maintains the data contents of the previous query. Is there some way to refresh the bindingsource so that it uses the tables current content The odd part is that even if I exit the program, restart it and run a new query. The bindingsource still has the data from the previous query. Where does it keep that info ...Show All

• Visual Studio Team System different processes depending on iteration

  I was giving a demo on VSTS to management today and they hit me with a question that I wasn't really prepared for. They want to be able to have different processes for one team project depending on iteration. I stated that I didn't think this was available in VSTS, but I am wondering if I gave answered this question correctly. If the iteration is very small, say only a couple days to code, test and deploy they want it to use a more agile process. If the iteration is much larger they want to use a more formal process. It seems like this issue would have been talked about before and I just haven't run across it. So, the answer is that yo ...Show All

• SQL Server Using CASE statement within GROUP BY

  Just a simple question, is it possible to somehow assign an alias to a case statement so that it does not need to be repeated within both the SELECT and GROUP BY clause For example... SELECT CASE WHEN Order_Date IS NULL THEN 'Unknown' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 0 AND 6 THEN 'Recent' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 6 AND 18 THEN 'Old' ELSE 'Ancient' END AS Recency, count(*) FROM Orders GROUP BY CASE WHEN Order_Date IS NULL THEN 'Unknown' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 0 AND 6 THEN 'Recent' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 6 AND 18 THEN ...Show All

• Visual Studio Tools for Office Excel - Clear contents for a sheet

  What is the best way to clear a sheet of all values off of an Excel sheet Either using the WorkSheet or WorkBook class My system is throwing an exception and am wondering if I am doing it wrong. advTHANKSance You can clear contents by using the ClearContents method of the Selection object. Using the Selection object, you can select cells in a specific range or a whole worksheet. It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issue ...Show All

• Visual C++ XML reader for native C++

  Hi! I'm looking for a small C++ XML SAX reader, similar to XmlTextReader in .NET. The most important thing is that the library is small can be statically linked. Can anybody recommend me anything Thanks in advance! Just look at www.codeproject.com and search for MSXML. You find enough samples there! Also search in the MSDN for MSXML and sample, also there is enough stuff. ...Show All

• Windows Forms Asynchronous Web service call real-time patterns

  I am currently using a timer to kick off periodic (say every 0.2 second) calls to a Web service a synchronously using the background worker component. I intend to use this pattern to update various user interface elements with the results from the Web service calls. I'm trying to use binding source objects (experimenting as they seem useful) to tie in the Web service results with the user interface (refreshing the binding source underlying list/data source in the work completed method of the background worker). I am new to Windows forms programming. Sorry if these questions are a bit too generic. A few ques ...Show All

• Visual Basic Unable to Connect to SQL Database when i Install my Application on Clients system....

  Hi! I have completed an Online Examination project in vb.net with SQL Database at Clients Office .. and i Deployed to Client.. and i installed it successfully...The problem is: When i open the Application an error message displays that unable to connect to server... but the application runs perfectly from the computer in which i developed... Actually the Database has to be connected through Office LAN... I have used the Connection String in vb.net as Dim conn As New SqlConnection("Data Source=BPO75;" + "Initial Catalog=ONLINEEXAM;" + "User ID=onlineexam;" + "Password=Exam;") Is i ...Show All

• Windows Forms Noob's Dumb Question

  What code do I use to make a the program reload  Or at least the command Reload what  Are you displaying some data from a database  A web site ...Show All

• Visual C++ why can't I use a vector<T> in in my C++/CLR DLL?

  #include <vector> using namespace System; public ref class SHELLS { public : SHELLS( void ); long shKey; int * faces; HPoint* pts; int faceCt; int ptCt; ShellTypes type; String^ path; }; ==> typedef vector<SHELLS> HShells; <== I get this compile error: error C2143: syntax error : missing ';' before '<' Use std::vector or put using namespace std somewhere within scope. Snickel65 wrote: #include <vector> using namespace System; public ref class SHELLS { public : SHELLS( void ); long shKey; int * faces; HPoi ...Show All

• Visual Studio Start Page and Proxys

  How can I make the visual studio 2005 RTM Start page work through an authenticating proxy server If you have proper configuration about the proxy on your IE settings, VS start page should work the same way as your IE browser. Thanks, Daniel ...Show All

• Visual C# Aborting and Managing Threads: The Dog or the Cat?

  Newbie here .... thanks in advance for your patience. I'm working w/ C# Visual Studio 2005 I've read up on all the comments about problems w/ aborting and suspending/resuming threads.  Lots of things to consider.  Looks kinda ugly on all fronts.  Note that I'm not thinking of using suspend and resume to synchronize threads.  I would like to just pause and then restart a particular thread from where it left off.  Worst case is to abort the thread. I'm not using a ThreadPool.  This is because some of my operations may take a long time (long running database access routines), may require different prioriti ...Show All

• Visual Basic drag and drop to a form lacks functionality

  1.  There is no error catching code in the bindingNavigator toolstrip buttons. 2. There is no canceledit button.  It's a pain having to add one each time. 3.  I would like to make my own control that includes not only the canceledit button but all the code I want.  I have no experience whatsoever in inherited controls or user controls.  So,    a.  Is it possible to include code in a user control   Can I create my own toolstrip with the code I want on the click event on each button, that also refers to subroutines that catches errors   As in DataWalkthrough, Smart Client Data in Visual Ba ...Show All

• Visual Basic generic error occured in GDI+ (drawline)

  I've just converted my program from VB 6 to VB 2005. There is a lot of graphics involved, drawing lots of lines to make models. The lines were all formerly drawn with the Line command on the forms, but now that that is gone i have run into problems switching to the new commands. My program is fairly large with many forms and modules so I was unsure about some of the things i did. I declared all the graphics in one module as follows: "Public Graph3d_yz As Graphics = frmDraw3d_yz.CreateGraphics() Public Graph3d_xz As Graphics = frmDraw3d_xz.CreateGraphics() Public Graph3d_xy As Graphics = frmDraw3d_xy.CreateGraphics() Public ...Show All

• .NET Development Column Expression

  I have database with two tables what i would like to do is in the sales table when i put data in the datagrid is to have a column expression that calculates the quantity * price that gives the total.I am using C# express edition2005 and SQL server express edition 2005 hope someone can help with code and where to place it. Thankyou http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp ...Show All