How to Install npm Packages

Read more

Encapsulation and Abstraction

-Encapsulation and Abstraction is the advanced mechanism in c# that lets your program hide unwanted code within a capsule and show the only essential feature of an object.

-Encapsulation is used to hide its members from outside class or interface.

-abstracter is used to show only essential features.

-Encapsulation is a process of hiding irrelevant data from the user for example whenever you buy a mobile you don't see how circuit Bord work. You are also not interested to know how a digital signal converts into an analog signal and vice versa which is irrelevant information.

-abstraction is just the opposite of encapsulation. Abstraction is a mechanism to show only relevant data to the user for example whenever you buy a mobile you see a different type of functionality like a camera, Mp3 Player, calling function, recording function, multimedia, etc. it is abstract.

Read more

51 Recipes With jQuery and ASP.NET Controls With Source Code

Book Details
Publisher:	--------
By:	Suprotim Agarwal
ISBN:	0672335948
Year:	2010
Pages:	186
Language:	English
File size:	3.0 MB
File format:	PDF

Read more

Save And Display Data From XML File

in this post, we are discussing how to save data in XML and how to retrieve it.
here I am giving you a simple example to display how it works

here I m putting some control that is as below

i am adding some textbox, file upload control for upload a file, and, for the record display purpose put one gridview.

we can save data and also edit that data.

Read more

DML After Trigger

Hello Friend Today We Are talking about After Trigger.After Trigger is use for insert,update delete operation

1)After Trigger(using FOR/AFTER CLAUSE) :

This Trigger is fire after sql server operation.

for example we fire one statement on the table after execute that statement trigger is effect into another table that is called after trigger.

After Insert Trigger

now try to insert data into dbo.a_student_info

insert into a_student_detail(s_name,s_std,s_school_name)values('Devid',8,'DPS School');

 after insert data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is insert record into dbo.a_student_fees_info automatically.

After Update Trigger

 now try to update record  of dbo.a_student_info

update a_student_info set s_name='Martin',s_std=8,s_school_name='Gurukul High School' where PK_s_id=1;

  after update data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is update record into dbo.a_student_fees_info automatically.

After Delete Trigger

 Now to try to delete data from dbo.a_student_detail

Delete From a_student_info where PK_s_id=2

 after Delete data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is Delete record into dbo.a_student_fees_info automatically.






 

Read more

Trigger Advantage And Disadvantage

The trigger is a special kind of store procedure that executes in response to certain actions on the table like insertion, updating, or, deletion of data.

Trigger stored program. The trigger is an automatic fire when any operation occurs on the database.

Advantage of Trigger:

• You can have the logic you wish to implement in a single place instead of writing it in multiple stored procedures.
• It is very much useful when we use it to audit the change in the data in a database table.
• It provides an alternative way to run the scheduled task.
• Using trigger we don't have to wait to run the scheduled task. that automatically fires that task before or after changes are made to the database table.

• Improve performance in the client/server environment. 

The disadvantage of Trigger:

• It is easy to view table relationships, constraints, index, and stored procedures but triggers are difficult to view.
• The trigger is run every time update table and it makes the system run slower.
• A trigger can provide extended validation and it cannot be replaced with all the validations.
• Trigger executes invisibly from the client application so it is hard to understand what happens at the database layer.
• The trigger doesn't scale in a cost-effective manner as the traffic increases.
• Data manipulation (insert, update, delete) often requires a lock on the table and even on an index that impedes other users' access to data.

Read more

ACID Property of Transaction

hello, Friend in My Previous post we discussed Transaction Commands COMMIT and ROLLBACK.

Today we talk about transaction property. The transaction has Four property which is available below

Transaction Property :

                                 -Atomicity

                                 -Consistency

                                 -Isolation

                                 -Durability

Atomicity :

ensure that all operations within the work unit are completed successfully otherwise the transaction is aborted at the point of failure and previous operations are rolled back to their former state

for example in the application that passes data from the parent table to the child table. the atomicity property is ensure that  if data is sent from the parent successfully  and received data successfully

Consistency : 

Ensure that the database property changes status upon a successfully committed transaction.

for example in an application that transfers funds from one account to another account. the consistency property ensures that the total value of funds in both accounts is the same at the start and end of each transaction.

Isolation :

enable a transaction to operate independently and transparent to each other

for example in an application that transfers funds from one account to another. the isolation property is ensure that another transaction sees the transferred funds in one account or another the other, but not in both nor in neither.

Durability :

Ensure that the result or effect of the committed transaction persists in case of a system failure

Read more