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…)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…)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…)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…)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…)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…)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…)The checkbox can be easily be checked or unchecked using jQuery with just a single line of code. If your webpage contains a checkbox element that you want to check or uncheck dynamically using jQuery, follow the steps outlined below..
(more…)More and more people now browse the internet on their smartphones, so it is essential that your website works well on small screens too. The technical term for this is Responsive Web Design: a site whose layout adapts to the size of the device it is viewed on. A responsive website improves user engagement across all kinds of devices and lowers the bounce rate. It also brings SEO benefits, since search engines like Google favor mobile-friendly sites.
(more…)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…)