Posts

Export html table data to excel using jQuery

If you are looking for a solution to export the html table data using jQuery, this post will help you in that. Let’s get started Step 1 - Prerequisite             jQuery - https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.5.9/angular.js Step 2 – Html Code < div >< img src ="~/Images/Excel.png" class ="export" id ="exportToExcel" /></ div > < iframe id ="frmExcel" style =" display : none"></ iframe > < table id ="tblDDeltaDrData">                     < tr >                         < th class ="tblHeader"> Account </ th >                 ...

Allow only numbers/decimal in input box using AngularJS

If your requirement is to restrict the user input on number and decimal using angularJS then this post will help you in that. If you are using the jQuery then you can visit this post. Let’s get started Step 1 – Prerequisites https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.5.9/angular.js Step 2 – HTML Code < input name ="NoOfContracts" allow-Decimal-Numbers type ="text" id ="NoOfContracts" /> < input name ="Price" allow-Numbers type ="text" id ="Price" /> Step 3 – angularJS code Only Numeric                 var app = angular.module( 'App' , []);        app.directive( 'allowNumbers' , function () {         return {             restrict: "A" ,             link: function (scope, element...

Microsoft SQL Server In A Glance

SQL Server In a glance Data manipulation Language (DML) – Insert/Update/Delete/Select Data Dynamic Language (DDL) – Create/Alter/Drop/Truncate Data Control Language (DCL) – Grant/Revoke Dynamic Management View (DMV) – Server State/Monitor health of system Transactional Control Language (TCL) – Commit/Rollback ACID Properties A – Atomicity – All or no transaction C – Consistency – Move a transaction from one state to another I - Isolation – Keep transaction separate D – Durability – Make sure no data lost Keys Primary Key – Uniquely identifying each row in a table Foreign Key – It is used to generate the relationship between the tables. Composite/Compound Key –key that consist of two or more columns that uniquely identify rows in a table. Unique Key - Uniquely identifying a row in a table. It can also store Null values Candidate Key – key that consist of two or more columns that uniquely identify rows in a table and one key chosen as primary key....

Open Dialog Box from Server side code

Open Dialog Box from Server side code If your requirement is to open a dialog box from the code behind, this post will help you in this. Mainly we need this when we are performing the validation on server side and wants to open the error messages in dialog box. Follow the below steps to implement this in your web application Step 1 – Prerequisite                 Jquery CDN < script   type ="text/javascript"   src ="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></ script > < script   src ="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js"   type ="text/javascript"></ script > Step 2 – Html Code             < div id ="dialog" title ="Warning" style =" display :none;">                 ...