Set Memory Limit
In wp-config.php edit or add this line: define('WP_MEMORY_LIMIT', '256M');
ERD Notation
Relationships illustrate an association between two tables. In the physical data model, relationships are represented by stylized lines. Cardinality and ordinality, respectively, refer to the maximum number of times an instance in one entity can be associated with instances in the related entity, and the minimum number of times an instance in one entity can [...]
DELETE BULK
WHILE @@ROWCOUNT <> 0 BEGIN DELETE TOP (1000000) FROM [database].[schema].[table] WHERE [Col1] = 'abc' DBCC SHRINKDATABASE(N'_APPL' ) END
Split (String)
string[] _Split = _DataRowView[2].ToString().Split((char)44); int _SplitCount = 1; foreach (string s in _Split) { if (s != "") { if (_SplitCount == 1) { _CursorX = System.Convert.ToInt32(s); } if (_SplitCount == 2) { _CursorY = System.Convert.ToInt32(s); } } _SplitCount += 1; } MSDN Artikel
HttpWebRequest
System.Net.HttpWebRequest _httpWebRequest = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(_URL); // Proxy Credentials System.Net.WebProxy _WebProxy = new System.Net.WebProxy(); _WebProxy.Address = new Uri(_ProxyServer); _WebProxy.Credentials = new System.Net.NetworkCredential(_ProxyUsername, _ProxyPassword); _httpWebRequest.Proxy = _WebProxy; // Network Credentials _httpWebRequest.Credentials = new System.Net.NetworkCredential(_NetworkUsername, _NetworkPassword); _httpWebRequest.PreAuthenticate = true; _httpWebRequest.Timeout = System.Threading.Timeout.Infinite; System.Net.HttpWebResponse _httpWebReponse = null; try { _httpWebReponse = (System.Net.HttpWebResponse)_httpWebRequest.GetResponse(); } catch (System.Net.WebException ex) { } System.IO.StreamReader [...]
Drive(s)
System.IO.DriveInfo[] _allDrives = System.IO.DriveInfo.GetDrives(); foreach (System.IO.DriveInfo _Drive in _allDrives) { System.Windows.Forms.MessageBox.Show(_Drive.TotalSize.ToString()); System.Windows.Forms.MessageBox.Show(_Drive.TotalFreeSpace.ToString()); }
Events
public delegate void Finished_EventHandler(System.DateTime _FinishedDateTime, string _RunTime, string _ThreadID); public event Finished_EventHandler Finished; private input_DelegateVoid private_DelegateVoid; public void Start(input_DelegateVoid _DelegateVoid) { Run(); } private void Run() { if (Finished != null) { Finished(System.DateTime.Now, (System.DateTime.Now - _StartTime).ToString(), System.Threading.Thread.CurrentThread.ManagedThreadId.ToString()); } } MSDN Artikel
Delegate
delegate void delegateUpdateProgress(int _ProgressValue); this.Invoke(new delegateUpdateProgress(this.UpdateProgress), new object[] { 'some value' }); private void UpdateProgress(int _ProgressValue) { this.UltraStatusBar.Panels["Progress"].Visible = true; this.UltraStatusBar.Panels["Progress"].ProgressBarInfo.Value = _ProgressValue; } MSDN Artikel
Cursor (C#)
// wait System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; // reset System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
context connection (SQL CLR)
using (System.Data.SqlClient.SqlConnection _SQLConnection = new System.Data.SqlClient.SqlConnection("context connection=true")) { // SQL Connection öffnen _SQLConnection.Open(); } MSDN Artikel