Pastable version of FlashCard Program Using SQLite

<pre class='prettyprint' language='cs'>//
// frmMain
//
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Owf.Controls; // Custom header panel from openwinforms.com
using System.Data.SQLite;

namespace FlashCards
{
    public partial class frmMain : Form
    {
        // Current directory - Used to find the database.
        private string _currentDirectory = Environment.CurrentDirectory;
        // Place to store the currentDatabase info once frmMain is initialized.
        private string _currentDatabase;
        // Place to store the connectionString info.
        private string _connectionString;

private SQLiteConnection _sqLiteConnection;
        private SQLiteCommand _sqLiteCommand;
        private SQLiteDataAdapter _sqLiteDataAdapter;
        private DataSet _dataSet = new DataSet();
        private DataTable _dataTable = new DataTable();

private Image _answerOff;
        private Image _answerOn;

private bool _answerEnabled = false;
        private bool _btnPrevEnabled = false;
        private bool _btnNextEnabled = false;

private int _answerIndexStart = 0;
        private int _answerIndexEnd = 0;
        private int _answerIndexCurrent;

public int AnswerIndexEnd
        {
            get
            {
                return _answerIndexEnd;
            }
        }

public frmMain()
        {
            InitializeComponent();
            _answerOff = new Bitmap(typeof(frmMain), &quot;off.png&quot;);
            _answerOn = new Bitmap(typeof(frmMain), &quot;on.png&quot;);
            _currentDatabase = _currentDirectory + @&quot;\FlashCards.db&quot;;
            _connectionString = @&quot;Data Source=&quot; + _currentDatabase + &quot;;New=True;UTF8Encoding=True;Version=3&quot;;
            _answerIndexCurrent = _answerIndexStart;
            GetRecordCount();
            LoadData();
            SetRtfText();
            StatusLabelUpdate();
            btnNextGetStatus();
            
        }

private void newToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmNewSet _frmNewSet = new frmNewSet(this);
            _frmNewSet.Show();
        }

public void LoadData()
        {
            string sqlCommandText = &quot;SELECT * FROM  Cards&quot;;

SetConnection();
            _sqLiteConnection.Open();
            _sqLiteDataAdapter = new SQLiteDataAdapter(sqlCommandText, _sqLiteConnection);
            _dataSet.Reset();
            _sqLiteDataAdapter.Fill(_dataSet);
            _dataTable.Reset();
            _dataTable = _dataSet.Tables[0];
            _sqLiteConnection.Close();
        }

private void SetConnection()
        {
            _sqLiteConnection = new SQLiteConnection(_connectionString);
        }

public void ExecuteQuery(string qryText)
        {
            SetConnection();
            _sqLiteConnection.Open();

_sqLiteCommand = _sqLiteConnection.CreateCommand();
            _sqLiteCommand.CommandText = qryText;

_sqLiteCommand.ExecuteNonQuery();
            _sqLiteConnection.Close();
        }

private void AnswerButtonChangeImage()
        {
            switch (_answerEnabled)
            {
                case true:
                    _answerEnabled = false;
                    this.btnAnswerShow.Image = _answerOff;
                    this.rtfBoxAnswer.Visible = false;
                    break;

case false:
                    _answerEnabled = true;
                    this.btnAnswerShow.Image = _answerOn;
                    this.rtfBoxAnswer.Visible = true;
                    break;

default:
                    _answerEnabled = false;
                    this.btnAnswerShow.Image = _answerOff;
                    this.rtfBoxAnswer.Visible = false;
                    break;
            }
        }

private void btnAnswerShow_Click(object sender, EventArgs e)
        {
            AnswerButtonChangeImage();
        }

public void GetRecordCount()
        {
            string sqlCommandText = &quot;SELECT COUNT(*) AS Total FROM Cards;&quot;;

SetConnection();
            _sqLiteConnection.Open();
            _sqLiteDataAdapter = new SQLiteDataAdapter(sqlCommandText, _sqLiteConnection);
            _dataSet.Reset();
            _dataTable.Reset();
            _sqLiteDataAdapter.Fill(_dataSet);
            _dataTable = _dataSet.Tables[0];
            _sqLiteConnection.Close();
            _answerIndexEnd = Convert.ToInt32(_dataTable.Rows[_answerIndexStart][&quot;Total&quot;]);
        }

private void SetRtfText()
        {
            if ((_answerIndexCurrent &lt; _answerIndexEnd) &amp;&amp; (_answerIndexCurrent &gt;= _answerIndexStart))
            {
                this.rtfBoxQuestion.Text = _dataTable.Rows[_answerIndexCurrent][&quot;card_question&quot;].ToString();
                this.rtfBoxAnswer.Text = _dataTable.Rows[_answerIndexCurrent][&quot;card_answer&quot;].ToString();
            }
        }

private void btnNextGetStatus()
        {            
            switch (_answerIndexCurrent &lt; (_answerIndexEnd - 1))
            {
                case true:
                    this.btnNext.Enabled = true;
                    break;

case false:
                    this.btnNext.Enabled = false;
                    break;

default:
                    this.btnNext.Enabled = false;
                    break;
            }
        }

private void btnPrevGetStatus()
        {
            switch (_answerIndexCurrent &gt; _answerIndexStart)
            {
                case true:
                    this.btnPrev.Enabled = true;
                    break;

case false:
                    this.btnPrev.Enabled = false;
                    break;

default:
                    this.btnPrev.Enabled = false;
                    break;
            }
        }

private void btnPrev_Click(object sender, EventArgs e)
        {
            _answerIndexCurrent = _answerIndexCurrent - 1;
            _answerEnabled = true;
            AnswerButtonChangeImage();
            SetRtfText();
            btnPrevGetStatus();
            btnNextGetStatus();
            StatusLabelUpdate();
        }

private void btnNext_Click(object sender, EventArgs e)
        {
            _answerIndexCurrent = _answerIndexCurrent + 1;
            _answerEnabled = true;
            AnswerButtonChangeImage();
            SetRtfText();
            btnNextGetStatus();
            btnPrevGetStatus();
            StatusLabelUpdate();
        }

public void StatusLabelUpdate()
        {
            this.tStripLabel1.Text = @&quot;Record # &quot; + (_answerIndexCurrent + 1).ToString();
        }
    }
}

