c# Programming Glossary: withhttp://stackoverflow.com/questions/142003/cross-thread-operation-not-valid-control-accessed-from-a-thread-other-than-the
Create Excel (.XLS and .XLSX) file from C# [closed] http://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c-sharp file from C# closed How can I create an Excel Spreadsheet with C# Ideally I would like open source so I don't have to add any.. but may not yield much more than what I can achieve with CSV files. I will look more into the 2003 xml format but that.. that lets you use DataSets and DataTables to easily work with Excel data. ExcelLibrary seems to still only work for the older..
How to properly clean up Excel interop objects http://stackoverflow.com/questions/158706/how-to-properly-clean-up-excel-interop-objects guess you're invoking at least one member of a COM object without assigning it to a variable. For me it was the excelApp.Worksheets.. was the excelApp.Worksheets object which I directly used without assigning it to a variable Worksheet sheet excelApp.Worksheets.Open.. rule for the usage of COM objects in C# Never use 2 dots with com objects. So with this knowledge the right way of doing the..
Encrypt/Decrypt string in .NET http://stackoverflow.com/questions/202011/encrypt-decrypt-string-in-net new MemoryStream bytes Create a RijndaelManaged object with the specified key and IV. aesAlg new RijndaelManaged aesAlg.Key..
Sending email in .NET through Gmail http://stackoverflow.com/questions/32260/sending-email-in-net-through-gmail not the deprecated System.Web.Mail . Doing SSL with System.Web.Mail is a gross mess of hacky extensions. using System.Net..
Dynamic LINQ OrderBy on IEnumerable<T> http://stackoverflow.com/questions/41244/dynamic-linq-orderby-on-ienumerablet this question Just stumbled into this oldie... To do this without the dynamic LINQ library you just need the code as below... scenarios including nested properties. To get it working with IEnumerable T you could add some wrapper methods that go via.. T result Edit it gets more fun if you want to mix that with dynamic although note that dynamic only applies to LINQ to Objects..
http://stackoverflow.com/questions/441309/why-are-mutable-structs-evil in the answer to this question . What's the actual problem with mutability and structs c# struct immutability mutable share..
Random number generator only generating one random number http://stackoverflow.com/questions/767999/random-number-generator-only-generating-one-random-number int 0xFFFF int 0xFFFFFF 256 If I step that loop with the debugger during runtime I get different values which is..
http://stackoverflow.com/questions/78536/deep-cloning-objects-in-c-sharp copying each property individually but it always leaves me with the feeling that there is a better or more elegant way of handling.. copy an object so that the cloned object can be modified without any changes being reflected in the original object c# .net.. cloning everything when an object gets too complex. And with the use of extension methods also from the originally referenced..
http://stackoverflow.com/questions/846994/how-to-use-html-agility-pack body if bodyNode null Do something with bodyNode NB This code is an example only and not necessarily.. also accepts a stream which is very useful in integrating with other stream oriented classes in the .NET framework. While HtmlEntity.DeEntitize..
Problem with converting int to string in Linq to entities http://stackoverflow.com/questions/1066760/problem-with-converting-int-to-string-in-linq-to-entities linq to entities tostring share improve this question With EF v4 you can use SqlFunctions.StringConvert . There is no overload..
Communicate between two windows forms in C# http://stackoverflow.com/questions/1665533/communicate-between-two-windows-forms-in-c-sharp Property as public in Form1 which is modified in Form2. With this approach you can do communication in different ways. Download..
Getting attributes of Enum's value http://stackoverflow.com/questions/1799370/getting-attributes-of-enums-value following enum enum FunkyAttributesEnum Description Name With Spaces1 NameWithoutSpaces1 Description Name With Spaces2 NameWithoutSpaces2.. enum FunkyAttributesEnum Description Name With Spaces1 NameWithoutSpaces1 Description Name With Spaces2 NameWithoutSpaces2 What.. Name With Spaces1 NameWithoutSpaces1 Description Name With Spaces2 NameWithoutSpaces2 What I want is given the enum type..
What's the point of the var keyword? http://stackoverflow.com/questions/209199/whats-the-point-of-the-var-keyword by making it optional to declare a local variable . With Boo both the type and the declaration can be implied. Which..
Why .NET String is immutable? [duplicate] http://stackoverflow.com/questions/2365272/why-net-string-is-immutable of memory was a performance win in the case in question . With mutable objects that can't be done. No side effects can come..
Why XML-Serializable class need a parameterless constructor http://stackoverflow.com/questions/267724/why-xml-serializable-class-need-a-parameterless-constructor constructor I'm writing code to do Xml serialization. With below function. public static string SerializeToXml object obj..
Convert webpage to image from ASP.NET http://stackoverflow.com/questions/2715385/convert-webpage-to-image-from-asp-net m_FileName string.Empty public WebsiteToImage string url Without file m_Url url public WebsiteToImage string url string fileName.. url public WebsiteToImage string url string fileName With file m_Url url m_FileName fileName public Bitmap Generate Thread..
Code Coverage for C#/.NET [closed] http://stackoverflow.com/questions/276829/code-coverage-for-c-net right click on your unit test class library and hit Test With Coverage and it will pull up the report. share improve this..
What is the best way to build XML in C# code? [closed] http://stackoverflow.com/questions/284324/what-is-the-best-way-to-build-xml-in-c-sharp-code your best practices for building XML using C#. Edit With the help of Shog9 I just learned about the community wiki feature..
How To Represent 0.1 In Floating Point Arithmetic And Decimal http://stackoverflow.com/questions/3448777/how-to-represent-0-1-in-floating-point-arithmetic-and-decimal mmmmmmmmmmmmmmmmmmmmmmm 0 01111110 10100000000000000000000 With the implicit base of 1 that's equivalent to the binary 01111110..
Entity Framework 4 Delete Object from entity collection http://stackoverflow.com/questions/4922228/entity-framework-4-delete-object-from-entity-collection of unique Id and OrderId which is FK of Order table. With this configuration you don't need to iterate through OrderItems..
C# - The foreach identifier and closures http://stackoverflow.com/questions/512166/c-sharp-the-foreach-identifier-and-closures improve this question The second is safe the first isn't. With foreach the variable is declared outside the loop i.e. Foo f..
Using Xpath With Default Namespace in C# http://stackoverflow.com/questions/585812/using-xpath-with-default-namespace-in-c-sharp Xpath With Default Namespace in C# I've got an XML document with a default..
Fastest Way of Inserting in Entity Framework http://stackoverflow.com/questions/5940225/fastest-way-of-inserting-in-entity-framework 9 scalar properties no navigation properties into the DB. With this code it works in less than 3 minutes. For the performance..
Accessing a Shared File (UNC) From a Remote, Non-Trusted Domain With Credentials http://stackoverflow.com/questions/659013/accessing-a-shared-file-unc-from-a-remote-non-trusted-domain-with-credentials a Shared File UNC From a Remote Non Trusted Domain With Credentials We've run into an interesting situation that needs..
http://stackoverflow.com/questions/796195/c-sharp-autocomplete SELECT Name from view_customers where Details LIKE ' 0 ' With 0 being the placeholder for the searched string. c# winforms..
Entity Framework - Using Transactions or SaveChanges(false) and AcceptAllChanges()? http://stackoverflow.com/questions/815586/entity-framework-using-transactions-or-savechangesfalse-and-acceptallchanges framework transactions share improve this question With the Entity Framework most of the time SaveChanges is sufficient...
C# How can I check if a URL exists/is valid? http://stackoverflow.com/questions/924679/c-sharp-how-can-i-check-if-a-url-exists-is-valid DownloadString to check for errors no error It exists... With C# 2.0 VS2005 private bool headOnly public bool HeadOnly get..
C# 3.0 auto-properties - useful or not? http://stackoverflow.com/questions/9304/c-sharp-3-0-auto-properties-useful-or-not or not Note This was posted when I was starting out C#. With 2014 knowledge I can truly say that auto properties are among..
LINQ to SQL: Updating without Refresh when ?𤔡pdateCheck = Never??/a> http://stackoverflow.com/questions/11189688/linq-to-sql-updating-without-refresh-when-updatecheck-never
Is it possible to get the parsed text of a SqlCommand with SqlParameters? http://stackoverflow.com/questions/2789476/is-it-possible-to-get-the-parsed-text-of-a-sqlcommand-with-sqlparameters would hope to see the following text or something similar WITH SomeTable SomeColumn AS SELECT N' ' UNION ALL SELECT N' o' UNION.. static void Main string args const string COMMAND_TEXT @ WITH SomeTable SomeColumn AS SELECT N' ' UNION ALL SELECT N' o' UNION..
Exclusive access could not be obtained because the database is in use http://stackoverflow.com/questions/4046708/exclusive-access-could-not-be-obtained-because-the-database-is-in-use DATABASE DatabaseFullPath FROM DISK N' backUpPath ' WITH FILE 1 NOUNLOAD STATS 10 using SqlConnection con new SqlConnection.. kick all users off is ALTER DATABASE MyDB SET Single_User WITH Rollback Immediate GO Now you can perform your restore with..
Can I set up HTML/Email Templates with ASP.NET? http://stackoverflow.com/questions/620265/can-i-set-up-html-email-templates-with-asp-net of the page and voila You have your HTML email UPDATED WITH CAVEAT I was using the MailDefinition class on some aspx pages..
|