Database creation Learn programming C#



Lesson:

Access To Relational Databases


Exercise:

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.


Code:

using System;
using System.Data.SQLite;
using System.IO;
public 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);
        }
    }
}



Juan A. Ripoll - Systems Tutorials and Programming Courses ©  All rights reserved.  Legal Conditions.