CRUDDummyMSSQLServerConsole3a

using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CRUDDummyMSSQLServerConsole3a
{
    class Program
    {
        static OleDbConnection aConnection;

        static void Main(string[] args)
        {
            /*
            aConnection =
                new OleDbConnection("Provider=SQLNCLI11;Data Source=FMI-431-2\\SQLEXPRESS;Password=sa;User ID=sa;Initial Catalog=Users");

            Add();

            OleDbCommand aCommand = new OleDbCommand("SELECT * from users", aConnection);
            try
            {
                aConnection.Open();

                OleDbDataReader aReader = aCommand.ExecuteReader();
                Console.WriteLine("This is the returned data from emp_test table");
                while (aReader.Read())
                {
                    // Console.WriteLine(aReader.GetInt32(0).ToString());
                    // Console.WriteLine(aReader.GetString(1));
                    Console.WriteLine("{0} \t {1}", aReader.GetInt32(0).ToString(), aReader.GetString(1));
                }

                aReader.Close();
                aConnection.Close();
            }
            catch (OleDbException e)
            {
                Console.WriteLine("Error: {0}", e.Errors[0].Message);
                aConnection.Close();
            }
            */
            // System.Data.SqlClient
            Console.WriteLine("hello");
            string connectionString = "Data Source=FMI-431-2\\SQLEXPRESS;Password=sa;User ID=sa;Initial Catalog=Users";
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            Console.WriteLine("done");

        }

        public static void Add()
        {
            try
            {
                aConnection.Open();
                OleDbCommand aCommand = new OleDbCommand("INSERT INTO Users (id, username, password, email) VALUES (2, 'rewr','sdsa','[email protected]')", aConnection);
                // !!! SQL Injections
                aCommand.ExecuteNonQuery();
                aConnection.Close();
            }
            catch (OleDbException e)
            {
                Console.WriteLine("Error: {0}", e.Errors[0].Message);
                aConnection.Close();
            }
        }
    }
}