Dot Net Full Stack Developer Course-c sharp, c, javascript, ajax, bootstrap, css, sqlserver, mysql

Razor vs Blazor in .NET: What's the Difference?

2025-07-24T01:34:00.007+05:30

When diving into modern web development using Microsoft technologies, it's easy to get confused between Razor and Blazor—two powerful tools in the .NET ecosystem. Though they share a similar name and syntax, their purposes, use cases, and behaviors are distinctly different.

In this post, we’ll unpack what each of them does, how they differ, and when to use one over the other.

What is Razor?

Razor is a templating syntax that allows you to seamlessly embed C# code within HTML. It's primarily used in ASP.NET MVC and ASP.NET Core MVC applications to create server-rendered HTML views.

Razor makes it easier to generate dynamic content without writing raw HTML strings or using clunky code-behind logic.

Example Razor Code (in a `.cshtml` file):

<h2>Welcome, @Model.Username!</h2>
<p>Today's date is @DateTime.Now.ToLongDateString()</p>

Key Characteristics of Razor:

Files have the extension .cshtml
Runs on the server.
Generates HTML that is sent to the browser.
Best suited for traditional server-rendered websites.
Limited client-side interactivity without JavaScript.

What is Blazor?

Blazor is a modern web UI framework that allows developers to build interactive, client-side web apps using C# instead of JavaScript. It utilizes Razor syntax for its components, but it’s more than just a templating engine—it’s a full-fledged single-page application (SPA) framework.

There are two main hosting models for Blazor:

Blazor Server—The UI is rendered on the server, with UI updates sent via SignalR.
Blazor WebAssembly (WASM)—Runs entirely in the browser using WebAssembly.

Example Blazor Code (in a `.razor` file):

<h3>Hello, @name!</h3>

<input @bind="name" placeholder="Enter your name" />
<button @onclick="SayHello">Greet</button>

@code {
    private string name = "Guest";

    private void SayHello()
    {
        Console.WriteLine($"Hello {name}!");
    }
}

Key Characteristics of Blazor:

Files have the extension .razor
Uses C# on both client and server.
Component-based architecture.
Supports real-time DOM updates and rich interactivity.
There's no need for JavaScript for most tasks.

Razor vs Blazor: Feature Comparison

When Should You Use Razor or Blazor?

✅ Use Razor when:

You're building a traditional web application.
SEO and server-side rendering are crucial.
You prefer simplicity and minimal client-side logic.

✅ Use Blazor when:

You want a modern SPA experience without relying on JavaScript.
You’re building rich, dynamic UIs with real-time interactions.
You want to reuse C# code on both the server and the client.

Final thoughts

While Razor and Blazor share a similar syntax and naming style, they cater to different architectural needs. Razor is a solid choice for server-rendered applications with minimal client interactivity, while Blazor unlocks the full power of C# for building modern, interactive web applications—all without touching JavaScript.

As the .NET ecosystem continues to evolve, Blazor is emerging as a strong contender for building full-fledged web apps using only .NET technologies.

Whether you choose Razor or Blazor depends on your project’s goals, but understanding both will make you a more versatile developer.

Have questions or want to share your experience with Razor or Blazor? Drop a comment below!

Understanding Polymorphism in Object-Oriented Programming with Example

2025-07-09T16:27:00.004+05:30

In Object-Oriented Programming (OOP), polymorphism is one of the four core principles (along with inheritance, encapsulation, and abstraction). In C#, polymorphism allows you to treat different types of objects in the same way, which makes your code more flexible and extensible.

Let’s break it down simply and see how it works in real-world applications and in actual C# code.

What is polymorphism?

"Poly" means "many."

"Morphism" comes from the Greek word "morphḗ" + "ism." The meaning of morphḗ is "form/shape."

There are two main types of polymorphism in C#:

Compile-Time Polymorphism (Static) – Achieved through method overloading.
Run-Time Polymorphism (Dynamic) – Achieved through method overriding using inheritance.

Compile-time polymorphism (static polymorphism):

This type of polymorphism is resolved at compile time. This includes method overloading, where a class can have multiple methods with the same name but different parameter lists. The correct way is selected during compilation based on the number or type of arguments.

Runtime Polymorphism (Dynamic Polymorphism):

The resolution of runtime polymorphism is done at runtime. This can be done through method overriding, where a subclass provides a specific implementation for a method already defined in its superclass. The proper method is determined during runtime based on the actual type of the object.

Advantages of Polymorphism:

Polymorphism provides several benefits in software development:

Code Reusability: Polymorphism allows us to write generic code that can work with different types of objects, promoting code reusability and reducing redundant code.

Flexibility and extensibility: With polymorphism, new classes can be added without affecting the existing codebase. It promotes a flexible and easily extendable architecture.

Maintainability and Scalability: Polymorphic code is easy to maintain and update, making it ideal for large-scale applications.

Real-Time Example of Polymorphism

Imagine you run a payment processing system. You have different types of payment methods: CreditCard, PayPal, and UPI. Each payment method processes the payment differently, but from the user's perspective, they just call a MakePayment() function.

This is polymorphism: different classes implement the same method in their own way.

Coding Example in C#

Compile-Time Polymorphism (Method Overloading)

public class Calculator

{

public int Add(int a, int b) => a + b;

public double Add(double a, double b) => a + b;

}

Run-Time Polymorphism

using System;

namespace PolymorphismExample

