Programming

SQLite in C#? [Part 2]

SQLite in C#? [Part 2]

Building off the previous tutorial  SQLite in C# [Part 1] we are going to get a little more in detail with SQLite and populate our database with some information that we can pull back out later.

Lets start off with inserting information into our database.  We will do this in a similar fashion as we did creating our database table.  By creating a query string, passing it to a SQLiteCommand, and then executing the command.

Continue reading →

Posted by DCCoder in Programming, Tutorials, 0 comments
SQLite in C#? [Part 1]

SQLite in C#? [Part 1]

I can’t tell you how many times I am working on an application that I want to store data in an organized fashion but I don’t want the dependency of an external server.  Maybe I want to be able to use the application offline?  Or maybe the device I am running it on doesn’t have the ability to hold a database server.

Enter the realm of SQLite.  I have used it extensively in the past with simple Python and PHP applications, but now I figured I’d give a good overview of using it with C# and .NET.

Continue reading →

Posted by DCCoder in Programming, Tutorials, 0 comments
C# 7.1 Update

C# 7.1 Update

Last month Microsoft released Visual Studio 2017.3 and with it C#’s latest minor upgrade C# 7.1!  C#’s latest update includes four new (very useful) features that I am honestly very excited about.

  • async Main method
  • default literal expressions
  • inferred tuple names

Below I’ll go into some detail on each of the new features and show some examples of each, along with how to update your current project to the new C#7.1 update.

Continue reading →

Posted by DCCoder in Programming, 0 comments

Storing Sessions in a database

Most common applications and “home-brew” sites use sessions for storing temporary data as well as authentication. However,
sometimes a developer may want the session to span over multiple domains and or servers, and some may just be very security
conscience. It is common knowledge that session data is stored in a text file on the webserver, however if you are using
a shared server (as most cannot afford dedicated hosting or VPS) then any user on that server may see your session files.
To prevent this, and allow your user’s sessions to span over multiple domains the answer is easy: store the session data in a
MySQL database! Most of you may not be sure how to do this, or may have even been unaway that this is possible, however it is
very easy. When storing sessions in a database PHP makes the work easy for us with the use of a function called
session_set_save_handler(), this function can control the way that sessions are stored, retrieved, destroyed, etc. Continue reading →

Posted by DCCoder in Posts from old site, Security, Tutorials, 0 comments

Uploading Files

PHP as you all know is a very powerful and yet fairly loose language, however one of it’s very usefully abilities is the ability to upload files. PHP can upload literally any type of file you allow it to. However this can also open up many holes for many exploits, which is why we’ll also cover some basic security along with uploading the files. Continue reading →

Posted by DCCoder in Posts from old site, Tutorials, 0 comments