Tutorials on ASP.NET Core, Blazor, jQuery, JavaScript, Entity Framework, Identity, WordPress, SQL, HTML & more


How to Script Database With All Data From Microsoft SQL Server Management Studio

Last Updated: June 8, 2021

Script Database

Sometimes in SQL Server when attempting to restore a database on server A (whose backup is taken on server B) fails due to servers A and B using different versions of SQL server. In such a situation restoring database is done by generating database scripts of both schema and data.

(more…)

Custom Paging in ASP.NET without using controls like GridView and Repeater

Last Updated: June 6, 2021

Custom Paging in ASP.NET

In this Tutorial I will show how to fetch data from database using Custom Paging and show it inside an HTML table. Yes I will "not" use GridView and Repeater to show the data, instead my HTML table will do this work.

The HTML table will itself look like a Grid and will also have pagination links. Here I will bind data from Northwind Products Table.

(more…)

How to easily implement ASP.NET GridView Custom Paging

Last Updated: June 6, 2021

GridView Custom Paging

ASP.NET GridView now supports custom paging too. By using Custom Paging your GridView will never slow down as it only fetches the records needed for the current page only. The GridView Custom Paging supports the developers to make their application much faster and light weight too.

(more…)

How to implement Custom Paging with SQL Server using row_number() method

Last Updated: June 8, 2021

Custom Paging SQL Server

Huge data with paging always causes big headaches to developers. It not only slows down the performance of the application but also takes up lot of resources of the server.

But fortunately you can use the technique of custom paging in your SQL server stored procedure that make your application faster and better.

(more…)

Tutorial – Populate ASP.NET MVC Dropdownlist with ViewBag and Model values

Last Updated: June 7, 2021

asp.net mvc dropdownlist

Sometimes it our ASP.NET MVC application it becomes necessary to populate dropdown with dynamic values such as from the database. So here in the controller you can create a list object of type SelectListItem, fill it with values and then send this object to the View.

(more…)

Creating jQuery Expand Collapse Panels In HTML with “minimum” codes

Last Updated: June 4, 2021

Creating Expandable & Collapsible Panels in jQuery

The jQuery Expand Collapse Panels are used for breaking content rich pages into separate sections. So they allow visitors to navigate easily to a particular section based on his choice. There is an arrow, which on clicking, reveals the content of the section. Developers always have the need to include these Expand Collapse Panels in their websites, and therefore they will find this tutorial useful.

(more…)

Tutorial on doing Backup and Restore of WordPress Website with Images

Last Updated: June 9, 2021

Backup and Restore

A website owner worst nightmare is when his website fails to load,due to been hacked or just fallen into pieces. Therefore it becomes very important for them to know how to take backup of their website, and restore it when there is a need to do so. In this tutorial I will explain how to do Backup and Restore of your WordPress website.

(more…)

Check Uncheck all checkbox Of ASP.NET Checkboxlist using jQuery

Last Updated: June 6, 2021

jquery check checkbox

The checkbox can be easily be checked or unchecked using jQuery with just a line of code. Suppose there is a checkbox in the web page, and you have to check or uncheck it using jQuery. Here you have to perform the given steps.

(more…)

How to create Responsive Web Design using CSS Media Queries

Last Updated: June 8, 2021

css media queries

With the increase in the number of people surfing internet with smartphones, it becomes necessary that your website works well in smartphones too. In technical term you need a responsive website. A Responsive Web Design will increase user engagement from all sorts of devices and lowers the bounce rate. It also brings SEO benefits to your website.

(more…)

jQuery Modal PopUp Window with Animation Effects – with Codes

Last Updated: June 4, 2021

jquery modal popup

Sometimes we need to show visitors some important message when they visit our website. It can be done with jQuery Modal (also known commonly as 'Popup'). Here jQuery is used to open a small message box on the center of the screen. In this message box we can show any message like welcome text, coupons, sale discounts or anything else.

(more…)