Tuesday, March 31, 2015

Kendo UI Grid show no data text in to grid


if you want to show no data in to the grid when the grid datasource will be empty use this in to grid script 

  //No data in the grid show message  
               function gridDataBound(e) {  
                 var grid = e.sender;  
                 if (grid.dataSource.total() == 0) {  
                   var colCount = grid.columns.length;  
                   $(e.sender.wrapper)  
                     .find('tbody')  
                     .append('<tr class="kendo-data-row"><td colspan="' + colCount + '" class="no-data EmptyGrid">There is no data to show in the grid.</td></tr>');  
                 }  
               };  

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...