public static void getWords()
{
#region Npgsql
NpgsqlConnection conn;
conn = new NpgsqlConnection("Server=" + Settings.DBSrvIP + ";Port=" + Settings.DBSrvPort + ";User Id=" +
Settings.DBconnectID + ";Password="******";Database=endoDB;" + Settings.sslSetting);
try
{
conn.Open();
}
catch (NpgsqlException)
{
MessageBox.Show(Properties.Resources.CouldntOpenConn, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
conn.Close();
}
catch (System.IO.IOException)
{
MessageBox.Show(Properties.Resources.ConnClosed, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
conn.Close();
}
#endregion
string sql = "SELECT no, words1, words2, words3, operator, word_order FROM words ORDER BY word_order";
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
da.Fill(localDB, "words");
if (localDB.Tables["words"].Rows.Count == 0)
{ MessageBox.Show("[words]" + Properties.Resources.NoRecord, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
conn.Close();
}