https://wiki.borovicka.name/ 2026-04-30T11:52:56+02:00 https://wiki.borovicka.name/ https://wiki.borovicka.name/lib/tpl/artic/images/favicon.ico text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/aspnetshedule?rev=1529603281&do=diff ASP.NET shedule private const string ReloadBartCodes_CacheKey = "ReloadBartCodes_CacheKey"; private const string HIT_PAGE_URL = "http://hit_page_url/"; private bool RegisterCacheEntry(string key, string value, int interval) { if (null != HttpContext.Current.Cache[key]) return false; HttpContext.Current.Cache.Add(key, value, null, DateTime.MaxValue, TimeSpan.FromMinutes(interval), … text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/bulkcopy?rev=1529603281&do=diff Bulk Copy (fast db insert) * Bulk copy is usually used when we need to insert bigger amount of data at once. * For bulk copy we need to have data in DataTable and define mappings to destination table. * Define mappings is not necessary when source and destination table are equivalent. text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/configfile?rev=1529603281&do=diff Configuration File * for windows application we usually use app.config, for web application web.config Get Connection String var connStr = ConfigurationManager.ConnectionStrings["MyConnStr"].ConnectionString; Get App Settings var settings = ConfigurationSettings.AppSettings["Mykey"]; text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/datetimefromexcel?rev=1529603281&do=diff Convert DateTime from excel DateTime.FromOADate DateTime.ToOADate Resources * <http://dotnetperls.com/datetime-1> text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/exceptionhandling?rev=1529603281&do=diff C# ASP.NET Exception handling Ošetření vyjímek na úrovni aplikace Pokud chceme, aby se uživateli neobjevila standardní hlaska Unhandled exception, nastavíme přesměrování na naší vlastní error stránku. web.config <customErrors mode="RemoteOnly" defaultRedirect="~/ErrorPage.aspx"> <error statusCode="404" redirect="404.html"/> <error statusCode="500" redirect="500.html"/> </customErrors> text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/executiontime?rev=1529603281&do=diff Execution time DateTime.UtcNow * very fast * bad resolution (10 milliseconds) DateTime begin = DateTime.UtcNow; ... DateTime end = DateTime.UtcNow; Console.WriteLine("Execution time: " + (end-begin).TotalMilliseconds + " ms."); Stopwatch * text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/getextension?rev=1529603281&do=diff Get extension from file name string extension; extension = Path.GetExtension(fileName); Resources * <http://msdn.microsoft.com/en-us/library/system.io.path.getextension.aspx> text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/gettopnfromdatatable?rev=1529603281&do=diff Get TOP N from DataTable private DataTable GetTopN(DataTable dt, int RowCount, int Start) { DataTable table = dt.Clone(); for(var i = Start; i <= Start + RowCount; i++) { if( i >= dt.Rows.Count ) break; table.ImportRow(dt.Rows[i]); } return table; } text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/lazyinitialization?rev=1529603281&do=diff Lazy initialization static readonly object padlock = new object(); private DataSet _dataSet; public DataSet DataSet { get { lock (padlock) { if (_dataSet == null) { _dataSet = new ...; } } return _dataSet; } } text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/md5hash?rev=1529603281&do=diff MD5 Hash * Returns MD5 Hash as string. using System.Security.Cryptography; ... /// <summary> /// Creates MD5 hash as a string. /// </summary> /// <param name="bytearray">Input array to be hashed.</param> /// <returns>Returns MD5 hash string</returns> public string GetMD5Hash(byte[] bytearray) { using (MD5 md5 = MD5.Create()) { byte[] byteHashed = md5.ComputeHash(bytearray); return… text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/memebershipandroleprovider?rev=1529603281&do=diff Membership and Role Provider <http://localhost:10428/asp.netwebadminfiles/default.aspx?applicationPhysicalPath=c>:\...\&applicationUrl=/ <connectionStrings> <add name="FinancialCalculatorConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Database;User ID=user;Password=pasword" providerName="System.Data.SqlClient" /> </connectionStrings> text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/readfromtextfile?rev=1529603281&do=diff Read from text file * Here is the code for reading from text file. StreamReader sr = null; string file = @"c:\temp\test.txt"; string line; try { sr = new StreamReader(file); while ((line = sr.ReadLine()) != null) { Console.WriteLine(line); } } finally { if (sr!= null) sr.Dispose(); } text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/regularexpressions?rev=1529603281&do=diff Regular expressions Password ?=^.{8,}$)((?=.*\d)|(?=.*\W+))(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$ Passwords will contain at least (1) upper case letter Passwords will contain at least (1) lower case letter Passwords will contain at least (1) number or special character Passwords will contain at least (8) characters in length Password maximum length should not be arbitrarily limited ^.*(?=.{8,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).*$ Must be at least 8 characters , contain at least one lower case le… text/html 2018-06-21T19:48:01+02:00 https://wiki.borovicka.name/programming/csharp/singleton?rev=1529603281&do=diff Singleton Singleton vs. static class Singleton * + we can use singletons as parameters * + control over instantion Static class * - lazy initialization * + easier Implementations With locks * Standard solution using locks. public sealed class Singleton { static Singleton _instance=null; static readonly object _lock = new object(); Singleton() { } public static Singleton Instance { get { lock (_lock) { …