C#: Getting started with Databases

  private void button1_Click(object sender, EventArgs e)
  {
   string connetionString;
   SqlConnection cnn;
   connetionString = @"Data Source=WIN-50GP30FGO75;Initial Catalog=Demodb;User ID=sa;Password=demol23";
   cnn = new SqlConnection(connetionString);
   cnn.Open();
   MessageBox.Show("Connection Open  !");
   cnn.Close();
  }

Select allOpen in new window

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SQLite;
using System.IO;

namespace sqlite_test
{
    class Program
    {
        private static SQLiteConnection m_dbConnection;

        static void Main(string[] args)
        {
            if (File.Exists("D:\\Vb\\Test\\sqlite-test\\HelloWorld.sqlite"))
            {
                m_dbConnection = new SQLiteConnection("Data Source=D:\\Vb\\Test\\sqlite-test\\HelloWorld.sqlite;Version=3;");
                m_dbConnection.Open();



                string sql = @"SELECT d.FirstName AS dFirstName, d.LastName AS dLastName, a.DoctorID AS Did, p.PatientID AS PID, p.FirstName, p.LastName, a.aDate, a.aTime 
                            FROM
                            Doctors d, Patients p, Appointments a
                            WHERE
                             a.DoctorID = d.DoctorID AND
                            a.PatientID = p.PatientID AND
                            dFirstName = 'NANCY'";

                SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
                SQLiteDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine("Doctor = {0}: {1}: ", reader[0].ToString(), reader[1].ToString());

                }

            }
            else
            {
                Console.WriteLine("Wot no DB?");       
            }
            Console.ReadLine();


        }
    }
}

Select allOpen in new window