In this article we will see how we can export data to an Excel file in a web application where the Interop library might no be available. We saw a similar approach in a previous article but that approach generates a file that is not a proper Excel file, rather it was a text file […]
Create HTML table from Chartjs data
In this article we will see how we can convert a data source compatible with Chartjs to an HTML table.
Export GridView or Repeater to Excel
In this article we will see how we can use the GridView control for this task. This approach still limits us to use a GridView, so after that we will see how we can make a Repeater (or any other control) that renders an HTML table to an excel file.
Export data to excel for non-latin characters
A common feature in applications is to export data in excel. With .NET it is pretty simple with the use of the Microsoft Excel Object Library. Sadly, in asp.net this is not available in medium trust. The alternative in a web application is to render the data in a HTML table and send it to […]
Backup the data from your Sql Server
An often requirement in a CMS is the user to be able to backup the database of its CMS installation. If you are using MS Sql Server there is a simple command that creates a .bak file of your database. BACKUP DATABASE [mydb] TO DISK = N'<bak_file_path>’ Restoring the database is also simple with the […]