MY NET Tutorials

How to Perform Some DML Commands with Single Stored Procedure in SQL Server

On 01:20:00 By RAMASHANKER VERMA // No comments:

Introduction:- There are two types of statements used in SQL Server
1.) DML(Data Manipulation Language):- Some Commands of DML are:

SELECT :-Retrieve information from the database.
INSERT:-Insert data into a table.
UPDATE:-Update Existing Records in a table.
DELETE:- Delete Records in a table.

2.) DDL (Data Definition Language) :- There are some Commands of DDL are:-

CREATE:-Create table in database.
ALTER:-Modify the structure of database.
DROP:- Delete the table in database.
TRUNCATE:-Remove all records from the table including all allotted space also.
COMMENT:- It is used for comment.
RENAME:- Rename the objects.

Here we will perform select, insert,Update and Delete commands in a single Stored Procedure in sql server.

How to implement Ajax Balloon Popup Extender on Asp.net website

On 22:43:00 By RAMASHANKER VERMA // No comments:

Hi Friend, Today we will learn about Balloon popup Extender control in asp.net.This control display a popup message which can contain any information when you move your mouse and focus to a TextBox control.This control supports three Balloon style properties

Balloon
Rectangle
Custom

You can choose three size of this style properties

Small
Medium
Large

If you want to choose Balloon Style Property Custom then you have to set CustumCssUrl Property to point to a custom Stylesheet.

This Popup can be set to 5 positions

TopRight
TopLeft
BottomLeft
BottomRight
Auto

If you select value the Auto then the position of BalloonPopup will be determined automatically based on available space.

This popup will be displayed when any user move your mouse or click on textBox.

There are some step to implement this whole concepts as shown below:-

How to implement Virtual keyboard concepts on asp.net website easily

On 21:22:00 By RAMASHANKER VERMA // 1 comment:

Hi Friend,Today, we will learn "how to use virtual keyboard concepts on asp.net or other websites?". Nowadays ,there are many malicious "spyware" and "Trojan programs" which are harmful for our Username and password .if you use virtual keyboard on website,this will reduce the risk of password theft. If you are using banking sites from the cyber cafe ,please use virtual keyboard only otherwise your password may be compromised.In cyber cafe, may be installed key logger programs that will be risk of password theft .This programs might have infected your computers also .So that today i am going to show you "how to implement virtual keyboard concepts on asp.net websites".

How to create secure Registration and login page with Hashing encryption concepts in asp.net

On 16:05:00 By RAMASHANKER VERMA // 1 comment:

Introduction:- Hi friend,Today we will learn how to make secure registration and login page with hashing concepts in asp.net applications.Here we will also learn how to create https certificate on iis server.First we will learn why does we use hasing concepts and its advantages ? How to know this website is using hashing concepts or encryption or decryption concepts. Check by two steps..
1.) Change Password:-Suppose you want to change the password,if website send your password to your respective mobile or email address then you have to know that this website is not using hashing concepts otherwise it uses hashing concepts.
2.) Forget Password:-Suppose you want to forget your password and you want to change it,if website send your password on your respective mobile and email address then that website is not using hashing concepts otherwise it uses hashing concepts.
Nowadays , many popular websites are using hashing concepts like google (gmail,youtube, google+ ,etc.) , Facebook ,yahoo ,paypal ,twitter ,Instagram,linkedin , all banking websites etc. Many websites are used encryption and decryption concepts also.But hashing concepts is more better than others .How to use hashing concepts in asp.net website?

How to add and verify captcha codes on 3 tier login and registration page in asp.net applications

On 22:40:00 By RAMASHANKER VERMA // No comments:

Introduction:-
Hi friend, today we will learn "how to add and verify captcha codes on your existing 3 tier login and registration page in asp.net". I have already explained ,how to to create 3 tier login and registration page.But here i will explain "how to add and verify captcha codes in 3 tier login and registration page".If you want to add more features on your registration and login page, you can follow below links.

I have alreafy implemented more concepts separately , It is yours responsibility, how to use it in different .NET applications.Here we will learn how to add captcha(.dll) codes in 3 tier architecture.You can add another captcha codes(graph) also in this application.This is easy process but you have to follow some steps as given below:-

How to convert original text to hash text using md5 and sh1 Algorithms in asp.net c#

On 15:43:00 By RAMASHANKER VERMA // 1 comment:

Introduction:- Hashing is secure and helpful concepts to convert original text to hash text.It is a cryptography Technology.There are many cryptography technology such symmetric and asymmetric but here we will learn only hashing concepts (md5 and sh1).If you want to discuss more details about cryptography ,you can contact me(holiday only).

A Hash function is an Algorithm which creates a digital representation or 'fingerprint' in the form of a "hash value" of a standard length.
Hash value is usually much smaller than the message.
It is one way function.