Dotnet Tutorials ,Codings & Examples: April 2016 <h1 class='display-2'> April 2016 ~ Dotnet Tutorials ,Codings & Examples</h1>

Jquery masked input control with knockout JS

Below is the sample code for phone and date mask with knockout js and jquery masked input


 <script src="http://knockoutjs.com/downloads/knockout-3.4.0.js" type="text/jscript"></script>  
 <script src="https://code.jquery.com/jquery-2.2.2.js" type="text/jscript"></script>  
 <script src="https://rawgit.com/digitalBush/jquery.maskedinput/1.4.1/dist/jquery.maskedinput.js" type="text/jscript"></script>  
 PhoneNumber :  
 <input type="text" id="txtPhoneNumber" data-bind="MaskedInput: WorkPhone, mask: '(999) 999-9999'" />  
 </br>  
 </br>  
 Date :  
 <input type="text" id="txtDate" data-bind="MaskedInput: Date, mask: '99/99/9999'" />  
 <script>  
   var ViewModel = function () {  
     var self = this;  
     self.WorkPhone = ko.observable('');  
     self.Date = ko.observable('');  
     ko.bindingHandlers.MaskedInput = {  
       init: function (element, valueAccessor, allBindings, viewModel, bindingContext) {  
         ko.bindingHandlers.value.init(element, valueAccessor, allBindings, viewModel, bindingContext);  
       },  
       update: function (element, valueAccessor, allBindings, viewModel, bindingContext) {  
         ko.bindingHandlers.value.update(element, valueAccessor, allBindings, viewModel, bindingContext);  
         $(element).mask(allBindings.get('mask'));  
         valueAccessor()($(element).val());  
       }  
     };  
     //uncomment the following line to enable ko.validation for the control, otherwise validation for the control won't work.  
     //ko.validation.makeBindingHandlerValidatable('MaskedInput');  
   }  
   ko.applyBindings(new ViewModel());  
 </script>  

What is the difference between char, nchar, varchar, and nvarchar in SQL Server?

nchar:

 1) support unicode characters
 2) fixed length variable
 3) Maximum length of 4,000 characters.
 3) it will reserve  storage space for number of size you specify.

e.g: nchar(10) if you store only 3   characters and it will reserve space for 10 characters and remaining 7 character space  will be waste.

char:

 1) does not support unicode character.
 2) fixed length variable 
 3) Maximum length of 8,000 characters.
 4) it will reserve  storage space for number of size you specify.

 e.g: nchar(10) if you store only 3   characters and it will reserve space for 10 characters and remaining 7 character space  will be waste.


varchar:

 1) does not support unicode character.
 2) variable length variable
 3) varchar(n) - Maximum 8,000 characters and varchar(max) - Maximum 1,073,741,824 characters
 4) it will reserve storage space for the data you store.

e.g: nvarchar(50) if you store only 25   characters and it will reserve space only for 25 characters and remaining 25 character space  will not allocate  in memory.

nvarchar:

 1) support unicode characters
 2) variable length variable
 3) nvarchar(n) - Maximum 4,000 characters and nvarchar(max) - 536,870,912 characters
 4) it will reserve storage space for the data you store.

e.g: nvarchar(50) if you store only 25   characters and it will reserve space only for 25 characters and remaining 25 character space  will not allocate  in memory.