| c# Programming Glossary: openHow to check for file lock? http://stackoverflow.com/questions/1304/how-to-check-for-file-lock  catch block Right now the only way I know of is to just open the file and catch any System.IO.IOException.  c# .net io filelock.. If your code would look like this if not locked then open and update file Then between the two lines another process could.. 
 Create Excel (.XLS and .XLSX) file from C# [closed] http://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c-sharp  I create an Excel Spreadsheet with C# Ideally I would like open source so I don't have to add any third party dependencies to..  You can use a library called ExcelLibrary. It's a free open source library posted on Google Code ExcelLibrary This looks.. 
 What are the pros and cons to keeping SQL in Stored Procs versus Code http://stackoverflow.com/questions/15142/what-are-the-pros-and-cons-to-keeping-sql-in-stored-procs-versus-code  Stored Procs I've been discussing this with a friend on an open source project that we're working on C# ASP.NET Forum . At the.. 
 TransactionScope automatically escalating to MSDTC on some machines? http://stackoverflow.com/questions/1690892/transactionscope-automatically-escalating-to-msdtc-on-some-machines  connection.Open and yes there is no other connection open at the time. using TransactionScope transactionScope new TransactionScope.. strings nor do we have nested secondary connections opening there should not be escalation to DTC . http davidhayden.com.. cause a transaction to be promoted. However whenever you open a second connection to a database causing the database to enlist.. 
 Proper use of the IDisposable interface http://stackoverflow.com/questions/538060/proper-use-of-the-idisposable-interface  to eventually come along and free it What if there's an open database connection Surely we don't want that connection sitting.. connection Surely we don't want that connection sitting open waiting for the GC to finalize the object. If the user has called.. 
 How do I convert Word files to PDF programmatically? http://stackoverflow.com/questions/607669/how-do-i-convert-word-files-to-pdf-programmatically  Word files to PDF programmatically  I have found several open source freeware programs that allow you to convert .doc files.. add in installed. It searches a directory for .doc files opens them in Word and then saves them as a PDF. Note that you'll.. Close the Word document but leave the Word application open. doc has to be cast to type _Document so that it will find the.. 
 Using C# regular expressions to remove HTML tags [duplicate] http://stackoverflow.com/questions/787932/using-c-sharp-regular-expressions-to-remove-html-tags   This question already has an answer here   RegEx match open tags except XHTML self contained tags     36 answers     How.. 
 How can I detect the encoding/codepage of a text file http://stackoverflow.com/questions/90838/how-can-i-detect-the-encoding-codepage-of-a-text-file  this. I've created a small app that the user can use to open the file with and enter a text that user knows it will appear.. 
 ExecuteReader requires an open and available Connection. The connection's current state is Connecting http://stackoverflow.com/questions/9705637/executereader-requires-an-open-and-available-connection-the-connections-curren  requires an open and available Connection. The connection's current state is.. people connect simultaneously ExecuteReader requires an open and available Connection. The connection's current state is.. execution many identical connections will be repeatedly opened and closed. To minimize the cost of opening connections ADO.NET.. 
 How can a Word document be created in C#? [closed] http://stackoverflow.com/questions/10412/how-can-a-word-document-be-created-in-c  of either using Office Automation or using the Office Open XML format see links below which is supported by Microsoft Office.. via Google and is fairly simple to learn. However the Open Office XML format is fairly new so you might find the learning.. might find the learning curve to be a bit higher. Office Open XML Iinformation Office Open XML http en.wikipedia.org wiki.. 
 Making Entity Class Closed for Changes http://stackoverflow.com/questions/11425993/making-entity-class-closed-for-changes  my œPayment domain class. How do I make the payment class Open for Extension and Closed for Changes still using ORM Note The.. 
 Keeping ASP.NET Session Open / Alive http://stackoverflow.com/questions/1431733/keeping-asp-net-session-open-alive  ASP.NET Session Open Alive  What is an easy and unobstrusive way to keep an ASP.NET.. 
 Create Excel (.XLS and .XLSX) file from C# [closed] http://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c-sharp  System.Threading.Thread.CurrentThread.CurrentCulture Open a DB connection in this example with OleDB OleDbConnection con.. con new OleDbConnection dbConnectionString con.Open Create a query and fill the data table with the data from the.. 
 Transitioning from Windows Forms to WPF http://stackoverflow.com/questions/15681352/transitioning-from-windows-forms-to-wpf 
 The underlying provider failed on Open http://stackoverflow.com/questions/2475008/the-underlying-provider-failed-on-open  underlying provider failed on Open  I was using .mdf for connect to DB and entityClient. Now I.. I always get error The underlying provider failed on Open  c# sql server entity framework database connection   share.. 
 Code Coverage for C#/.NET [closed] http://stackoverflow.com/questions/276829/code-coverage-for-c-net  Integrated into Visual Studio At least 5 469 PartCover Open Source Supports statement coverage OpenCover successor to PartCover.. 5 469 PartCover Open Source Supports statement coverage OpenCover successor to PartCover OpenSource Supports branch and statement.. statement coverage OpenCover successor to PartCover OpenSource Supports branch and statement coverage 32 and 64 bit support.. 
 Facebook/ Twitter with dotnetopenauth? [closed] http://stackoverflow.com/questions/4821747/facebook-twitter-with-dotnetopenauth  Twitter with dotnetopenauth closed  I've pretty much got OpenID working using the DotNetOpenAuth library. Now I would like..  I've pretty much got OpenID working using the DotNetOpenAuth library. Now I would like users to be able to use Facebook.. OAuth so I am looking for a tutorial on how to use DotNetOpenAuth OAuth. I'm having trouble trying to find some simple tutorials.. 
 How do I convert Word files to PDF programmatically? http://stackoverflow.com/questions/607669/how-do-i-convert-word-files-to-pdf-programmatically  FileInfo wordFile in wordFiles Cast as Object for word Open method Object filename Object wordFile.FullName Use the dummy.. for optional arguments Document doc word.Documents.Open ref filename ref oMissing ref oMissing ref oMissing ref oMissing.. 
 Generate a PDF that automatically prints http://stackoverflow.com/questions/6167995/generate-a-pdf-that-automatically-prints  PdfAction.PRINTDIALOG for this and associate it with the OpenAction event of your pdf file. The code in iText Java should.. action new PdfAction PdfAction.PRINTDIALOG writer.setOpenAction action ... It should not be too diferent in C#. As a side.. document pdfCreator1.Document Open a PDF document from file System.IO.FileStream file1 new System.IO.FileStream.. 
 Finalize vs Dispose http://stackoverflow.com/questions/732864/finalize-vs-dispose  in a single action. The general usage is often like this. Open read or write close Dispose . It fits very well with the using.. 
 Free obfuscation tools for .NET [closed] http://stackoverflow.com/questions/805549/free-obfuscation-tools-for-net  obfuscation tools for .NET closed  Please point me to FREE Open source obfuscation tools for .NET assemblies. Edit I also want.. 
 How can I detect the encoding/codepage of a text file http://stackoverflow.com/questions/90838/how-can-i-detect-the-encoding-codepage-of-a-text-file  about codepages Codepages exist and are annoying. Solution Open the received file in Notepad look at a garbled piece of text... 
 ExecuteReader requires an open and available Connection. The connection's current state is Connecting http://stackoverflow.com/questions/9705637/executereader-requires-an-open-and-available-connection-the-connections-curren  string promotionUrl Promotion promotion null SqlOpenConnection SqlCommand sql SqlCommandConnection sql.CommandText.. each given connection configuration. Whenever a user calls Open on a connection the pooler looks for an available connection.. returned to the pool it is ready to be reused on the next Open call. So obviously there's no reason to avoid creating opening.. 
 |