How to check for ‘IS NOT NULL’ And…
If you only want to match N'' as an empty string SELECT COLUMN FROM TABLE WHERE DATALENGTH(COLUMN) > 0 If you want to count any string consisting entirely of spaces as empty SELECT COLUMN FROM…
How to auto-scroll or manually to end of…
Auto-Scroll (every 5 seconds) window.setInterval(function() { var element = document.getElementById("myDiv"); element.scrollTop = element.scrollHeight; }, 5000); (more…)
Filter Rows By Max Date in SQL
SELECT m1.Column1, m1.Column2, m1.Column3, r.MaxTime FROM ( SELECT Column1, MAX(TimeColumn) as MaxTime FROM MyTable GROUP BY Column1 ) r INNER JOIN MyTable m1 ON m1.Column1= r.Column1AND m1.TimeColumn = r.MaxTime
How to Validate a DateTime in C#?
DateTime myDate; if(DateTime.TryParse(txtBirthDate.Text, out myDate)) { //Valid Date } else { //Invalid Date }
Convert comma separated string into a List in…
string myList = "9,3,12,43,2"; List<int> intList = myList.Split(',').Select(int.Parse).ToList();
Converting a List to a comma separated string…
List<int> list = new List<int>() {1,2,3}; string.Join<int>(",", list) Join has generic overloads. It is so much easier to use it in that way to convert your list to the different types.
How to add placeholder to Multiple Selection DropDownList…
@Html.ListBox( "Countries", ViewBag.AllCountries as MultiSelectList, new { @class = "form-control", data_placeholder = "Choose a Country..." } )
How to use toFixed() for Float numbers in…
The toFixed() method formats a number using fixed-point notation. function financial(x) { return Number.parseFloat(x).toFixed(2); } console.log(financial(123.456)); // expected output: "123.46" console.log(financial(0.004)); // expected output: "0.00" console.log(financial('1.23e+5')); // expected output: "123000.00" OUTPUT: > "123.46" > "0.00" > "123000.00"
Convert List to List in one line in…
string sNumbers = "1,2,3,4,5"; var numbers = sNumbers.Split(',').Select(Int32.Parse).ToList();