private void button1_Click(object sender, EventArgs e) //save
{
System.Data.SqlServerCe.SqlCeConnection con = new System.Data.SqlServerCe.SqlCeConnection();
System.Data.SqlServerCe.SqlCeDataAdapter daHangmanDB;
DataRow drow;
DataSet dsSavedGames = new DataSet();
DataSet dsSavedGame_Words = new DataSet();
con.ConnectionString = "Data Source=HangmanDB.sdf";
con.Open();
daHangmanDB = new System.Data.SqlServerCe.SqlCeDataAdapter("SELECT * From SavedGames", con);
daHangmanDB.Fill(dsSavedGames, "SavedGames");
con.Close();
if (dsSavedGames.Tables["SavedGames"].Rows.Count > 0)
{
drow = dsSavedGames.Tables["SavedGames"].Rows[dsSavedGames.Tables["SavedGames"].Rows.Count - 1];
latestID = System.Convert.ToInt32(drow[0]) + 1;
}
else
{
latestID = 0;
}
drow = dsSavedGames.Tables["SavedGames"].NewRow();
drow[1] = textBox1.Text;
drow[2] = wins;
drow[3] = losses;
drow[4] = DateTime.Now;
dsSavedGames.Tables["SavedGames"].Rows.Add(drow);
con.Open();
System.Data.SqlServerCe.SqlCeCommandBuilder cb;
cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(daHangmanDB);
cb.DataAdapter.Update(dsSavedGames.Tables["SavedGames"]);
con.Close();
/*---------------------------------------------------------------------*/
con.Open();
daHangmanDB = new System.Data.SqlServerCe.SqlCeDataAdapter("SELECT * From SavedGame_Words", con);
daHangmanDB.Fill(dsSavedGame_Words, "SavedGame_Words");
con.Close();
foreach (int id in wordsplayedimported)
{
drow = dsSavedGame_Words.Tables["SavedGame_Words"].NewRow();
drow[0] = latestID;
drow[1] = id;
dsSavedGame_Words.Tables["SavedGame_Words"].Rows.Add(drow);
}
con.Open();
cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(daHangmanDB);
cb.DataAdapter.Update(dsSavedGame_Words.Tables["SavedGame_Words"]);
con.Close();
MessageBox.Show("Game Saved");
}
private void button3_Click(object sender, EventArgs e) //Loading a new wordlist
{
OpenFileDialog loadlist = new OpenFileDialog();
loadlist.Filter = "Text Files (.txt)|*.txt|All Files (*.*)|*.*";
loadlist.FilterIndex = 1;
loadlist.Multiselect = false;
loadlist.InitialDirectory = "";
if (loadlist.ShowDialog() == DialogResult.OK) //user clicked ok
{
String Filepath = loadlist.FileName;
System.IO.StreamReader inpfile = new System.IO.StreamReader(Filepath);
System.Data.SqlServerCe.SqlCeConnection con = new System.Data.SqlServerCe.SqlCeConnection();
System.Data.SqlServerCe.SqlCeDataAdapter daHangmanDB;
DataRow drow;
DataSet dsWordlist = new DataSet();
con.ConnectionString = "Data Source=HangmanDB.sdf";
con.Open();
SqlCeCommand cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM Wordlist";
cmd.ExecuteNonQuery();
daHangmanDB = new System.Data.SqlServerCe.SqlCeDataAdapter("SELECT * From Wordlist", con);
daHangmanDB.Fill(dsWordlist, "Wordlist");
con.Close();
String data, category, words;
while ((data = inpfile.ReadLine()) != null)
{
category = data.Split(',')[0];
words = data.Split(',')[1];
drow = dsWordlist.Tables["Wordlist"].NewRow();
drow[1] = category;
drow[2] = words;
dsWordlist.Tables["Wordlist"].Rows.Add(drow);
}
con.Open();
System.Data.SqlServerCe.SqlCeCommandBuilder cb;
cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(daHangmanDB);
cb.DataAdapter.Update(dsWordlist.Tables["Wordlist"]);
con.Close();
MessageBox.Show("Database Updated.");
}
}
private void button2_Click(object sender, EventArgs e) //delete
{
System.Data.SqlServerCe.SqlCeConnection con = new System.Data.SqlServerCe.SqlCeConnection();
System.Data.SqlServerCe.SqlCeDataAdapter daHangmanDB;
DataRow drow;
DataSet dsSavedGame_Words = new DataSet();
con.ConnectionString = "Data Source=HangmanDB.sdf";
con.Open();
daHangmanDB = new System.Data.SqlServerCe.SqlCeDataAdapter("SELECT * From SavedGame_Words", con);
daHangmanDB.Fill(dsSavedGame_Words, "SavedGame_Words");
con.Close();
int selectedID = System.Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text);
for (int i = 0; i < dsSavedGame_Words.Tables["SavedGame_Words"].Rows.Count; ++i)
{
drow = dsSavedGame_Words.Tables["SavedGame_Words"].Rows[i];
if (System.Convert.ToInt32(drow[0]) == selectedID)
{
dsSavedGame_Words.Tables["SavedGame_Words"].Rows[i].Delete(); //Marks row for deletion (does not remove)
}
}
con.Open();
SqlCeCommand cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM SavedGame_Words";
cmd.ExecuteNonQuery();
con.Close();
con.Open();
System.Data.SqlServerCe.SqlCeCommandBuilder cb;
cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(daHangmanDB);
cb.DataAdapter.Update(dsSavedGame_Words.Tables["SavedGame_Words"]);
con.Close();
MessageBox.Show("Database Updated.");
con.Close();
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM SavedGames WHERE ID=" + System.Convert.ToString(selectedID);
cmd.ExecuteNonQuery();
con.Close();
listView1.Items.Remove(listView1.SelectedItems[0]);
}