internal static int udpdateowlingStyle(clsBowlingStyle BowlingStyle)
{
int result = 0;
SqlCeCommand com = new SqlCeCommand("UPDATE tblBowlingStyle set styleName=@p2 WHERE styleId=@p1", connection.CON);
com.Parameters.AddWithValue("@p1", BowlingStyle.styleCode);
com.Parameters.AddWithValue("@p2", BowlingStyle.styleName);
result = com.ExecuteNonQuery();
return(result);
}
internal static int addBowlingStyle(clsBowlingStyle BowlingStyle)
{
SqlCeCommand com = new SqlCeCommand("INSERT INTO tblBowlingStyle VALUES(@p1,@p2)", connection.CON);
com.Parameters.AddWithValue("@p1", BowlingStyle.styleCode);
com.Parameters.AddWithValue("@p2", BowlingStyle.styleName);
try
{
return(com.ExecuteNonQuery());
}
catch (Exception e)
{
clsMessages.showMessage(clsMessages.msgType.error, e.Message);
}
return(0);
}
