Events in C# are a way for a class to provide notifications to clients of that class when some interesting thing happens to an object. The most familiar use for events is in graphical user interfaces; typically, the classes that represent controls in the interface have events that are notified when the user does something…
Author: Pablo Francesco
C# Abstract Classes: Definition, Usage With Example
C# is a versatile and extensively used programming language known for its durability and adaptability. It provides developers with a variety of tools that enable them to write efficient and well-structured code. Abstract classes, for example, play an important function in object-oriented programming (OOP) and serve as a blueprint for derived classes. What are Abstract…
Using SQL to Build a Secure Password Storage System in ASP.NET Web Forms
What exactly is Password Hashing? The process of transforming a user’s plain-text password into an irreversible and fixed-length string of characters is known as password hashing. The password hash string is then kept in the database instead of the original password. Why is Password Hashing Used? The storage of plain-text passwords in a database poses…
SQL Server Hosting Tutorial : Encryption of Stored Procedures in SQL Server
The stored procedure can be encrypted. When you have complex business logics and want to hide the logic implementation then the schema of the stored procedure can be encrypted. The sql server do not have any mechanism to decrypt the encrypted stored procedure. They have store manually. CREATE PROCEDURE Proc_RetrieveProducts WITH ENCRYPTION AS BEGIN SET…
Export Blob(BINARY or VARBINARY) From SQL Table And Save It As A File
A binary value or type in SQL Server is a series of bytes (known as a byte array in some programming languages). Just like char/varchar, there are fixed-length types, binary(1-8000), and variable-length ones, varbinary(1-8000) and varbinary(max). Sometimes we store this type of data in SQL Tables and lose the source files. This type of data is stored in a binary…