SQL Server Order By in Union with Example

Introduction:

Here I will explain how to use order by in union query in sql server with example or order by clause with union operator in sql server with example or use union operator with order by in sql server or how to combine and use order by and union in sql server with example. To use Order By property with union we need to create sub query for union query statements in sql server.

Description:

In previous articles I explained sql server show exact match values top then partial match values, sql server difference between @@identity, scope_identity and ident_current, joins in sql server with examples, difference between len and datalength functions in sql server, sql server charindex function example, sql server difference between dml, ddl, dcl, tcl, SQL Server restore database from .bak / .mdf file and many articles relating to SQL server. Now I will explain how to use order by clause in union query in sql server with example.

Asp.Net MVC Create Roles, Assign Roles to Users in Membership Provider

Introduction: 

Here we will learn how to create roles and assign roles to users using membership in asp.net mvc with example or assigning roles to users in asp.net mvc membership provider with example. Generally membership provider will provide default functionality to create roles and assign roles to users using membership database in asp.net mvc applications. In case if we want to use our own custom database for membership provider then we can use it in asp.net mvc based on our requirements.

Description:
  
In previous articles I explained use hidden fields in asp.net mvc with html helpers, asp.net mvc custom route constraints with example, view models in asp.net mvc with example, query string parameters in asp.net mvc, exception handling in asp.net mvc with example, areas in asp.net mvc with example, Global action filters in asp.net mvc with example and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to create roles and assign roles to users using membership provider in asp.net mvc with example.

Asp.Net MVC Create User using Membership Provider with Example

Introduction: 

Here we will learn how to create users using membership in asp.net mvc with example or use membership in asp.net mvc with example or how to use createuser method in asp.net mvc membership provider to create new user with example. Generally membership provider will provide default functionality to create users using membership database in asp.net mvc applications and we can use custom database for membership provider in asp.net mvc based on our requirements.

Description:
  
In previous articles I explained query string parameters in asp.net mvc, exception handling in asp.net mvc with example, areas in asp.net mvc with example, Global action filters in asp.net mvc with example, asp.net mvc controller scaffolding templates with example, action filters in asp.net mvc with example, insert data into database using asp.net mvc web api with example, create master page with layouts in asp.net mvc razor view and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to create users using membership provider in asp.net mvc with example.

jQuery Disable F12 Key, Console Log in Browser in JavaScript Example

Introduction:

By clicking F12 in the browser we can open the Console log and development tool of a web site running in the browser. As a developer while you are developing its OK for you, but when others are trying to see your application code and do some operations definitely we don't want to disclose this. So what is the solution? we can easily prevent this using some simple JavaScript  and jQuery scripts. Let’s see how.

Description:

To stop this we can do two things. One, while users are opening the console log he or she will be prompted with some message or user will not be accessing the F12 key with mouse right click options. We will discuss both the ways one by one.

Asp.Net Membership Provider Tutorial (Create Users, Roles, Assign Roles) Examples

Introduction: 

Here we will learn asp.net membership provider tutorial with topics like creating users, roles, assign roles to users, edit / update / delete user details, recover user password using password recovery / change user password using changepassword control, etc.. using asp.net membership provider with examples using c#, vb.net.

Description:
  
In previous articles I explained get users ip address in asp.net, jquery auto complete textbox from database in asp.net, create / read / get cookies in asp.net, generate one time password (otp) in asp.net with example, jQuery Gridview Crud Operations in asp.net, show multiple markers in google map from database in asp.net and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain complete asp.net membership provider tutorial with examples in c#, vb.net.

Get Users IP Address in Asp.Net using C#, VB.NET with Example

Introduction: 

Here we will learn how to get users / client IP address in asp.net using c# and vb.net with example or retrieving user's IP address in asp.net using c# and vb.net or how to get IP address of visitors machine in asp.net using c# and vb.net with example.

Description:
  
In previous articles I explained JavaScript Get User IP Address, City, Latitude, Longitude, how to find client machine IP using jquery in asp.net, show users current location in google map using latitude and longitude in asp.net, show google map with latitude & longitude in asp.net and many articles relating to asp.net, c#, vb.net jQuery. Now I will explain how to get users ip address or client IP address of machine in asp.net using c# and vb.net.

Asp.Net MVC Get / Pass Query String Parameters to Controller with Example

Introduction: 

Here we will learn how to pass / send a query string parameters in asp.net mvc with example or how to retrieve / get query string parameters in asp.net mvc with example or how to use query string parameters in asp.net mvc controller with example. Generally query string parameters are used send information from one page to another page in asp.net mvc applications.

Description:
  
In previous articles I explained use hidden fields in asp.net mvc with example, asp.net mvc tight coupling view in asp.net mvc, asp.net mvc simple application with example, difference between web api and web service, insert data into database using asp.net mvc web api with example, exception handling in asp.net mvc with example, create master page with layouts in asp.net mvc razor view and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how use query string parameters in asp.net mvc with example.

Asp.Net MVC Use Hidden Fields with HTML Helpers Example

