ASP ALGO Education

23/12/2015

Display Data in ASP.NET MVC Application.

http://www.aspalgo-edu.in/Home/ADetails/1

C #, jQuery, ASP.NET, ASP.NET MVC, WCF, Visual Studio, MS SQL Server, ASP.NET Project, online tutorial, programming, source code, programming

23/12/2015

VIEW in MS SQL Server.
http://www.aspalgo-edu.in/Home/ADetails/2

C #, jQuery, ASP.NET, ASP.NET MVC, WCF, Visual Studio, MS SQL Server, ASP.NET Project, online tutorial, programming, source code, programming

23/12/2015

CASCADING Referential Integrity in Sql Server.

http://www.aspalgo-edu.in/Home/ADetails/3

C #, jQuery, ASP.NET, ASP.NET MVC, WCF, Visual Studio, MS SQL Server, ASP.NET Project, online tutorial, programming, source code, programming

23/12/2015

SQL CHECK Constraint

http://www.aspalgo-edu.in/Home/ADetails/4

23/12/2015

Use of Unique Key Constraint in SQL Server.

The UNIQUE constraint uniquely identifies each record in a database table.

The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.

A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it.

CREATE DATABASE SQL_DEMO
USE SQL_DEMO
CREATE TABLE tbl_Employee
(
EmpID INT PRIMARY KEY NOT NULL,
EmpName VARCHAR (50) NOT NULL,
EmpEmail VARCHAR(20) ,
EmpMobile VARCHAR(20),
UNIQUE (EmpEmail,EmpMobile)
)
INSERT INTO tbl_Employee (EmpID,EmpName,EmpEmail,EmpMobile) VALUES (1,'Robin','[email protected]','999988888')
INSERT INTO tbl_Employee (EmpID,EmpName,EmpEmail,EmpMobile) VALUES (2,'Ram','[email protected]','5555544444')
INSERT INTO tbl_Employee (EmpID,EmpName,EmpEmail,EmpMobile) VALUES (3,'Remo','[email protected]','5555544444')
INSERT INTO tbl_Employee (EmpID,EmpName,EmpEmail,EmpMobile) VALUES (3,'Remo','[email protected]','5555544444')
When we try to run 4th statement then output with error –
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__tbl_Employee__31EC6D26'. Cannot insert duplicate key in object 'dbo.tbl_Employee'.
The statement has been terminated.
Note that you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint per table.

http://www.aspalgo-edu.in/

C #, jQuery, ASP.NET, ASP.NET MVC, WCF, Visual Studio, MS SQL Server, ASP.NET Project, online tutorial, programming, source code, programming

23/12/2015

What is Windows Communication Foundation (WCF)?

Windows Communication Foundation (WCF) is a framework for building service-oriented applications. Using WCF, you can send data as asynchronous messages from one service endpoint to another. A service endpoint can be part of a continuously available service hosted by IIS, or it can be a service hosted in an application

http://www.aspalgo-edu.in/

C #, jQuery, ASP.NET, ASP.NET MVC, WCF, Visual Studio, MS SQL Server, ASP.NET Project, online tutorial, programming, source code, programming

12/11/2015

What is AngularJS?
AngularJS is a structural framework for dynamic web applications. AngularJS framework best for single-page web applications. AngularJS extends HTML attributes with directives, and binds data to HTML with Expressions.
Example of AngularJS:

Learn Angular JS




Enter Your Name:

Hello, My name is {{name}}



Note:
1. Copy, Paste above code in you web page and run web page.
2. Here we use three angularJS directive
ng-app: is a main angularJS directive to tell us that it is owner of AngularJS application web page.
ng-model: directive binds the value of the input field to the application variable name.
ng-bind: directive binds the innerHTML of the element to the application variable name.
--------------------
http://www.aspalgo-edu.in/

/* AngularJS v1.3.14 (c) 2010-2014 Google, Inc. http://angularjs.org License: MIT */ (function(P,X,u){'use strict';function M(b){return function(){var a=arguments[0],c;c="["+(b?b+":":"")+a+"] http://errors.angularjs.org/1.3.14/"+(b?b+"/":"")+a;for(a=1;a").append(a).html())):c?La.clone.call(a):a;if(h…

03/09/2015

What is advantage and disadvantage of loading jQuery from CDN?
-------------------
If you want to use jQuery then you need to download and save jQuery file in your application but if you don’t want to download jQuery file then you can include if from CDN (Content Delivery Network).

You can use jQuery CDN from Google or Microsoft. These companies provide free public CDN from which you can load jQuery instead of hosting it on your own web server.

Use below link to use Google jQuery CDN







Use this link to use Microsoft jQuery CDN





Advantage of using the hosted jQuery CDN from Google or Microsoft-

Distributed CDN Server

Browser Caching

Parallel Downloading

Reduce Server load

Note: only one disadvantage of using jQuery CDN if your client firewalls may block the CDN. So you may have to request your client to whitelist the CDN but you can solve this issue to download and save jQuery file in your application’s folder and use it when your network not work or block by client firewall.

Use this lines of code in your page header section to solve this issue-



window.jQuery || document.write("")


http://www.aspalgo-edu.in/

03/09/2015

What is difference between $(window).load and $(document).ready.
---------------------
The $(window).load event fires when the DOM and all the content on the page like images, CSS, etc. is fully loaded.

The $(document).ready event fires before $(window).load event.






$(window).load(function () {
alert("windows.load fires after Document.ready.");
});
$(document).ready(function () {
alert("Document.ready fires before windows.load ");
});








When you run this script in web browser you will display to alert pop up message first message will ready function and second message will load function means load function message display after ready function.

http://www.aspalgo-edu.in/

03/09/2015

What is $(document).ready (function ()) in JQuery and when to use it.
--------------------
$(Document).ready is a jQuery event and it fire when the DOM (document object model) has been loaded. This is first steps in the page load process. Ready event is fired before all the files like image, css etc. fully loaded.





$(document).ready(function () {
$(' ').click(function () {
alert("This is document ready function");
});
});










Write this code in your page (I am using ASP.NET). When run this page in web browser and click on button you will show pop us message “This is document ready function”.

The ready () method can only be used on the current document.

http://www.aspalgo-edu.in/

/*! jQuery v1.11.3 | (c) 2005, 2015 jQuery Foundation, Inc. | jquery.org/license */ !function(a,b){"object"==typeof module&&"object"==typeof module.exports?module.exports=a.document?b(a,!0):function(a){if(!a.document)throw new Error("jQuery requires a window with a document");return b(a)}:b(a)}("und…

31/07/2015

ASP.NET MVC Component-

The MVC - Model-View-Controller divide web application in to three parts so that is very easy to learn, code, test and maintain.

The model folder contain data access code files, business logic code files and data validation code files.

The view contain HTML files and use these files as a user interface which view on browser when user send a request from computer.

The controller contain the files that receive the request from the user and get data from the model and provide that data to user.

Note : One optional component name "view model" contain the files which main role is transfer data from controller to view.
view mode is optional not is part of MVC is it make your coding style easy .

29/07/2015

First Step to create ASP.NET website.

To Build websites in ASP.NET you can choose any framework like ASP.NET Web Forms, ASP.NET MVC, and ASP.NET Web Pages. These frameworks are use for desing and develop web application. Each framework have different development style. You can choose any one framwork and any programming language (like C # or VB.NET) supported by these framework to create web application.