SQL Server Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT

Introduction:

Here I will explain difference between @@identity, scope_identity and ident_current in sql server with example. Generally @@identity, scope_identity and ident_current properties in sql server is used to get identity / id value of last or newly inserted record in table but only difference is scope either local or global and session either current session or other session in sql server.

Description:

In previous posts I explained cursor with example in sql server, difference b/w stored procedure and function in sql server, handle exceptions in sql server, difference between page_init and page_load events in asp.net, difference between ref and out parameters in c#, constructors in c#, vb.net with examples, delegates in c# with example, difference between len and datalength in sql server and many articles relating to interview questions, asp.net, c#.net. Now I will explain difference between @@identity, scope_identity and ident_current in sql server with example.

Angularjs ng-click Event in Inside UI-Grid Cell Template Not Trigger (Firing) Function in Controller

Introduction: 

Here I will explain how to set ng-click event in ui-grid cell template in AngularJS or fix problem of ng-click event in ui-grid cell template not working / firing / triggering function in controller in AngularJS. Generally ui-grid will isolate scope variable so there is no access to scope variable from row or cell template to fix this problem we need to use grid.appScope property it will allow to access scope variable from ui-grid row or cell template in AngularJS. We need to use the property like “ng-click="grid.appScope.yourfunction()"” in ui-grid cell template in AngularJS.

Description:
  
In previous articles I explained Angularjs show ui-grid no records found, Angularjs tutorial with simple hello world example, Angularjs convert number to currency format, Angularjs get dropdownlist selected value, Angularjs convert text to uppercase while typing, Angularjs refresh div for every 1 second using interval mode and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to set ng-click event in ui-grid cell template to access function in controller using AngularJS.

Angularjs Set Radio Button Default Value Checked / Selected using ng-init Example

Introduction: 

Here I will explain how to set default value of radiobutton selected / checked in AngularJS or radio button set default value checked or selected in AngularJS or show / hide div when radiobutton checked (selected) or option changed in AngularJS. By using ng-init, ng-show and ng-model properites we can set default value and we can show or hide div using AngularJS.

Description:
  
In previous articles I explained Angularjs tutorial with simple hello world example, Angularjs show confirm dialog box on button click example Angularjs convert number to currency format, Angularjs get dropdownlist selected value, Angularjs convert text to uppercase while typing, Angularjs refresh div for every 1 second using interval mode and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to set default value of radibutton selected or checked and show or hide div on radio button selection in AngularJS.

Angularjs Show Hide Div Based on Radiobutton Selection with Example

Introduction: 

Here I will explain how to show or hide div based on radiobutton selected option using AngularJS or show / hide div when radiobutton checked (selected) or option changed example in AngularJS. By using ng-show and ng-model options we can show or hide div based on radiobutton selection using AngularJS.

Description:
  
In previous articles I explained Angularjs tutorial with simple hello world example, Angularjs show confirm dialog box on button click example Angularjs convert number to currency format, Angularjs get dropdownlist selected value, Angularjs convert text to uppercase while typing, Angularjs refresh div for every 1 second using interval mode and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to show or hide div on radio button selection in AngularJS.

Set Date Format in JavaScript dd/mm/yyyy hh:mm:ss Example

Introduction: 

Here I will explain how to use JavaScript to set date format in dd/mm/yyyy hh:mm:ss with example or JavaScript change or set date format in dd/mm/yyyy hh:mm:ss with example. By using new Date() properties we can change date format to dd/mm/yyyy hh:mm:ss in JavaScript.

Description:
  
In previous articles I explained JavaScript replace special characters in string, jQuery create modal popup windows with example, jQuery remove whitespaces from string with regex, jQuery load more records on button click in repeater, jQuery fixed header on scroll with example, jQuery show asp.net exception message in ajax calls and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to change date format to dd/mm/yyyy hh:mm:ss in JavaScript with example.

JavaScript Get Date of 30 Days Prior (Ago) to Current Date Example

Introduction: 

Here I will explain how to use JavaScript to get date of 30 days prior to current date with example or JavaScript get 30 days minus / previous / ago of current date with example. By using new Date() property we can get date of 30 days prior to current date in JavaScript.

Description:
  
In previous articles I explained JavaScript replace special characters in string, jQuery create modal popup windows with example, jQuery remove whitespaces from string with regex, jQuery load more records on button click in repeater, jQuery fixed header on scroll with example, jQuery show asp.net exception message in ajax calls and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to date of 30 days prior to current date in JavaScript with example.

Save (Upload) Files to SQL Server Database using FileUpload Control in Asp.net

Introduction: 

Here I will explain how to save files to sql server database using file upload control in asp.net and retrieve files from sql server database in asp.net gridview control using c#, vb.net with example or save / upload files to database and load it from database and display it in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained save & retrieve images from database with handler in asp.net, jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and retrieve files from sql server database in asp.net gridview control using c#, vb.net with example.

Save and Retrieve Images from SQL Database in ASP.Net Gridview

Introduction: 

Here I will explain how to save images in binary format and display binary images from sql server database in asp.net gridview control using c#, vb.net with example or upload or insert and retrieve binary format images from database and display it in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, upload & download files from database in asp.net, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and display images from sql server database in asp.net gridview control using c#, vb.net with example.

Display (Show) Binary Format Images from Database with Handler (ashx) file in Asp.net

Introduction: 

Here I will explain how to show or display binary format images from database with handler ashx file in asp.net gridview control using c#, vb.net with example or upload images in binary format and displaying images from sql server database using handler ashx in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, upload & download files from database in asp.net, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and display images from sql server database in asp.net gridview control using c#, vb.net with example.

Upload (Insert) & Display Images from SQL Database in Asp.net Gridview using C#, VB.NET

Introduction: 

Here I will explain how to upload or insert images binary format in sql server database and display images from database in asp.net gridview control using c#, vb.net with example or uploading and displaying images from sql server database in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, upload & download files from database in asp.net, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and display images from sql server database in asp.net gridview control using c#, vb.net with example.

Display Images from SQL Server Database with Handler file in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to display binary images from sql server database using handler (ashx) file in asp.net gridview control using c#, vb.net with example or upload / insert images in sql server database and display / retrieve binary format images from database and show it in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, upload & download files from database in asp.net, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and display images from sql server database in asp.net gridview control using c#, vb.net with example.

Save & Retrieve (Display) Binary Images in Gridview from Database in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to save images in binary format and display binary images from sql server database in asp.net gridview control using c#, vb.net with example or upload or insert and retrieve binary format images from database and display it in asp.net gridview using c#, vb.net.

Description:
  
In previous articles I explained jQuery upload multiple files using handler file in asp.net, display images from database path in asp.net gridview, upload & download files from database in asp.net, save images in folder and path in database display it in asp.net gridview, gridview examples in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to save and display images from sql server database in asp.net gridview control using c#, vb.net with example.