//Insert data into DB
public bool Insert(WordClass c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstring);
try {
string sql = "INSERT INTO WT_table (Word, Translate) VALUES (@Word, @Translate)";
SqlCommand cmd = new SqlCommand(sql, conn);
if (String.IsNullOrEmpty(Word))
{
cmd.Parameters.AddWithValue("@Word", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Word", c.Word);
}
if (String.IsNullOrEmpty(Translate))
{
cmd.Parameters.AddWithValue("@Translate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Translate", c.Translate);
}
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Inserted");
}
conn.Open();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
throw;
}
finally {
conn.Close();
}
return(isSuccess);
}
//Delete data from DB
public bool Delete(WordClass c)
{
bool isSucccess = false;
SqlConnection conn = new SqlConnection(myconnstring);
try {
string sql = "DELETE FROM WT_table WHERE WordID=@WordID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@WordID", c.WordID);
conn.Open();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Inserted");
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
throw;
}
finally {
conn.Close();
}
return(isSucccess);
}