Introduction: 

Here we will learn how to create hidden fields in asp.net mvc using html helpers with example or how to use hidden fields in asp.net mvc with example or how to set / use hidden field values in asp.net mvc controller with html helpers example. Generally hidden fields are used to store information on web page without displaying it in asp.net mvc applications.

Description:
  
In previous articles I explained exception handling in asp.net mvc with example, asp.net mvc custom route constraints with example, create master page with layouts in asp.net mvc razor view, asynchronous controllers in asp.net mvc, asp.net mvc architecture with example, asp.net mvc tutorial for beginners & experienced and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how use hidden fields in asp.net mvc with html helpers example.

Asp.Net MVC Exception / Error Handling or Logging with Example

Introduction: 

Here we will learn how to handle exceptions / errors in asp.net mvc with example or exception handling in asp.net mvc with example or logging errors in asp.net mvc using global action filters with example or handle errors in asp.net mvc using global action filters in asp.net mvc with example. Generally by using global action filters we can handle errors in asp.net mvc applications.

Description:
  
In previous articles I explained areas in asp.net mvc with example, controller scaffolding template in asp.net mvc with example, ado.net entity framework with crud operations in asp.net mvc, asp.net mvc entity framework database first approach example, partial views in asp.net mvc with example, asp.net mvc html helpers with example and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to handle errors / exceptions in asp.net mvc with example.

Asp.Net MVC Areas with Example

Introduction: 

Here we will learn areas in asp.net mvc with example or understand areas in asp.net mvc with example or how to use areas in asp.net mvc with example or what are the areas in asp.net mvc and why we need to use areas in asp.net mvc with example. Generally in asp.net mvc if we partition large web application into smaller units then we will call it as areas.

Description:
  
In previous articles I explained asp.net mvc global action filters with example, for loop example in asp.net mvc razor view, razor view engine in asp.net mvc with example, asynchronous controllers in asp.net mvc with example, difference between viewbag, viewdata and tempdata with example, validation using fluent validation in asp.net mvc and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain areas in asp.net mvc with example.

Asp.Net MVC Global Action Filters to Handle Exceptions / Errors with Example

Introduction: 

Here we will learn global action filters in asp.net mvc to handle exceptions or errors logging with example or action filters in asp.net mvc for error logging with example or how to configure global action filters in asp.net mvc for exception handling with example. Generally in asp.net mvc global action filters are used to handle exceptions or errors and logging exceptions in applications.

Description: 
  
In previous articles I explained controller scaffolding template in asp.net mvc, asp.net mvc scaffolding template view with example, asp.net mvc remote validations with example, Data annotations with example in asp.net mvc, custom route constraints in asp.net mvc, view models in asp.net mvc, validation using fluent validation in asp.net mvc and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now we will learn global action filters in asp.net mvc to handle exceptions / errors.

Asp.Net MVC Controller Scaffolding Templates with Example

Introduction: 

Here we will learn controller scaffolding templates in asp.net mvc with crud operations example or understand asp.net mvc controller scaffolding templates view with crud operations example or how to use controller scaffolding view template in asp.net mvc to create crud operations with example. In asp.net mvc controller scaffolding template is used to perform basic crud operations without writing much code.

Description:
  
In previous articles I explained custom route constraints in asp.net mvc, view models in asp.net mvc, validation using fluent validation in asp.net mvc, ado.net entity framework with crud operations in asp.net mvc, create custom html helpers in asp.net mvc, asp.net mvc example demo project with database, complete asp.net mvc step by step tutorial and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now we will learn controller scaffolding templates in asp.net mvc with crud operations example.

Asp.Net MVC Scaffolding Template View with Crud Operations Example

Introduction: 

Here we will learn scaffolding view templates in asp.net mvc with crud operations example or understand asp.net mvc scaffolding template view with crud operations example or how to use scaffolding view template in asp.net mvc to create crud operations with example. In asp.net mvc scaffolding template is used to perform basic crud operations without writing much code.

Description:
  
In previous articles I explained asp.net mvc custom route constraints with example, asp.net mvc example demo project with database, asp.net mvc create hyperlinks or actionlinks with example, insert data into database using asp.net web api example, difference between asp.net web api and web service with example, complete asp.net mvc step by step tutorial and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now we will learn scaffolding view template in asp.net mvc with crud operations example.

Asp.Net MVC Custom Route Constraints with Example

Introduction: 

Here we will learn custom route constraints in asp.net mvc with example or understand asp.net mvc route constraints with example or create custom route constraints in asp.net mvc with example. Generally in asp.net mvc routing module is responsible for mapping browser request to particular controller action methods.

Description:
  
In previous articles I explained view model in asp.net mvc with example, Repository pattern in asp.net mvc with example, asp.net mvc scaffolding template with example, data annotations in asp.net mvc with example, asp.net mvc create hyperlinks or actionlinks with example, asp.net mvc remote validations with example, asp.net mvc types of action filters with examples and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now we will learn about custom route constraints in asp.net mvc with example.