Please enable Javascript to correctly display the contents on Dot Net Tricks!

Dot Net Tricks Tutorial - For Beginners & Professionals

.net article,c# tutorial,asp.net tutorial,linq tutorial,wcf tutorial,mvc tutorial,entity framework tutorial,sqlserver tutorial,jquery tutorial,visual studio tutorial
 
Author : Shailendra Chauhan
Posted On : 28 Sep 2012

Asp.net framework is a part of .net platform for building, deploying and running web applications. Asp.net development framework is used for developing web applications and web sites with the help of Html, CSS, jQuery, JavaScript and many more javascript library like knout. There are three development models in asp.net as shown below.

 

 

Author : Shailendra Chauhan
Posted On : 27 Sep 2012

Sometimes, there is a case, when we need to remove all tables, stored procedure, views and triggers completely from the database. If you have around 100 tables, stored procedure and views in your database, to remove these, completely from database became a tedious task. In this article, I would like to share the script

 

 

Author : Shailendra Chauhan
Posted On : 26 Sep 2012

In SQL Server, there are two keys - primary key and foreign key which seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and foreign key.

 

 

Author : Shailendra Chauhan
Posted On : 26 Sep 2012

In SQL Server, we have two keys - primary key and unique key which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key.

 

 

Author : Shailendra Chauhan
Posted On : 25 Sep 2012

From last couple of days I was trying to call a ajax enabled wcf service method with the help of jquery. But each and every time I am getting the error code 12031 returned by the service. I did googling for this error but I was unable to find the solution. After spending much time on R&D, I found the reason why I wa geeting this error.

 

 

Author : Shailendra Chauhan
Posted On : 25 Sep 2012

There are Inserted and Deleted logical tables in SQL Server. These tables are automatically created and managed by SQL Server internally to hold recently inserted, deleted and updated values during DML operations (Insert,Update,Delete) on a database table.

 

 

Author : Shailendra Chauhan
Posted On : 16 Sep 2012

A partial view is like as user control in Asp.Net Web forms that is used for code re-usability. Partial views helps us to reduce code duplication. Hence partial views are reusable views like as Header and Footer views.

 

 

Author : Shailendra Chauhan
Posted On : 15 Sep 2012

Stored Procedures are pre-compile objects which are compiled for first time and it's compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed every time when it is called.

 

 

Author : Shailendra Chauhan
Posted On : 15 Sep 2012

LINQ to Entity is a great ORM for querying and managing database. It offers a lot of things, so it is mandatory to know about performance of it. These are right up to a certain point as LINQ comes with its own penalties. There are some tips and tricks that we should keep in mind while desiging and query database using entity framework ORM.

 

 

Author : Shailendra Chauhan
Posted On : 14 Sep 2012

Basically, IEnumerable is an interface that can move forward only over a collection, it can’t move backward and between the items. Var is used to declare implicitly typed local variable means it tells the compiler to figure out the type of the variable at compilation time. A var variable must be initialized at the time of declaration.

 

 

Author : Shailendra Chauhan
Posted On : 14 Sep 2012

Sometimes it is required to prevent your web page images from being copied by another one. You can secure your images by disabling right click or by disabling image context menu on images only. This is an effective approach to prevent your images from being copied or stolen.

 

 

Author : Shailendra Chauhan
Posted On : 31 Aug 2012

One student of me asked "how can we get nth highest and lowest salary on an employee ?". In this article I am going to expose, how can we achieve this in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 31 Aug 2012

One student of me asked "how can we get fields name of a table with theirs type and size ?". In this article I am going to expose, how can we achieve this in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 24 Aug 2012

Sometimes we required to remove duplicate records from a table although table has a UniqueID Column with identity. In this article, I would like to share a best way to delete duplicate records from a table in SQL Server.

 

 

Author : Shailendra Chauhan
Posted On : 26 Aug 2012

Today’s browsers like Chrome, Firefox, Internet Explorer and Safari has functionality of auto complete values in TextBoxes. If you have enabled this features in your browser, then each and every time when you start to enter value in TextBox you get a drop down of prefilled values in that TextBox.

 

 

 
 
3 APR
Master Class Fast Track MVC 5 with Angular2 Development (Online)

10:30 AM -03:30 PM IST (Fast Track)

Know More
25 MAR
MEAN Stack 2 Development (Classroom)

11:00 AM-12:30 PM

Know More
25 MAR
ASP.NET MVC with Angular2 Development (Classroom)

3:00 PM-4:30 PM

Know More
25 MAR
Xamarin Forms : Build Cross-platform Apps (Classroom)

8:00 AM-9:30AM

Know More
21 MAR
ASP.NET MVC with Angular2 Development (Online)

09:00 PM - 11:00 PM IST( TUS, THR, SAT)

6 MAR
ASP.NET MVC with Angular2 Development (Online)

07:00 AM - 09:00 AM IST( MON, WED, FRI)

25 FEB
ASP.NET MVC with Angular2 Development (Classroom)

05:00 PM-06:30 PM

31 JAN
ASP.NET MVC with Angular2 Development (Online)

07:00 AM-09:00 AM IST(Tuesday & Thursday)

30 JAN
NODEJS & MEAN Stack 2.x Development (Online)

09:00 PM-11:00 PM IST( MON, WED, FRI)

31 DEC
ASP.NET MVC with AngularJS Development (Classroom)

09:30 AM-11:00 AM

BROWSE BY CATEGORY
 
 
LIKE US ON FACEBOOK
 

Professional Speaks

+