10.01 - Database creation

Objetive

Create a program to ask the user for data about books (title, author, genre and summary) and store them in a SQLite database.

Solution

using System;
using System.Data.SQLite;
using System.IO;


class DatabaseCreation
{
    static void Main(string[] args)
    {
        SQLiteConnection conexion;
        SQLiteCommand cmd;

        try
        {
            conexion = new SQLiteConnection
                ("Data Source=ejemplo01.sqlite;Version=3;New=True;Compress=True;");
            conexion.Open();

            if (!File.Exists("ejemplo01.sqlite"))
            {
                string creacion = "create table books ("
                + " title varchar(50),autor varchar(50),genre varchar(50), summary varchar(50));";
                cmd = new SQLiteCommand(creacion, conexion);
                cmd.ExecuteNonQuery();
            }

            string line;
            string title = "",
                   autor = "",
                   genre = "",
                   summary = "";
            do
            {
                Console.Write("Title: ");
                line = Console.ReadLine();
                if (line != null)
                    title = line;

                Console.Write("Autor: ");
                line = Console.ReadLine();
                if (line != null)
                    autor = line;

                Console.Write("Genre: ");
                line = Console.ReadLine();
                if (line != null)
                    genre = line;

                Console.Write("Summary: ");
                line = Console.ReadLine();
                if (line != null)
                    summary = line;

                string insercion = "insert into books values ('" + title +
                    "', '" + autor + "','" + genre + "', '" + summary + "')";

                cmd = new SQLiteCommand(insercion, conexion);
                cmd.ExecuteNonQuery();

                Console.WriteLine("Insert OK!");
            }
            while (line != null);
            conexion.Close();
        }
        catch (Exception e)
        {
            Console.WriteLine("Error" + e.Message);
        }
    }
}

Popular Posts