How to use SQL Stored Procedures in .NET MVC Application

A stored procedure is a group of Transact-SQL statements compiled into a single function. If you are using .NET MVC Application from your previous projects this will be quite easy for you. Here is a sample project that will show you how to execute database queries using SQL Stored Procedure. Related Blog Article: Creating a … Read more How to use SQL Stored Procedures in .NET MVC Application

Display line numbers in SQL Server Editor

When you are editing in SQL Server Management Studio Line Numbers would be very useful specially if you are working on large module. To enable line numbers in SQL Query Editor, follow below steps: Step1: Go to Tools > Options Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General Step … Read more Display line numbers in SQL Server Editor

PYROCMS – CheatSheet

I came across with PyroCMS project and I find it really hard in searching basic composer command. So I decided to compile and create a PyroCMS cheat sheet. This is not a complete guide but hopefully, you can make it as your reference. Pyro – Laravel Development Platform Upgrading Clear composer cache Migration Seeding Create … Read more PYROCMS – CheatSheet

Installing a private package with composer

Most of the PHP framework now a day uses composer.json to install packages from Git Repository. In this article, I am going to show you an overview of adding PHP packages from your private repository to a composer.json file. 1. Configure Composer Add this line into your composer.json to point to your private repository. “repositories”: … Read more Installing a private package with composer

How to Install Free SSL on a Shared Hosting

In this tutorial, I am going to show you how to generate free SSL certificate and install it in your shared hosting. I am using Hostinger for my hosting and we are going to use SSL For Free. 1. On SSL For Free website enter your website url and press on create free ssl certificate. … Read more How to Install Free SSL on a Shared Hosting

GET and POST Request using HttpClient(C#)

GET and POST Request using HttpClient – Requesting data is one of the most common things in client projects. That include GET request to get specific data from server and post request to insert data into the server. There are two ways to implement this request it can be done using WebClient or HttpClient. But … Read more GET and POST Request using HttpClient(C#)

Apache Installation on Windows(Apache 2.4, PHP7)

For Web Developers, one of the requirements for testing web application is having a web server. Apache is one the popular Web Server used for most Web Server. The Apache HTTP server is an open-source Web server application developed by the Apache Software Foundation. The server software is freely distributed, and the open source license means … Read more Apache Installation on Windows(Apache 2.4, PHP7)

Create Offline Installer for Visual Studio

The latest version of Visual Studio removed the availability to download an offline installer but instead, they offer to download a layout of the installer in case you have unreliable network environments or no internet at all. Basically, what this method does, is to create a copy of the installer itself having the option of … Read more Create Offline Installer for Visual Studio

Fix: An unexpected error occurred in the .NET Framework Data Provider for MySQL

If you are here I’m expecting that you encountered the same problem as mine. I was transferring a DataSet file to another solution in Visual Studio 2013 and I got this error “An unexpected error occurred in the .Net Framework Data Provider for MySQL”. I don’t really know what was causing the problem. So I did … Read more Fix: An unexpected error occurred in the .NET Framework Data Provider for MySQL