{

// Base class

public class Payment

{

public virtual void MakePayment()

{

Console.WriteLine("Processing generic payment...");

}

// Derived class 1

public class CreditCard : Payment

{

public override void MakePayment()

{

Console.WriteLine("Processing payment through Credit Card.");

}

// Derived class 2

public class PayPal : Payment

{

public override void MakePayment()

{

Console.WriteLine("Processing payment through PayPal.");

}

// Derived class 3

public class UPI : Payment

{

public override void MakePayment()

{

Console.WriteLine("Processing payment through UPI.");

}

class Program

{

static void Main(string[] args)

{

Payment[] payments = new Payment[]

{

new CreditCard(),

new PayPal(),

new UPI()

};

foreach (Payment payment in payments)

{

payment.MakePayment(); // Calls the appropriate method depending on object type

}

Output:

Processing payment through Credit Card.

Processing payment through PayPal.

Processing payment through UPI.

How It Works

The base class Payment defines a virtual method MakePayment().
Derived classes override the method with their own specific implementations.
At runtime, C# decides which MakePayment()method to call based on the object type — this is run-time polymorphism.

Why Use Polymorphism?

Makes code more maintainable and scalable
Encourages code reuse through inheritance
Helps you follow SOLID principles, especially the Open/Closed Principle
Useful when working with interfaces or base classes to handle a variety of behaviors

Conclusion:

Polymorphism is a key concept in object-oriented programming that promotes code flexibility, reusability, and maintainability. By adopting polymorphism, developers can create elegant and scalable solutions that adapt to changing needs and future expansion. Understanding this powerful concept opens the door to more sophisticated software design, making it an essential skill for every OOP developer.

Login Form and Registration form using Bootstrap design for Responsive and more UI friendly

2024-05-03T09:52:00.002+05:30

We have already designed a simple Login Form and Registration Form using only HTML. In this blog, we will link bootstrap cdn and apply bootstrap classes to see the changes. We are using Bootstrap 5 for this content.

Procedure to get bootstrap CDN

1. Google on "bootstrap 5 cdn".

2. Get into the official website of "https://getbootstrap.com/" s "https://getbootstrap.com/docs/5.0/getting-started/introduction/" page.

3. Copy CSS:- <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet">

JS:- <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js"></script>

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" ></script>

Get it from the site or copy from this blog.

Paste the CSS link in the head section, and the JS link all the way down of the design.

Let's apply some bootstrap classes to make our design more attractive and responsive.

Login page

<!DOCTYPE html> <html> <head> <title>Login Form</title> </head> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" > <style> .container{ border: 1px solid black; padding: 50px; width: fit-content; margin-top:50px; } h3{ text-align: center; padding-bottom: 10px; } </style> <body> <div class="container"> <h3>Login Form</h3> <form method="post"> <div class="row mb-1"> <div class="col-sm"> <label for="">Email Id</label> </div> <div class="col-sm"> <input type="email" name="emailid" id="emailid" class="form-control" placeholder="Enter Email Id here"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Password </label> </div> <div class="col-sm"> <input type="password" name="password" id="password" class="form-control" placeholder="Enter Password here"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <button type="button" class="btn btn-primary" value="">Login</button> </div> <div class="col-sm"> <a href="Register.html">Register here</a> </div> </div> </form> </div> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" ></script> </body> </html>

Registration page

<!DOCTYPE html> <html> <head> <title>Registration Form</title> </head> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" > <style> .container{ border: 1px solid black; padding: 50px; width: fit-content; margin-top:50px; } h3{ text-align: center; padding-bottom: 10px; } </style> <body> <div class="container"> <form method="post"> <h3>Registration Form</h3> <div class="row mb-1"> <div class="col-sm"> <label for="">Name</label> </div> <div class="col-sm"> <input type="text" name="name" id="name" class="form-control" placeholder="Enter your name"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Email Id</label> </div> <div class="col-sm"> <input type="email" name="emailid" id="emailid" class="form-control" placeholder="Enter Email Id here"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Phone</label> </div> <div class="col-sm"> <input type="number" name="phone" id="phone" class="form-control" placeholder="Enter mobile number"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">DOB</label> </div> <div class="col-sm"> <input type="date" name="dob" id="dob" class="form-control"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Gender</label> </div> <div class="col-sm"> <input type="radio" name="gender" id="male" value="male">Male <input type="radio" name="gender" id="female" value="female">Female </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Photo</label> </div> <div class="col-sm"> <input type="file" name="phote" id="photo" class="form-control" accept="image/*"> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Country</label> </div> <div class="col-sm"> <select name="country" id="country" class="form-control"> <option>Select your country</option> <option>India</option> <option>Nepal</option> <option>Srilanka</option> <option>USA</option> <option>UK</option> <option>Canada</option> </select> </div> </div> <div class="row mb-1"> <div class="col-sm"> <label for="">Address</label> </div> <div class="col-sm"> <textarea name="address" id="address" class="form-control" placeholder="Enter address"></textarea> </div> </div> <div class="row mb-1"> <div class="col-sm"> <input type="submit" class="btn btn-primary" value="Register"> </div> <div class="col-sm"> Already user?<a href="Login.html">Login here</a> </div> </div> </form> </div> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" ></script> </body> </html>

Happy coding...

Video tutorial coming shortly

Design a Registration Form using only HTML

2024-04-26T10:14:00.005+05:30

This is a simple registration form design only using HTML tags. We have designed the same form using Bootstrap classes. Have a look here.

<!DOCTYPE html> <html> <head> <title>Registration Form</title> </head> <style> table{ border: 1px solid black; padding: 20px; } </style> <body> <center> <form method="post"> <h3>Registration Form</h3> <table> <tr> <td>Name</td> <td><input type="text" name="name" id="name" placeholder="Enter your name"></td> </tr> <tr> <td>Email Id</td> <td><input type="email" name="emailid" id="emailid" placeholder="Enter your email id"></td> </tr> <tr> <td>Phone</td> <td><input type="number" name="phone" id="phone" placeholder="Enter mobile number"></td> </tr> <tr> <td>DOB</td> <td><input type="date" name="dob" id="dob" ></td> </tr> <tr> <td>Gender</td> <td> <input type="radio" name="gender" id="male" value="male">Male <input type="radio" name="gender" id="female" value="female">Female </td> </tr> <tr> <td>Photo</td> <td><input type="file" name="phote" id="photo" accept="image/*"></td> </tr> <tr> <td>Country</td> <td> <select name="country" id="country"> <option>Select your country</option> <option>India</option> <option>Nepal</option> <option>Srilanka</option> <option>USA</option> <option>UK</option> <option>Canada</option> </select> </td> </tr> <tr> <td>Address</td> <td><textarea name="address" id="address" placeholder="Enter address" ></textarea></td> </tr> <tr> <td><input type="submit" value="Register"></td> <td>Already user?<a href="Login.html">Login here</a></td> </tr> </table> </form> </center> </body> </html>

I have tried to implement the maximum number of elements that are being used in the basic registration form.

In the next blog, we will see the implementation of Bootstrap on these basic form designs.

Video Tutorial coming soon...

Hope this blog finds you useful. Thank you.

Design a Login Form using only HTML

2024-04-21T11:42:00.002+05:30

This is a very simple login form design, only using HTML elements. To see the Bootstrap design on this form, click here.

<!DOCTYPE html> <html> <head> <title>Login</title>

</head> <body> <center> <h3>Login Form</h3> <form method="post"> <table> <tr> <td>Id</td> <td><input type="text" placeholder="Enter Email Id"></td> </tr> <tr> <td>Password</td> <td><input type="password" placeholder="Enter Password"></td> </tr> <tr> <td><input type="button" name="Login" value="Login"></td> <td> <a href="#"> Register here </a></td> </tr> </table> </form> </center> </body> </html>

To create a border and a gap between the border and the login page elements, add the following CSS to the head section.

<head> <title>Login</title>

//css styling for the border <style> table{ padding: 50px; border: 1px solid black; } </style>

</head>

Video Tutorial coming soon...

Hope this blog finds you useful. Thank you.

Reverse the words of a sentence in C# without using predefined Reverse Method

2023-09-02T22:12:00.002+05:30

In this scenario, we have to reverse each word of a sentence. For example, the input string is "Hello, This is Me", the output will be ",olleH sihT si eM".

Program

public class Program

{

public static void Main(string[] args)

{

string inputString="Hello World, This is a Reverse word Example";

string[] stringArr = inputString.Split(' ');

string result= string.Empty;

for (int i=0;i< stringArr.Length;i++)

{

char[] charArr= stringArr[i].ToCharArray();

for (int j= charArr.Length- 1;j>=0;j--)

{

result += charArr[j];

}

result +=" ";

}

Console.WriteLine(result)

}

O/P- ,olleH sihT si eM

Explanation

Taking the Input from the user/ Initlilising with any string value by hardcoding

string inputString="Hello World, This is a Reverse word Example";

Console.WriteLine("Enter a string");

string inputString=Console.ReadLine();

Split the input string when there is a space.

string[] stringArr = inputString.Split(' ');

Declaring a variable to store the result

string result= string.Empty;

Loop to read all split strings

for (int i=0;i< stringArr.Length;i++)

{

Converting the ith position string to a character array

char[] charArr= stringArr[i].ToCharArray();

Loop through the character array, but read it from the last index

for (int j= charArr.Length- 1;j>=0;j--)

{

Store the reversed characters in the "result" variable by concatenating

result += charArr[j];

}

Adding a space when the iteration of one split string is done

result +=" ";

}

Printing the result

Console.WriteLine(result);

Hope this will help you to understand the program.

Thank you

Find the Sum of values of an Array those are in Even position in C#

2023-08-08T22:02:00.010+05:30

Find the Sum of values of an Array that are in the Even position including the 0th index.

The scenario is looking like the below image.

According to the scenario we have to loop through the array and check the position of the array items.

Here is the solution to the program.

Including the 0th index

public class Program

{

public static void Main(string[] args)

{

int[] arr = { 10, 20, 30, 40, 50 }; // declaring and initializing the arr variable with the array items.

int result = 0;// declaring a variable to store result

for (int i = 0; i < arr.Length; i++) // for loop for reading each value

{

if (i % 2 == 0)// checking the index position is even by finding mod value 0

{

result += arr[i]; // sum of the values those sartisfy the condition

}

Console.WriteLine(result); //printing the result

}

O/P- 90

Excluding the 0th index

public class Program

{

public static void Main(string[] args)

{

int[] arr = { 10, 20, 30, 40, 50 }; // declaring and initializing the arr variable with the array items.

int result = 0;// declaring a variable to store result

for (int i = 0; i < arr.Length; i++) // for loop for reading each value

{

if (i!=0 && i % 2 == 0)// checking the index position is not 0 and even by finding mod value 0

{

result += arr[i]; // sum of the values those sartisfy the condition

}

Console.WriteLine(result); //printing the result

}

O/P- 80

Happy Coding...

Capgemini Asp.Net Core Interview Questions

2023-06-13T22:47:00.000+05:30

Here is the list of 20 questions on Asp.Net Core and related that is asked by Capgemini L1 Interview.

Why ASP .Net Core is different from previous versions.
Difference between Ref and Out Parameter.
Difference between IEnumerable and IQuerable.
Difference between read-only and constant.
Can we create an instance of Private Constructor?
What is Static Method?
Do you have any knowledge about Design Patterns?
What is the Solid Principle? Explain Liskove Substitution Principle.
What is Dependency Injection? How do you use it in your project?
What is middleware and configure service?
What is Collection?
What is ArrayList?
How to handle Exception in Asp.Net Core?
What is Temp Table & Table Variable?
What is Generic Class?
Do you know about the Generic class?
What is the difference between Constant and Readonly?
Where is the JWT token stored?
What is lazy loading?
What is content negotiation?

Please answer the above question in the comment section.

Asp .NET Core Interview Question and Answers

2023-06-07T00:11:00.208+05:30

Are you preparing for a job change / Interview? Here are some sets of questions and Answers for you to crack your goal.

Let's start and best of luck in advance.

1. What is ASP.NET Core, and how does it differ from previous versions of ASP.NET?

Ans:- ASP.NET Core is a modern, open-source framework used to build cross-platform web applications.

It differs from previous versions of ASP.NET by being lightweight, modular, and designed for improved performance.
It also introduces a unified programming model for building web APIs and MVC applications.

2. Explain the concept of middleware in ASP.NET Core?

Ans:- Middleware in ASP.NET Core refers to components that handle HTTP requests and generate responses. Each middleware component performs specific tasks like authentication, logging, routing, or exception handling. Middleware is configured in the application pipeline and is executed sequentially based on the request and response flow.

Ex:- Inside Startup.cs class file Configure() method we can see middlewares

app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseSession();

3. What is Dependency Injection, and how is it implemented in ASP.NET Core?

Ans:- Dependency injection is a design pattern.

It allows objects to receive their dependencies from an external source rather than creating them internally.

In ASP.NET Core, dependency injection is implemented through Microsoft.Extensions.DependencyInjection framework.

It allows you to register dependencies in the startup class and inject them into controllers, services, or other components.

We have three ways to do Dependency Injection

Constructor Injection
Method Injection
Property Injection

4. How does routing work in ASP.NET Core?

Ans:- Routing in ASP.NET Core determines which controller and action method should handle an incoming HTTP request based on the URL pattern and HTTP verb.

It can be configured using attributes or convention-based approaches, providing flexibility in defining custom routes, route constraints, and route parameters.

We can set our custom routes in Route.config.

The default route in ASP .Net Core is {controller=Home}/{action=Index}/{id?}

5. Can you describe the request pipeline in ASP.NET Core?

Ans:- The request pipeline in ASP.NET Core consists of a series of middleware components that process an incoming HTTP request and generate a response.

Each middleware component performs specific tasks, such as authentication, authorization, request processing, and response generation. The pipeline is configured in the Startup class using the Configure(...) method.

6. What is the purpose of tag helpers in ASP.NET Core?

Ans:- Tag helpers in ASP.NET Core extend HTML tags with additional functionality or logic.

They allow server-side code to participate in rendering and processing HTML elements, making it easier to work with server-side code in Razor views. Tag helpers simplify the development of dynamic views, form validation, or data binding scenarios.

Ex:-

here asp-action, asp-for, and asp-route-id are tag helpers.

7. How do you handle authentication and authorization in ASP.NET Core?

Ans:- ASP.NET Core provides a flexible and extensible authentication and authorization system.

It supports so many authentication schemes such as cookies, JWT tokens, OAuth, and OpenID Connect.

Authorization can be based on roles, policies, or custom requirements.

Using attributes or middleware, you can configure authentication and authorization in the Startup class and apply them to controllers or actions.

8. Differenciate Razor Page and MVC in ASP.NET Core?

Ans:- Razor Pages and MVC are two approaches for building web applications in ASP.NET Core. MVC follows the Model-View-Controller pattern.

Ex:-

Razor Pages adopt the simpler approach, allowing developers to put the UI and logic for a specific page in a single file.

Ex of Razor Page:- This is the example of a razor page, where we can write HTML codes and cs logics in one page i.e. ".cshtml"

@if (SignInManager.IsSignedIn(User) && (User.IsInRole("Admin") || User.IsInRole("Manager")))
{
@if (Model.TeamLeaves != null)
{
@foreach (var item in Model.TeamLeaves)
{
<tr>
<td>
@item.AppliedBy
</td>
<td>
@item.DateRequested.Value.ToString("dd/MM/yyyy")
</td>
<td>
@item.Reason
</td>
<td>
@Html.ActionLink("Details", "Details", new { id = item.Id })
</td>
<td>
</td>
</tr>
}
}
}

9. Can you explain the concept of model binding in ASP.NET Core?

Ans:- Model binding in ASP.NET Core maps incoming request data to parameters or properties of an action method's input model. It simplifies handling user input and binding it to strongly typed models. ASP.NET Core's model binding infrastructure automatically maps form data, query strings, route data, and request headers to the corresponding action method parameters.

10. How to implement caching in ASP.NET Core?

Ans:- ASP.NET Core provides built-in support for caching data. It offers in-memory caching, distributed caching with providers like Redis or SQL Server, and response caching to cache the output of specific actions or pages. Caching improves performance by storing frequently accessed data and reducing the load on the server.

11. What are the advantages of using Entity Framework Core in ASP.NET Core?

Ans:- Entity Framework Core simplifies database access and data manipulation in ASP.NET Core applications. It offers a higher-level abstraction over database operations, supports multiple database providers, and provides features like migrations, LINQ query generation, and automatic change tracking. Entity Framework Core promotes productivity, maintainability, and testability in data access code.

12. How do you handle errors and exceptions in ASP.NET Core?

Ans:- ASP.NET Core provides a centralized error-handling mechanism through middleware. You can configure custom error-handling middleware to catch exceptions and generate appropriate responses. Additionally, ASP.NET Core offers logging facilities for capturing and tracking application errors. Proper exception handling and logging contribute to the robustness and maintainability of an application.

13. Can you describe the different deployment options for an ASP.NET Core application?

Ans:- ASP.NET Core applications can be deployed as self-contained executables, including the runtime, or as framework-dependent executables that rely on a shared runtime. Deployment options include traditional web servers, containerized environments like Docker, and cloud platforms such as Azure or AWS.

14. How do you implement logging in ASP.NET Core?

Ans:- Logging in ASP.NET Core is achieved using the built-in logging framework based on Microsoft.Extensions.Logging namespace. It supports various logging providers like console, debug, file, or external logging frameworks such as Serilog. Logging can be configured in the Startup class to capture application logs, handle exceptions, and track important events for troubleshooting and monitoring purposes.

15. What are the best practices for securing an ASP.NET Core application?

Ans:- Securing an ASP.NET Core application involves practices like using strong authentication mechanisms, implementing authorization based on the principle of least privilege, protecting sensitive data through encryption and secure storage, following secure coding practices, regularly updating dependencies and frameworks, and performing threat modeling and security testing to identify and mitigate potential risks.

Thank You :)

Bitwise Operators in C Language

2023-04-11T15:17:00.010+05:30

In C Language we have 6 Bitwise Operators. Those are listed below

& Bitwise AND Operator
| Bitwise OR Operator
~ Bitwise NOT Operator
^ Bitwise XOR Operator
<< Bitwise Left Shift Operator
>> Bitwise Right Shift Operator

The Bitwise operator converts the Decimal value into a Binary number and then does the Operation at the bit level.

Truth Table of & | and ^

Look at the above table; here a and b are two Operands, when we use the Operator, the corresponding operation happens at the bit level.

& Bitwise AND Operator

When both operands are 1 then it returns 1 as a result if one of the operands is 0 then it will return 0 as result.

Example:-

int a = 7 ;//00000111 int b = 9 ;//00001001 ____________________ a&b = 1 ;//00000001

| Bitwise OR Operator

When one of the operands is 1 then it returns 1 as a result if both operands are 0 then it will return 0 as result.

Example:-

int a = 7 ;//00000111 int b = 9 ;//00001001 ____________________ a|b = 15 ;//00001111

^ Bitwise XOR Operator

When two operands are different then it returns 1 as a result and if both operands are the same then it will return 0 as result.

Example:-

int a = 7 ;//00000111 int b = 9 ;//00001001 ____________________ a^b = 14 ;//00001110

~ Bitwise NOT Operator

This operator is also known as Binary One's Complement. It returns the result as 1 when the operand is 0 and returns 0 when the operand is 1.

int a = 7 ;//00000111 ~ a = -8 ;//11111000

<< Bitwise Left Shift Operator

It shifts to the left side bitwise and the empty space that remains on the right side will be placed with zero. See the below example for an understanding.

Example:-

int a = 7 ;//00000111 a<< 1 = 14 ;//00001110 a<< 2 = 28 ;//00011100

>> Bitwise Right Shift Operator

It shifts to the right side bitwise and the empty space that remains on the left side will be placed with zero. See the below example for a better understanding.

Example:-

int a = 7 ;//00000111 a>> 1 = 3 ;//0000011 a>> 2 = 1 ;//00000001

Run the Code and see the result on the code compiler

Thank you Happy Coding💻☺

Logical Operators in C Language

2023-04-01T00:43:00.003+05:30

Logical Operators are used mainly between two conditions. It checks whether both operands are True(1 or Non-zero) or False(Zero).

In C Programming 3 logical operators are highly used. Those are

&& AND Operator returns true if both sides are non-zero.
|| OR Operator returns true if any of the sides is non-zero.
! NOT Operator returns the reverse value of the result; if the result is true then it will return false and vice versa.

&& AND Operator

if(Operand1 && Operand2) {

//true

}

else{

//false

}

|| OR Operator

if(Operand1 || Operand2) {

//true

}

else{

//false

}

! NOT Operator

if(!Operand) {

//true

}

else{

//false

}

Let's code

#include<stdio.h>

int main(){
    //Change the numbers with 1 and 0 and see the output

also change it signed integer and integer values other than 1
    if(1 && 0)
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }

    if(1 || 0)
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }

        if(!(1))
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }
}

Let's take another example. Here we will take inputs from the user and check some conditions and compare if the statement satisfies or not.

#include<stdio.h>

int main(){
    int num1,num2;
    printf("Enter 1st Number:");
    scanf("%d",&num1); 
    printf("Enter 2nd Number:");
    scanf("%d",&num2);
    if(num1>num2 && num1==num2)
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }

    if(num1>num2 || num1<num2)
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }
    
    if(!(num1>num2))
    {
        printf("True\n");
    }
    else{
        printf("False\n");
    }
}

Change the inputs and operators to see different outputs and try to understand what it returns.

Thank you Happy Coding

Relational/Comparision Operations in C Program

2023-03-30T22:54:00.002+05:30

In C Programing language sometimes we need to compare two values.

For example, we are evaluating students' marks, and we have to check if the student passes or fails?

The pass mark is 23 out of 70, below the 23 mark will count as a failure.

How to check?

Student Marks Obtained Result

-----------------------------------------

1. Student1 45 Pass

2. Student2 23 Pass

3. Student3 21 Fail

Condition is:- if(marks >= 23) {

//Pass

}

else{

//Fail

}

To do this type of comparison/Operation we have Relational Operators. We have 6 Operators here given below.

== Compares both side values, returns true if both are equal
!= Compares both side values returns true if both are not equal
> Checks if the left side value is greater than the right side value
< Checks if the left side value is less than the right side value
>= Checks if the left side value is greater than or equal to the right side value
<= Checks if the left side value is less than or equal to the right side value

== Equal to Operator

if(Operand1 == Operand2) { //true } else{ //false }

!= Not Equal to Operator

if(Operand1 != Operand2) { //true } else{ //false }

> Greater Than Operator

if(Operand1 > Operand2) { //true } else{ //false }

< Less Than Operator

if(Operand1 < Operand2) { //true } else{ //false }

>= Greater Than Equal to Operator

if(Operand1 >= Operand2) { //true } else{ //false }

<= Less Than Equal to Operator

if(Operand1 <= Operand2) { //true } else{ //false }

Let's use these operands on code, run it and see the outputs by providing different inputs.

#include <stdio.h>
int main(){
    int num1,num2;
    printf("Enter 1st Number:");
    scanf("%d",&num1); 
    printf("Enter 2nd Number:");
    scanf("%d",&num2);
     if(num1==num2)
     {
        printf("num1 is equal to num2 \n");
     }
   if(num1!=num2){
    printf("num1 is not equal to num2 \n");
   }
   if(num1>num2){
        printf("num1 is greater than num2 \n");
   }
   if(num1<num2){
        printf("num1 is less than num2 \n");
   }
   if(num1>=num2){
        printf("num1 is greater than equal to num2 \n");
   }
   if(num1<=num2){
        printf("num1 is less than equal to num2 \n");
   }
    return 0;
}

See the video tutorial here

Arithmetic Operations in C Program

2023-03-25T01:52:00.002+05:30

In Arithmetic Operators in C Program, all the mathematical operations like Addition, Subtractions are done. We have the following Operators

+ Adds two Operands
- Used for subtraction
* Used for multiplication
/ Used for Division
% Used for Modulus
++ Increment Operator
-- Decrement Operator

Let's see how we can implement these operations in C program Coding.

Here we are taking 2 inputs from the user and scanning the input values to the address of the "num1" and "num2" variable memory location, and doing the arithmetic operation.

Here the inputs for the 1st Number is 20 and the 2nd Number is 10.

 #include<stdio.h>

int main(){
    int num1,num2;
    printf("Enter 1st Number:");
    scanf("%d",&num1);
    printf("Enter 2nd Number:");
    scanf("%d",&num2);

    printf("Sum value is: %d \n",num1+num2);
    printf("Subtraction value is: %d \n",num1-num2);
    printf("Multiplication value is: %d \n",num1*num2);
    printf("Division value is: %d \n",num1/num2);
    printf("Modulus value is: %d \n",num1%num2);
    num1++;
    printf("num1++ value is: %d \n",num1);
    ++num1;
    printf("++num1 value is: %d \n",num1);
    num2--;
    printf("num2-- value is: %d \n",num2);
    --num2;
    printf("--num2 value is: %d \n",num2);
    return 0;
}

O/P

Enter 1st Number:20

Enter 2nd Number:10

Sum value is: 30

Subtraction value is: 10

Multiplication value is: 200

Division value is: 2

Modulus value is: 0

num1++ value is: 21

++num1 value is: 22

num2-- value is: 9

--num2 value is: 8

Q.What "++" operator does?

A. It increments the value with 1.

Example:- int x=2;

x++;

print("%d",x);

O/P:-3

It means x++ is same as x=x+1;

and aswell ++x means x=x+1;

Q. If x++ and ++x is same then why it is defined in two different way?

It is the same but in x++ condition, the statement executes 1st then assigns the incremented by 1 value later;

but in ++x 1st the increase will happen then the execution will happen.

It is the same for x-- and --x; It means x=x-1;

It will decrease the value by 1.

To see the difference change the coding by following

#include<stdio.h>

int main(){
    int num1,num2;
    printf("Enter 1st Number:");
    scanf("%d",&num1);
    printf("Enter 2nd Number:");
    scanf("%d",&num2);

    printf("num1++ value is: %d \n",num1++);
    printf("++num1 value is: %d \n",++num1);
    printf("num2-- value is: %d \n",num2--);
    printf("--num2 value is: %d \n",--num2);
    return 0;
}

O/P

Enter 1st Number:20

Enter 2nd Number:10

num1++ value is: 20

++num1 value is: 22

num2-- value is: 10

--num2 value is: 8

Hope this article helps you please give feedback in the comment section

Learn Operators in C Language

Thank you.

Operators in C Language

2023-03-23T22:18:00.007+05:30

In every programming language, we need to do several operations like mathematical, comparison, condition checks, etc.

So to let the machine understand the actions we want to do there are some operators that are predefined.

We can use those operators between two operands and can do the required operations easily.

Let's start here.

Operators

Click here for the reference video

	Operators
1. Arithmetic Operator	+,-,*,%,++,--
2. Relational Operator	==,!=,>,<,>=,<=
3. Logical Operator	&&,\|\|,!
4. Bitwise Operator	&,\|,~,^,<<,>>
5. Assignment Operator	=,+=,-=,*=,/=,%=,<<=,>>=,&=,\|=,^=
i. Ternary Operator	?:

Let's know more about these operators

Arithmetic Operator

Operator	Description
+	Adds two Operands
-	Used for subtraction
*	Used for multiplication
/	Used for Division
%	Used for Modulus
++	Increment Operator
--	Decrement Operator

Relational/Comparision Operator

Operator	Description
==	Compares both side values returns true if both are equal
!=	Compares both side values returns true if both are not equal
>	Checks if the left side value is greater than the right side value
<	Checks if the left side value is less than the right side value
>=	Checks if the left side value is greater than or equal to the right side value
<=	Checks if the left side value is less than or equal to the right side value

Logical Operator

Operator	Description
&&	AND Operator returns true if both sides are non zero
\|\|	OR Operator returns true if any of the sides is non zero
!	NOT Operator returns the reverse value of the result; if the result is true then it will return false and vice versa

Bitwise Operator

Operator	Description
&	Bitwise AND Operator
\|	Bitwise OR Operator
~	Bitwise NOT Operator
^	Bitwise XOR Operator
<<	Bitwise Left Shift Operator
>>	Bitwise Right Shift Operator

Assignment Operator

Operator	Description
=	Equals to, Assigns right side result to left side Operand
+=	Add and Assignment Operator
-=	Subtract and Assignment Operator
*=	Multiply and Assignment Operator
/=	Divide and Assignment Operator
%=	Modulus and Assignment Operator
<<=	Left shift and Assignment Operator
>>=	Rightshift and Assignment Operator
&=	Bitwise AND and Assignment Operator
\|=	Bitwise OR and Assignment Operator
^=	Bitwise XOR and Assignment Operator

Ternary Operator

Operator	Description
?:	Syntax:- ConditionalStatement?The true expression: The false Expression checks the condition and returns the true expression else returns the false expression

Thank You

Modulus of two Integers in C Program

2023-03-23T00:06:00.000+05:30

In C Programming Language Modulus means the remainder value of a division operation.

To get this value in C programming we use the % (percentile) symbol.

Let's do coding to get the modulus of two numbers.

#include<stdio.h>
int main(){
    int num1,num2;
    printf("Enter 1st Number : ");
    scanf("%d",&num1);
    printf("Enter 2nd Number : ");
    scanf("%d",&num2);
    
    printf("Modulus of %d and %d is : %d",num1,num2,num1%num2);
    return 0;
}

Run the above code on Code Editor and Try.

Add, Substract,Multiply and Divide Two Integers in C Program

2023-03-21T00:36:00.007+05:30

In Mathematics the formula for SUM is a+b=c.

But our machine doesn't know mathematical equations.

Here is the simple code to add Two numbers in the C program

#include<stdio.h>

int main(){
int num1=10,num2=20;
printf("Sum is : %d",num1+num2);
return 0;
}

Let's take two inputs from the user.

For that, we have to read the value given by the user to do this, and we have to use scanf.

It reads the user input and stores it in a variable.

So here is the code for user input and adding two integers.

#include<stdio.h>

int main(){
    int num1,num2;
    printf("Enter 1st Number : ");
    scanf("%d",&num1);
    printf("Enter 2nd Number : ");
    scanf("%d",&num2);
    
    printf("Sum is : %d",num1+num2);
    return 0;
}

Like the above example, we can do Subtraction (-), Multiplication (*), and Division(/) operations by replacing the + sign with the -, *, and / symbols.

Thank you.

Try and write your query.

ASP .Net Core CRUD Operation with Photo/File Upload using ADO.Net in MVC Pattern

2022-08-25T00:39:00.005+05:30

In this post we will see an Asp .Net Core CREATE, READ, UPDATE and DELETE functionality using ADO .Net using MVC architecture . In next post we will see the same example with Entity Framework Core. So lets get started.

Database Table Creation

Open SQL Server --> click on "New Query" then write the following code for generating a new Database Table tblEmployee.


USE [Your Database]
CREATE TABLE [dbo].[tblEmployee](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Email] [varchar](50) NULL,
	[Phone] [varchar](50) NULL,
	[Address] [varchar](100) NULL,
	[Photo] [varchar](1000) NULL,
	[Gender] [varchar](10) NULL,
	[DOB] [datetime2](7) NULL,
	[Salary] [decimal](18, 0) NULL,
	[IsActive] [bit] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

(fig. 1)

Now Open Visual Studio ,then click on Create a new project (fig. 2)--> Select template ASP.NET Core Web App(Model-View-Controller) (fig. 3)--> Set Name and Location (fig. 4)--> Choose the version of .Net here I am choosing ".Net Core 3.1 (Log term support)".

(fig. 2)

(fig. 3)

(fig. 4)

(fig. 5)

After doing this a ASP.Net Core Project is created successfully.

Model

(ConnectionString.cs)

This class establishing the connection with Sql Server to our project.

 namespace MVC_CRUD.Models
{
    public class ConnectionString
    {
        private static string constr = "Data Source=<Your Server Name>; Initial Catalog=<Your Database>;Trusted_Connection=True;MultipleActiveResultSets=true";
        
        public static string Constr
        {
            get => constr;
        }
    }
}

(tblEmployee.cs)

This this the model mapping class of tblEmployee table.

using Microsoft.AspNetCore.Http;
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace MVC_CRUD.Models
{
    [Table("tblEmployee")]
    public class tblEmployee
    {
        [Key]
        public int Id { get; set; } 
        public string Name { get; set; }    
        public string Email { get; set; }
        public string Phone { get; set; }
        public string Address { get; set; }
        [NotMapped]
        public IFormFile Photo { get; set; }
        public string PhotoPath { get; set; }
        public string Gender { get; set; }
        public DateTime DOB { get; set; }
        public string Salary { get; set; }
        public bool IsActive { get; set; }
    }
}

Controller(EmployeeController.cs)

Add a new controller by Right Clicking on Controller folder -->MVC Controller - Empty --> Name it as EmployeeController.cs.

(fig. 6)

using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;
using MVC_CRUD.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

using System.IO;

namespace MVC_CRUD.Controllers
{
    public class EmployeeController : Controller
    {
        SqlConnection con;
        SqlCommand cmd;
        SqlDataAdapter sda;
        DataTable dt;
        string connectionString = ConnectionString.Constr;
        IWebHostEnvironment _webHostEnvironment;
        public EmployeeController(IWebHostEnvironment webHostEnvironment)
        {
            _webHostEnvironment = webHostEnvironment;
        } 
        [HttpGet]
        public IActionResult Add()
        {
            return View();
        }
        [HttpPost]
        public IActionResult Add(tblEmployee employee)
        {
            if (ModelState.IsValid)
            {
                using (con = new SqlConnection(connectionString))
                {
                    string img = SaveImage(employee);
                    if (img != "")
                    {
                        employee.PhotoPath = img;
                    }
                    cmd = new SqlCommand("Insert into tblEmployee(Name,Email,Phone,Address,Photo,Gender,DOB,Salary,IsActive) " +
                        "values('" + employee.Name + "','" + employee.Email + "','" + employee.Phone + "','" + employee.Address + "','" + employee.PhotoPath + "'" +
                        ",'" + employee.Gender + "','" + DateTime.Parse(employee.DOB.ToString()).ToString("yyyy-MM-dd hh:MM:ss") + "','" + employee.Salary + "',1)", con);
                    cmd.CommandType = CommandType.Text;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    ViewBag.msg = "Success";
                }
            }
            return RedirectToAction("AllEmployees");
        }
        public IActionResult AllEmployees(int? id)
        {
            using (con = new SqlConnection(connectionString))
            {
                List<tblEmployee> employee;
                tblEmployee emp;
                if (id != null)
                {
                    //cmd = new SqlCommand("Update tblEmployee set IsActive=0 where Id=" + id + "", con); to update the IsActive field 0
                    cmd = new SqlCommand("Delete from tblEmployee where Id=" + id + "", con);
                    cmd.CommandType = CommandType.Text;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    ViewBag.msg = "Removed";
                }
                
                cmd = new SqlCommand("select * from tblEmployee where IsActive=1", con); //get all data where IsActive is 1
                cmd.CommandType = CommandType.Text;
                con.Open();
                employee = new List<tblEmployee>();
                using (sda = new SqlDataAdapter(cmd))
                {
                    using (dt = new DataTable())
                    {
                        sda.Fill(dt);
                        foreach (DataRow dr in dt.Rows)
                        {
                            emp = new tblEmployee();
                            emp.Id = Convert.ToInt32(dr[0].ToString());
                            emp.Name = dr[1].ToString();
                            emp.Email = dr[2].ToString();
                            emp.Phone = dr[3].ToString();
                            employee.Add(emp);
                        }
                    }
                }
                con.Close();
                //ViewBag.employee = dt;
                return View(employee);
            }

        }
        public IActionResult Details(int id)
        {
            tblEmployee emp = GetbyId(id);
            return View(emp);
        }
        [HttpGet]
        public IActionResult Edit(int id)
        {
            tblEmployee emp = GetbyId(id);
            return View(emp);
        }
        [HttpPost]
        public IActionResult Edit(tblEmployee employee)
        {
            if (ModelState.IsValid)
            {
                if (employee.Photo != null)
                {
                    string img = SaveImage(employee);
                    employee.PhotoPath = img;
                }

                using (con = new SqlConnection(connectionString))
                {
                    cmd = new SqlCommand("Update tblEmployee set Name='" + employee.Name + "',Email='" + employee.Email + "',Phone='" + employee.Phone + "'," +
                        "Address='" + employee.Address + "',Photo='" + employee.PhotoPath + "',Gender='" + employee.Gender + "'," +
                        "DOB='" + DateTime.Parse(employee.DOB.ToString()).ToString("yyyy-MM-dd hh:ss:mm") + "',Salary='" + employee.Salary + "',IsActive=1 where Id=" + employee.Id + "", con);
                    cmd.CommandType = CommandType.Text;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    ViewBag.msg = "Success";
                }
            }
            tblEmployee emp = GetbyId(employee.Id);
            return View(emp);

        }
        public tblEmployee GetbyId(int id)
        {
            tblEmployee emp;
            using (con = new SqlConnection(connectionString))
            {
                cmd = new SqlCommand("Select * from tblEmployee where Id=" + id + "", con);
                cmd.CommandType = CommandType.Text;
                con.Open();
                cmd.ExecuteReader();
                con.Close();
                using (sda = new SqlDataAdapter(cmd))
                {
                    using (dt = new DataTable())
                    {
                        sda.Fill(dt);
                        emp = new tblEmployee();
                        emp.Id = Convert.ToInt32(dt.Rows[0][0].ToString());
                        emp.Name = dt.Rows[0][1].ToString();
                        emp.Email = dt.Rows[0][2].ToString();
                        emp.Phone = dt.Rows[0][3].ToString();
                        emp.Address = dt.Rows[0][4].ToString();
                        emp.PhotoPath = dt.Rows[0][5].ToString();
                        emp.Gender = dt.Rows[0][6].ToString();
                        emp.DOB = Convert.ToDateTime(dt.Rows[0][7].ToString());
                        emp.Salary = dt.Rows[0][8].ToString();
                    }
                }
            }
            return emp;
        }
        public string SaveImage(tblEmployee employee)
        {
            string filename = "";
            string path = Path.Combine(_webHostEnvironment.WebRootPath, "ProfileImage");

            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }
            if (employee.PhotoPath != null)
            {
                FileInfo file = new FileInfo(Path.Combine(path, employee.PhotoPath));
                if (file.Exists)
                {
                    file.Delete();
                }
            }
            string ext = Path.GetExtension(employee.Photo.FileName);
            filename = Guid.NewGuid().ToString() + "_cover" + ext;
            var filepath = Path.Combine(path, filename);
            using (var fileStream = new FileStream(filepath, FileMode.Create))
            {
                employee.Photo.CopyTo(fileStream);

            }

            return filename;
        }
    }
}

View

To add view for Add method, Hover on method body then Right Click on it then click on Add View --> Choose Razor View - Empty

(fig. 7)

(Add.cshtml)

@model MVC_CRUD.Models.tblEmployee
@{
    ViewData["Title"] = "Employee";
}
<style>
    .card-header {
        background-color: #b8daff;
    }
</style>
<section>
    <div class="row">
        <div class="col-lg-12">
            <a class="btn btn-primary mb-2 float-right" asp-area="" asp-controller="Employee" asp-action="AllEmployees">All Employees</a>
        </div>
    </div>

    <div class="card">
        <div class="card-header">
            <h2>Employee Registration Form</h2>
        </div>
        <div class="card-body">
            <form asp-action="Add" asp-controller="Employee" method="post" enctype="multipart/form-data" autocomplete="off">
                <div class="form-group">

                    <div class="row">
                        <div class="col-lg-6">
                            <label asp-for="Name"></label>
                            <input type="text" class="form-control" id="txtName" asp-for="Name">
                        </div>
                        <div class="col-lg-6">
                            <label asp-for="Email"></label>
                            <input type="email" class="form-control" id="txtEmail" asp-for="Email" placeholder="">
                        </div>
                    </div>
                    <div class="row mt-3">
                        <div class="col-lg-6">
                            <label asp-for="Phone"></label>
                            <input type="text" class="form-control" id="txtPhone" asp-for="Phone">
                        </div>
                        <div class="col-lg-6">
                            <label asp-for="Photo"></label>
                            <input type="file" class="form-control" id="Photo" asp-for="Photo">
                        </div>

                    </div>
                    <div class="row mt-3">
                        <div class="col-lg-3">
                            <label asp-for="Gender"></label>
                            <select class="form-control" asp-for="Gender">
                                <option value="">--Select Gender--</option>
                                <option value="Male">Male</option>
                                <option value="Female">Female</option>
                                <option value="Other">Other</option>

                            </select>
                        </div>
                        <div class="col-lg-3">
                            <label asp-for="DOB"></label>
                            <input type="date" class="form-control" id="txtDob" asp-for="DOB">
                        </div>
                        <div class="col-lg-6">
                            <label asp-for="Salary"></label>
                            <input type="text" class="form-control" id="txtSalary" asp-for="Salary">
                        </div>
                    </div>
                    <div class="row mt-3">

                        <div class="col-lg-12">
                            <label asp-for="Address"></label>
                            <textarea class="form-control" id="txtName" asp-for="Address" rows="3"></textarea>
                        </div>
                    </div>

                    <div class="row mt-2">
                        <div class="col-lg-12">
                            <input type="submit" class="btn btn-primary float-right" value="Submit" />
                            <input type="reset" class="btn btn-default float-right" />
                        </div>

                    </div>

                </div>
            </form>
        </div>

    </div>

</section>

(AllEmployees.cshtml)

@using System.Data
@model IEnumerable<tblEmployee>

@{
    ViewData["Title"] = "Employee";
    int sl = 1;
}
<div class="row">
    <div class="col-lg-12">
        <a class="btn btn-primary mb-2 float-right" asp-area="" asp-controller="Employee" asp-action="Add">Add Employee</a>
    </div>
</div>
<div class="table-responsive-sm">

    @if (ViewBag.msg != null)
    {
        <div class="row">
            <div class="col-md-12 text-center  bg-danger">
                <span class="text-light">@ViewBag.msg</span>
                <span class="text-light float-right">x</span>
            </div>
        </div>
    }
    <table class="table table-bordered table-hover">
        <thead>
            <tr class="table-primary">
                <th scope="col">Sl No.</th>
                <th scope="col">Name</th>
                <th scope="col">Email Id</th>
                <th scope="col">Phone</th>
                <th scope="col">Action</th>
            </tr>
        </thead>
        <tbody>
            @foreach (var item in Model)
            {

                <tr>
                    <th scope="row">@sl.</th>
                    <td>@item.Name</td>
                    <td>@item.Email</td>
                    <td>@item.Phone</td>
                    <td>
                        <a asp-action="Details" asp-controller="Employee" asp-route-id="@item.Id" class="btn btn-primary">View</a>
                        <a asp-action="Edit" asp-controller="Employee" asp-route-id="@item.Id" class="btn btn-primary">Edit</a>
                        <a asp-action="AllEmployees" asp-controller="Employee" asp-route-id="@item.Id" class="btn btn-danger">Delete</a>
                    </td>
                </tr>
                sl++;
            }

        </tbody>
    </table>
</div>

(Details.cshtml)

@model tblEmployee
@{
    ViewData["Title"] = "Employee";
}
<section>
    <div class="row">
        <div class="col-lg-12">
            <a class="btn btn-primary mb-2 float-right" asp-area="" asp-controller="Employee" asp-action="AllEmployees">All Employees</a>
        </div>
    </div>

    <div class="card">
        <div class="card-header">
            <h2>Employee Details</h2>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-lg-4">
                    <div class="card mb-4">
                        <div class="card-body text-center">
                            @if (Model.PhotoPath.ToString() != "")
                            {
                                <img src='~/ProfileImage/@Model.PhotoPath' alt="avatar" class="rounded-circle img-fluid" style="width: 150px;height:150px;">
                            }
                            else
                            {
                                <img src="/Images/park.jpg" alt="avatar" class="rounded-circle img-fluid" style="width: 150px;">
                            }
                            <h5 class="my-3">@Model.Name </h5>
                            <p class="text-muted mb-1">@Model.Email</p>
                            <div class="d-flex justify-content-center mb-2">
                                <a asp-action="Edit" asp-controller="Employee" asp-route-id="@Model.Id" class="btn btn-primary">Edit</a>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-8">
                    <div class="card mb-4">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-sm-3">
                                    <p class="mb-0">Phone</p>
                                </div>
                                <div class="col-sm-9">
                                    <p class="text-muted mb-0">@Model.Phone</p>
                                </div>
                            </div>
                            <hr>
                            <div class="row">
                                <div class="col-sm-3">
                                    <p class="mb-0">Gender</p>
                                </div>
                                <div class="col-sm-9">

                                    <p class="text-muted mb-0">@Model.Gender</p>


                                </div>
                            </div>
                            <hr>
                            <div class="row">
                                <div class="col-sm-3">
                                    <p class="mb-0">DOB</p>
                                </div>
                                <div class="col-sm-9">
                                    <p class="text-muted mb-0">@Model.DOB.ToShortDateString()</p>
                                </div>
                            </div>
                            <hr>
                            <div class="row">
                                <div class="col-sm-3">
                                    <p class="mb-0">Salary</p>
                                </div>
                                <div class="col-sm-9">
                                    <p class="text-muted mb-0">@Model.Salary</p>
                                </div>
                            </div>
                            <hr>
                            <div class="row">
                                <div class="col-sm-3">
                                    <p class="mb-0">Address</p>
                                </div>
                                <div class="col-sm-9">
                                    <p class="text-muted mb-0">@Model.Address</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</section>

(Details.cshtml)

@model tblEmployee
@{
    ViewData["Title"] = "Employee";
}
<style>
    img {
        height: 71px;
        width: 71px;
        padding: 5px;
    }

    .card-header {
        background-color: #b8daff;
    }
</style>
<section>
    <div class="row">
        <div class="col-lg-12">
            <a class="btn btn-primary mb-2 float-right" asp-area="" asp-controller="Employee" asp-action="AllEmployees">All Employees</a>
        </div>
    </div>

    <div class="card">
        <div class="card-header">
            <h2>Edit Employee</h2>
        </div>
        <div class="card-body">
            <form asp-action="Edit" asp-controller="Employee" method="post" enctype="multipart/form-data">
                <div class="form-group">
                    @if (ViewBag.msg != null)
                    {
                        <div class="row bg-success">
                            <div class="col-lg-12 text-center">
                                <span class="text-light">@ViewBag.msg</span>
                                <span class="text-light float-right">x</span>
                            </div>
                        </div>
                    }
                    <div class="row">
                        <div class="col-lg-6">
                            <label asp-for="Name"></label>
                            <input type="text" class="form-control" id="txtName" asp-for="Name">
                        </div>
                        <div class="col-lg-6">
                            <label asp-for="Email"></label>
                            <input type="email" class="form-control" id="txtEmail" asp-for="Email" placeholder="">
                        </div>
                    </div>
                    <div class="row mt-3">
                        <div class="col-lg-6">
                            <label asp-for="Phone"></label>
                            <input type="text" class="form-control" id="txtPhone" asp-for="Phone">
                        </div>
                        <div class="col-lg-4">
                            <label asp-for="Photo"></label>
                            <input type="file" class="form-control" id="txtPhoto" asp-for="Photo">
                        </div>
                        <div class="col-lg-2">
                            <input type="hidden" asp-for="PhotoPath" value="@Model.PhotoPath" />
                            <img src="~/ProfileImage/@Model.PhotoPath" alt="" />
                        </div>
                    </div>
                    <div class="row mt-3">
                        <div class="col-lg-3">
                            <label asp-for="Gender"></label>
                            <select class="form-control" asp-for="Gender">
                                <option value="">--Select Gender--</option>
                                <option value="Male">Male</option>
                                <option value="Female">Female</option>
                                <option value="Other">Other</option>

                            </select>
                        </div>
                        <div class="col-lg-3">
                            <label asp-for="DOB"></label>
                            <input type="date" class="form-control" id="txtDob" asp-for="DOB">
                        </div>
                        <div class="col-lg-6">
                            <label asp-for="Salary"></label>
                            <input type="text" class="form-control" id="txtSalary" asp-for="Salary">
                        </div>
                    </div>
                    <div class="row mt-3">

                        <div class="col-lg-12">
                            <label asp-for="Address"></label>
                            <textarea class="form-control" id="txtName" asp-for="Address" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="row mt-2">
                        <div class="col-lg-12">
                            <input type="submit" class="btn btn-primary float-right" value="Save" />
                        </div>

                    </div>
                </div>
            </form>
        </div>

    </div>

</section>

Demo Video

In the next Post we will do the ASP.NET CORE project using Entity Framework Core.

Thank You

Creating Database in SQL Server in any Location /Directory(.mdf and .ldf files)

2022-05-13T02:27:00.000+05:30

To work with SQL Server Database we need to create a database first. We can do it in many ways. Let's discuss.

Using Graphical User Interface (GUI)

After login to SSMS(SQL Server Management Studio)

Open Object Explorer
Right Click on Database
Click on New Database

A new window will open; Give the Database name
Click OK

✅ Your Database is created successfully.

After Creating a database, SQL Server creates 2 database files internally in C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA location with .mdf and .ldf extensions.

Those files are PRIMARY DATA FILE/MASTER DATA FILE (.mdf) and LOG DATA FILE (.ldf). Primary Data File contains all database information and the Log Data File contains all the transactions/log activities.

Using Character User Interface (CUI)

We can write queries to create a database.

Open Query Editor

Syntax to create a Database

create database <Database Name>

Ex:-create database MyFirstDB

then Execute

✅ Your Database is created successfully.

Note:- It will also store the database files on the above default path i.e. C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA. We can also change the location of these file paths and their size.

Giving customized Path, Size, Max size, and File growth of the database file

Using GUI

While creating a new database we have seen this table also.

we can clearly see the columns, Logical Name, File Type, Filegroup, etc. The Red dotted column values we can customize.

Click on the Autogrowth/Maxsize columns box we have another window to set those properties; the image reference is given below

Note:-Filegrowth data can be set in percentage value/ Megabyte value, and Max size data can be set as Megabyte value/Unlimited.

Let's understand these columns clearly. These fields are helpful while writing the query for customized database creation.

Logical Name/ Name:- It is the logical name of the file; we have to set both .mdf and .ldf file names. In GUI while giving the database name the application automatically sets file names as follows. .mdf/data file name-> databasename and .ldf/log file name->databasename_log.

Initial Size(MB)/ Size:- It is the size of the file initially while creating the DB.

Autogrowth/ Filegrowth:- Sometimes SQL server needs to expand its size. This property helps to grow the file size automatically when it needs some extra space in the disk. the value can be set in Megabyte/Percentage.

Maxsize:- This property sets the maximum size of the file.

Path/ Filename:- It is the physical path/location of data and log file.

Using CUI

Syntax:-

create database <database name>

on primary

(.mdf/data file Properties)

log on

(.ldf/log file Properties)

Ex:-

create database MyFirstDB

on primary

(name = 'MyFirstDB ', filename = 'D:\MyDatabase\MyFirstDB .mdf' , size = 2MB , maxsize = 6MB, filegrowth = 1MB)

log on

(name = 'MyFirstDB _log', filename = 'D:\MyDatabase\MyFirstDB _log.ldf' , size = 2MB , maxsize = UNLIMITED , filegrowth = 10%);

then Execute

✅ Your Database is created successfully.

We can only set Customized Path like the below query

create database MyFirstDB

on primary

(name = 'MyFirstDB ', filename = 'D:\MyDatabase\MyFirstDB .mdf')

log on

(name = 'MyFirstDB _log', filename = 'D:\MyDatabase\MyFirstDB _log.ldf');

then Execute

✅ Your Database is created successfully.

Thank You

Captcha Creation and Validation using JavaScript

2021-12-09T01:09:00.002+05:30

In this article, we can Create a captcha and validate the captcha. To achieve this we used javascript.

The demo video is given below

In Head Section

link bootstrap.min.css

In Body Section

</div>

<a href="#" class="btn btn-primary" onclick="createCaptcha()">Reload Captcha</a>

</div>

</div>

<button type="submit" class="btn btn-primary" onclick="return validateCaptcha()">Submit Form</button>

</div>

Script

window.onload = function () {

createCaptcha();

};

var code;

function createCaptcha() {

document.getElementById('captcha').innerHTML = '';

document.getElementById('errorMsg').innerHTML = '';

var charsArray = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!#$%^&*';

var len = 4;

var captcha = [];

for (var i = 0; i < len; i++) {

var index = Math.floor(Math.random() * charsArray.length + 1);

if (captcha.indexOf(charsArray[index]) == -1) {

captcha.push(charsArray[index]);

}

else {

i--;

}

var canv = document.createElement('canvas');

canv.id = 'captcha';

canv.width = 162;

canv.height = 50;

var ctx = canv.getContext('2d');

ctx.font = 'bold 25px Apple Chancery, Georgia';

var grd = ctx.createLinearGradient(0, 0, 200, 0);

grd.addColorStop(0, 'red');

ctx.fillStyle = grd;

ctx.fillText(captcha.join(''), 0, 30);

code = captcha.join('');

document.getElementById('captcha').appendChild(canv);

}

function validateCaptcha() {

document.getElementById('errorMsg').innerHTML = '';

if (document.getElementById('txtCapcha').value != code || document.getElementById('txtCapcha').value == '') {

createCaptcha();

document.getElementById('errorMsg').innerHTML += '<span style="padding: 13px 25px 25px 0px;">Invalid Captcha</span> ';

return false;

}

else if (document.getElementById('txtCapcha').value == code) {

alert('Form Submitted !');

return true;

}

</script>

Generated multi-node xml file in asp.net or multiple child nodes xml file generated in asp.net C#

2021-03-18T23:38:00.001+05:30

1) create a web from right below codes

<div>

<h3>Generated multi-node or multiple child nodes xml file in asp.net</h3>

<hr />

<asp:TextBox ID="txtxmlname" runat="server"></asp:TextBox>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />

<br />

<asp:Label ID="lblMessage" runat="server" Text=""></asp:Label>

</div>

</form>

2) now add code in aspx.cs page

protected void Button1_Click(object sender, EventArgs e)

{

string FileName = txtxmlname.Text.Trim();

FileName = FileName.Replace(" ", "");

XmlTextWriter xmlwriter = new XmlTextWriter(Server.MapPath("~/LaptopDistribution/" + FileName + ".xml"), Encoding.UTF8);

xmlwriter.Formatting = Formatting.Indented;

xmlwriter.WriteStartDocument();

xmlwriter.WriteComment("Total Students list XML Generate");

xmlwriter.WriteStartElement("root");// root Start

xmlwriter.WriteStartElement("studentslist");//students List Start

xmlwriter.WriteStartElement("student");//student Node start

xmlwriter.WriteElementString("studentroll", "347NA064");

xmlwriter.WriteElementString("studentname", "AJIT KUMAR RANA");

xmlwriter.WriteElementString("studentdbo", "27-05-1995");

xmlwriter.WriteStartElement("subject");

xmlwriter.WriteElementString("sub1", "Physics");

xmlwriter.WriteElementString("sub2", "Chemistry");

xmlwriter.WriteElementString("sub3", "Mathematics");

xmlwriter.WriteElementString("sub4", "Biology");

xmlwriter.WriteEndElement();

xmlwriter.WriteEndElement();//student Node end

xmlwriter.WriteStartElement("student");

xmlwriter.WriteElementString("studentroll", "115GA130");

xmlwriter.WriteElementString("studentname", "PRATEEK PANIGRAHI");

xmlwriter.WriteElementString("studentdbo", "28-11-1993");

xmlwriter.WriteStartElement("subject");

xmlwriter.WriteElementString("sub1", "Language Odia");

xmlwriter.WriteElementString("sub2", "Chemistry");

xmlwriter.WriteElementString("sub3", "English");

xmlwriter.WriteEndElement();

xmlwriter.WriteStartElement("teacherslist");//students List Start

xmlwriter.WriteStartElement("teacher");

xmlwriter.WriteElementString("teacherid", "20210025");

xmlwriter.WriteElementString("teachername", "JYOTI RANJAN DEHURY");

xmlwriter.WriteStartElement("Specialties");

xmlwriter.WriteElementString("sub1", "Language Odia");

xmlwriter.WriteEndElement();

xmlwriter.WriteStartElement("teacher");

xmlwriter.WriteElementString("teacherid", "20210026");

xmlwriter.WriteElementString("teachername", "ADITYA RAJ BEHERA");

xmlwriter.WriteStartElement("Specialties");

xmlwriter.WriteElementString("sub1", "Chemistry");

xmlwriter.WriteElementString("sub2", "English");

xmlwriter.WriteEndElement();

xmlwriter.WriteEndElement();//students List Start

xmlwriter.WriteEndElement(); // root End

xmlwriter.WriteEndDocument();

xmlwriter.Flush();

xmlwriter.Close();

lblMessage.Text = "<a href=../LaptopDistribution/" + FileName + ".xml target='_blank' >View XML file</a>";

}

now you find xml file like this

How to upload file on SFTP using Asp.Net C#

2021-03-13T17:32:00.010+05:30

SFTP – SSH Secure File Transfer Protocol

SFTP (SSH File Transfer Protocol) is a secure file transfer protocol. It runs over the SSH protocol. It supports the full security and authentication functionality of SSH.

SFTP has pretty much-replaced legacy FTP as a file transfer protocol and is quickly replacing FTP/S. It provides all the functionality offered by these protocols, but more securely and more reliably, with easier configuration. There is basically no reason to use the legacy protocols anymore.

SFTP also protects against password sniffing and man-in-the-middle attacks. It protects the integrity of the data using encryption and cryptographic hash functions and authenticates both the server and the user.

Start Upload File on SFTP

1) First you need Renci.SshNet.ddl for uploaded files, you can download from www.nuget.org.
2) you need Host, User Name, Password, Port.

3) Add a web form and add design.

<div>

<p><strong>How to upload file on SFTP server using Aps.net C#</strong></p>

<br />

<asp:Button ID="Button1" runat="server" Text="Uplode File To SFTP" OnClick="Button1_Click" />

<br />

<asp:Label ID="lblresponsemsg" runat="server" Text=""></asp:Label>

</div>

</form>

4) Now write C# code like below .

protected void Button1_Click(object sender, EventArgs e)

{

try

{

string SftpPth = "//HOME";

string SftPHost = "***.***.***.**";//Use Your IP Address

string SftpUserName = "UserName";

string SftpPsd = "UserPass@123";

int SftpPort = 22; //Port 22 is defaulted for SFTP upload

//Local file address

string source = "location Of File ";//Upload File Address

string destination = SftpPth;// If destination address available

UploadSFTPFile(SftPHost, SftpUserName, SftpPsd, source, destination, SftpPort);

lblresponsemsg.Text = "File uploaded";

}

catch (Exception ex)

{

lblresponsemsg.Text = ex.Message.ToString();

}

private void UploadSFTPFile(string host, string username, string password, string sourcefile, string destination, int port)

{

using (SftpClient client = new SftpClient(host, port, username, password))

{

client.Connect();

client.ChangeDirectory(destination);

using (FileStream fs = new FileStream(sourcefile, FileMode.Open))

{

client.BufferSize = 4 * 1024;

client.UploadFile(fs, Path.GetFileName(sourcefile));

}

CRUD operation in ASP. Net Framework using Connection-Oriented Architecture. Work with Stored Procedure, Database table using only Data Reader.

2020-10-21T00:23:00.007+05:30

This blog contains only for students who want to practice the Dot Net Framework CRUD Operation in Connected Architecture.

What is Connection-Oriented Architecture?

Connection-Oriented Architecture in .Net Framework means when we are working with the Data Source we have to keep the connection continuously.

In this scenario, we load data from Data Source to DataReader through the Command Class.

Let's begin

This page is our insert page. Where we are taking the input of Name and Department from the user and provide them their generated Id.

For this, we have a Department table. from the Department, we are bringing all the departments to the dropdown menu.

Department Table

----------------------------

I have inserted some values before.

DId int IDENTITY(10,10) NOT NULL,

DName varchar(50) NULL,

Loaction varchar(50) NULL,

Stored Procedure for Department

------------------------------------------------

create proc usp_Department
(
@DId int=null,
@DName varchar(50)=null
)
as
begin
Select DId, DName from Department
end

Employee Table

-------------------------

Stored Procedure for Employee

------------------------------------------------

create proc usp_Employee

(

@EId int=null,

@Name varchar(50)=null,

@DId int=null,

@type char(2)=null

)

if(@type='in')

begin

insert Employee (Name,DId) values(@Name,@DId)

end

if(@type='up')

begin

update Employee set Name=@Name,DId=@DId where EId=@EId

end

if(@type='de')

begin

delete Employee where EId=@EId

end

if(@type='se')

begin

select Name,DId from Employee where EId=@EId

end

if(@type='mx')

begin

Select Max(EId) from Employee

end

if(@type='s')

begin

select EId from Employee

end

in Web.config

-----------------

</connectionStrings>

Designing of Insert page

EmployeeInsert.aspx

---------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EmployeeInsert.aspx.cs" Inherits="Example1.EmployeeInsert" %>

<!DOCTYPE html>

<style>

.divbox{

margin:10px;

}

.box{

border:groove;

padding:20px 20px 20px 60px;

align-content:center;

margin:40px 100px;

}

</style>

</head>

<body>

<h3>Employee Insert</h3>

<asp:Label ID="Label3" runat="server" Text="Employee Id"></asp:Label>

</div>

<asp:TextBox ID="txtEid" CssClass="form-control" runat="server" ReadOnly="true"></asp:TextBox>

</div>

<asp:Button ID="Button1" CssClass="btn btn-dark" runat="server" OnClick="btnReset_Click" Text="New Registration" />

</div>

<asp:Label ID="Label1" runat="server" Text="Employee Name"></asp:Label>

</div>

<asp:TextBox ID="txtEname" CssClass="form-control" runat="server"></asp:TextBox>

</div>

<asp:LinkButton ID="LinkButton1" CssClass="btn-light" PostBackUrl="~/EmployeeEdit.aspx" runat="server">Go To Edit Page</asp:LinkButton>

</div>

<asp:Label ID="Label5" runat="server" Text="Department"></asp:Label>

</div>

<asp:DropDownList ID="ddlDept" CssClass="form-control" runat="server"></asp:DropDownList>

</div>

</div>

<asp:Button ID="btnSubmit" CssClass="btn btn-success" OnClick="btnSubmit_Click" runat="server" Text="Submit" />

<asp:Button ID="btnReset" runat="server" CssClass="btn btn-light " OnClick="btnReset_Click" Text="Reset" />

</div>

</form>

</body>

</html>

EmployeeInsert.aspx.cs

-----------------------------

using System;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace DBExamples

{

public partial class EmployeeInsert : System.Web.UI.Page

{

SqlConnection con;

SqlDataReader dr;

SqlCommand cmd =new SqlCommand();

protected void Page_Load(object sender, EventArgs e)

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);

if(!IsPostBack)

{

LoadDept();

}

private void LoadDept()

{

cmd.Connection = con;

cmd.CommandText = "usp_Department";

cmd.CommandType = CommandType.StoredProcedure;

con.Open();

dr = cmd.ExecuteReader();

ddlDept.DataValueField = "DId";

ddlDept.DataTextField = "DName";

ddlDept.DataSource = dr;

ddlDept.DataBind();

ddlDept.Items.Insert(0, "--select--");

con.Close();

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

if(ddlDept.SelectedIndex>0)

{

cmd.Connection = con;

cmd.CommandText = "usp_Employee";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Name", txtEname.Text);

cmd.Parameters.AddWithValue("@DId", ddlDept.SelectedValue);

cmd.Parameters.AddWithValue("@type","in");

con.Open();

if(cmd.ExecuteNonQuery()>0)

{

SqlCommand cmd1 = new SqlCommand("usp_Employee", con);

cmd1.CommandType = CommandType.StoredProcedure;

cmd1.Parameters.AddWithValue("@type", "mx");

txtEid.Text= cmd1.ExecuteScalar().ToString();

Response.Write("<script>alert('Registration Successful')</script>");

con.Close();

}

else

{

Response.Write("<script>alert('Registration Failed')</script>");

}

else

{

Response.Write("<script>alert('Select a Department')</script>");

}

protected void btnReset_Click(object sender, EventArgs e)

{

ClaerData();

}

private void ClaerData()

{

txtEid.Text = txtEname.Text = "";

ddlDept.SelectedIndex = 0;

}

EmployeeEdit.aspx

--------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EmployeeEdit.aspx.cs" Inherits="Example1.EmployeeEdit" %>

<!DOCTYPE html>

<style>

.divbox{

margin:10px;

}

.box{

border:groove;

padding:20px 20px 20px 60px;

align-content:center;

margin:40px 100px;

}

</style>

</head>

<body>

<h3>Employee Edit</h3>

<asp:Label ID="Label3" runat="server" Text="Employee Id"></asp:Label>

</div>

<asp:DropDownList ID="ddlEid" CssClass="form-control" OnSelectedIndexChanged="ddlEid_SelectedIndexChanged" AutoPostBack="true" runat="server"></asp:DropDownList>

</div>

<asp:LinkButton ID="LinkButton1" CssClass="btn-light" PostBackUrl="~/EmployeeInsert.aspx" runat="server">New Registration</asp:LinkButton>

</div>

<asp:Label ID="Label1" runat="server" Text="Employee Name"></asp:Label>

</div>

<asp:TextBox ID="txtEname" CssClass="form-control" runat="server"></asp:TextBox>

</div>

<asp:Label ID="Label5" runat="server" Text="Department"></asp:Label>

</div>

<asp:DropDownList ID="ddlDept" CssClass="form-control" runat="server"></asp:DropDownList>

</div>

</div>

<asp:Button ID="btnUpdate" CssClass="btn btn-success" OnClick="btnUpdate_Click" runat="server" Text="Update" />

<asp:Button ID="btnDelete" runat="server" CssClass="btn btn-light" OnClick="btnDelete_Click" Text="Delete" />

</div>

</form>

</body>

</html>

EmployeeEdit.aspx.cs

----------------------------

using System;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace DBExamples

{

public partial class EmployeeEdit : System.Web.UI.Page

{

SqlConnection con;

SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);

if(!IsPostBack)

{

btnUpdate.Enabled = false;

btnDelete.Enabled = false;

loadEmp();

loadDept();

}

private void loadEmp()

{

SqlCommand cmd = new SqlCommand("usp_Employee", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@type","s");

con.Open();

dr = cmd.ExecuteReader();

ddlEid.DataValueField = "EId";

ddlEid.DataTextField = "EId";

ddlEid.DataSource = dr;

ddlEid.DataBind();

ddlEid.Items.Insert(0,"--select--");

con.Close();

}

private void loadDept()

{

SqlCommand cmd1 = new SqlCommand("usp_Department", con);

cmd1.CommandType = CommandType.StoredProcedure;

con.Open();

dr = cmd1.ExecuteReader();

ddlDept.DataValueField = "DId";

ddlDept.DataTextField = "DName";

ddlDept.DataSource = dr;

ddlDept.DataBind();

ddlDept.Items.Insert(0,"--select--");

con.Close();

}

protected void btnUpdate_Click(object sender, EventArgs e)

{

if(ddlEid.SelectedIndex>0)

{

SqlCommand cmd = new SqlCommand("usp_Employee",con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@EId", ddlEid.SelectedValue);

cmd.Parameters.AddWithValue("@Name",txtEname.Text);

cmd.Parameters.AddWithValue("@DId", ddlDept.SelectedValue);

cmd.Parameters.AddWithValue("@type", "up");

con.Open();

if (cmd.ExecuteNonQuery() > 0)

{

Response.Write("<script>alert('User Detail Updated')</script>");

}

else

{

Response.Write("<script>alert('Failed')</script>");

}

else

{

Response.Write("<script>alert('Select Employee Id')</script>");

}

con.Close();

loadEmp();

}

protected void btnDelete_Click(object sender, EventArgs e)

{

if (ddlEid.SelectedIndex > 0)

{

SqlCommand cmd = new SqlCommand("usp_Employee", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@EId", ddlEid.SelectedValue);

cmd.Parameters.AddWithValue("@type", "de");

con.Open();

if (cmd.ExecuteNonQuery() > 0)

{

Response.Write("<script>alert('User Deleted')</script>");

}

else

{

Response.Write("<script>alert('Failed')</script>");

}

else

{

Response.Write("<script>alert('Select Employee Id')</script>");

}

con.Close();

loadEmp();

txtEname.Text = "";

ddlDept.SelectedIndex = 0;

}

protected void ddlEid_SelectedIndexChanged(object sender, EventArgs e)

{

btnUpdate.Enabled = true;

btnDelete.Enabled = true;

SqlCommand cmd = new SqlCommand("usp_Employee", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@EId", ddlEid.SelectedValue);

cmd.Parameters.AddWithValue("@type", "se");

con.Open();

dr = cmd.ExecuteReader();

if (dr.Read())

{

txtEname.Text = dr["Name"].ToString();

ddlDept.SelectedValue = dr["DId"].ToString();

}

con.Close();

}

--------------- The End ---------------

Pattern Lock in ASP.NET using JQuery

2020-06-30T01:41:00.001+05:30

Demo video In the end

Instead of making a Login form, we can implement Pattern lock to our website. We can achieve this using some JQuery codings. So here is the technique of implementing Pattern lock in the ASP.NET framework project using Jquery.

In this tutorial, we have Login.aspx page, if I will draw the right pattern it will take to you Dashboard.aspx otherwise it will show you error message. It will validate the pattern from the database then it will unlock it.

So let's start.

Step 1:- (Database table)

Table Name:- "UserTable"

Column Name	Data Type
uid	int	(PK)
name	varchar(50)
password	varchar(10)

Insert data into the table:-

INSERT into UserTable (uid, name, password) VALUES (1, 'Ankit', '12369')

Step 2:-

Create a new ASP.NET Framework project.
Add two webforms Login.aspx, Dashboard.aspx.
Add three folders. Name it as img, css, js.

and paste it into the js folder.

and paste it into the css folder.

and paste it into the img folder.

Step 3:- Login.aspx and Login.aspx.cs

Write the following code in Login.aspx

-------------------------------------------------

In <head> section

</head>

In <body> section

<p id="errmessage">authentication invalid...</p>

<script>
$("#gesturepwd").GesturePassword({
backgroundColor: "transparent",
color: "#FFFFFF",
roundRadii: 50,
pointRadii: 12,
space: 60,
width: 480,
height: 480,
lineColor: "#ECF0F1",
zindex: 100
});

$("#errmessage").hide();

$("#gesturepwd").on("hasPasswd", function (e, passwd) {

debugger;

if (passwd != '') {

$.ajax({

type: 'POST',

url: 'Login.aspx/ValidLogin',

data: "{'password':'" + passwd + "'}",

contentType: "application/json; charset=utf-8",

dataType: 'json',

success: function (response) {

debugger;

var result = response.d;

if (result == true) {

$("#gesturepwd").trigger("passwdRight");

setTimeout(function () {

// alert("Pattern is correct")

}, 500);

}

else {

$("#gesturepwd").trigger("passwdWrong");

}

if (result == true) {

window.location.href = "Dashboard.aspx";

}

if (result == false) {

$("#errmessage").show();

}

console.log(lstdtl);

error: function (response) {

$("#gesturepwd").trigger("passwdWrong");

var msg = jQuery.parseJSON(response.responseText);

console.log("Message: " + msg.Message);

console.log("StackTrace: " + msg.StackTrace);

console.log("ExceptionType: " + msg.ExceptionType);

});

}

else {

$("#gesturepwd").trigger("passwdWrong");

}

});

</script>

</body>

Write the following code in Login.aspx.cs

------------------------------------------------------

namespace PatternLock
{
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
[WebMethod()]
public static dynamic ValidLogin(string password)
{
SqlConnection con = new SqlConnection("Data Source=/*your server name*/; Initial Catalog=/*Your database name*/; USER ID=/*Your server id*/; password=/*your password*/");
con.Open();
string qry = "select * from UserTable where password='"+ password +"'";
SqlCommand cmd = new SqlCommand(qry, con);
SqlDataReader sdr = cmd.ExecuteReader();

if (sdr.Read())
{
con.Close();
return true;
}
else
{
con.Close();
return false;
}
}
}
}

Step 4:- Dashboard.aspx and Dashboard.aspx.cs

Write the following code in Dashboard.aspx

---------------------------------------------------------

In <head> section

<style>

body {

color: aquamarine;

background-color: darkcyan;

}

h2{

padding:20% ;

margin-left:20%;

}

</style>

</head>

In <body> section

<body>

<div>

<h2>Welcome to My Palm Book</h2>

</div>

</form>

</body>

Write the following code in Dashboard.aspx.cs

------------------------------------------------------------

//no coding..

Write the code as following and browse your Login page to see the result.

Web API Introduction and Simple API Project using ASP.Net Framework

2020-06-27T02:44:00.001+05:30

In this tutorial, we will learn what is Web API and the step by step demonstration of a simple Web API project in ASP.NET. Along we will learn about the Postman tool also.

Web API

A Web API is an application programming interface for either a web server or a web browser.

In simple word, we can say it is a Service which is created once and can be used in any devices to access data or features. It is lightweight so it can reach to low bandwidth devices like Tablet and Mobile. The responses can be formatted as JSON, BSON, XML, etc through Web API Media Type Formatter.

Uses of Web API

· ASP.NET Web API is an ideal platform for building RESTful services.

· ASP.NET Web API is built on top of ASP.NET and supports ASP.NET request/response pipeline

· ASP.NET Web API maps HTTP verbs to method names.

· ASP.NET Web API supports different formats of response data. Built-in support for JSON, XML, BSON format.

· ASP.NET Web API can be hosted in IIS, Self-hosted, or any other web hosting server that supports .NET 4.0+.

· ASP.NET Web API framework includes new HttpClient to communicate with the Web API server. HttpClient can be used in ASP.MVC server side, Windows Form application, Console application, or other apps.

Create ASP.NET Web Application in Visual Studio

Open Visual Studio 2019 and open a new project. Select ASP.NET Web Application(.Net Framework).

Give the project name and click Create.

Select Web API in the template window. After selecting Web API, we can see on the right side in the "Add folders & code references" section MVC and WEB API are selected automatically as shown in the below figure.

So we can develop both Mvc And Api projects together.

To develop only Web API project, we have to select an Empty Template and check only the Web API option like below.

Over View of Project Files

After the project is created you can see this interface. The project architecture is same as the MVC project. We have the same Model , controller, App_Start folders etc..we don't have View folder, because we are not going for showing any GUI in API Services. Have a look on the App_Start folder.

API Configuration

Open App_Start -> WebApiConfig.cs

You can see below code on the WebApiConfig.cs file

Here the routing is defined for our API ,instead we can change it.

public static void Register(HttpConfiguration config)

{

// Web API configuration and services

// Web API routes

config.MapHttpAttributeRoutes();

config.Routes.MapHttpRoute(

name: "DefaultApi",

routeTemplate: "api/{controller}/{id}",

defaults: new { id = RouteParameter.Optional }

);

}

In the above code the routing for our API call will be like "api/{controller}/{id}"

Ex:- here is a controller HomeController, I have 2 methods method1(),method2(int id).

public class HomeController: ApiController

{

[HttpGet]

public string method1()

{

}

[HttpGet]

public string method2(int id)

{

}

for the above method1() call we have to write the API route as "api/Home"

and for the method2(int id) call we have to write the API route as "api/Home/1001"

But for the same request we can not define multiple actions, so to overcome this we can change our routing to "api/{controller}/{action}/{id}" like this.

Ex:- here is a controller HomeController, I have 2 methods method1(),method2(int id) and methods().

public class HomeController: ApiController

{

[HttpGet]

public string method1()

{

}

[HttpGet]

public string method2(int id)

{

}

[HttpGet]

public string method3()

{

}

requests for actions will be like below

method1() call :-"api/Home/method1"

method2(int id) call :-"api/Home/method1/1001"

method2(int id) call :-"api/Home/method3"

Note:- we have to configure the Register method [public static void Register(...)] in the Global.asax file.as given below. It is by default configured while creating the project.

Adding a Controller

Now, go to Controller and expand the controller folder. We need to create a new API controller, we can create that in the following way.

Select and right-click on Controllers Folder -> Add -> Controller.

Select Web API 2 Controller-Empty.

Rename control name as HomeController.

Adding a Method in Controller

Now, create a simple method in Controller, build the application, and run it finally. In web API, we use the method name as View()We can use any other method name. Let's write the below code in the HomeController.

public class HomeController : ApiController

{

[HttpGet]

publicstring View()

{

return "My first Web Api";

}

Run Web API

We have to run the Web API api/Controller/Method URL format. For example, in MVC we define URL format using “RouteConfig” class and “RegisterRoutes” static methods. The same for Web API also; we are using the “WebApiConfig” and “Register” static method.

Go to the “Global.aspx” file we can see in detail. We see it before in this tutorial.

Now Run the project: http://localhost:55410/api/home/view

Web API has returned a result in XML or JSON format. Our output will look like above.

To test the API calls we have so many tools are available like Postman, Swagger, feeder, etc. Here we will know about Postman.

Postman

Postman is a software tool. It enables people to test calls to APIs.

Installing the Postman API client

Download the Postman API Client from the Postman website (https://www.getpostman.com/product/api-client).
Double-click the downloaded installer and follow prompts.
Once the installer finishes, launch the application by clicking the Postman icon.
Once the application starts for the first time, users will be presented with a login window.

Have a Postman account? Enter your Postman username and password.
Have a Google account for university use? Click the "Sign in with Google" button and follow prompts. Do not use a personal Google account.
Avoid signing in by clicking the "Skip signing in" link at the bottom of the window.

So,After doing all pre processes let us check our API here.

copy the browser URL of our API i.e. http://localhost:55410/api/home/view

paste it in the text box as shown below. Make sure the left dropdown is GET(i.e. it is a GET method). Click Send.

Note:- Do not close the running project in the background.

You can see the result as shown below.

So, In the next post, we will see the Crud Operation with API. We will implement the action methods and all. So stay tuned.

Stored Procedure in MySQL || MySQL Stored Procedure for Select/Insert/Update

2020-06-21T20:30:00.000+05:30

In this tutorial, you will learn how to work with STORED PROCEDURE in MySQL to perform multiple actions/tasks.

CREATE TABLE IN MYSQL

---------------------------------------

Table structure for table `tbl_test`

CREATE TABLE `tbl_test` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`phone` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE PROCEDURE FOR SELECT Statement

-------------------------------------------------------------------

This query returns all data from the sample database table.

SELECT * FROM tbl_test;

The following statement creates a new stored procedure that wraps the query:

DELIMITER //
CREATE PROCEDURE USP_GetAllDATA()
BEGIN
SELECT * FROM tbl_test;
END //

DELIMITER ;

Executing the stored procedure

---------------------------------------

To execute a stored procedure, you use the CALL statement:
syntax:- CALL ProcedureName(Arguments);

This example illustrates how to call the USP_GetAllDATA() stored procedure:

CALL USP_GetAllDATA();

This procedure returns all data from the sample database table

CREATE PROCEDURE FOR INSERT Statement

-------------------------------------------------------------------

This query using for insert data from the sample database table.

INSERT INTO tbl_test(name, phone)
VALUES(P_NAME,P_PHONE);

The following statement creates a new stored procedure that wraps the query:

DELIMITER //
CREATE PROCEDURE USP_AddDATA (
IN `P_NAME` VARCHAR(528) CHARSET utf8,
IN `P_PHONE` VARCHAR(12) CHARSET utf8)
BEGIN
INSERT INTO tbl_test(name, phone)
VALUES(P_NAME,P_PHONE);
END //
DELIMITER;

Executing the stored procedure

---------------------------------------

This example illustrates how to call the USP_AddDATA() stored procedure:

CALL USP_AddDATA('Ankit','0000000000');

Here we are inserting two parameters.

CREATE PROCEDURE FOR SELECT/INSERT/UPDATE Statement

--------------------------------------------------------------------------------------------

It means one procedure can perform multiple taxes.

DELIMITER $$
--

-- Procedures
--
CREATE PROCEDURE `USP_MINIMASTER`
(
IN `P_ACTION` VARCHAR(3),
IN `P_ID` INT,
IN `P_NAME` VARCHAR(528) CHARSET utf8,
IN `P_PHONE` VARCHAR(12) CHARSET utf8)
BEGIN
IF(P_ACTION='S') THEN
SELECT * FROM tbl_test;
END IF;
IF(P_ACTION='A') THEN
START TRANSACTION;
INSERT INTO tbl_test(name, phone)
VALUES(P_NAME,P_PHONE);
COMMIT;
END IF;
IF(P_ACTION='U')THEN
UPDATE tbl_test SET name=P_NAME WHERE id = P_ID;
END IF;
END$$
DELIMITER ;

Executing the stored procedure

---------------------------------------

In this example we will see how to call the USP_MINIMASTER stored procedure:

CALL USP_ MINIMASTER ('A','','Ankit','0000000000'); --INSERT

CALL USP_ MINIMASTER ('S','','',''); --SELECT

CALL USP_ MINIMASTER ('U','1','',); --UPDATE

Dot Net Full Stack Developer Course-c sharp, c, javascript, ajax, bootstrap, css, sqlserver, mysql

Razor vs Blazor in .NET: What's the Difference?

What is Razor?

Example Razor Code (in a .cshtml file):

Key Characteristics of Razor:

What is Blazor?

Example Blazor Code (in a .razor file):

Key Characteristics of Blazor:

Razor vs Blazor: Feature Comparison

When Should You Use Razor or Blazor?

Final thoughts

Understanding Polymorphism in Object-Oriented Programming with Example

What is polymorphism?

Advantages of Polymorphism:

Real-Time Example of Polymorphism

Coding Example in C#

Compile-Time Polymorphism (Method Overloading)

Run-Time Polymorphism

How It Works

Why Use Polymorphism?

Conclusion:

Login Form and Registration form using Bootstrap design for Responsive and more UI friendly

Login page

Registration page

Design a Registration Form using only HTML

Design a Login Form using only HTML

Reverse the words of a sentence in C# without using predefined Reverse Method

Program

Explanation

Find the Sum of values of an Array those are in Even position in C#

Including the 0th index

Excluding the 0th index

Capgemini Asp.Net Core Interview Questions

Asp .NET Core Interview Question and Answers

Bitwise Operators in C Language

Truth Table of & | and ^

& Bitwise AND Operator

| Bitwise OR Operator

^ Bitwise XOR Operator

~ Bitwise NOT Operator

<< Bitwise Left Shift Operator

>> Bitwise Right Shift Operator

Related Links

Thank you Happy Coding💻☺

Logical Operators in C Language

&& AND Operator

|| OR Operator

! NOT Operator

Related Links

Thank you Happy Coding

Relational/Comparision Operations in C Program

== Equal to Operator

!= Not Equal to Operator

> Greater Than Operator

< Less Than Operator

>= Greater Than Equal to Operator

<= Less Than Equal to Operator

Related Links

Arithmetic Operations in C Program

Operators in C Language

Operators

Operators

Arithmetic Operator

Operator

Description

Relational/Comparision Operator

Operator

Description

Logical Operator

Operator

Description

Bitwise Operator

Operator

Description

Assignment Operator

Operator

Description

Ternary Operator

Operator

Description

Example Razor Code (in a `.cshtml` file):

Example Blazor Code (in a `.razor` file):