How to format decimal number like “00.00” in…
=Format(CDbl(Fields!YourDecimalNumber.Value),"00.00") OUTPUT for 3,2: 03.20 for 34: 34.00
How to display total sum of seconds in…
=Format(DateAdd("s", Fields!MySecondsField.Value, "00:00:00"), "HH:mm:ss")
How to split numeric and decimal parts in…
'Int' Function returns the integer protion of a number. For integer part: =Int(3.14159) -> This gives the number 3 or you can use with that value comes from DataSource =Int(Fields!TheDataSourceField.Value) For decimal part: =3.14159 -…
How to prevent to install a specific Windows…
The only thing you have to do is downloading "Windows Show or Hide Updates" troubleshooter tool. Here is the link: http://download.microsoft.com/download/F/2/2/F22D5FDB-59CD-4275-8C95-1BE17BF70B21/wushowhide.diagcab (more…)
How to fix Windows 10 can’t type in…
Usually, the issue is caused because your Language bar is turned off. Ctfmon.exe is the file responsible for controlling this feature. So, running the ctfmon.exe file resolves the issue. Hold Windows key and press R Type C:\Windows\system32\ctfmon.exe and press Enter
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();
How to use column search in datatable when…
just add "$("th").show();" in the end of initComplete ... , initComplete: function () { ... $("th").show(); } , ...