Database Development
|
| SQL Server |
7 Mar 2011
Updated: 9 Mar 2011
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 7,481
Bookmarked: 2
Downloaded: 0
I like the original solution, especially when compared to this (which I am posting just to show that there are other solutions):-- Initialize table.CREATE TABLE #BigStrings( StringID bigint IDENTITY(1,1) NOT NULL, StringValue text NOT NULL, CONSTRAINT PK_BigStrings PRIMARY KEY...
|
IDE
|
|
29 Jan 2010
Updated: 22 May 2010
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 19,241
Bookmarked: 1
Downloaded: 0
View multiple browser windows in the Visual Studio IDE to consolidate your workflow.
|
Productivity Apps and Services
|
| Microsoft Office |
19 Jul 2013
Updated: 20 Jul 2013
Rating: 4.71/5
Votes: 4
Popularity: 2.84
Licence: CPOL
Views: 21,163
Bookmarked: 7
Downloaded: 0
This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.
|
Programming Languages
|
| C# |
19 Nov 2009
Updated: 19 Nov 2009
Rating: 4.50/5
Votes: 3
Popularity: 2.15
Licence: CPOL
Views: 9,331
Bookmarked: 1
Downloaded: 0
I agree that in the above example, the use of var is a bit excessive. However, for very long types (such as a dictionary with the key and value both being lists of some nested classes... see below code example), this might actually improve readability (seeing so many details may overwhelm you). Assu
|
|
3 Feb 2011
Updated: 6 Feb 2011
Rating: 4.00/5
Votes: 3
Popularity: 1.91
Licence: CPOL
Views: 23,541
Bookmarked: 2
Downloaded: 4
I prefer this technique (uses less memory and may be faster, but requires slightly more code):public bool IsPalindrome(string str, StringComparison comparisonType){ bool valid = true; int halfway = str.Length / 2; int lastIndex = str.Length - 1; for (int i = 0; i <...
|
|
18 Mar 2011
Updated: 19 Mar 2011
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: CPOL
Views: 15,431
Bookmarked: 4
Downloaded: 0
Here is a slightly shorter version of your first conversion:object someValue = 1;int result = someValue as int? ?? -1;
|
| C# 4.0 |
23 Mar 2010
Updated: 23 Mar 2010
Rating: 5.00/5
Votes: 9
Popularity: 4.77
Licence: CPOL
Views: 8,590
Bookmarked: 4
Downloaded: 0
This version works regardless of parameters:public void AnyMethod(int parameter){ MethodInvoker wrapper = new MethodInvoker(delegate() { // Do your thing here! }); if (this.InvokeRequired) this.Invoke(wrapper); else wrapper();}Note also...
|
| SQL |
21 Mar 2010
Updated: 2 Feb 2011
Rating: 4.73/5
Votes: 4
Popularity: 2.85
Licence: CPOL
Views: 18,830
Bookmarked: 10
Downloaded: 0
Rather than use multiple subqueries to extract TOP 1 data, this shows you how to use a single TOP 1 JOIN.
|
|
18 Jul 2011
Updated: 18 Jul 2011
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 7,142
Bookmarked: 0
Downloaded: 0
If you are the type that likes to debug production code, you can use SQL Profiler to find queries generated by your LINQ statements. This is a technique I recently used because it was so simple and did not require me to recompile anything.Note that StefanHam already posted this alternate...
|
| Visual Basic |
2 Feb 2011
Updated: 2 Feb 2011
Rating: 4.69/5
Votes: 11
Popularity: 4.89
Licence: CPOL
Views: 38,632
Bookmarked: 8
Downloaded: 0
Lambdas can be composed of multiple lines of code.
|
|
30 Mar 2011
Updated: 2 Apr 2011
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 8,160
Bookmarked: 2
Downloaded: 0
VB.NET Version (C# Version)Thanks to cechode for inspiring this tip/trick. Suppose you have the following functions:Function Step1() As Boolean Return TrueEnd FunctionFunction Step2(ByVal val1 As Integer, ByVal val2 As Integer) As Boolean Return val1 = val2End...
|
|
24 Sep 2011
Updated: 26 Sep 2011
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 14,710
Bookmarked: 2
Downloaded: 0
The Silverlight WebBrowser won't navigate to some URL's, but this can be worked around.
|
|
28 Mar 2011
Updated: 1 May 2012
Rating: 5.00/5
Votes: 16
Popularity: 6.02
Licence: CPOL
Views: 48,664
Bookmarked: 17
Downloaded: 0
Call a series of functions until the return value meets a condition without a chained-if or short-circuiting.
|
| XSLT |
6 Dec 2010
Updated: 6 Dec 2010
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 37,752
Bookmarked: 3
Downloaded: 0
There are many ways to insert a newline in the output of an XSLT, but this is probably the easiest.
|
|
18 May 2011
Updated: 18 May 2011
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 6,650
Bookmarked: 1
Downloaded: 0
Thanks to this page, I found an even shorter alternative. First, you can add an entity in your DOCTYPE section:"> ]>You can then use this where you like in the document:&newline;That will get rendered...
|
Web Development
|
| ASP.NET |
22 Jun 2011
Updated: 22 Jun 2011
Rating: 4.83/5
Votes: 10
Popularity: 4.83
Licence: CPOL
Views: 12,610
Bookmarked: 3
Downloaded: 0
This can be automated and streamlined with generics. First, create a SessionVariable class:public class SessionVariable{ private string VariableName { get; set; } private System.Web.SessionState.HttpSessionState Session { get; set; } public T Value { get ...
|
|
20 May 2013
Updated: 20 May 2013
Rating: 3.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 56,080
Bookmarked: 6
Downloaded: 0
Call a uniquely named JavaScript function inside of an ASP.NET user control from the page it is hosted inside of.
|
|
3 Dec 2010
Updated: 4 Dec 2010
Rating: 4.33/5
Votes: 2
Popularity: 1.30
Licence: CPOL
Views: 12,232
Bookmarked: 3
Downloaded: 0
If you place your ASP.Net embedded code blocks after the controls they reference, you may not get the output you expected.
|
|
2 Mar 2011
Updated: 3 Mar 2011
Rating: 4.33/5
Votes: 3
Popularity: 2.07
Licence: CPOL
Views: 45,412
Bookmarked: 4
Downloaded: 0
Using TinyMCE is fairly simple, but attempting to access the value entered by the user in ASP.NET 4.0 presents with some problems.
|
|
5 Jul 2011
Updated: 5 Jul 2011
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 14,390
Bookmarked: 1
Downloaded: 0
There is a fourth function.RegisterClientScriptResource(): Adds a reference to a JavaScript file that has been embedded into an assembly (DLL). Read more about that here: Managing Your JavaScript Library in ASP.NET.
|
|
12 Jan 2012
Updated: 18 Oct 2012
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 39,363
Bookmarked: 7
Downloaded: 0
You can't use an if statement in a bound code block, but you can still use conditions in your markup based on bound data.
|
|
12 Jan 2012
Updated: 18 Oct 2012
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 21,751
Bookmarked: 6
Downloaded: 0
C# version
|
|
14 Jul 2013
Updated: 15 Jul 2013
Rating: 4.83/5
Votes: 3
Popularity: 2.31
Licence: CPOL
Views: 11,821
Bookmarked: 3
Downloaded: 0
In this alternate version, we take into account the possibility that binding to a list of different types may cause compile errors.
|
| HTML |
23 Nov 2010
Updated: 6 May 2011
Rating: 4.93/5
Votes: 22
Popularity: 6.30
Licence: CPOL
Views: 174,782
Bookmarked: 26
Downloaded: 0
This demonstrates how you can call a C# method in a Windows Forms application from JavaScript that is hosted in a webpage inside a WebBrowser control on your form.
|
|
25 May 2011
Updated: 27 May 2011
Rating: 5.00/5
Votes: 15
Popularity: 5.88
Licence: CPOL
Views: 211,522
Bookmarked: 25
Downloaded: 0
A JavaScript function to replace string placeholders with values
|
Submit an article or tip