Help Doc For Dynamic ShowHideColumns Related to DataTables

Snippet Sample HTMl Snippet <div class=”dropdown showHideColumns” data-target=”mainTable1″>     <button class=”btn btn-primary dropdown-toggle” type=”button” data-toggle=”dropdown”>         <i class=”fa fa-gear”></i>         Show Hide Columns         <span class=”caret”></span>     </button>     <ul class=”dropdown-menu”></ul> </div> Here data-target=”mainTable1″ -> here mainTable1 represents the id for datatable Required Dependent JS Snippet function ShowHideColumn(target, colIndex) { var mTable = ‘#’ + target; var myDataTable = $(mTable).DataTable(); // Get the column API object var column = myDataTable.column(colIndex); // Toggle the visibility column.visible(!column.visible()); …

Help Doc For Dynamic ShowHideColumns Related to DataTables Read More »

EF Context CheckList

Normal General Processing Synchronous EF DB Context Data Insert EF DB Context Data Update EF DB Context Data Select EF DB Context Data Delete Bulk Processing Synchronous EF DB Context Data Insert EF DB Context Data Update EF DB Context Data Select EF DB Context Data Delete Normal General Processing Asynchronous EF DB Context Data …

EF Context CheckList Read More »

For Ajax Add Page

c# aspt.net controller part region url for ajax load blank form create async partiaviewresult action method load respective add form in partial view region url for ajax submit/save Create async JSONResult action method grab/get posted data save them to table if success return json with status true and data with recently added id if fail …

For Ajax Add Page Read More »

For Fixed Header Sample Code

<table class=”table table-striped table-fixed-header table-hover ” id=”reportContent “> <thead id=”pageHeader” class=”header”> <tr> <th colspan=”2″ width=”100px”>&nbsp;</th> <th width=”100px”>Ledger Code</th> <th>Ledger Name</th> <th width=”100px”>Debit</th> <th width=”100px”>Credit</th> </tr> </thead>

Madhyapur Hospital Backup Plan

Application/Files/Database to backup SN Application Description Runtime User Uploads Database 1 Main MIS Web Application Yes Yes Yes 2 Desktop Application Yes No No 3 Payroll Application Yes Yes Yes 4 Inventory Application Yes No Yes 5 Main MIS Web Application [2073] Yes No Yes 6 Old Record Check Application Yes Yes Yes

Fix User Server Principal authentication error after db restore

use database_name; — ALTER DATABASE database_name SET READ_WRITE ——– Reset SQL user account guids ——————— DECLARE @UserName nvarchar(255) DECLARE orphanuser_cur cursor for SELECT UserName = su.name FROM sysusers su JOIN sys.server_principals sp ON sp.name = su.name WHERE issqluser = 1 AND (su.sid IS NOT NULL AND su.sid <> 0x0) AND suser_sname(su.sid) is null ORDER BY …

Fix User Server Principal authentication error after db restore Read More »