C# Notes

Encrypt ConnectionString of Web.Config

In ordre to add security, we need to encrypt connectionstring section of web.config file. As web.config is plain text file, if not encrypted, username and password used for making database connection will be exposed to any reader. Encrypting Web.Config Open Command Prompt with Administrator privileges At the Command Prompt, enter: cd C:\Windows\Microsoft.NET\Framework\v4.0.30319 In case your …

Encrypt ConnectionString of Web.Config Read More »

DataTable Ajax Server Side Loading

Instead of Loading all items at once in clientside, we may require to load data partially with pagination for better loading. scenario: when we have 1000s of data in table and we are showing them without filtration Simple use Datatable Serverside Loading Changes in Controller side: For Client Side:

Things to take care while working with EF Code First

Code First Can be enabled for existing db or blank db Command for enabling Code First Enabled-Migrations This will generate Migration Folder and Migration Configuration File where by default automaticmigration will be false. Many people consider to change that as that will not apply pending changes to database automatically When we do have change in …

Things to take care while working with EF Code First Read More »

Change All Data Type of column from different table to new one

Things that we considered Default Constraint Nullable Renamed Default constraint name to df_tablename_column_name format declare @tData varchar(25) = ‘ decimal(14,2) ‘;–1. for cols without default constraint SELECT N’alter table ‘ + OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) + ‘.’ + T.[name] + ‘ alter column ‘ + C.[name] + @tData + case when C.[is_nullable] = 0 then ‘ not null …

Change All Data Type of column from different table to new one Read More »

handy css classes with js function

clickLoadAjaxModal clickLoadPage [data-poload] ajaxLoad showLoading hideLoading submitForm cmdPrint CheckAll ajaxSubmit showLoading [Type: function]: this function can be called anytime before calling ajax stuffs, it will simply show loading icon in screen hideLoading [type: function]: This function can be used to close loading icon in screen once ajax process is completed cmdPrint [type: css class]:this class …

handy css classes with js function Read More »

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 »