Category: Development

C# – Load Json data in your .Net application

Posted on by SQL Master

Javascript Object Notation (JSON) is a standard text-based format to structure data based on Javascript object syntax. We can see this format being used to transfer data in web applications. { “firstName”: “Robert”, “lastName”: “Patrick”, “age”: 37, “address”: { “streetAddress”: “21, Glory Street”, “city”: “Boston”, “state”: “MT”, “postalCode”: “100-8888” }, “phoneNumbers”: [ { “type”: “home”, … Continue reading “C# – Load Json data in your .Net application”

Python – Do you know Google Colaboratory ?

Posted on by SQL Master

You don´t ?! but you should! Colaboratory, or “Colab” for short, is a product from Google Research. Colab allows anybody to write and execute arbitrary python code through the browser, and is especially well suited to machine learning, data analysis and education. More technically, Colab is a hosted Jupyter notebook service that requires no setup … Continue reading “Python – Do you know Google Colaboratory ?”

C# – Create a website to upload an excel file and process it on a Python program.

Posted on by SQL Master

In this exercise we will create a simple Web Application just to upload an excel file and send it to a python program. We will implement this solution to perform the steps described in the flowchart below. 1 – The user will upload a file to application 2 – The file will be sent to … Continue reading “C# – Create a website to upload an excel file and process it on a Python program.”

Python – Inserting data from Excel file into Database table

Posted on by SQL Master

On this post we will do an exercise in which we will read data from an Excel file and insert this data into a SQL Server database table. Consider the situation in which you want open an excel file to perform some mathematical operations and after that insert the results into a database table. Note … Continue reading “Python – Inserting data from Excel file into Database table”

C# – Create Your Own Report

Posted on by SQL Master

Sometimes you have a lot of things to do, but you don´t have the means for that, so you will have to create your own means. We will apply this “philosophy” to present the data you have in your database, but you don´t have access to any reporting tool. In this case, we will create … Continue reading “C# – Create Your Own Report”

Python – Querying data from SQL Server

Posted on by SQL Master

In this post we will work on a database connection using python. It´s very simple, let´s see how it works! Obviously you need the python installed on your system. For this exercise I am using verson 3.9.2. On the database side, we are using a table from Microsoft SQL Server with sales information. Although there … Continue reading “Python – Querying data from SQL Server”