YogiHosting - Tutorials on jQuery, JavaScript, Asp.Net, Entity Framework, WordPress, SEO, HTML & more


Complete Guide: Union all vs Union operators in SQL Server

Last Updated: October 6, 2019

union all vs union

SQL Server has 2 operators called Union All and Union that combine the result-set of two or more SELECT statements. The difference between Union All and Union operators is that Union All will ‘not remove the duplicate rows’ from the combined result-set, on the other hand Union operator will ‘remove the duplicate rows’ from the combined result-set. (more…)

How to implement Certificate Authentication in ASP.NET Core

Last Updated: September 29, 2019

certificate authentication

Certificate-based Authentication is the use of a Digital Certificate to identify a client request before granting it the access to a resource, network, application, etc. Certificate Authentication provides added security to web applications. You can easily implement it in ASP.NET Core 3.0. Let us understand how to do it.

(more…)

How to manually Install Let’s Encrypt free SSL Certificate on any hosting

Last Updated: September 28, 2019

install let's encrypt ssl

You can install free SSL on both cPanel & Plesk control panels.

This method works on every hosting like GoDaddy, HostGator, Linux, Windows, etc.

The best part?

You will get the SSL Certificate from Let’s Encrypt free of charge at the very same instance.

(more…)

jQuery removeData() method – Used to remove attached data to elements

Last Updated: September 14, 2019

jquery removedata

The jQuery removeData method removes the data previously attached to elements. The data is attached by jQuery Data method. (more…)

Serverspace: Full review and why you should choose it

Last Updated: September 11, 2019

serverspace

Serverspace offers high-quality VPS/VDS services at affordable prices. Our cloud servers are easy to use via your personal account. We offer 24/7 support. Our staff is highly experienced in virtualized systems and aim to deliver the best possible performance for a VPS service. We strive to offer VPS services at the best possible prices, without cutting down on the quality. (more…)

SqlBulkCopy class of ADO.NET

Last Updated: September 14, 2019

sqlbulkcopy ado net

In cases where you need to inserts lots of records into the database, eg 1 million records, then ADO.NET has a class called SqlBulkCopy which does this work very quickly. (more…)

How to use Try Catch Block to Catch Exceptions

Last Updated: August 17, 2019

try catch block ado.net

When performing an ADO.NET operation you can sometimes get some exception like: 1. Database connection error – due to wrong connection string. 2. Operation timeout error – due to some network error. (more…)

Delete Records using ADO.NET in ASP.NET Core Application

Last Updated: July 30, 2019

delete records ado.net aspnet-core

Previously I taught how to Update Records using ADO.NET in ASP.NET Core Application. Now it’s time to make the final functionality which is the Delete Record feature. Like the update feature, in the delete feature to - there will be a new added column called Delete in the HTML table of the Index View. (more…)

Update Records using ADO.NET in ASP.NET Core Application

Last Updated: July 30, 2019

update records ado.net aspnet core

I should also have the Update Inventory feature in my project. With this feature I will have the power to update any previously created Inventory records. Like, I can update the Name, Price and Quantity of a record that I want. (more…)

Read Records using ADO.NET in ASP.NET Core Application

Last Updated: July 26, 2019

read records ado.net

I will now create Read operation in ADO.NET to display all inventory records in the View. I will use SqlDataReader object for implementing this operation. (more…)

Ads - Alex does SEO Bidvertiser2004765