What is  Cloud computing?

Cloud technologies are the services which provide a strong compute, optimized services to establish a strong database and  IT solutions.

Benefits of Cloud

Cloud makes an entrepreneur life easy on creating IT solutions as cloud saves a lot of efforts on spending time on server maintenance and investment on software purchase.
Just by using a simple configured computer a developer can connect a Cloud instance and work with high-end technologies.
Server maintenance also cloud service provider takes care. So, that saves a lot for a firm in terms of money and manpower as well.
The best feature of Cloud is pay-as-you-go pricing. It means to pay for use only.

How does Cloud work?

Cloud works on the internet base. By connecting to the instance a user can access different features just by paying for the utilized features only.


Who are the Cloud service providers in the market?

We have different cloud providers available nowadays in the market like
Amazon, Google, Microsoft Azure, IBM, and so many other providers are also available.


Disadvantages of Cloud

Cloud is an internet-based service so the services accessing depends on internet speed.
Even high secured environment is available, our code is always there in providers hand. So, there is a chance to stop our applications in crucial situations.

The best example is Wikileaks. Wikileaks was hosted its code base on Amazon web services.
They stopped their services to Wikileaks at one stage to restrict the company journals opposite to different countries even they are right.

In this post let us see how to convert column values into the column names using MySQL.

DROP TABLE IF EXISTS Temp1;
CREATE TEMPORARY TABLE Temp1 (
    Col1 VARCHAR(100)
);

INSERT INTO Temp1(Col1) VALUES('Xyz A'),('BCD A'),('C'),('B');
 
SET @SqlString = (SELECT
    GROUP_CONCAT(DISTINCT Col1
        ORDER BY Col1 ASC
        SEPARATOR '` VARCHAR(100), `')FROM  Temp1);
SET @SqlString = CONCAT("`",@SqlString,"` VARCHAR(100)");

DROP TABLE IF EXISTS TempRowsToColumns;
SET @sql1 = CONCAT("CREATE TEMPORARY TABLE TempRowsToColumns (ID INT AUTO_INCREMENT PRIMARY KEY,",@SqlString,")");
 
PREPARE stmt FROM @sql1;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
SELECT * FROM TempRowsToColumns;

In C#. properties are the extension of data fields. In the object-oriented programming language, encapsulation and hiding are the pillars.  By using various access modifiers like private, public, protected, internal etc, we can control the accessibility of the class members.
Usually, inside a class, we declare a data field as private and provide a set of public SET and GET methods to access the data fields. Since this is not a good programming practice to give direct accessibility of data fields outside the class.

Let us suppose we have an employee class with three fields, Empid, name and company name.
If we give direct access to these three fields outside the class, there is a chance to get false data as below.


In any organization, the employee never has an ID with the negative number as well null value to the Employee name. So, while supplying the required data it is mandatory to identify whether the data is valid or not.
So, by applying data encapsulation and hiding techniques, we should stop direct access to the data fields and provide through properties as below



Using GET() and SET() methods we can read value and assign to the field members.

GET() represents read property and SET() represents write property.
A property with GET() only,  it is a read-only property. We can't manipulate the value on it. In the above example, Company name is common for all employees across the organization. So, we should stop overwriting on it.  So, it has GET() attribute only.

C# is a modern, strong, object-oriented programming language inaugurated by Microsoft. C# (the product) was developed by Anders Hejlsberg and his team. C# is designed for Common Language Infrastructure (CLI), which consists of the executable code and runtime environment that allows the use of various high-level languages on different computer platforms and architectures.

The following reasons make C# a widely used professional language:

• C# is a modern, strong programming language
• C# strongly supports the OOP concepts
• It is easy to learn.
• It is a part of DotNet Framework.
• Using C# we can develop modern applications on windows, console, mobile, and web.
• C# contains the same working environment as C/C++. So, the legacy C\C++ developers could feel more comfortable to work with C#.Net.
• Automatic memory management techniques available in C#.Net.
• C#.Net works (not only C# all the languages that are supported by the .Netframework) perfectly works on Windows platforms and other than windows, the user needs to take the help of other tools(on Linux - mono)

Link button displays the button like a hyperlink. Use the text property to change the link text.
Link button works on the server side. We can have all the basic properties like font, style properties etc...
The difference between the Link button and Hyperlink is, Hyperlink works on the client side and the link button works on the server side. When we click on the Link button, the page will get the past back.

Button control is to post the request to the server. It is an ASP.Net server control which contains the tag 'runat="server"'.

ASP.NET Web server controls are the objects on ASP.NET Web pages. They are to perform different operations like storing, display and transfer the data. Each server control contains its own set of events(click, change, load etc...) to execute the functionalities. They are called control events. ASP.Net controls contains the tag "runat="server"". There are different types of Server controls available in ASP.Net

They are
1. Button Controls

• Button
• Link button
• Image button