//
// frmAddNew
//
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;

namespace FlashCards
{
    public partial class frmNewSet : Form
    {
        private frmMain _frmMain;
        private int _answerIndexNext;
        private RichTextBox _rtfCurrent;

public frmNewSet(frmMain mainFrm)
        {
            InitializeComponent();
            _frmMain = mainFrm;
            _rtfCurrent = new RichTextBox();
            _answerIndexNext = _frmMain.AnswerIndexEnd + 1;
        }

private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

private void btnSave_Click(object sender, EventArgs e)
        {
            Add();

rtfNewQuestion.Text = string.Empty;
            rtfNewAnswer.Text = string.Empty;

_frmMain.LoadData();
            this.Close();
        }

private void Add()
        {
            string txtSQLQuery = &quot;INSERT INTO Cards VALUES (&quot; + _answerIndexNext + &quot;,'&quot; + rtfNewQuestion.Text + &quot;','&quot; + rtfNewAnswer.Text + &quot;')&quot;;
            _frmMain.ExecuteQuery(txtSQLQuery);
        }

private void rtfNewQuestion_Enter(object sender, EventArgs e)
        {
            _rtfCurrent = this.rtfNewQuestion;
        }

private void rtfNewAnswer_Enter(object sender, EventArgs e)
        {
            _rtfCurrent = this.rtfNewAnswer;
        }
        
        //
        // This method sends special keys like Ã¡Ã©ÃÃ³ÃºÃ±Â¿ to the richtextbox  when entering new card data
        //
        private void btnSpaKey_Click(object sender, EventArgs e)
        {
            string _btnSpaKeyPressed = (sender as Button).Text;
            _rtfCurrent.Focus();
            SendKeys.Send(_btnSpaKeyPressed);

}
    }
}</pre>
<a href="http://www.refactormycode.com/codes/1084-flashcard-program-using-sqlite" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of FlashCard Program Using SQLite