function selectAll() { $("#DivContainingCheckboxesID :checkbox").attr('checked', true); } function selectNone() { $("#DivContainingCheckboxesID :checkbox").attr('checked', false); } //if you want to do something specific for each check box $("#DivContainingCheckboxesID :checkbox").each(function () { //do it here if (this.checked) this.click();}); ......

---

So, this morning, my phone was locked out after many wrong lock pattern entries.Phone was asking for gmail username/pass. For some reason, it was not accepting the correct username/password. It was relief when it occurred to me that I had two step verification enabled. I disabled the two step verification from my PC and was able to log into the phone ......

---

Here is a extension method which can be used to perform the Delete operation on a DataTable just like the select i.e. using a filterExpression: using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; public static class MyExtensions { /// <summary> /// Delete row based on filterExpression /// </summary> ......

---

I ended up using the MS Excel objects to convert files from XLS to CSV . Converted CSV had comma "," as field separator. But, what if the a filed content has comma like "lastName,FirstName". Now if you use default .net split method to get the fileds of a row in csv file, it will treat "lastName,FirstName" as two fields. I ended up writing my own split ......

---

Presumption/limitation: yearly holidays are stored in a table maximum 2 consecutive holidays Table structure: HOLIDAY_DATE (DATETIME),HOLIDAY_DESC (VARCHAR) DB Script : DECLARE @CurrentDay DATETIME DECLARE @LastWorkingDay DATETIME, @CurrentWeekDay INT SET @CurrentDay = CAST(CONVERT(VARCHAR, GETDATE(), 101) AS DATETIME) SET @LastWorkingDay = CAST(CONVERT(VARCHAR, ......

---

I got this error on production for a report which was working fine in Dev and it took me a while to figure out the cause. Report's Data Source was pointing to a SQL Server View, when I looked at the SQL Query ( Database - > Show SQL Query ), I noticed that Database name was there with view name: "DbName.dbo.ViewName" I did a lot of googling, trying ......

---

Quite Straight forward: Select the Column , Right Click -> Propoerties OR hit F4 Visibility -> Hidden -> Expression i.e. Click on Hidden under Visibility and select Expression from Drop Down Write the expression e,g. =IIF(Parameters!MonthlyOrYe... ......

---

compared to FormatDateTime Good old 'Format' function makes the job a lot easier : Format(Fields!ResultDate.Va... Format(Fields!ResultDate.Va... =IIF(Parameters!MonthlyOrYe... ......

---

I was trying to add a new field in an Oracle DB table using this script: alter table TABLENAME add FIELDNAME char(1) not null default '0' ; it was throwing an error: 'ORA-30649:missing directory keyword' it drove me nutts for a while and after some googling, I was able to figure it out, its the Order: 'not null' should come after default value. right ......

---

A JavaScript object can be of great help when you need to pass multiple values to a Modal Window. E.G. var objArgs = new Object(); objArgs.Value1 = "Value 1"; objArgs.Value2 = 2; var modalWindowFeatures = 'dialogHeight:600px;dialogW... url = 'relative/path/to/page'; var returnValue; returnValue = window.showModalDialog(url,... ......

---